sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Savitha Devi Inbasekaran <Savith...@smartek21.com>
Subject Special character in Sqoop exported data
Date Mon, 28 Apr 2014 14:29:57 GMT
I trying to import HDFS data to Mysql using the following command:

 /opt/cloudera/parcels/CDH-5.0.0-1.cdh5.0.0.p0.47/bin/sqoop export --driver com.mysql.jdbc.Driver
--connect jdbc:mysql://server:port/dbname --table table_name   --username user --password
pwd  --export-dir /user/hdfs/hiveoutput/consolidatedconsumption/Hits/*  --input-fields-terminated-by
'\t'  --input-lines-terminated-by '\n'

Though the export is successfull, the data in the mysql db looks like this

[enter image description here]

Any suggestion to remove the "SOH" from mysql would be appreciated.

Thanks, Savitha

View raw message