fail to run Hive Metastore Service on Postgres hot-standby replication

2023-09-12 Thread Mingmin Xu
Hello, I'm deploying a readonly HMS on a replication DB to offload some traffic on the primary DB, however it fails with error message as below, although the default value for `datanucleus.transactionIsolation` is `read-committed`, we tried to set it as `repeatable-read`, same problem. ``` Caused

Re: Hive metastore service

2019-04-17 Thread Odon Copon
M > *To:* user@hive.apache.org > *Subject:* Re: Hive metastore service > > > > Hi, > > I don't know if I am not understanding properly the design, but, isn't > there supposed to be a Hive metastore service that Hive server uses to > access the metastore db?

RE: Hive metastore service

2019-04-17 Thread Shawn Weeks
@hive.apache.org Subject: Re: Hive metastore service Hi, I don't know if I am not understanding properly the design, but, isn't there supposed to be a Hive metastore service that Hive server uses to access the metastore db? On Tue, 16 Apr 2019, 22:26 Mich Talebzadeh, mailto:mich.talebza...

Re: Hive metastore service

2019-04-17 Thread Odon Copon
Hi, I don't know if I am not understanding properly the design, but, isn't there supposed to be a Hive metastore service that Hive server uses to access the metastore db? On Tue, 16 Apr 2019, 22:26 Mich Talebzadeh, wrote: > Try this > > Assuming that you are talking about

Re: Hive metastore service

2019-04-16 Thread Mich Talebzadeh
authentication to the Thrift Hive metastore > service? like user and password? > I cannot find any documentation on how to protect this endpoint. > Thanks. >

Hive metastore service

2019-04-16 Thread Odon Copon
Hi, would be possible to add authentication to the Thrift Hive metastore service? like user and password? I cannot find any documentation on how to protect this endpoint. Thanks.

答复: Can I specify database name in hive metastore service?

2016-10-27 Thread Huang Meilong
19:06:32 收件人: Huang Meilong 抄送: user@hive.apache.org 主题: Re: Can I specify database name in hive metastore service? Hi Huang, It is possible to use the same Metastore server for 2 HiveServer2 instances, but then the HiveServer2 instances will share the metastore. They will have the same dat

Re: Can I specify database name in hive metastore service?

2016-10-27 Thread Peter Vary
HiveServers. Here someone with more experience might help more. Thanks, Peter > On Oct 27, 2016, at 4:41 AM, Huang Meilong wrote: > > Thanks Peter for your detailed explanation, it works now. > > BTW, can I start 2 HiveServer2 instances with ONLY ONE remote metastore > service and

答复: Can I specify database name in hive metastore service?

2016-10-26 Thread Huang Meilong
Thanks Peter for your detailed explanation, it works now. BTW, can I start 2 HiveServer2 instances with ONLY ONE remote metastore service and make the metastore db stored in the same RDBMS in a different database? 发件人: Peter Vary 发送时间: 2016年10月26日 21:11:26 收件人

Re: Can I specify database name in hive metastore service?

2016-10-26 Thread Mich Talebzadeh
astore services work fine? > > In short, I want to use the same RDBMS database for the two hive > metastore services, and the meta data is isolated form each other. How > can I achieve that? > > > > ------ > *发件人:* Peter Vary > *发送时间:* 2016年10月26日 0

Re: Can I specify database name in hive metastore service?

2016-10-26 Thread Peter Vary
ted form each other. How can I achieve > that? > > > > 发件人: Peter Vary > 发送时间: 2016年10月26日 0:49 > 收件人: user@hive.apache.org > 主题: Re: Can I specify database name in hive metastore service? > > Hi Huang, > Hive metastore is a component of the "Hive databas

答复: Can I specify database name in hive metastore service?

2016-10-25 Thread Huang Meilong
发件人: Peter Vary 发送时间: 2016年10月26日 0:49 收件人: user@hive.apache.org 主题: Re: Can I specify database name in hive metastore service? Hi Huang, Hive metastore is a component of the "Hive database". See: https://cwiki.apache.org/confluence/display/Hive/Design The metastor

Re: Can I specify database name in hive metastore service?

2016-10-25 Thread Peter Vary
pe this helps, Peter 2016. okt. 25. 17:32 ezt írta ("Huang Meilong" ): > Hi, > > > To use hive metastore service, I must set `javax.jdo.option.ConnectionURL`, > `javax.jdo.option.ConnectionDriverName` and `hive.metastore.uris` in > hive-site.xml, like this:

Can I specify database name in hive metastore service?

