Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

why does importation from mssql hive does not support timestamp?

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

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

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

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

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

Mentor

@Christian Lunesa

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.