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.markgro...@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 <mslimo...@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 >> >> >> >
