Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HUE - HIVE question

SOLVED Go to solution

HUE - HIVE question

New Contributor

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

Accepted Solutions

Re: HUE - HIVE question

New Contributor

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

4 REPLIES 4

Re: HUE - HIVE question

Champion

would you consider using  is null built-in operator 

please refer the below link 

 

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

Re: HUE - HIVE question

New Contributor

I tried that already, no luck.

 

Thanks

Highlighted

Re: HUE - HIVE question

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>

 

Re: HUE - HIVE question

New Contributor

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