Re: Queries to custom serde return 'NULL' until hiveserver2 restart

2018-09-11 Thread Jason Gerlowski
Hi all, Thanks for the suggestion Gopal. It turns out the error occurs on both "SELECT *" and "SELECT col" queries. The only sort of query that seems safe are those with aggregations or other things that cause them to be run as mr tasks (e.g. "SELECT SUM(price_f) FROM my_external_table").

Re: Queries to custom serde return 'NULL' until hiveserver2 restart

2018-09-10 Thread Gopal Vijayaraghavan
>query the external table using HiveCLI (e.g. SELECT * FROM >my_external_table), HiveCLI prints out a table with the correct If the error is always on a "select *", then the issue might be the SerDe's handling of included columns. Check what you get for colNames =