Sqoop export not working

Question

What is the mistake I am making?

using sqoop export :
sqoop export --connect jdbc:mysql://sqoopdb.edu.cloudlab.com/trading --username labuser --password edureka --table trade --input
-fields-terminated-by "," --export-dir /user/edureka_525450/FINAL_FROM_DF1.csv --num-mappers 1 --columns "SYMBOL, SERIES,OPEN,HIGH,LOW,CLOSE,LAST,PREVCLOSE,TOTTRDQ
TY,TOTTRDVAL,TIMESTAMP,TOTALTRADES,ISIN"

I created the table in Database trading and the table name trade using below syntax

create table trade (SYMBOL varchar(20),SERIES varchar(2),OPEN DECIMAL(10,2),HIGH DECIMAL(10,2),LOW DECIMAL(10,2),CLOSE DECIMAL(10,2),LAST DECIMAL(10,2),PREVCLOSE DECIMAL(10,2),TOTTRDQTY integer(15),TOTTRDVAL DECIMAL(15,2),TIMESTAMP varchar(10),TOTALTRADES integer(20),ISIN varchar(20))

exported the file in the below location
/ user/ edureka_525450/ FINAL_FROM_DF1.csv

Answer 1

The issue that you might be getting is because of the headers that are present in your data file in the hdfs. When you are directly exporting the data to mysql, it is encountering an error because of the headers. Thus you have to remove the headers before loading the file to hdfs since hdfs is WORM that is Write Once Read Many times, so you will not be able to make changes in the hdfs. 

I have loaded another the same data without the headers in your hdfs in the same location with the name FINAL_FROM.csv and exported it to mysql. Please have a look below for the commands and the screenshots:

sqoop export --connect jdbc:mysql://sqoopdb.edu.cloudlab.com/trading --username labuser --P --table trade  --export-dir /user/edureka_525450/FINAL_FROM_DF1.csv -m 1