While running sql commands in Zeppelin notebook

Question

%sqlselect * from enrichedEvents order by hoursDriven desc limit 20 Table or view not found: enrichedEvents; line 1 pos 14set 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

smdas · Accepted Answer

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

Scharan · Answer

@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

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.