Re: 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-tp4082p4084.html

Opps, sorry 

I was supposed to email this one to hive mailiing list.

On Fri, Dec 18, 2015 at 2:19 AM, Philip Lee <[hidden email]> wrote:

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