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

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


Copy link to this message
-
DROP TABLE does not respect the IF EXISTS clause
Marc Limotte 2013-01-31, 18:42
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
+
Mark Grover 2013-01-31, 19:42
+
Marc Limotte 2013-01-31, 21:57
+
Harsh J 2013-02-01, 00:40
+
Marc Limotte 2013-02-01, 00:58
+
Mark Grover 2013-02-01, 01:02
+
Marc Limotte 2013-02-01, 16:54