2014년 12월 30일 화요일

[cdh-user] CDH 5.2.0/Hive 13 issues with select queries

We upgraded from CDH 4.6. to CDH 5.2 and all hive tables with text input format are not able to give correct answers on select queries.

I see errors like:

14/12/31 04:43:16 [HiveServer2-Handler-Pool: Thread-26]: DEBUG lazy.LazyPrimitive: Data not in the BIGINT data type range so converted to null. Given data is :31252932,additionalemailaddress@gmail.com,42,detroit,detroit,pc

Basically Hive is not able to get the value of the selected column, which is a bigint type but is parsing entire row as first column.

These queries work perfectly fine with CDH 4.6.


댓글 없음:

댓글 쓰기