You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Veera Naranammalpuram <vn...@maprtech.com> on 2016/05/31 19:01:36 UTC

HiveMetastore HA with Drill

Anyone has any insights into how the Hive storage plug-in can handle Hive
MetaStore HA? The Hive storage plug-in has only one property for
hive.metastore.uris and it takes only one IP:port. When I add a second one,
the update of the storage plug-in fails.

  "configProps": {
    "hive.metastore.uris": "thrift://<ip>:9083"
  }

How can we give 2 IP's to Drill so it knows to try the second IP if its not
able to talk to the first one?

Thanks in advance.

-- 
Veera Naranammalpuram
Product Specialist - SQL on Hadoop
*MapR Technologies (www.mapr.com <http://www.mapr.com>)*
*(Email) vnaranammalpuram@maprtech.com <na...@maprtech.com>*
*(Mobile) 917 683 8116 - can text *
*Timezone: ET (UTC -5:00 / -4:00)*

Re: HiveMetastore HA with Drill

Posted by Veera Naranammalpuram <vn...@maprtech.com>.
This is helpful. Thank you!

-Veera

On Thu, Jun 2, 2016 at 1:56 PM, Venki Korukanti <ve...@gmail.com>
wrote:

> Looking at the HiveMetaStoreClient code, following format is accepted:
>
> "hive.metastore.uris": "thrift://<ip1>:9083,thrift://<ip2>:9083,
> thrift://<ip3>:9083"
>
> Thanks
> Venki
>
> On Thu, Jun 2, 2016 at 10:23 AM, rahul challapalli <
> challapallirahul@gmail.com> wrote:
>
> > Not sure if our hive storage plugin supports this feature. Even if the
> > feature is available, we haven't tested it.
> >
> > - Rahul
> >
> > On Tue, May 31, 2016 at 12:01 PM, Veera Naranammalpuram <
> > vnaranammalpuram@maprtech.com> wrote:
> >
> > > Anyone has any insights into how the Hive storage plug-in can handle
> Hive
> > > MetaStore HA? The Hive storage plug-in has only one property for
> > > hive.metastore.uris and it takes only one IP:port. When I add a second
> > one,
> > > the update of the storage plug-in fails.
> > >
> > >   "configProps": {
> > >     "hive.metastore.uris": "thrift://<ip>:9083"
> > >   }
> > >
> > > How can we give 2 IP's to Drill so it knows to try the second IP if its
> > not
> > > able to talk to the first one?
> > >
> > > Thanks in advance.
> > >
> > > --
> > > Veera Naranammalpuram
> > > Product Specialist - SQL on Hadoop
> > > *MapR Technologies (www.mapr.com <http://www.mapr.com>)*
> > > *(Email) vnaranammalpuram@maprtech.com <na...@maprtech.com>*
> > > *(Mobile) 917 683 8116 - can text *
> > > *Timezone: ET (UTC -5:00 / -4:00)*
> > >
> >
>



-- 
Veera Naranammalpuram
Product Specialist - SQL on Hadoop
*MapR Technologies (www.mapr.com <http://www.mapr.com>)*
*(Email) vnaranammalpuram@maprtech.com <na...@maprtech.com>*
*(Mobile) 917 683 8116 - can text *
*Timezone: ET (UTC -5:00 / -4:00)*

Re: HiveMetastore HA with Drill

Posted by Venki Korukanti <ve...@gmail.com>.
Looking at the HiveMetaStoreClient code, following format is accepted:

"hive.metastore.uris": "thrift://<ip1>:9083,thrift://<ip2>:9083,
thrift://<ip3>:9083"

Thanks
Venki

On Thu, Jun 2, 2016 at 10:23 AM, rahul challapalli <
challapallirahul@gmail.com> wrote:

> Not sure if our hive storage plugin supports this feature. Even if the
> feature is available, we haven't tested it.
>
> - Rahul
>
> On Tue, May 31, 2016 at 12:01 PM, Veera Naranammalpuram <
> vnaranammalpuram@maprtech.com> wrote:
>
> > Anyone has any insights into how the Hive storage plug-in can handle Hive
> > MetaStore HA? The Hive storage plug-in has only one property for
> > hive.metastore.uris and it takes only one IP:port. When I add a second
> one,
> > the update of the storage plug-in fails.
> >
> >   "configProps": {
> >     "hive.metastore.uris": "thrift://<ip>:9083"
> >   }
> >
> > How can we give 2 IP's to Drill so it knows to try the second IP if its
> not
> > able to talk to the first one?
> >
> > Thanks in advance.
> >
> > --
> > Veera Naranammalpuram
> > Product Specialist - SQL on Hadoop
> > *MapR Technologies (www.mapr.com <http://www.mapr.com>)*
> > *(Email) vnaranammalpuram@maprtech.com <na...@maprtech.com>*
> > *(Mobile) 917 683 8116 - can text *
> > *Timezone: ET (UTC -5:00 / -4:00)*
> >
>

Re: HiveMetastore HA with Drill

Posted by rahul challapalli <ch...@gmail.com>.
Not sure if our hive storage plugin supports this feature. Even if the
feature is available, we haven't tested it.

- Rahul

On Tue, May 31, 2016 at 12:01 PM, Veera Naranammalpuram <
vnaranammalpuram@maprtech.com> wrote:

> Anyone has any insights into how the Hive storage plug-in can handle Hive
> MetaStore HA? The Hive storage plug-in has only one property for
> hive.metastore.uris and it takes only one IP:port. When I add a second one,
> the update of the storage plug-in fails.
>
>   "configProps": {
>     "hive.metastore.uris": "thrift://<ip>:9083"
>   }
>
> How can we give 2 IP's to Drill so it knows to try the second IP if its not
> able to talk to the first one?
>
> Thanks in advance.
>
> --
> Veera Naranammalpuram
> Product Specialist - SQL on Hadoop
> *MapR Technologies (www.mapr.com <http://www.mapr.com>)*
> *(Email) vnaranammalpuram@maprtech.com <na...@maprtech.com>*
> *(Mobile) 917 683 8116 - can text *
> *Timezone: ET (UTC -5:00 / -4:00)*
>