hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 董亚军 <ric.d...@liulishuo.com>
Subject Re: sqoop import --hive-import failing for row_version (datatype: timestamp) column for MS SQL Server
Date Wed, 20 Jan 2016 05:10:55 GMT
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 <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