2016-10-25 Thread Huang Meilong
Hi, To use hive metastore service, I must set `javax.jdo.option.ConnectionURL`, `javax.jdo.option.ConnectionDriverName` and `hive.metastore.uris` in hive-site.xml, like this: javax.jdo.option.ConnectionURL jdbc:mysql://x/hivemeta?createDatabaseIfNotExist=true

Does hive metastore service support proxy user access ?

2016-03-15 Thread Jeff Zhang
I try to access hive metastore service using proxy user, but didn't succeed. I just wonder whether hive metastore support this kind of access ? 16/03/15 08:57:57 DEBUG security.UserGroupInformation: PrivilegedAction as:jeff (auth:PROXY) via l...@example.com (auth:KER

Configuring Hive metastore service to use SAP ASE as container for metastore

2015-03-09 Thread Mich Talebzadeh
Hi, As you may be aware hive metastore stores hive metadata in a relational database. The recommendation is to have this database in a remote container. Currently this database can be created "remotely" on MySQL and PostgresSQL plus Oracle and I believe MSSQL. I have now adapted the relevan

hive metastore service uses

2015-01-08 Thread Bharath Kumar
Hi Team, I fail to understand what is the use of hive metastore service when hive service can connect to metastore directly using jdbc ? -- Warm Regards, *Bharath Kumar *

RE: Metastore service

2014-05-16 Thread Dima Machlin
Thanks a lot Bryan that did the trick. From: Bryan Jeffrey [mailto:bryan.jeff...@gmail.com] Sent: Wednesday, May 14, 2014 8:47 PM To: user@hive.apache.org Subject: Re: Metastore service Dima, You can simply set the variable in your hive-site.xml: datanucleus.connectionPool.maxPoolSize 20

Metastore service

2014-05-15 Thread Dima Machlin
Hi, Starting the metastore (Hive 0.12) service there is a WARNING [main] WARN bonecp.BoneCPConfig: Max Connections < 1. Setting to 20 What does this setting mean? Max connections from hive servers to the metastore? How can this be changed? Thanks.

Re: Metastore service

2014-05-14 Thread Bryan Jeffrey
Dima, You can simply set the variable in your hive-site.xml: datanucleus.connectionPool.maxPoolSize 20 creates an annoying log message if this is not set The default value is -1, so it is just warning you that it is setting the maximum number of connections to a valid value (default 20)

Multiple metastore service question

2012-05-13 Thread Xiaobo Gu
Hi, >From the documentation I know that we can use multiple stand alone metastore services for high availability purpose, but what happens to these cases: 1. Define new objects or update existing objects through one metastore service, does the operation known to other metastore serv

Re: RE: Where should I put JDBC drivers for metastore service

2012-05-12 Thread Xiaobo Gu
I am sorry, I forget starting hadoop first, but the error messages are confusing too :) Xiaobo Gu From: ransom.hezhiqiang Date: 2012-05-12 15:46 To: user@hive.apache.org; 'guxiaobo1982' Subject: RE: Where should I put JDBC drivers for metasto

RE: Where should I put JDBC drivers for metastore service

2012-05-12 Thread ransom.hezhiqiang
ssage- From: Xiaobo Gu [mailto:guxiaobo1...@gmail.com] Sent: Saturday, May 12, 2012 3:37 PM To: user Subject: Where should I put JDBC drivers for metastore service Hi, I put mysql-connector-java-5.1.20-bin.jar into $HIVE_HOME/lib, and configurations in hive-site.xm

Where should I put JDBC drivers for metastore service

2012-05-12 Thread Xiaobo Gu
Hi, I put mysql-connector-java-5.1.20-bin.jar into $HIVE_HOME/lib, and configurations in hive-site.xml are javax.jdo.option.ConnectionURL jdbc:mysql://192.168.72.1:3306/hive JDBC connect string for a JDBC metastore javax.jdo.option.ConnectionDriverName com.mysql.jdbc.Driver Drive

Re: Stopping Hive Metastore Service

2011-01-27 Thread Dave Brondsema
That's what we do, seems to be ok. On Tue, Jan 25, 2011 at 2:40 PM, Matias Silva wrote: > Hi I’m in the process of setting up an init script for the hive metastore. > Whats the proper way > > to shutdown the hive metastore without killing pid? Or is killing the pid > the only way? > > > > http://

Stopping Hive Metastore Service

2011-01-25 Thread Matias Silva
Hi I'm in the process of setting up an init script for the hive metastore. Whats the proper way to shutdown the hive metastore without killing pid? Or is killing the pid the only way? http://wiki.apache.org/hadoop/Hive/AdminManual/MetastoreAdmin Thanks, Matt Matias Silva [Sr. Software Engin