What versions of Hive and Sqoop are you using? Can you share the whole log generated with parameter —verbose?
Jarcec > On Jan 20, 2016, at 6:01 AM, 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 >
