select count(*) from AGGREGATION_TABLE | 1s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.43s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.56s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
| select count(1) from AGGREGATION_TABLE group by HOST | 1.1s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.42s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.63s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select core, count(1) from AGGREGATION_TABLE group by CORE | 0.98s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.47s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.7s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select core, host, sum(ACTIVE_VISITOR) from AGGREGATION_TABLE group by core, host | 2.36s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.42s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.72s 4.X-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' | 1.05s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.93s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.09s 4.X-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.19s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.22s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.43s 4.X-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.24s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.37s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.67s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(active_visitor) count from AGGREGATION_TABLE | 2.08s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.1s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.35s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(distinct active_visitor) count from AGGREGATION_TABLE | 2.78s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.88s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.12s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select percentile_cont(0.9) within group (order by active_visitor asc) from AGGREGATION_TABLE | 2.75s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.83s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.18s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select percentile_cont(0.1) within group (order by active_visitor desc) from AGGREGATION_TABLE | 2.75s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.95s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.18s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core), count(db), count(active_visitor) from AGGREGATION_TABLE | 2.43s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.55s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.93s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(distinct core), count(distinct db), count(distinct active_visitor) from AGGREGATION_TABLE | 3.51s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.86s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 4.08s 4.X-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.53s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.79s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 4.06s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select core, count(db) count from AGGREGATION_TABLE group by CORE | 0.97s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.82s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.16s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select core, count(distinct db) count from AGGREGATION_TABLE group by CORE | 2.59s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.52s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.91s 4.X-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 | 2.67s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.63s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 3.98s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from AGGREGATION_TABLE where core IN (1,25,50,75,100) | 1.04s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.15s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.23s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from AGGREGATION_TABLE where core < 10 and db < 200 | 1.19s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.35s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.46s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from AGGREGATION_TABLE where core < 10 and active_visitor < 1000 | 2.03s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.13s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.28s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select * from AGGREGATION_TABLE LIMIT 100 | 0.02s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.02s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.01s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from AGGREGATION_TABLE where core > 90 | 1.09s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.15s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.27s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
LOAD DATA AGGREGATION_TABLE [2000000 ROWS] | 152.17s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 134.83s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 150.78s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(1) from IN_LIKE_TABLE where K1 in ('Z', 'D', 'F', 'X') | 0.25s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.41s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.54s 4.X-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.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.01s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.01s 4.X-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.02s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.01s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.01s 4.X-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%' | 1.75s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.42s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.61s 4.X-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.21s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.6s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.7s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
LOAD DATA IN_LIKE_TABLE [2000000 ROWS] | 106.82s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 102.08s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 111.81s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from INDEXED_TABLE | 0.52s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.5s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.53s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
| select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(*) from INDEXED_TABLE | 0.49s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.48s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.5s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ count(*) from INDEXED_TABLE | 0.69s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.86s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.87s 4.X-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.27s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.25s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.23s 4.X-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.95s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.99s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.99s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core IN (1,100) | 0.04s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.04s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.05s 4.X-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.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.03s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.04s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core IN (1,100) | 0.7s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.8s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.82s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) | 0.07s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.07s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.06s 4.X-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.06s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.05s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.06s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) | 0.68s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.79s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.8s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core < 10 and db < 200 | 0.12s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.14s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.16s 4.X-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.09s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 11.6s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 11.28s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core < 10 and db < 200 | 0.83s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.02s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.98s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core < 100 and db < 2000 | 1.18s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.58s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.58s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core < 100 and db < 2000 | 1.16s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.55s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.44s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core > 90 | 0.07s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.08s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.07s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core > 90 | 0.73s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.82s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.88s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(core) from INDEXED_TABLE where core > 0 | 0.59s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.64s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.57s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core > 0 | 0.85s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.98s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.96s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select db from INDEXED_TABLE where db >5 and db <7 order by db | 0.04s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.03s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.03s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ db from INDEXED_TABLE where db >5 and db <7 order by db | 1.32s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.06s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.11s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select db from INDEXED_TABLE order by db limit 10 | 0.05s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.05s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.02s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select /*+NO_INDEX*/ db from INDEXED_TABLE order by db limit 10 | 1.36s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.55s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.45s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
CREATE INDEX idx5 ON INDEXED_TABLE (CORE) INCLUDE (DB,ACTIVE_VISITOR) | 37.51s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 25.56s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 28.03s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
LOAD DATA INDEXED_TABLE [2000000 ROWS] | 383.92s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 373.45s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 386.14s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(1) from TABLE_6CF where K1 in ('A', 'B', 'C', 'D') | 0.98s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.02s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.14s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
| select count(1) from TABLE_6CF where K1 in ('A', 'C') | 0.69s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.66s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.7s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from TABLE_6CF where f < 1000 | 0.92s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.67s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.7s 4.X-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.82s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.74s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.76s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select sum(a),sum(b),sum(c),sum(d) from TABLE_6CF group by K1 | 5.01s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 4.67s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 4.66s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from TABLE_6CF group by A | 0.72s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.93s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.97s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from TABLE_6CF group by B | 2.26s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.93s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.04s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from TABLE_6CF where f < 10000 | 1.76s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.73s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.77s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
LOAD DATA TABLE_6CF [2000000 ROWS] | 145.43s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 142.12s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 155.21s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(1) from TABLE_1CF where K1 in ('A', 'B', 'C', 'D') | 1.51s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.45s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.6s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
| select count(1) from TABLE_1CF where K1 in ('A', 'C') | 1.1s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.71s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 0.83s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from TABLE_1CF where f < 1000 | 1.69s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.37s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.42s 4.X-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 | 2.11s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.55s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.59s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select sum(a),sum(b),sum(c),sum(d) from TABLE_1CF group by K1 | 1.69s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.12s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.06s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from TABLE_1CF group by A | 1.57s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.39s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.37s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from TABLE_1CF group by B | 2.99s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.12s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 2.16s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
select count(*) from TABLE_1CF where f < 10000 | 1.61s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.41s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 1.44s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|
LOAD DATA TABLE_1CF [2000000 ROWS] | 126.44s V4.6.0-HBASE-0.98-0.98.17-HADOOP2 |
| 125.58s V4.7.0-HBASE-0.98-0.98.17-HADOOP2 |
| 139.34s 4.X-HBASE-0.98-0.98.17-HADOOP2 |
|