Support Questions

Find answers, ask questions, and share your expertise

Getting error Table not found 'tweets_simple'

avatar
New Contributor

Got below error while running the query as given in tutorial. query: CREATE VIEW IF NOT EXISTS tweets_clean AS SELECT t.tweet_id, t.ts, t.msg, m.country FROM tweets_simple t LEFT OUTER JOIN time_zone_map m ON t.time_zone = m.time_zone; Error: Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 7:6 Table not found 'tweets_simple' [ERROR_STATUS]

1 ACCEPTED SOLUTION

avatar
New Contributor

I was making a view [tweets_clean] using another view [tweets_simple] as given in the sample tutorial. Initially error was "Table not found 'tweets_simple' " but after restart it has gone now.

View solution in original post

2 REPLIES 2

avatar
Master Mentor

Take a look whether you're in proper database, I.e.

use default;

select statement

avatar
New Contributor

I was making a view [tweets_clean] using another view [tweets_simple] as given in the sample tutorial. Initially error was "Table not found 'tweets_simple' " but after restart it has gone now.