[jira] [Comment Edited] (TRAFODION-2041) UPDATE STATS uses select count(*) on large tables on HDP 2.3.4

[David Wayne Birdsall (JIRA)]

[ 
https://issues.apache.org/jira/browse/TRAFODION-2041?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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:

 
 hbase.bucketcache.ioengine
 offheap
   
 
 hbase.bucketcache.size
 1000
   

(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:

 
 \hbase.bucketcache.ioengine\
 \offheap\
   \
   \  
 \hbase.bucketcache.size\
 \1000\
   \

(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)

[jira] [Comment Edited] (TRAFODION-2041) UPDATE STATS uses select count(*) on large tables on HDP 2.3.4

[David Wayne Birdsall (JIRA)]

[ 
https://issues.apache.org/jira/browse/TRAFODION-2041?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15321209#comment-15321209
 ] 

David Wayne Birdsall edited comment on TRAFODION-2041 at 6/8/16 6:54 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:

 
 \hbase.bucketcache.ioengine\
 \offheap\
   \
   \  
 \hbase.bucketcache.size\
 \1000\
   \

(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:

   \  
 \hbase.bucketcache.ioengine\
 \offheap\
   \
   \  
 \hbase.bucketcache.size\
 \1000\
   \

(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)