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)