Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

HUE - HIVE question

avatar
Explorer

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

1 ACCEPTED SOLUTION

avatar
Explorer

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

View solution in original post

4 REPLIES 4

avatar
Champion

would you consider using  is null built-in operator 

please refer the below link 

 

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

avatar
Explorer

I tried that already, no luck.

 

Thanks

avatar
Expert Contributor

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>

 

avatar
Explorer

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