kasi Posted October 6, 2016 Report Posted October 6, 2016 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. Quote
mettastar Posted October 6, 2016 Author Report Posted October 6, 2016 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. Quote
MrDexter Posted October 7, 2016 Report Posted October 7, 2016 how did you load the files into HDFS? Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.