hive does not support the data type for column row_version, you may skip this column or maps a new data type for row_version
please reference: https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_controlling_type_mapping On Wed, Jan 20, 2016 at 1:03 PM, sudeep mishra <sudeepshekh...@gmail.com> wrote: > 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 > > > >
