Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

New Contributor

38608-zeppelin-select-query-started-a-day-ago-will-not-f.png

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:

%jdbc(hive)
SELECT a.driverid, a.riskfactor, b.city, 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:

%jdbc(hive)
SELECT b.city, b.state FROM geolocation b
%jdbc(hive)
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?

3 REPLIES 3

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

New Contributor

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

Highlighted

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

Contributor

I expect an java out of memory error.

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

Contributor

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.

64853-zep-ex.png

Don't have an account?
Coming from Hortonworks? Activate your account here