question Re: Ambari Hive View output skips every 101st row in Archives of Support Questions (Read Only)

Ambari Hive View output skips every 101st row

bpreachuk — Mon, 19 Aug 2019 09:44:15 GMT

**** Update: This has been fixed in Ambari 2.5 (released April 4, 2017). See below for more details. ****

This has been observed in Ambari 2.4 using HDP 2.5.0/HDP 2.5.3.4-5.

Customer is having the issue and I am able to replicate it.

Using the Ambari Hive view, I'm running a simple select query. By using tpcds data, it is easy to spot the problem since the customer table has an auto-number row_id.

select c_customer_sk, c_customer_id, c_last_name from customer limit 204;

The query runs successfully & the results page in the browser every 50 rows.

The first page shows rows 1..50
the second page shows rows 51..100,
but the 3rd page starts with row 102. Row 101 is skipped on the output.

The 3rd page shows rows 102..151
The 4th page shows rows 152..201
but the 5th page starts with row 203. Row 202 is skipped on the output.

The same pattern is displayed when using "Save Results" -> "Download as CSV" - every 101st row is skipped.

In Beeline when I run the same query - no issues. All rows are displayed.

Have attempted to set the following values in Ambari but they don't affect the results:

set hive.cli.print.header=true;
set showHeader false (beeline)
set headerInterval 0

Thanks in advance for the assistance.

Re: Ambari Hive View output skips every 101st row

apappu — Tue, 11 Apr 2017 02:51:12 GMT

@bpreachuk

This is a bug and it was fixed in 2.4.x version but still not part of apache. If you are hortonworks customer you can request support for HOTFIX.

Re: Ambari Hive View output skips every 101st row

ciaran_porter5 — Tue, 11 Apr 2017 02:51:12 GMT

@bpreachuk @apappu Hey - I am having the same issue on Ambari using HDP 2.5 when looking to export results to csv format. Is there a workaround I could use to fix this?

Thanks!

Re: Ambari Hive View output skips every 101st row

bpreachuk — Mon, 19 Aug 2019 09:43:50 GMT

Update: This has been fixed in Ambari 2.5 (released April 4th, 2017). An added bonus is that Ambari 2.5 includes the new Hive View 2.0 - a vastly improved GUI for developing Hive apps. See attached picture:

Re: Ambari Hive View output skips every 101st row

bpreachuk — Tue, 11 Apr 2017 02:51:13 GMT

Thanks @apappu. I will request the hotfix for the customer.

Re: Ambari Hive View output skips every 101st row

bpreachuk — Tue, 11 Apr 2017 02:51:13 GMT

Hi @Ciarán Porter. There is a hotfix required for this issue. In the meantime you can use the beeline cli and send the output to a csv format. A good explanation is found here: https://community.hortonworks.com/questions/25789/how-to-dump-the-output-from-beeline.html