...
...
| Info | ||
|---|---|---|
| ||
Datameer X contains the connector 'HiveServer2' which supports ZooKeeper. Therefore the Hive JDBC client has to be enabled. |
| Info | ||
|---|---|---|
| ||
Note when using Hive 3: We are now converting all Datameer DATE columns to Hive TIMESTAMP and Hive DATE type data when exporting to HIVE 3 from the Datameer server time zone to UTC. And on import from Hive TIMESTAMP and Hive DATE back from UTC to Datameer server time zone. Never set the property "hive.parquet.timestamp.skip.conversion" to "TRUE". This would result in inconsistent data being stored in HIVE. |
| Table of Contents |
|---|
Configuring HiveServer2 as a JDBC Connection
...
| Code Block |
|---|
jdbc:hive2://pmaster.datameer.lan:2181,pnode-02.datameer.lan:2181,pnode-04.datameer.lan:2181/default;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 |
Example SSL
| Code Block |
|---|
jdbc:hive2://localhost:10000/mydb;ssl=true;sslTrustStore=/opt/cloudera/security/jks/jssecacerts;trustStorePassword=changeit |
...