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

[#1]

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

[#2]

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

[#3 · Accepted solution]

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

[#4]

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