You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Dima Machlin <Di...@pursway.com> on 2014/05/14 15:38:18 UTC

Metastore service

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

Posted by Dima Machlin <Di...@pursway.com>.

Thanks a lot Bryan that did the trick.

From: Bryan Jeffrey [mailto:bryan.jeffrey@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:

<property>
  <name>datanucleus.connectionPool.maxPoolSize</name>
  <value>20</value>
  <description>creates an annoying log message if this is not set</description>
</property>

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).  20 has worked for us -- we just added the setting to get rid of the warning.

Regards,

Bryan Jeffrey

On Wed, May 14, 2014 at 9:38 AM, Dima Machlin <Di...@pursway.com>> wrote:
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.

************************************************************************************
This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals & computer viruses.
************************************************************************************

Re: Metastore service

Posted by Bryan Jeffrey <br...@gmail.com>.

Dima,

You can simply set the variable in your hive-site.xml:

<property>
  <name>datanucleus.connectionPool.maxPoolSize</name>
  <value>20</value>
  <description>creates an annoying log message if this is not
set</description>
</property>

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).  20 has worked
for us -- we just added the setting to get rid of the warning.

Regards,

Bryan Jeffrey

On Wed, May 14, 2014 at 9:38 AM, Dima Machlin <Di...@pursway.com>wrote:

>  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.
>