question Re: Ambari's hive config references hive.metastore.heapsize - is this a real property? in Archives of Support Questions (Read Only)

Ambari's hive config references hive.metastore.heapsize - is this a real property?

vromeo — Tue, 23 Aug 2016 23:44:56 GMT

Ambari's hive config includes an entry for "Metastore Heap Size" and the context help says this corresponds to hive.metastore.heapsize, but I can't find any other reference to this parameter in Apache or any hadoop vendor's documentation. Is this actually a parameter? Where is it set? The value we are setting in Ambari does not appear to be affecting the actual heap being used on our server.

(Ambari 2.2.2.0)

Re: Ambari's hive config references hive.metastore.heapsize - is this a real property?

emaxwell — Tue, 23 Aug 2016 23:56:14 GMT

@Vincent Romeo

The hive.metastore.heapsize is not a parameter that is in a file like hive-site.xml. This value is used by Ambari for substitution into the hive-env template file. You can see this section in the text box in Ambari:

if [ "$SERVICE" = "metastore" ]; then
 export HADOOP_HEAPSIZE={{hive_metastore_heapsize}} # Setting for HiveMetastore
else
 export HADOOP_HEAPSIZE={{hive_heapsize}} # Setting for HiveServer2 and Client
fi

The {{hive_metastore_heapsize}} is where the substitution is made.

Re: Ambari's hive config references hive.metastore.heapsize - is this a real property?

vromeo — Wed, 24 Aug 2016 00:04:46 GMT

I think our hive-env template is missing the section related to setting the heapsize.... We're reaching out to support for a fresh copy of that.

Re: Ambari's hive config references hive.metastore.heapsize - is this a real property?

gael__urbauer — Thu, 19 Jan 2017 01:10:26 GMT

had the same problem on IBM BigInsight 4.1

You saved my day