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