Re: Hive CLI issue when killing with Ctrl+c

gandra · ‎08-02-2017

Thank you.

gandra · ‎08-01-2017

I too got same issue and resolved by doing hive --hiveconf hive.execution.engine=mr . But, how to resolve it if we want to use Tez instead of mr ?

gandra · ‎08-01-2017

pulling data using oozie workflow

gandra · ‎08-01-2017

sqoop import -Dorg.apache.sqoop.splitter.allow_text_splitter=true --connect jdbc:oracle:thin:@XXXXX:XXXX:XXXX --username XXXX --password-file XXXX --table schema.tablename --hive-import --hive-overwrite --hive-table dbname.tablename -m 4

gandra · ‎08-01-2017

Please find attachment hdp.txt

gandra · ‎08-01-2017

https://community.hortonworks.com/questions/31847/sqoop-error-while-import-from-mysql-sqlexception-i.html Could you please go through this @Kuldeep Kulkarni ?

gandra · ‎08-01-2017

Error: java.io.IOException: SQLException in nextKeyValue at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:277) at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:556) at org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:80) at org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:91) at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:145) at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:64) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:787) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1724) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:162)

gandra · ‎07-18-2017

@simran kaur Can you tell how did you ran multiple table imports using oozie/Sqoop ? apart from using import-all tables too.

gandra · ‎07-13-2017

@Rajendra Chandrasekhar

gandra · ‎07-13-2017

https://community.hortonworks.com/questions/106322/sqoop-hive-import-through-oozie.html

gandra · ‎07-12-2017

@Rajendra Chandrasekhar @simran kaur I'm also getting same error, do you have a solution for this?

gandra · ‎06-21-2017

Hello @Ramon Wartala , I too have similar issue. are you able to resolve this ?

gandra · ‎06-01-2017

It works, Thank you!!

Online	Offline
Last Visited	‎08-03-2017 10:12 PM

Date Registered	‎04-28-2017 12:40 AM
Last Visited	‎08-03-2017 10:12 PM
Total Messages Posted	13

Re: Hive CLI issue when killing with Ctrl+c

Re: Hive CLI issue when killing with Ctrl+c

Re: While ingesting from oracle to Hive, Sqoop thr...

Re: While ingesting from oracle to Hive, Sqoop thr...

Re: While ingesting from oracle to Hive, Sqoop thr...

Re: While ingesting from oracle to Hive, Sqoop thr...

While ingesting from oracle to Hive, Sqoop throws ...

Re: sqoop job for incremental import execution fro...

Re: Main class [org.apache.oozie.action.hadoop.Sqo...

Re: Main class [org.apache.oozie.action.hadoop.Sqo...

Re: Main class [org.apache.oozie.action.hadoop.Sqo...

Re: Ambari Infra (Solr) doesn't start after cluste...

Re: Sqoop to SQL Server with Integrated Security