Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

why does importation from mssql hive does not support timestamp?

avatar
Contributor

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.


mssql-error.png
2 ACCEPTED SOLUTIONS

avatar
Master Mentor

@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

View solution in original post

avatar
Master Mentor

@Christian Lunesa

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

View solution in original post

3 REPLIES 3

avatar
Master Mentor

@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

avatar
Contributor

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

avatar
Master Mentor

@Christian Lunesa

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