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
Thanks, Harsh.   My issues seems to be related to the one-user limitation
of the derby metastore.  Once that issue was resolved the "table not found"
error went away.  It was just a misleading error message.

Marc

On Thu, Jan 31, 2013 at 4:40 PM, Harsh J <[EMAIL PROTECTED]> wrote:

> Not sure how relevant it is but I faced a similar problem around ALTER
> TABLE DROP PARTITION IF EXIST.
>
> See https://issues.apache.org/jira/browse/HIVE-3576 for the specific
> issue and my commands to reproduce it, and also try to perhaps set
> hive.exec.drop.ignorenonexistent to true to see if it changes anything
> for you?
>
> On Fri, Feb 1, 2013 at 3:27 AM, Marc Limotte <[EMAIL PROTECTED]> wrote:
> > 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
> >>>
> >>>
> >>
> >
>
>
>
> --
> Harsh J
>