Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Explorer

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.

1 ACCEPTED SOLUTION

avatar
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
3 REPLIES 3

avatar
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
Explorer

Yes, this fixed the issue.

One extra is in 'Tez' container size, I changed it to recommended size, was 256MB, which might be the problem.

avatar

Awesome! Glad it worked.