sqoop import error from teradata to hive -


i using below given sqoop command:

sqoop import      --libjars /usr/hdp/2.4.0.0-169/sqoop/lib,/usr/hdp/2.4.0.0-169/hive/lib      --connect jdbc:teradata://x/database=x      --connection-manager org.apache.sqoop.teradata.teradataconnmanager      --username ec      --password dc      --query "select *  hb yr_nbr=2017"     --hive-table schema.table      --num-mappers 1      --hive-import       --target-dir /user/hive/warehouse/gg 

i'm getting error:

org.apache.hadoop.security.usergroupinformation.doas(usergroupinformation.java:1657) @ org.apache.hadoop.mapred.yarnchild.main(yarnchild.java:162)     17/04/06 11:15:41 info mapreduce.job:  map 100% reduce 0%     17/04/06 11:15:41 info mapreduce.job: task id : attempt_1491466460468_0029_m_000000_1, status : failed     error: org.apache.hadoop.fs.filealreadyexistsexception: /user/root/temp_111508/part-m-00000 client 192.168.211.133 exists 

from error, can guess output file in target directory, may previous sqoop import. there option in sqoop import named --delete-target-dir delete target output directory , re-create them in next sqoop import. hope helps.


Comments

Popular posts from this blog

commonjs - How to write a typescript definition file for a node module that exports a function? -

openid - Okta: Failed to get authorization code through API call -

ios - Change Storyboard View using Seague -