question HUE - HIVE question in Archives of Support Questions (Read Only)

HUE - HIVE question

HiveQ — Fri, 16 Sep 2022 12:47:31 GMT

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 — Sun, 28 Jan 2018 08:53:06 GMT

would you consider using is null built-in operator

please refer the below link

HiveQ — Mon, 29 Jan 2018 02:51:26 GMT

I tried that already, no luck.

Thanks

David M. — Mon, 12 Feb 2018 02:43:29 GMT

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 — Mon, 12 Feb 2018 02:51:48 GMT

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