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

yleigh — Thu, 25 May 2017 21:47:14 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.

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

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

Response(s) provided here: