Support Questions
Find answers, ask questions, and share your expertise

why does importation from mssql hive does not support timestamp?

Solved Go to solution
Highlighted

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

Accepted Solutions

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

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

Highlighted

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

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

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

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

Highlighted

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

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

Highlighted

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

Mentor

@Christian Lunesa

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

View solution in original post