Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - DROP TABLE does not respect the IF EXISTS clause


Copy link to this message
-
Re: DROP TABLE does not respect the IF EXISTS clause
Marc Limotte 2013-01-31, 21:57
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
<[EMAIL PROTECTED]>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 <[EMAIL PROTECTED]>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
>>
>>
>>
>