01-26-2018 11:12 AM
Hello:
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.
Thanks
01-28-2018 12:53 AM
would you consider using is null built-in operator
please refer the below link
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF
01-28-2018 06:51 PM
I tried that already, no luck.
Thanks
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>
02-11-2018 06:51 PM
I have to send back to fix the data & in the format i can query. developer import data that was not massage correctly.