select count(*) from AGGREGATION_TABLE | 0.72s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.34s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.5s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.53s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
| select count(1) from AGGREGATION_TABLE group by HOST | 0.77s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.38s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.54s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.6s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select core, count(1) from AGGREGATION_TABLE group by CORE | 0.94s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.59s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.55s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.45s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select core, host, sum(ACTIVE_VISITOR) from AGGREGATION_TABLE group by core, host | 3.41s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.59s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.57s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.54s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select AVG(DB), MIN(CORE), MAX(ACTIVE_VISITOR) from AGGREGATION_TABLE where host='CS' and DOMAIN<>'Google.com' | 3.67s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.96s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.96s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.94s 4.X-HBASE-0.98-HBASE-0.98.7-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.64s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.26s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.91s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.8s 4.X-HBASE-0.98-HBASE-0.98.7-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) | 3.35s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.61s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.52s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.52s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(active_visitor) count from AGGREGATION_TABLE | 3.04s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.38s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.33s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.32s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(distinct active_visitor) count from AGGREGATION_TABLE | 3.48s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.74s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.63s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.62s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select percentile_cont(0.9) within group (order by active_visitor asc) from AGGREGATION_TABLE | 3.36s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.77s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.67s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.73s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select percentile_cont(0.1) within group (order by active_visitor desc) from AGGREGATION_TABLE | 3.3s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.77s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.7s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.66s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core), count(db), count(active_visitor) from AGGREGATION_TABLE | 4.13s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.83s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.87s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.77s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(distinct core), count(distinct db), count(distinct active_visitor) from AGGREGATION_TABLE | 4.68s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 2.44s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 2.29s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 2.33s 4.X-HBASE-0.98-HBASE-0.98.7-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 | 4.7s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 2.38s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 2.34s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 2.33s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select core, count(db) count from AGGREGATION_TABLE group by CORE | 1s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.55s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.52s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.53s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select core, count(distinct db) count from AGGREGATION_TABLE group by CORE | 1.8s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.97s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.9s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.49s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select core, percentile_cont(0.9999) within group (order by db asc) from AGGREGATION_TABLE group by CORE | 1.88s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 2s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 2.02s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.58s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core) from AGGREGATION_TABLE where core IN (1,25,50,75,100) | 1.51s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.34s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.88s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.95s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core) from AGGREGATION_TABLE where core < 10 and db < 200 | 1.74s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.41s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.09s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.08s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core) from AGGREGATION_TABLE where core < 10 and active_visitor < 1000 | 2.97s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.49s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.29s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.33s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select * from AGGREGATION_TABLE LIMIT 100 | 0.02s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.02s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.01s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.01s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core) from AGGREGATION_TABLE where core > 90 | 1.56s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.31s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.89s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.85s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
LOAD DATA AGGREGATION_TABLE [2000000 ROWS] | 113.88s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 109.81s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 112.62s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 133.88s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(1) from IN_LIKE_TABLE where K1 in ('Z', 'D', 'F', 'X') | 0.47s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.24s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.13s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.15s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
| select * from IN_LIKE_TABLE where K1 in ('A','B') and K2 in ('xxx1000000','xxx2000000','xxx2000001') | 0.01s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.01s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.01s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.01s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select * from IN_LIKE_TABLE where K1 in ('A', 'C', 'E', 'F', 'H') and K2 like 'xxxxxx1%' | 0.02s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.01s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.01s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.02s 4.X-HBASE-0.98-HBASE-0.98.7-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%' | 1.06s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.8s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.84s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.79s 4.X-HBASE-0.98-HBASE-0.98.7-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.01s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.69s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.65s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.85s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
LOAD DATA IN_LIKE_TABLE [2000000 ROWS] | 95.55s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 85.05s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 89.26s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 102.43s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(*) from INDEXED_TABLE | 0.29s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.22s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.24s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.22s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
| select /*+ INDEX(INDEXED_TABLE idx1 idx2 idx3 idx4) */ count(*) from INDEXED_TABLE | 0.67s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.66s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.33s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.4s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(*) from INDEXED_TABLE | 0.26s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.22s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.23s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.25s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ count(*) from INDEXED_TABLE | 0.82s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.6s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.85s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.92s 4.X-HBASE-0.98-HBASE-0.98.7-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.18s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.14s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.18s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.15s 4.X-HBASE-0.98-HBASE-0.98.7-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 | 1.51s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.37s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.29s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.16s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core IN (1,100) | 0.04s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.03s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.04s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.04s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE idx1 idx2 idx3 idx4) */ count(core) from INDEXED_TABLE where core IN (1,100) | 0.02s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.03s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.04s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.03s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(core) from INDEXED_TABLE where core IN (1,100) | 0.02s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.01s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.02s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.02s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core IN (1,100) | 1.38s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.23s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.11s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.03s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) | 0.05s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.04s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.07s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.06s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE idx1 idx2 idx3 idx4) */ count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) | 0.05s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.05s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.04s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.04s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) | 0.02s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.03s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.03s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.03s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) | 1.38s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.23s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.11s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.06s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core < 10 and db < 200 | 0.13s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.13s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.15s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.14s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE idx1 idx2 idx3 idx4) */ count(core) from INDEXED_TABLE where core < 10 and db < 200 | 0.56s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.61s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 9.47s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 13.48s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(core) from INDEXED_TABLE where core < 10 and db < 200 | 0.11s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.11s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 9.34s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 10.51s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core < 10 and db < 200 | 1.63s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.31s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.32s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.25s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core < 100 and db < 2000 | 0.44s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.43s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.61s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.6s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core < 100 and db < 2000 | 1.38s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.04s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.97s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.98s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core > 90 | 0.07s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.05s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.08s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.06s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core > 90 | 1.47s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.24s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.13s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.04s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core > 0 | 0.41s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.3s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.35s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.32s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core > 0 | 1.14s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.86s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.78s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.78s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select db from INDEXED_TABLE where db >5 and db <7 order by db | 0.05s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.03s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.05s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.04s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ db from INDEXED_TABLE where db >5 and db <7 order by db | 2.48s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 2.02s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.87s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.85s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select db from INDEXED_TABLE order by db limit 10 | 0.04s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.04s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.04s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.04s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ db from INDEXED_TABLE order by db limit 10 | 1.25s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.02s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.01s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.25s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
CREATE INDEX idx5 ON INDEXED_TABLE (CORE) INCLUDE (DB,ACTIVE_VISITOR) | 40.59s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 43.79s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 31.58s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 32.58s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
LOAD DATA INDEXED_TABLE [2000000 ROWS] | 450.21s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 561.61s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 571.67s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 596.41s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(*) from INDEXED_TABLE_MUTABLE | 0.53s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.49s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.5s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.48s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
| select /*+ INDEX(INDEXED_TABLE_MUTABLE midx1 midx2 midx3 midx4) */ count(*) from INDEXED_TABLE_MUTABLE | 1.42s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.07s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.36s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.23s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE_MUTABLE mids1 mids2 mids3 mids4) */ count(*) from INDEXED_TABLE_MUTABLE | 0.5s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.53s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.51s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.49s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ count(*) from INDEXED_TABLE_MUTABLE | 0.86s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.63s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.71s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.66s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select round(date, 'day',50), sum(core)+2 from INDEXED_TABLE_MUTABLE where (CORE<10 or CORE>90) group by round(date, 'day',50), host | 0.42s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.14s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.16s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.15s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ round(date, 'day',50), sum(core)+2 from INDEXED_TABLE_MUTABLE where (CORE<10 or CORE>90) group by round(date, 'day',50), host | 1.61s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.4s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.11s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.03s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core) from INDEXED_TABLE_MUTABLE where core IN (1,100) | 0.03s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.02s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.04s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.04s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE_MUTABLE midx1 midx2 midx3 midx4) */ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,100) | 0.03s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.03s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.03s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.03s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE_MUTABLE mids1 mids2 mids3 mids4) */ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,100) | 0.02s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.01s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.02s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.02s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,100) | 1.45s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.26s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.94s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.89s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core) from INDEXED_TABLE_MUTABLE where core IN (1,25,50,75,100) | 0.04s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.04s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.06s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.05s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE_MUTABLE midx1 midx2 midx3 midx4) */ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,25,50,75,100) | 0.03s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.03s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.03s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.03s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE_MUTABLE mids1 mids2 mids3 mids4) */ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,25,50,75,100) | 0.02s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.02s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.03s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.03s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,25,50,75,100) | 1.4s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.16s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.96s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.87s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core) from INDEXED_TABLE_MUTABLE where core < 10 and db < 200 | 0.4s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.11s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.13s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.11s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE_MUTABLE midx1 midx2 midx3 midx4) */ count(core) from INDEXED_TABLE_MUTABLE where core < 10 and db < 200 | 0.32s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.5s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 8.6s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 13.02s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+ INDEX(INDEXED_TABLE_MUTABLE mids1 mids2 mids3 mids4) */ count(core) from INDEXED_TABLE_MUTABLE where core < 10 and db < 200 | 0.42s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.09s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 9.35s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 10.67s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core < 10 and db < 200 | 1.66s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.34s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.13s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.05s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core) from INDEXED_TABLE_MUTABLE where core < 100 and db < 2000 | 0.78s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.45s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.62s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.62s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core < 100 and db < 2000 | 1.26s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.08s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.71s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.74s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core) from INDEXED_TABLE_MUTABLE where core > 90 | 0.06s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.04s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.06s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.06s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core > 90 | 1.42s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.24s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.96s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.89s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(core) from INDEXED_TABLE_MUTABLE where core > 0 | 0.42s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.29s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.3s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.27s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core > 0 | 1.13s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.88s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.58s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.59s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select db from INDEXED_TABLE_MUTABLE where db >5 and db <7 order by db | 0.03s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.03s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.04s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.04s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ db from INDEXED_TABLE_MUTABLE where db >5 and db <7 order by db | 2.53s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 2.06s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.64s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.49s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select db from INDEXED_TABLE_MUTABLE order by db limit 10 | 0.41s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.39s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.37s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.4s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select /*+NO_INDEX*/ db from INDEXED_TABLE_MUTABLE order by db limit 10 | 1.38s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.03s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.76s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
CREATE INDEX midx5 ON INDEXED_TABLE_MUTABLE (CORE) INCLUDE (DB,ACTIVE_VISITOR) | 52.58s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 27.45s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 35.94s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 26.43s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
LOAD DATA INDEXED_TABLE_MUTABLE [2000000 ROWS] | 571.2s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 542.53s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 502.68s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 509.97s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(1) from TABLE_6CF where K1 in ('A', 'B', 'C', 'D') | 0.52s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.27s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.63s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.77s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
| select count(1) from TABLE_6CF where K1 in ('A', 'C') | 0.42s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.19s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.56s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.76s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(*) from TABLE_6CF where f < 1000 | 1.32s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.71s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.84s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select a,b,c,d,e,f from TABLE_6CF where B>1000 and B<2000 and f>1000 and f<2000 | 1.96s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.98s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.22s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.43s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select sum(a),sum(b),sum(c),sum(d) from TABLE_6CF group by K1 | 4.26s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 2.02s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 2.66s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 3.11s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(*) from TABLE_6CF group by A | 0.61s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.35s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.38s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.43s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(*) from TABLE_6CF group by B | 2.36s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.28s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.54s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.75s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(*) from TABLE_6CF where f < 10000 | 2.1s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.05s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.35s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.61s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
LOAD DATA TABLE_6CF [2000000 ROWS] | 113.2s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 104.94s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 107.92s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 120.94s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(1) from TABLE_1CF where K1 in ('A', 'B', 'C', 'D') | 1.28s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.56s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.76s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.8s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
| select count(1) from TABLE_1CF where K1 in ('A', 'C') | 1.15s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.53s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.49s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.58s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(*) from TABLE_1CF where f < 1000 | 1.95s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.29s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.07s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.34s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select a,b,c,d,e,f from TABLE_1CF where B>1000 and B<2000 and f>1000 and f<2000 | 2.24s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.16s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.3s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.34s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select sum(a),sum(b),sum(c),sum(d) from TABLE_1CF group by K1 | 1.58s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.75s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.81s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.97s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(*) from TABLE_1CF group by A | 1.25s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.74s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.7s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 0.8s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(*) from TABLE_1CF group by B | 1.3s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 1.74s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 1.35s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.12s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
select count(*) from TABLE_1CF where f < 10000 | 1.52s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 0.78s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 0.82s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 1.07s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|
LOAD DATA TABLE_1CF [2000000 ROWS] | 99.95s V4.1.0-HBASE-0.98.7-HADOOP2 |
| 92.09s V4.2.2-HBASE-0.98.7-HADOOP2 |
| 96.2s V4.3.1-HBASE-0.98.7-HADOOP2 |
| 108.04s 4.X-HBASE-0.98-HBASE-0.98.7-HADOOP2 |
|