[ https://issues.apache.org/jira/browse/TRAFODION-2041?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15321209#comment-15321209 ]
David Wayne Birdsall edited comment on TRAFODION-2041 at 6/8/16 6:56 PM: ------------------------------------------------------------------------- I was able to reproduce this issue on a workstation by adding the following to hbase-site.xml in the usual install_local_hadoop configuration: <property> <name>hbase.bucketcache.ioengine</name> <value>offheap</value> </property> <property> <name>hbase.bucketcache.size</name> <value>1000</value> </property> (I had to experiment with the hbase.bucketcache.size parameter a few times to make it small enough that HMaster could come up.) I found that the original suggested fix still failed with an OOM. Therefore, I changed the fix to simply unset the hbase.bucketcache.ioengine property in HBaseClient.estimateRowCount if it is found. was (Author: davebirdsall): I was able to reproduce this issue on a workstation by adding the following to hbase-site.xml in the usual install_local_hadoop configuration: <property> \<name\>hbase.bucketcache.ioengine\</name\> \<value\>offheap\</value\> \</property\> \<property\> \<name\>hbase.bucketcache.size\</name\> \<value\>1000\</value\> \</property\> (I had to experiment with the hbase.bucketcache.size parameter a few times to make it small enough that HMaster could come up.) I found that the original suggested fix still failed with an OOM. Therefore, I changed the fix to simply unset the hbase.bucketcache.ioengine property in HBaseClient.estimateRowCount if it is found. > UPDATE STATS uses select count(*) on large tables on HDP 2.3.4 > -------------------------------------------------------------- > > Key: TRAFODION-2041 > URL: https://issues.apache.org/jira/browse/TRAFODION-2041 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp > Affects Versions: 2.1-incubating > Reporter: David Wayne Birdsall > Assignee: David Wayne Birdsall > Priority: Critical > Fix For: 2.1-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)