hey guys, here's something bizarre. i created about 200 external tables with a location something like this 'hdfs://<ec2-host>/path'. this was three months ago and now i'm revisiting and want to drop these tables.
ha! no can do! that <ec2-host> is long gone. Upon issuing the drop table command i get this: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.lang.IllegalArgumentException: java.net.UnknownHostException: <ec2-host>) where <ec2-host> is that old host name. so i ask is there a work around for this? given they are external tables i'm surprised it "checks" that that location exists (or not.) thanks, Stephen
