Unfortunately there is no clear standard that has been followed on naming client side vs server side properties. hive.metastore.* as the name suggests would be Hive metastore server side properties, similarly hive.server2.* would be HiveServer2 server side properties. However whitelisted properties listed as part of SQL Standard Authorization can be used as cue, these are client side properties that the end user is allowed to set when running under the SQL Standard authorization configuration. ... View more

Hive has two services - Hive Metastore and HiveServer2. Multiple Hive Metastore processes can be started and specified in the hive.metastore.uris. I believe the clients pick up the first active one from the list. Multiple HiveServer2 instances can be restarted and they register with the Zookeeper. The client will randomly pick one and connect to it. In either case once a client session has been initiated, killing/shutting down will invalidate the client session needing the client to reconnect. For HiveServer2 however you can gracefully shut an instance using the deregister command. When a HiveServer2 instance is de-registered, it is removed from the list of servers available for new client connections. (Client sessions on the server are not affected). When the last client session on a server is closed, the server is closed. ... View more

We should be using mysql-connector-java-5.1.29.jar or above. There is an internal JIRA BUG-38264 tracking this, please reopen that. ... View more

No, WebHCat does not provide any options to get the query output as part of the response object. Either you use the WebHDFS api to inspect the contents of the output directory or if your concern is the transport mode, you could JDBC connection to the HiveServer2 configured in HTTP mode. ... View more

No there is no global way to set casting in Hive. What do you want to achieve by trimming decimal, do you want to use trim to remove trailing zeros? Looks like even Hive 0.11 trim was for removing the leading and trailing space characters. Its just that now they do explicit type check for string/var/varchar before trimming spaces which seem like the right behavior. ... View more

Remember when you connect to HiveServer2 over JDBC you are running commands at the HiveServer2, so your client environment properties are not available. You can however pass additional properties at the time of initiating beeline session: $ beeline -hiveconf hs2.connect.user=deepesh beeline> !connect jdbc:hive2://localhost:10000 hrt pwd scan complete in 2ms Connecting to jdbc:hive2://localhost:10000 Transaction isolation: TRANSACTION_REPEATABLE_READ 0: jdbc:hive2://localhost:10000> set hs2.connect.user; +---------------------------+--+ | set | +---------------------------+--+ | hs2.connect.user=deepesh | +---------------------------+--+ 1 row selected (0.112 seconds) ... View more