why does importation from mssql hive does not support timestamp?

[#1]

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.

[#2 · Accepted solution]

@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

[#3 · Accepted solution]

@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

[#4]

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??

[#5 · Accepted solution]

@Christian Lunesa

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