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)
