Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> question about applying patch

Copy link to this message
question about applying patch

I am trying to import sqlserver table in to hive table using sqoop.  The import failed on nvarchar field.  There is a patch released as per https://issues.apache.org/jira/browse/SQOOP-323?page=com.atlassian.jira.plugin.system.issuetabpanels%3Aall-tabpanel#issue-tabs.

How do I apply this patch to the existing sqoop?

Thank you,

The error I am getting is,

Hive does not support the SQL type for column xxxxxxxx  -- the column is nvarchar
        at com.cloudera.sqoop.hive.TableDefWriter.getCreateTableStmt(TableDefWriter.java:150)
        at com.cloudera.sqoop.hive.HiveImport.importTable(HiveImport.java:187)
        at com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:362)
        at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79)
        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:218)
        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:228)