About sunile_manjee

sunile_manjee · ‎12-25-2016

try some of the option documented here https://community.hortonworks.com/questions/41355/unable-to-start-postgres-for-ambari.html

sunile_manjee · ‎12-23-2016

You can use jmx term. Article here: https://community.hortonworks.com/content/kbentry/61188/enable-jmx-metrics-on-hadoop-using-jmxterm.html

sunile_manjee · ‎12-22-2016

yes you can. I have found this article here useful to understand how spark job (long running) run on yarn. http://mkuthan.github.io/blog/2016/09/30/spark-streaming-on-yarn/

sunile_manjee · ‎12-20-2016

HWX support found my issue. here is what I was doing wrong::: Forgot the double quotes around the jdbc driver beeline -u "jdbc:hive2://example.com:2181,example.com:2181,example:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" and now it works. cool. @milind pandit thank you for your help. I am sure port checking should be on the list of what to check. however, the issue where was missing double quotes.

sunile_manjee · ‎12-20-2016

I got it working now. Here is what I did [LAKE] [smanjee@lake1 ~]# beeline -u "jdbc:hive2://example.com:2181,example.com:2181,example:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" --hiveconf hive.execution.engine=mr and it worked. I was missing the " " around the jdbc 0: jdbc:hive2://example.com:2> set hive.execution.engine; +---------------------------+--+ | set | +---------------------------+--+ | hive.execution.engine=mr | +---------------------------+--+ 1 row selected (0.192 seconds) 0: jdbc:hive2://example.com:2>

sunile_manjee · ‎12-20-2016

Do you have ranger audit enabled? if so please provide what the log shows when nifi tries to hit /tmp

sunile_manjee · ‎12-19-2016

I just tried --hiveconf and it did not set the execution engine. Digging why it didn't take.

sunile_manjee · ‎12-19-2016

I am able to connect to hive via beeline by issuing >beeline and then >!connect jdbc:hive2://zzz.com:2181,zzzz.com:2181,zzz.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 However I would like to connect to hive in 1 shot using -u >beeline -u jdbc:hive2://zzz.com:2181,zzzz.com:2181,zzz.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 and it fails [LAKE] [smanjee@lake1 ~]# beeline -u jdbc:hive2://z:2181,zzzzz.com:2181,zzzzzz.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/hdp/2.5.3.0-37/phoenix/phoenix-4.7.0.2.5.3.0-37-hive.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/hdp/2.5.3.0-37/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] Connecting to jdbc:hive2://zzzzz.com:2181,zzzzz.com:2181,zzzzz.com:2181/ 16/12/19 21:56:21 [main]: WARN jdbc.HiveConnection: Failed to connect to zzzzz.com:2181 Error: Could not open client transport with JDBC Uri: jdbc:hive2://zzzzz.com:2181/: null (state=08S01,code=0) Beeline version 1.2.1000.2.5.3.0-37 by Apache Hive 0: jdbc:hive2://zzzz.com:2 (closed)>

sunile_manjee · ‎12-19-2016

per release notes, it is still supported http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.3/bk_release-notes/content/ch_relnotes_v253.html

sunile_manjee · ‎12-19-2016

what version of hive are you using?

Online	Offline
Last Visited	‎05-25-2022 10:07 AM

Member Since	‎05-30-2018 10:40 PM
Last Visited	‎05-25-2022 10:07 AM
Posts	1,322
Kudos received	713

Cloudera Community

Re: Iterate over ADLS files using spark?

Re: Install NiFi CA service post nifi cluster inst...

Re: Which storage format is optimum for training m...

Re: Ambari custom alert failing

Re: df.cache() is not working on jdbc table

Re: Postgresql for Ambari not starting

Re: how to get JMX data for any service at a parti...

Re: Can we have a long running Spark application w...

Re: How to use Beeline -u with zk?

Re: Beeline Configuration hiveconf Equivalent

Re: Hive: INSERT OVERWRITE does not work

Re: Beeline Configuration hiveconf Equivalent

How to use Beeline -u with zk?

Re: Does hortonworks support Hue?

Re: Beeline Configuration hiveconf Equivalent