Rohith Nama created SQOOP-3284:
----------------------------------
Summary: Sqoop-Hcatalog Table Creation Error- Parsing Exception
Key: SQOOP-3284
URL: https://issues.apache.org/jira/browse/SQOOP-3284
Project: Sqoop
Issue Type: Bug
Components: hive-integration
Affects Versions: 1.4.6
Environment: AWS EMR with Sqoop 1.4.6 and Hive 2.3.2!
Reporter: Rohith Nama
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.
Rohith
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
