Reply
Highlighted
New Contributor
Posts: 5
Registered: ‎01-26-2018
Accepted Solution

HUE - HIVE question

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

Champion
Posts: 632
Registered: ‎05-16-2016

Re: HUE - HIVE question

would you consider using  is null built-in operator 

please refer the below link 

 

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

New Contributor
Posts: 5
Registered: ‎01-26-2018

Re: HUE - HIVE question

I tried that already, no luck.

 

Thanks

Cloudera Employee
Posts: 28
Registered: ‎11-20-2015

Re: HUE - HIVE question

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>

 

New Contributor
Posts: 5
Registered: ‎01-26-2018

Re: HUE - HIVE question

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

Announcements