Im pretty sure schema tool does this for people who convert to ha name node.
On Wednesday, May 17, 2017, Neil Jonkers <neilod...@gmail.com> wrote: > 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 > <javascript:_e(%7B%7D,'cvml','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 >> <javascript:_e(%7B%7D,'cvml','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 >>> <javascript:_e(%7B%7D,'cvml','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 >>>> <javascript:_e(%7B%7D,'cvml','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 >>>>> <javascript:_e(%7B%7D,'cvml','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 >>>>>> <javascript:_e(%7B%7D,'cvml','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 >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> > -- Sorry this was sent from mobile. Will do less grammar and spell check than usual.