select count(*) from AGGREGATION_TABLE | 1.43s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.88s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.67s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
| select count(1) from AGGREGATION_TABLE group by HOST | 1.42s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.85s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.83s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select core, count(1) from AGGREGATION_TABLE group by CORE | 1.47s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.01s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.76s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select core, host, sum(ACTIVE_VISITOR) from AGGREGATION_TABLE group by core, host | 2.42s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.09s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.02s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select AVG(DB), MIN(CORE), MAX(ACTIVE_VISITOR) from AGGREGATION_TABLE where host='CS' and DOMAIN<>'Google.com' | 0.93s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.31s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.2s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select round(date, 'day',50), sum(core)+2 from AGGREGATION_TABLE where (CORE<10 or CORE>90) group by round(date, 'day',50), host | 1.22s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.64s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.67s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select trunc(date, 'hour', 1000), count(DB), count(ACTIVE_VISITOR) from AGGREGATION_TABLE where feature='Login' and (core<50 or db<20 or active_visitor > 200) group by trunc(date, 'hour', 1000) | 2.37s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.09s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.8s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(active_visitor) count from AGGREGATION_TABLE | 2.1s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.59s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.76s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(distinct active_visitor) count from AGGREGATION_TABLE | 2.88s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.5s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.43s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select percentile_cont(0.9) within group (order by active_visitor asc) from AGGREGATION_TABLE | 2.83s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.34s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.58s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select percentile_cont(0.1) within group (order by active_visitor desc) from AGGREGATION_TABLE | 2.95s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.45s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.98s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core), count(db), count(active_visitor) from AGGREGATION_TABLE | 2.55s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.08s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.08s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(distinct core), count(distinct db), count(distinct active_visitor) from AGGREGATION_TABLE | 3.86s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 4.54s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 4.46s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select percentile_cont(0.5) within group (order by core asc), percentile_cont(0.5) within group (order by db asc), percentile_cont(0.5) within group (order by active_visitor asc) from AGGREGATION_TABLE | 3.79s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 4.42s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 4.36s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select core, count(db) count from AGGREGATION_TABLE group by CORE | 1.82s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.34s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.27s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select core, count(distinct db) count from AGGREGATION_TABLE group by CORE | 3.52s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 4.69s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.93s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select core, percentile_cont(0.9999) within group (order by db asc) from AGGREGATION_TABLE group by CORE | 3.63s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 4.95s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 4.12s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from AGGREGATION_TABLE where core IN (1,25,50,75,100) | 1.15s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.52s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.27s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from AGGREGATION_TABLE where core < 10 and db < 200 | 1.35s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.68s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.56s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from AGGREGATION_TABLE where core < 10 and active_visitor < 1000 | 2.13s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.58s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.57s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select * from AGGREGATION_TABLE LIMIT 100 | 0.02s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.01s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.01s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from AGGREGATION_TABLE where core > 90 | 1.15s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.44s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.43s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
LOAD DATA AGGREGATION_TABLE [2000000 ROWS] | 134.83s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 146.07s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 144.39s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(1) from IN_LIKE_TABLE where K1 in ('Z', 'D', 'F', 'X') | 0.41s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.7s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.46s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
| select * from IN_LIKE_TABLE where K1 in ('A','B') and K2 in ('xxx1000000','xxx2000000','xxx2000001') | 0.01s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.01s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.01s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select * from IN_LIKE_TABLE where K1 in ('A', 'C', 'E', 'F', 'H') and K2 like 'xxxxxx1%' | 0.01s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.02s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.02s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from IN_LIKE_TABLE where K1 in ('X','A','B','C','D','E','F','G','H','I','Z') and K2 like '%1%' | 2.42s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.98s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.06s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from IN_LIKE_TABLE where (K1 in ('A','E','F','G','H','I','Z') or K1 like 'E%') and (K2 like '%xx1%' or K2 like '%xxxxxx2%') | 1.6s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.05s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.15s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
LOAD DATA IN_LIKE_TABLE [2000000 ROWS] | 102.08s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 111.32s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 110.61s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from INDEXED_TABLE | 0.5s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.58s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.72s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
| select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(*) from INDEXED_TABLE | 0.48s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.64s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.66s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ count(*) from INDEXED_TABLE | 0.86s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.88s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.03s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select round(date, 'day',50), sum(core)+2 from INDEXED_TABLE where (CORE<10 or CORE>90) group by round(date, 'day',50), host | 0.25s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.43s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.37s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ round(date, 'day',50), sum(core)+2 from INDEXED_TABLE where (CORE<10 or CORE>90) group by round(date, 'day',50), host | 0.99s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.14s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.13s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core IN (1,100) | 0.04s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.06s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.06s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(core) from INDEXED_TABLE where core IN (1,100) | 0.03s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.05s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.04s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core IN (1,100) | 0.8s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.1s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.88s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) | 0.07s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.08s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.1s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) | 0.05s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.06s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.07s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) | 0.79s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.08s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.89s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core < 10 and db < 200 | 0.14s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.23s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.24s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(core) from INDEXED_TABLE where core < 10 and db < 200 | 11.6s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 11.67s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 12.44s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core < 10 and db < 200 | 1.02s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.13s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.09s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core < 100 and db < 2000 | 1.58s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.32s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core < 100 and db < 2000 | 1.55s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.59s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.64s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core > 90 | 0.08s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.09s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.09s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core > 90 | 0.82s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.99s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.97s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core > 0 | 0.64s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.71s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.77s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core > 0 | 0.98s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.22s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.14s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select db from INDEXED_TABLE where db >5 and db <7 order by db | 0.03s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.03s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.03s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ db from INDEXED_TABLE where db >5 and db <7 order by db | 1.06s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.11s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.22s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select db from INDEXED_TABLE order by db limit 10 | 0.05s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.03s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.03s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ db from INDEXED_TABLE order by db limit 10 | 1.55s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.67s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.72s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
CREATE INDEX idx5 ON INDEXED_TABLE (CORE) INCLUDE (DB,ACTIVE_VISITOR) | 25.56s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 33.3s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 32.67s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
LOAD DATA INDEXED_TABLE [2000000 ROWS] | 373.45s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 394.84s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 389.99s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(1) from TABLE_6CF where K1 in ('A', 'B', 'C', 'D') | 1.02s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.1s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.35s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
| select count(1) from TABLE_6CF where K1 in ('A', 'C') | 0.66s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.6s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.84s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from TABLE_6CF where f < 1000 | 0.67s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.8s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.92s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select a,b,c,d,e,f from TABLE_6CF where B>1000 and B<2000 and f>1000 and f<2000 | 1.74s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.46s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.55s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select sum(a),sum(b),sum(c),sum(d) from TABLE_6CF group by K1 | 4.67s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 5.27s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 5.16s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from TABLE_6CF group by A | 0.93s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.29s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.26s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from TABLE_6CF group by B | 1.93s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.27s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.27s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from TABLE_6CF where f < 10000 | 0.73s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.06s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.87s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
LOAD DATA TABLE_6CF [2000000 ROWS] | 142.12s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 154.21s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 155.2s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(1) from TABLE_1CF where K1 in ('A', 'B', 'C', 'D') | 1.45s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.93s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.68s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
| select count(1) from TABLE_1CF where K1 in ('A', 'C') | 0.71s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.86s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.86s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from TABLE_1CF where f < 1000 | 1.37s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.44s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.7s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select a,b,c,d,e,f from TABLE_1CF where B>1000 and B<2000 and f>1000 and f<2000 | 1.55s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.76s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.79s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select sum(a),sum(b),sum(c),sum(d) from TABLE_1CF group by K1 | 2.12s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.62s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.16s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from TABLE_1CF group by A | 1.39s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.45s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.44s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from TABLE_1CF group by B | 2.12s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.35s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.5s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from TABLE_1CF where f < 10000 | 1.41s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.64s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.69s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|
LOAD DATA TABLE_1CF [2000000 ROWS] | 125.58s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 145.82s V4.8.0-HBASE-0.98-0.98.17-HADOOP2 |
| 140.26s 4.8-HBASE-0.98-0.98.17-HADOOP2 |
|