Im pretty sure schema tool does this for people who convert to ha name node.
On Wednesday, May 17, 2017, Neil Jonkers 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
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
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 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,
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 wrote:
> Did you try ALTER TABLE ... SET LOCATION ... ? maybe it could have worked.
>
>
> On Wed, May 17, 2017 at 6:57 PM, Vihang Karajgaonkar
> wrote:
>
>
hi vihang,
here's how to duplicate (hive version 2.1.0).
1. install hadoop on a host called "test-nn"
2. install hive on a host called "hive-client" and use a metastore on
"hive-client" (or anywhere else except "test-nn").
3. using hive on "hive-client" do this: create external table foo(a int)
Did you try ALTER TABLE ... SET LOCATION ... ? maybe it could have worked.
On Wed, May 17, 2017 at 6:57 PM, Vihang Karajgaonkar
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
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 wrote:
> fwiw. i ended up re-creating the ec2 cluster with that same host name just
>
