Re: Special character in Sqoop exported data

[Jarek Jarcec Cecho <ja...@apache.org>]

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
> 
>