-Re: Using delimiter for field termiantion
Jarek Jarcec Cecho 2013-12-07, 17:10
would you mind sharing with us entire Sqoop log generated with parameter --verbose?
If you have data that are not much suitable for text output, perhaps you could consider Avro as the storage format?
On Fri, Dec 06, 2013 at 03:03:00AM -0800, lovely kasi wrote:
> I have data in db which almost contains all the delimiters in its data
> so i though t i will use ecap(ê) as delimiter. while importing using sqoop
> into hive.
> I gave the option
> --fields-terminated-by 'ê'
> but i got the following error
> Imported Failed: Character 234 is an out-of-range delimiter.
> The sqoop is importing into HDFS but i am getting the above error when it
> continues to import that HDFS output into hive.