[
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)
