hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marc Limotte <mslimo...@gmail.com>
Subject Re: DROP TABLE does not respect the IF EXISTS clause
Date Thu, 31 Jan 2013 21:57:05 GMT
Hi Mark,

A table.  But it doesn't seem to matter.  I get this error on the DROP,
before even attempting to create a table.  I get the same thing for any
arbitrary table name.  For example:

hive> DROP TABLE IF EXISTS kdsjhfkjhds;
FAILED: Error in semantic analysis: Table not found kdsjhfkjhds


I think I found something, though.  This install is still using the Derby
metastore, and the hive web service is running, so I'm getting errors like
"A read-only user or a user in a read-only database…".  I'm guessing the
error above is just a consequence of this one-user limitation.  So, the
real issue is that the error message reported by "DROP TABLE IF EXISTS" is
mis-leading and obscures the real problem.


thanks,
Marc

On Thu, Jan 31, 2013 at 11:42 AM, Mark Grover
<grover.markgrover@gmail.com>wrote:

> Marc,
> It seemed to work on my installation of Hive 0.9. Is this a table or a
> view you are trying to drop?
> Mind sharing the create table definition?
>
> Mark
>
>
> On Thu, Jan 31, 2013 at 10:42 AM, Marc Limotte <mslimotte@gmail.com>wrote:
>
>> Hi,
>>
>> I'm testing with Hive 0.9.0 (in Amazon EC2, but NOT emr).  I'm
>> experiencing a problem where DROP TABLE does not respect the IF EXISTS
>> clause, so it still throws an error when the table doesn't exist and this
>> causes the script to stop executing.  Here's what it looks like from the
>> hive shell:
>>
>> hive> DROP TABLE IF EXISTS recalc_aggregate_premium;
>>
>> FAILED: Error in semantic analysis: Table not found
>> recalc_aggregate_premium
>>
>>
>> Marc
>>
>>
>>
>

Mime
View raw message