Member since
09-25-2015
356
Posts
382
Kudos Received
62
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2449 | 11-03-2017 09:16 PM | |
1924 | 10-17-2017 09:48 PM | |
3848 | 09-18-2017 08:33 PM | |
4526 | 08-04-2017 04:14 PM | |
3469 | 05-19-2017 06:53 AM |
04-28-2017
09:36 PM
3 Kudos
Yes, CBO is a client side property. You can disable at the beginning of query by specifying: set hive.cbo.enable=false;
... View more
04-28-2017
02:13 PM
1 Kudo
As the error message suggests, the containers launched by LLAP have failed, can you check the failed application logs?
... View more
04-27-2017
07:57 PM
1 Kudo
HiveServer2 transport mode can be set to http, clients will be able to connect using either the Zookeeper Service Discovery mode or directly to the HS2 server.
... View more
04-27-2017
05:14 AM
1 Kudo
If i understand your question, you want to connect to HiveServer2 using Zookeeper without having the client to worry about the transport mode. This is supported by the HiveServer2 feature - Zookeeper Service Discovery Mode. If you are using Ambari this is the default mode. With introduction of HIVE-11581, the JDBC url becomes very simple as none of the additional configuration parameters such as authentication mode, transport mode, or SSL parameters need to be specified, as they are retrieved from the ZooKeeper entries along with the hostname. JDBC URL: jdbc:hive2://<zookeeper quorum>/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 The <zookeeper quorum> is the same as the value of hive.zookeeper.quorum configuration parameter in hive-site.xml/hivserver2-site.xml used by HiveServer2. Read more about it here.
... View more
04-27-2017
04:16 AM
1 Kudo
hive.server2.transport.mode values are either binary or http. hive.server2.authentication – Authentication mode, default NONE. Options are NONE (uses plain SASL), NOSASL, KERBEROS, LDAP, PAM and CUSTOM. Read more at https://cwiki.apache.org/confluence/display/Hive/Setting+Up+HiveServer2#SettingUpHiveServer2-Authentication/SecurityConfiguration. I believe Tableau is making you select the authentication mode and not the transport mode.
... View more
04-21-2017
06:32 PM
1 Kudo
Set the Superset database type to 'mysql' or 'postgresql'.
... View more
04-17-2017
06:51 PM
1 Kudo
This is a known issue, see more on how to get around here. https://community.hortonworks.com/questions/96619/druid-superset-wont-start-on-hdp-26.html
... View more
04-14-2017
12:45 AM
1 Kudo
Depending on the scale and complexity of table I can think of one of three ways: Export the data from Hive and Oracle as CSV file and diff the files Use Sqoop to pull the tables from Hive to Oracle or vice versa and write a join query to get the diff Programmatically use a simple JDBC client to fetch data from Oracle and Hive and compare
... View more
04-12-2017
05:55 PM
1 Kudo
For HDP 2.6, supported OS are Centos 6/7/ppc, SLES 11/12, Debian 6/7, Ubuntu 12/14/16 https://community.hortonworks.com/articles/93067/hdp-26ambari-25-ga.html
... View more
04-12-2017
05:00 AM
1 Kudo
Sqoop allows you to export data from Hive to SQL Server, see Sqoop documentation here. A sample command to export a hive table would look like this: sqoop export --connect "jdbc:sqlserver://SQLHOST:9433;databaseName=DBNAME;user=USER;password=PASSWORD" --table TABLENAME --export-dir HDFS_EXPORT_DIR
... View more