question Re: Getting error Table not found 'tweets_simple' in Archives of Support Questions (Read Only)

Getting error Table not found 'tweets_simple'

psingh — Sat, 16 Jul 2016 18:59:17 GMT

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]

Re: Getting error Table not found 'tweets_simple'

aervits — Sat, 16 Jul 2016 23:18:46 GMT

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

use default;

select statement

Re: Getting error Table not found 'tweets_simple'

psingh — Sun, 17 Jul 2016 13:56:31 GMT

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.