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

Posted to user@sqoop.apache.org by Devender Yadav <de...@gmail.com> on 2016/04/13 12:43:01 UTC

Issue with char, varchar, decimal in Sqoop command with --map-column-hive tag

Hi,

I am importing data from teradata to hive using Sqoop.

I added --map-column-hive in sqoop import command

 --map-column-hive num_int=int, num_float=float
,num_dec=decimal,ts=timestamp, desc_varchar=varchar

I got exception:
FAILED: ParseException line 1:234 mismatched input ',' expecting ( near
'varchar' in primitive type specification

Then I tried:

 --map-column-hive num_int=int, num_float=float
,num_dec=decimal,ts=timestamp, desc_varchar=varchar(255)

I got:

bash: syntax error near unexpected token `('

How to handle char, varchar and decimal in --map-column-hive tag?

Regards,
Devender Yadav
Software Developer
Impetus Infotech Pvt Ltd