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.
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>