Support Questions

Find answers, ask questions, and share your expertise

HDP Tutorial 2.6 #build-charts-using-zeppelin %jdbc(hive) problem

New Contributor


I am walking through HDP Tutorial 2 (hadoop-tutorial-getting-started-with-hdp), Section 6 (data-reporting-with-zeppelin), and I am having trouble getting the query in step 8 (build-charts-using-zeppelin) to finish:

SELECT a.driverid, a.riskfactor,, b.state
FROM riskfactor a, geolocation b where a.driverid=b.driverid

Zeppelin can start and finish both of the following queries quickly and easily:

SELECT, b.state FROM geolocation b
SELECT a.driverid, a.riskfactor FROM riskfactor a

However, I have been running the select from geolocation and riskfactor for over 24 hours, and it still has not completed. I'm running the HDP Sandbox in VMware Workstation on a Dell ultrabook with a 2.3Ghz i5 proc and 16GB RAM. Any ideas why this query isn't completing?



Same issue; I am running the HDP Sandbox in Virtual Box using 16GM RAM.

Rising Star

I expect an java out of memory error.

Rising Star

and Even though enough mem resource in my server(128GB Ram),

We see the message "Output is truncated to 1000 rows. Learn more about common.max_count"

because of zeppelin configuration.