Cloudera Community
jyadav
user rank
Super Guru

Re: hive buckets sorted

by Super Guru in Support Questions
‎06-17-2016 01:07 PM
2 Kudos
‎06-17-2016 01:07 PM
2 Kudos
@Roberto Sancho Hope below post help you to understand the differences. http://stackoverflow.com/questions/13715044/hive-cluster-by-vs-order-by-vs-sort-by ... View more

Re: getting following exception while running spar...

by Super Guru in Support Questions
‎06-17-2016 11:10 AM
2 Kudos
‎06-17-2016 11:10 AM
2 Kudos
@a kumar You need to increase the driver memory try from 1G at least. use below parameter while submitting the job. --driver-memory 1g ... View more

Re: jobtracker port

by Super Guru in Support Questions
‎06-16-2016 07:45 PM
‎06-16-2016 07:45 PM
For oozie the job tracker URI should be pointing to the RM manager port. Try this. jobTracker=http://192.168.1.189:8032 Also please share the output of below command from RM node. lsof -i:8050 lsof -i:8032 ... View more

Re: sqoop fails with "Unsupported startup paramete...

by Super Guru in Support Questions
‎06-16-2016 11:41 AM
1 Kudo
‎06-16-2016 11:41 AM
1 Kudo
can you try like this? sqoop list-tables -Dignore_startup_parameters=extra_float_digits --connect jdbc:postgresql://my.server.com:6543/abserver-bigdata --username bigdata --password xxxxx Looks like it ... View more

Re: Hive CLI not launched

by Super Guru in Support Questions
‎06-16-2016 11:27 AM
2 Kudos
‎06-16-2016 11:27 AM
2 Kudos
@ravi kumar First check whether HDFS and YARN services are in healthy state in the cluster. If everything looks fine then try enabbling hive debug and review for more debug logs for any possible issue. hive --hiveconf hive.root.logger=DEBUG,console ... View more

Re: Hive Scratch Directory

by Super Guru in Support Questions
‎06-16-2016 11:18 AM
‎06-16-2016 11:18 AM
Sorry no other solution from my side since hive doesn't allow few parameters change after initiating session and this is how it works. Or Wait for other experts to answer. ... View more

Re: sqoop fails with "Unsupported startup paramete...

by Super Guru in Support Questions
‎06-16-2016 11:11 AM
3 Kudos
‎06-16-2016 11:11 AM
3 Kudos
@Roman Boyko Ca you please try with this connector? https://jdbc.postgresql.org/download/postgresql-9.1-903.jdbc4.jar ... View more

Re: Hive Scratch Directory

by Super Guru in Support Questions
‎06-16-2016 11:02 AM
‎06-16-2016 11:02 AM
Try creating .hiverc file inside the directory from where you are trying to run hive shell and add below line inside the file and run hive shell. Thats the only way remaining or use latest hive release. Thank You. SET hive.exec.scratchdir=/TMP/dir; ... View more

Re: about hue access HDFS ha

by Super Guru in Support Questions
‎06-16-2016 10:41 AM
‎06-16-2016 10:41 AM
It should not be, if confs are ok i believe restarting services might help in this case. As per http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.0/bk_hadoop-ha/content/ha-nn-deploy-hue.html ... View more

Re: Hive Scratch Directory

by Super Guru in Support Questions
‎06-16-2016 10:20 AM
‎06-16-2016 10:20 AM
@ammu ch Ok I got the version, but still as per the fix it should use same EZ directory for scratch where table exist. https://issues.apache.org/jira/browse/HIVE-8065 ... View more
Contact Me
Online
Offline
Last Visited
‎06-02-2017 09:42 PM
Community Statistics
Member Since ‎02-02-2016 09:29 AM
Last Visited ‎06-02-2017 09:42 PM
Posts 583
Kudos received 518