Re: Performance problem with HBase

2014-02-07 Thread Бородин Владимир
I've tried to update hive to 0.12 but it did not help :( It seems, that range scans and filter pushdown [1,2] do not work. Can anybody help? [1] https://issues.apache.org/jira/browse/HIVE-1643 [2] https://issues.apache.org/jira/browse/HIVE-2815 30.01.2014, в 17:31, Бородин Владимир написал(а):

Re: Performance problem with HBase

2014-02-02 Thread Navis류승우
1. current implementation of hbase handler cannot pushdown filter with 'like' expression. You might rewrite the query some thing like "key >= 0010_0 AND key <= 0010_9" 2. Each of all tasks seemed to be scanning whole table (ie. 1000+ time), which is fixed in HIVE-342

Performance problem with HBase

2014-01-30 Thread Бородин Владимир
Hi all! I'm having a performance problem with quering data from hbase using hive. I use CDH 4.5 (hbase-0.94.6, hive-0.10.0 and hadoop-yarn-2.0.0) on a cluster of 10 hosts. Right now it stores 3 TB of data in hbase table which now consists of 1000+ regions. One record in it looks like this: hba