Hi, Inspecting the Hive Metastore tables. Table SDS has a location field.
If for reason this does not work: "ALTER TABLE ... SET LOCATION ... ?" Manually updating the SDS metadata table is an option : update SDS set location = "hdfs://Node:8020/user/hive/warehouse/t" where ... On Wed, May 17, 2017 at 8:41 PM, Furcy Pin <furcy....@flaminem.com> wrote: > for that, sublime text + multi-line edit is your friend ! > > https://www.youtube.com/watch?v=-paR5m6m-Nw > > On Wed, May 17, 2017 at 7:24 PM, Stephen Sprague <sprag...@gmail.com> > wrote: > >> yeah. that's a potential idea too. gotta put the time in to script it >> with 200+ tables though. >> >> On Wed, May 17, 2017 at 10:07 AM, Furcy Pin <furcy....@flaminem.com> >> wrote: >> >>> Did you try ALTER TABLE ... SET LOCATION ... ? maybe it could have >>> worked. >>> >>> >>> On Wed, May 17, 2017 at 6:57 PM, Vihang Karajgaonkar < >>> vih...@cloudera.com> wrote: >>> >>>> This is interesting and possibly a bug. Did you try changing them to >>>> managed tables and then dropping or truncating them? How do we reproduce >>>> this on our setup? >>>> >>>> On Tue, May 16, 2017 at 6:38 PM, Stephen Sprague <sprag...@gmail.com> >>>> wrote: >>>> >>>>> fwiw. i ended up re-creating the ec2 cluster with that same host name >>>>> just so i could drop those tables from the metastore. >>>>> >>>>> note to self. be careful - be real careful - with "sharing" hive >>>>> metastores between different compute paradigms. >>>>> >>>>> Regards, >>>>> Stephen. >>>>> >>>>> On Tue, May 16, 2017 at 6:38 AM, Stephen Sprague <sprag...@gmail.com> >>>>> wrote: >>>>> >>>>>> 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 >>>>>> >>>>> >>>>> >>>> >>> >> >
