question Re: why does importation from mssql hive does not support timestamp? in Archives of Support Questions (Read Only)

why does importation from mssql hive does not support timestamp?

dcedielunesa — Sun, 15 Apr 2018 14:17:38 GMT

I'm only encountering this error when I import from mssql windows server 2003. When I import from MYSQL 5.5 to MYSQL 5.6 it does not have any problem. I'm using sqljdbc4.jar for the sql driver.

I also attached the screen shot of the error.

Please help me getting rid this error without mapping timestamp column to string.

Re: why does importation from mssql hive does not support timestamp?

Shelton — Sun, 15 Apr 2018 14:22:26 GMT

@Christian Lunesa

To Override the default mapping from SQL type to Hive type for configured columns use --map-column-hive option.

Refer to the documentation here

Re: why does importation from mssql hive does not support timestamp?

dcedielunesa — Sun, 15 Apr 2018 14:38:33 GMT

thank you for your fast response @Geoffrey Shelton Okot. I already know that --map-column-hive is used to override the default mapping from SQL type to Hive type. Is there any other way to get rid of that error without using --map-column-hive??

Re: why does importation from mssql hive does not support timestamp?

Shelton — Thu, 19 Apr 2018 03:36:37 GMT

@Christian Lunesa

Unfortunately no but setting the attribute --map-column-hive Date=Timestamp to Sqoop will definitely work