Sqoop import error in OOZIE Workflow

Lab Support
#1

Hi

I am getting the below error in Sqoop Import Task in OOZIE Workflow. But the same SQOOP command is working in webconsole. I have provided error message and Sqoop Command below. Please help me on this. Thanks.

Error: Could not find any valid local directory for nmPrivate/container_e123_1517296050843_4820_02_000004.tokens

Sqoop Command:
import --connect “jdbc:mysql://ip-172-31-13-154:3306/retail_db” --driver com.mysql.jdbc.Driver --connection-manager org.apache.sqoop.manager.GenericJdbcManager -username sqoopuser --table order_items -password NHkkP876rp --fields-terminated-by “|” --lines-terminated-by “\n” -z --compression-codec SNAPPY -m 1 --warehouse-dir http://a.cloudxlab.com:8020/user/karthimechatronics7605/retail_db/ --append

Regards,
Karthik

#2

Can someone help me on this from Lap Support Team?

#3

Hi @Karthi_Keyan,

This video will provide you more information on the same.

Hope this helps

Thanks

#4

Thanks abhinav. Can you please provide me the link where I can find these type of video tutorials in cloudxlab?

#5

Hi @Karthi_Keyan,

Yes, you can find getting started videos here

Thanks

1 Like