@Sateesh Battu please check if the hive.druid.broker.address.default propert is set . in HIVE confs ... View more

@pk reddy give enough memory to tez AM container. tez.am.resource.memory.mb ... View more

@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

@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

@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

@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

@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

@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

@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

@zkfs hope this article might help you for correct settings https://community.hortonworks.com/articles/591/using-hive-with-pam-authentication.html ... View more