question Re: I am working through Lab 6 - Data Reporting with Zeppelin and have run into a problem with Step 6.3.1. in Archives of Support Questions (Read Only)

I am working through Lab 6 - Data Reporting with Zeppelin and have run into a problem with Step 6.3.1.

Richard_Posylek — Wed, 16 Mar 2016 23:44:26 GMT

I am running the following query as substep 8 of Step 6.3.1 in the Zeppelin tutorial and the query does not finish. If I take the join out and select from either table it works fine.

%hive

SELECT a.driverid, a.riskfactor, b.city, b.state

FROM finalresults a, geolocation b where a.driverid=b.driverid

Re: I am working through Lab 6 - Data Reporting with Zeppelin and have run into a problem with Step 6.3.1.

aervits — Tue, 03 May 2016 06:05:07 GMT

Are you still having issues? Can you post the error messages you get from the Hive logs directory?

Re: I am working through Lab 6 - Data Reporting with Zeppelin and have run into a problem with Step 6.3.1.

Richard_Posylek — Wed, 04 May 2016 03:08:28 GMT

Must have been a memory issue. I restarted the sandbox and it worked fine.

Re: I am working through Lab 6 - Data Reporting with Zeppelin and have run into a problem with Step 6.3.1.

vakana54 — Wed, 15 Jun 2016 15:02:31 GMT

I restarted the sanbox services and it worked again. Is it windows? Almost all problems solved by restart.