Hive bug? about no such table

[Philip Lee]

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

[Philip Lee]

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

[Ufuk Celebi-2]

> On 18 Dec 2015, at 11:07, Philip Lee <[hidden email]> wrote:
>
> Opps, sorry
>
> I was supposed to email this one to hive mailiing list.

No problem. Can happen easily with auto completion ;)

– Ufuk