Support Questions

Find answers, ask questions, and share your expertise

Query execution time

Hi, I am new to Hadoop. I started uisng Ambari. I am following this tutorial : -

https://hortonworks.com/hadoop-tutorial/hello-world-an-introduction-to-hadoop-hcatalog-hive-and-pig/...

in this section : -

2.6.2 LOAD SAMPLE DATA OF TRUCK_MILEAGE

I am at the last step number 8 where it says Execute the “average mpg” query and view its results.

This query is running from last 2 hours. I believe its not normal. Can anyone help me. I can't really move forward.

1 ACCEPTED SOLUTION

Expert Contributor

Hi @Rajinder Kaur,

The step 8 should not take more than 3 seconds. Can you make sure you followed all the steps as instructed.

Also wanted to check if you created sandbox in Azure? If so there are certain configurations that needs to be changed, thats also been instructed as part of the lab.

Please rerun the steps and let me know if that works.

Attached the output screen shots just for reference.

Thanks,

Sujitha

5981-screen-shot-2016-07-21-at-25204-pm.png

View solution in original post

4 REPLIES 4

Expert Contributor

Hi @Rajinder Kaur,

The step 8 should not take more than 3 seconds. Can you make sure you followed all the steps as instructed.

Also wanted to check if you created sandbox in Azure? If so there are certain configurations that needs to be changed, thats also been instructed as part of the lab.

Please rerun the steps and let me know if that works.

Attached the output screen shots just for reference.

Thanks,

Sujitha

5981-screen-shot-2016-07-21-at-25204-pm.png

No iam not using azure

@s

I skipped the step 4 because i am not in azure. I moved to step 5. @sujitha sanku

I changed the Hive-Tez Java Opts from 200 to 512 and it worked. Thanks

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.