Jump to content

hadoop sqoop - oka doubt

mettastar

By mettastar
in Discussions

 Share

Recommended Posts

kasi Celebrity

kasi

Posted
Posted

This problem was caused by data-type mismatch between the HIVE table column (STRING) and the target RDBMS column (CHAR, VARCHAR or TEXT). Basically Hive STRING will not convert naturally into these ANSI data-types, I had to CAST the STRING into CHAR before the SQOOP Map-Reduce would let me move the data across.

Link to comment
Share on other sites
mettastar LEGEND

mettastar

Posted
  • Author
Posted
18 minutes ago, kasi said:

This problem was caused by data-type mismatch between the HIVE table column (STRING) and the target RDBMS column (CHAR, VARCHAR or TEXT). Basically Hive STRING will not convert naturally into these ANSI data-types, I had to CAST the STRING into CHAR before the SQOOP Map-Reduce would let me move the data across.

bro this is not string issue, when hive table is created avro schema file is being used and avro schema file lo it is defined as decimal. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...