question While running sql commands in Zeppelin notebook in Support Questions

While running sql commands in Zeppelin notebook

SurajP — Sun, 10 Jan 2021 15:44:07 GMT

%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

Re: While running sql commands in Zeppelin notebook

smdas — Mon, 11 Jan 2021 06:07:33 GMT

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

Re: While running sql commands in Zeppelin notebook

Scharan — Mon, 11 Jan 2021 06:27:14 GMT

@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

Re: While running sql commands in Zeppelin notebook

SurajP — Mon, 18 Jan 2021 16:50:03 GMT

Solved. Thank you