Hive bug? about no such table

Posted by Philip Lee on
URL: http://deprecated-apache-flink-user-mailing-list-archive.369.s1.nabble.com/Hive-bug-about-no-such-table-tp4082.html

I think It is from Hive Bug about something related to metastore.

Here is the thing.

After I generated scale factor 300 named bigbench300 and bigbench100, which already existed before,
I run "hive job with bigbench300". At first it was really fine.
Then I run hive job with bigbench100 again. It was still okay.
but then when I run bigbench300 again, the error "no such table" happened.

<< FAILED: SemanticException [Error 10001]: Line 8:7 Table not found 'product_reviews' >>

I tried to delete every "metastore_db" in a whole folder, but it still happens now.

Have you ever seen this kind of issue before?
I think there is something, belonging to hive metastore conf, leading this problem.
I did not see much infomation about this in Stackoverflow yet.

Best,
Philip