sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rohith Nama (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-3284) Sqoop-Hcatalog Table Creation Error- Parsing Exception
Date Wed, 07 Feb 2018 17:06:00 GMT
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)

Mime
View raw message