sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Benjamin BONNET (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-2895) NCLOB import to Hive not supported
Date Fri, 25 Mar 2016 16:14:25 GMT
Benjamin BONNET created SQOOP-2895:
--------------------------------------

             Summary: NCLOB import to Hive not supported 
                 Key: SQOOP-2895
                 URL: https://issues.apache.org/jira/browse/SQOOP-2895
             Project: Sqoop
          Issue Type: Bug
          Components: hive-integration
            Reporter: Benjamin BONNET


Hi,
Sqoop cannot import and create Hive table when the table to be imported contains NCLOB columns.
Actually, data is correctly imported into HDFS but Hive table creation fails with :
ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: Hive
does not support the SQL type for column myNClobColumn
        at org.apache.sqoop.hive.TableDefWriter.getCreateTableStmt(TableDefWriter.java:181)
        at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:188)
        at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:514)
        at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605)
        at org.apache.sqoop.Sqoop.run(Sqoop.java:148)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
        at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:184)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:226)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:235)
        at org.apache.sqoop.Sqoop.main(Sqoop.java:244)

That issue is due to the fact SQOOP knows CLOB type but not NCLOB. See type mappings in org.apache.sqoop.hive.HiveTypes
where NCLOB is not.

Regards



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message