HUE - HIVE question

[HiveQ]

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

[csguna]

would you consider using  is null built-in operator 

please refer the below link 

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF

[HiveQ]

I tried that already, no luck.

Thanks

[David M.]

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>

[HiveQ · Accepted solution]

I have to send back to fix the data & in the format i can query. developer import data that was not massage correctly.