[jira] [Assigned] (SQOOP-2895) NCLOB import to Hive not supported

["Benjamin BONNET (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SQOOP-2895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Benjamin BONNET reassigned SQOOP-2895:
--------------------------------------

    Assignee: Benjamin BONNET

> 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
>    Affects Versions: 1.4.6
>            Reporter: Benjamin BONNET
>            Assignee: 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)