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

[#1]

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;

or

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.

[#2 · Accepted solution]

Response(s) provided here:

https://community.hortonworks.com/questions/104805/hdp-sandbox-26-hivehive-2-select-count-or-select-...