Support Questions
Find answers, ask questions, and share your expertise

While running sql commands in Zeppelin notebook

Explorer

%sql
select * from enrichedEvents order by hoursDriven desc limit 20

 

Table or view not found: enrichedEvents; line 1 pos 14
set zeppelin.spark.sql.stacktrace = true to see full stacktrace
 
Why this error coming in HDP 2.6.0 where no issues with HDP 3.0 sandbox. Any confugration changes in Zeppelin notebo
1 ACCEPTED SOLUTION

Super Collaborator

Hello @SurajP 

 

Thanks for using Cloudera Community. You mentioned the SQL works in Zeppelin Notebook on HDP v3.0 while doesn't work on HDP v2.6. 

 

The error posted by you points to the fact that the Table "enrichedEvents" isn't found. The same isn't likely caused by any Configuration issues, rather pointing to the absence of the Table. You haven't mentioned the Interpreter used, yet would request you to query the Metadata to confirm if the concerned Object "enrichedEvents" is listed in the Metadata. Accordingly, you can proceed with the SQL. 

 

- Smarak

View solution in original post

3 REPLIES 3

Super Collaborator

Hello @SurajP 

 

Thanks for using Cloudera Community. You mentioned the SQL works in Zeppelin Notebook on HDP v3.0 while doesn't work on HDP v2.6. 

 

The error posted by you points to the fact that the Table "enrichedEvents" isn't found. The same isn't likely caused by any Configuration issues, rather pointing to the absence of the Table. You haven't mentioned the Interpreter used, yet would request you to query the Metadata to confirm if the concerned Object "enrichedEvents" is listed in the Metadata. Accordingly, you can proceed with the SQL. 

 

- Smarak

Super Collaborator

@SurajP Can you check is hive-site.xml is copied to /etc/spark/conf/ if not please copy hive-site.xml to spark conf directory

 

Also Can you try running "show databases" command to check is all the databases are listing

 

 

Explorer

Solved. Thank you

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