Member since
04-12-2016
46
Posts
74
Kudos Received
8
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
5889 | 03-09-2017 12:27 PM | |
1228 | 02-01-2017 09:54 AM | |
7506 | 07-07-2016 08:44 PM | |
7636 | 07-05-2016 10:18 AM | |
1466 | 07-01-2016 06:31 AM |
03-27-2018
01:42 PM
@Sateesh Battu please check if the hive.druid.broker.address.default propert is set . in HIVE confs
... View more
03-27-2018
01:22 PM
@pk reddy give enough memory to tez AM container. tez.am.resource.memory.mb
... View more
03-27-2018
01:18 PM
@Vinit Mahiwal You can alternatively modify below configs (/etc/hive/conf) on the host where Hiveserver2 is running (and restart HS2) 'hive.txn.manager': 'org.apache.hadoop.hive.ql.lockmgr.DbTxnManager', 'hive.support.concurrency': 'true', + . (To disable authorization add below params) 'hive.security.authorization.enabled': 'false', 'hive.security.authorization.manager': 'org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory', 'hive.server2.enable.doAs':'false',
... View more
12-22-2017
10:26 AM
1 Kudo
@Anand Babu As you pointed the doc,have you followed the last step(after linking exact connector jars)
rm -rf /var/lib/ambari-agent/tmp/mysql-* (On Hivemetastore and HIveserver2 hosts -- restart services)
... View more
12-22-2017
10:09 AM
1 Kudo
@Sai Sandeep this could also occur in case hive user password issue. modify exact password in HIve configs via Ambari. drop metastore db and rerun schema tool $HIVE_HOME/bin/schematool -initSchema -dbType postgres
... View more
12-22-2017
05:21 AM
1 Kudo
@Winnie Philip When we are trying to connect to HiveServer2Interactive via ZookeeperName space, the url should contain list of zookeeper servers uris, also use correct ZookeeperName space (check in Advanced hive-interactive-site) eg: hiveserver2-hive2. Unsecure: jdbc:hive2://<zkhost1>:2181,<zkhost2>:2181,<zkhost3>:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2 Secure: jdbc:hive2://<zkhost1>:2181,<zkhost2>:2181,<zkhost3>:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2;principal=hive/_HOST@XYZ.COM **principal=hive/_HOST@XYZ.COM --> sample hive (service user) Kerberos Principal
... View more
09-28-2017
06:20 PM
1 Kudo
@Sreejith Madhavan I see the comment "running a SELECT statement in LLAP" but using Hive1.2 env, Try using Hive2 code base. Connect to HSI (Hiveserver2Interactive) url via beeline, which will make use of llap containers
... View more
09-28-2017
06:00 PM
1 Kudo
@Phaniraj G Druid-Hive integration works when you connect to HiveServer2Interactive, Hive-Druid storage handlers are available in Hive2 code base. check in /usr/hdp/<hdp_version>/hive2/lib Try executing them by connecting to HSI url via beeline.
... View more
06-29-2017
06:11 PM
2 Kudos
@Santosh Kum Use --as-avrodatafile or --as-parquetfie in the sqoop commnad line options for respective formats. Also check if you SQOOP_HOME/lib contains parqust and avro jar files.
... View more
03-27-2017
07:27 AM
1 Kudo
@zkfs hope this article might help you for correct settings https://community.hortonworks.com/articles/591/using-hive-with-pam-authentication.html
... View more