Support Questions

Find answers, ask questions, and share your expertise

exercies 2 : Error while compiling statement: FAILED: SemanticException [Error 10001]

avatar
New Contributor

Hi i'm beginner on hadoop i install quickstart cloudera vm -5.12.0-0- on my laptop
i want to analysis some logs with hadoop
i try do exercise 2
but when i want to run query on hive
i get this error

Error while compiling statement: FAILED: SemanticException [Error 10001]: line 32:59 Table not found 'intermediate_access_logs'

how should i fix this problem?
Thanks

2 REPLIES 2

avatar
New Contributor

I met the same issue and I resolved it by separating the last query statement with others. 

 

So I run the sql statements( all but without last one) to create the tables and then run the last statement separately. 

avatar
New Contributor

thank you , it works with me after your solution thanks alot