sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sudeep mishra <sudeepshekh...@gmail.com>
Subject sqoop import --hive-import failing for row_version (datatype: timestamp) column for MS SQL Server
Date Wed, 20 Jan 2016 05:01:47 GMT
Hi,

I am trying to import MS SQL Server data into Hive using Sqoop import
--hive-import option but it is failing for a column of datatype 'timestamp'.

16/01/20 04:50:53 ERROR tool.ImportTool: Encountered IOException running
import job: java.io.IOException: Hive does not support the SQL type for
column row_version
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:70)
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)

Is there a way to suppress this or what is a good approach to handle such
cases?


Thanks & Regards,

Sudeep Shekhar Mishra

Mime
View raw message