[SQOOP-3284] Sqoop-Hcatalog Table Creation Error- Parsing Exception

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.4.6
• Component/s: hive-integration

Environment

AWS EMR with Sqoop 1.4.6 and Hive 2.3.2!

• Assignee: Unassigned
• Reporter: Rohith Nama
• Created: 07/Feb/18 17:05
• Updated: 07/Feb/18 17:05

Description

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