You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@sqoop.apache.org by Varun <v....@gmail.com> on 2013/07/13 00:13:22 UTC

Apache Sqoop - utf-8 data issue

Hi,

I am importing data from MySql to HDFS using free-form query import.
It works fine but facing issue when the data is utf-8.The source(MySql) db
is utf-8 compatible but looks like sqoop is converting the data during
import.

Example - The source value - elémeñt is loaded as elÃ©meÃ±t to HDFS.

Please provide a solution for this.

Thanks in advance!

-- 
<< Varun..>>

Re: Apache Sqoop - utf-8 data issue

Posted by Jarek Jarcec Cecho <ja...@apache.org>.

Hi Varun,
we are usually not seeing any issues with transferring text data in UTF. How are you validating the imported file? I can imagine that your shell might be messing the encoding.

Jarcec

On Fri, Jul 12, 2013 at 03:13:22PM -0700, Varun wrote:
> Hi,
> 
> I am importing data from MySql to HDFS using free-form query import.
> It works fine but facing issue when the data is utf-8.The source(MySql) db
> is utf-8 compatible but looks like sqoop is converting the data during
> import.
> 
> Example - The source value - elémeñt is loaded as elÃ©meÃ±t to HDFS.
> 
> Please provide a solution for this.
> 
> Thanks in advance!
> 
> -- 
> << Varun..>>