No progress for Hive query on Sandbox 2.5,

[#1]

Hi everyone,

I am trying to execute the Hive query

SELECT driverId, sum(hours_logged), sum(miles_logged) FROM timesheet GROUP BY driverId;

From the 'how-to-process-data-with-apache-hive'-Tutorial. Creating the tables and all other previous steps worked fine but all aggregation queries just like the one above show no progress, as illustrated by this screenshot of the hive-command line:

The cluster I am using has 2 cores and 16 GM RAM.

I'd be grateful for any advice how to start trouble shooting the problem.

Cheers,

simon

,

[#2]

@Simon Birkholz , can you please check the resource manager UI for pending applications. Navigate to {YourHostname}:8088 to see the list of applications. Make sure you have enough resources to run your applications. If the most recent application is still in the queue, kill other applications by simply clicking on it and you will see a Kill Application button on the next page. Let us know if this works for you.

[#3]

Thanks for your response, Mushtaq. I have no access to the sandbox until monday, but I will follow your instructions and give feedback asap.

Cheers,

simon

[#4]

I checked the list of applications as suggested and made sure there is no application running.

I am not certain how to check whether I have enough resources. In the Hive Configs page I left everything at recommended settings. When I run the query I mentioned above, the resource manager UI indicates that no CPU VCores and no Memory is allocated. How do I check that I configured Hive correctly?