hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Grover <grover.markgro...@gmail.com>
Subject Re: DROP TABLE does not respect the IF EXISTS clause
Date Thu, 31 Jan 2013 19:42:18 GMT
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