01-26-2018 11:12 AM
I came across table where i have to write HIVE query and table data is in a wierd way.
I have one table with 10 columns in HIVE where data is not on the same row.
first 5 columns have data and second five columns are empty(blank).
Now to complete my result sets, i have to join in a such a way that i can get complete row of data with "no empty".
Want to know if any one had encounter this issue or how ican do that.
Thank you in advance.
Solved! Go to Solution.
02-11-2018 06:43 PM
Is there text data in this result set? Are there new lines?
This can trip up Hive and Hue.
Try changing the file format to a binary format.
set hive.query.result.fileformat=SequenceFile; <query>