Hi Savitha, first of all, I would strongly suggest to drop the parameter --driver as it's usage is most likely completely incorrect. Check out blog post at [1] for background why is that.
Would you mind sharing with us example of the data? Jarcec Links 1: https://blogs.apache.org/sqoop/entry/connectors_and_drivers_in_the On Mon, Apr 28, 2014 at 02:29:57PM +0000, Savitha Devi Inbasekaran wrote: > 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 > >
signature.asc
Description: Digital signature
