question Re: HDP Sandbox 2.6 Hive/Hive 2 'SELECT COUNT' or 'SELECT DISTINCT' hangs in Archives of Support Questions (Read Only)

HDP Sandbox 2.6 Hive/Hive 2 'SELECT COUNT' or 'SELECT DISTINCT' hangs

yleigh — Thu, 25 May 2017 21:43:52 GMT

I just used the tutorial table drivers/timesheets table.

SELECT dirverid from drivers;

runs fine. It's a small table. But:

SELECT DISTINCT driverid from drivers;

SELECT COUNT(*) from drivers;

just hangs, never completes. I have to restart HIVE to stop it running.

I just use Virtual Box load the downloaded HortonWorks Sandbox 2.6, no configuration changes.

It works with HDP 2.5 though.

egarelnabi — Thu, 25 May 2017 22:36:58 GMT

Response(s) provided here:

yleigh — Thu, 25 May 2017 22:48:03 GMT

Sorry, How do I close the duplicates?

When i posted, each time browser got 504, so no idea three of them got posted.