sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jarek Jarcec Cecho <jar...@apache.org>
Subject Re: sqoop import --hive-import failing for row_version (datatype: timestamp) column for MS SQL Server
Date Wed, 20 Jan 2016 14:04:25 GMT
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 <sudeepshekharm@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
> 


Mime
View raw message