Affects Version/s: 1.4.6
Fix Version/s: None
AWS EMR with Sqoop 1.4.6 and Hive 2.3.2!
I'm in a process of importing data from sybase to hive using Sqoop. When use hive import everything worked fine but I need the data in orc format so I started using Hcatalog.
In Hcatalog the table is created as follows:
create external table default.val_deriv_orc (
deriv varchar ,
deriv_descr varchar )
stored as orcfile;
Using varchar is causing the following issue:
FAILED: ParseException line 2:13 mismatched input ',' expecting ( near 'char' in primitive type specification
18/02/07 16:25:13 INFO hcat.SqoopHCatUtilities: 18/02/07 16:25:13 ERROR ql.Driver: FAILED: ParseException line 2:13 mismatched input ',' expecting ( near 'char' in primitive type specification
Whereas, hive import used string type and everything worked fine!
I couldn't find any solution or possible clue so any help to resolve the issue would be appreciated. Thank you.