Cloudera Community
Announcements
Now Live: Explore expert insights and technical deep dives on the new Cloudera Community Blogs — Read the Announcement
nsabharwal
user rank
Master Mentor

Re: Free form query in Sqoop Import with WHERE cla...

by Master Mentor in Support Questions
‎02-12-2016 05:25 PM
‎02-12-2016 05:25 PM
@Satish S Did it fail? ... View more

Re: HDP-2.3.4.0-3485 upgrade failed due to HDP-UTI...

by Master Mentor in Support Questions
‎02-12-2016 05:16 PM
2 Kudos
‎02-12-2016 05:16 PM
2 Kudos
@wei yang Try this Remove redhat/centos repo mv /etc/yum.repos.d/redhat.repo or centos repo Remove snappy + devel and then force install snappy 1.0.5 from snappy-devel: yum clean all yum remove snappy snappy-devel yum install snappy* It should pick snappy from HDP repo. ... View more

Re: Free form query in Sqoop Import with WHERE cla...

by Master Mentor in Support Questions
‎02-12-2016 04:55 PM
‎02-12-2016 04:55 PM
Try this @Satish S and Are you using CDH cluster? sqoop import --connect jdbc:mysql://localhost/test --username sat -P --query 'select emp_no, salary from salaries where $CONDITIONS' --split-by emp_no --target-dir /user/cloudera/tmp/ ... View more

Re: Free form query in Sqoop Import with WHERE cla...

by Master Mentor in Support Questions
‎02-12-2016 04:36 PM
‎02-12-2016 04:36 PM
@Satish S Your query must include the token $CONDITIONS which each Sqoop process will replace with a unique condition expression. You must also select a splitting column with --split-by . For example: $ sqoop import \ --query 'SELECT a.*, b.* FROM a JOIN b on (a.id == b.id) WHERE $CONDITIONS' \ --split-by a.id --target-dir /user/foo/joinresults ... View more

Re: Free form query in Sqoop Import with WHERE cla...

by Master Mentor in Support Questions
‎02-12-2016 04:18 PM
1 Kudo
‎02-12-2016 04:18 PM
1 Kudo
@Satish S See this tutorial http://www.tutorialspoint.com/sqoop/sqoop_import.htm sqoop import \ --connect jdbc:mysql://localhost/userdb \--username root \ --table emp_add \ --m 1 \ --where“city =’sec-bad’” \ --target-dir /wherequery ... View more

Re: HDP java 8 update

by Master Mentor in Support Questions
‎02-12-2016 04:04 PM
‎02-12-2016 04:04 PM
@Brenden Cobb Please read this http://docs.hortonworks.com/HDPDocuments/Ambari-2.1.1.0/bk_ambari_reference_guide/content/ch_changing_the_jdk_version_on_an_existing_cluster.html ... View more

Re: Ambari error when restarting flume agent

by Master Mentor in Support Questions
‎02-12-2016 03:16 PM
‎02-12-2016 03:16 PM
@Kirill Elsukov I hate to say this ..You have to uninstall ambari-agent and reinstall...I have see this behavior few times and after lot of troubleshooting...I fixed it by following the above approach ambari-agent stop yum remove ambari-agent yum install ambari-agent ambar-agent start ... View more

Re: Basic Question: Install Spark on HDP 2.3 using...

by Master Mentor in Support Questions
‎02-12-2016 03:02 PM
‎02-12-2016 03:02 PM
@Rahul Tikekar Good question..Please see this doc and http://spark.apache.org/docs/latest/running-on-yarn.html When you submit spark job then you define master "the --master parameter is yarn ." In client mode, the driver runs in the client process, and the application master is only used for requesting resources from YARN. ... View more

Re: HBase shell throws exception at startup

by Master Mentor in Support Questions
‎02-12-2016 02:46 PM
‎02-12-2016 02:46 PM
@Steven Hirsch Thanks for the final followup. FYI: I believe phoenix installation ended up installing some other packages that needed for HBASE shell. ... View more

Re: Basic Question: Install Spark on HDP 2.3 using...

by Master Mentor in Support Questions
‎02-12-2016 02:43 PM
‎02-12-2016 02:43 PM
@Rahul Tikekar If you want spark client in all the nodes then you can install it using ambari. You can start spark thrift and History server from the ambari. You don't have to do anyting if you are using ambari to manager spark. ... View more
Contact Me
Online
Offline
Last Visited
‎07-18-2019 05:10 PM
Community Statistics
Member Since ‎09-18-2015 05:49 PM
Last Visited ‎07-18-2019 05:10 PM
Posts 3,274
Kudos received 1129