Unable to export pipe delimited data from hdfs into mysql

Unable to export pipe delimited data from hdfs into mysql
0.0 0

#1

sqoop export
–connect “jdbc:mysql://nn01.itversity.com/retail_export”
–username retail_dba
–password itversity
–table orders_testing
–input-fields-terminated-by ‘|’
–export-dir /user/shashankpathak/orders_testing

can anyone help me to this . what mistake i am doing in above sqoop commands


Sign up for our state of the art Big Data cluster for hands on practice as developer. Cluster have Hadoop, Spark, Hive, Sqoop, Kafka and more.



#2

@shashankpathak

provide us the error so that it will be easy to resolve the issue.
But, from the above table orders_testing is an empty set.


#3

yes , i created that table to export the pipe delimited data into this …
Data is located as i mentioned in export-dir …
So it should pull the data and export into empty table which is orders_testing but it is failing everytime…
here is the screenshot


#4

@shashankpathak
The export directory path is incorrect.


And orders_testing table datatype should same as file datatype.

For e.g:
1)Create table in mysql:
create table order_testing1(order_id int(11), order_date datetime, order_customer_id int(11), order_status varchar(45));
2) Then sqoop export command:
sqoop export --connect "jdbc:mysql://nn01.itversity.com/retail_export" --username retail_dba --password itversity --table order_testing1 --input-fields-terminated-by '|' --export-dir /user/annapurnachinta/sqoop/orders
3)
Screenshot%20from%202018-05-07%2012-50-15


#5