Phoenix Performance Result :: Mon Jan 13 13:11:59 PST 2014
Queries by Category

Aggregation with filter no non-pk

select count(*) from TABLE_6CF where f < 10000
4.6s PHOENIX-2.2.0
5.25s PHOENIX-SNAPSHOT

ColumnFamilies-Single

select count(1) from TABLE_6CF where K1 in ('A', 'B', 'C', 'D')
3.41s PHOENIX-2.2.0
3.35s PHOENIX-SNAPSHOT

select count(1) from TABLE_6CF where K1 in ('A', 'C')
3.23s PHOENIX-2.2.0
2.85s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF where f < 1000
2.44s PHOENIX-2.2.0
2.58s PHOENIX-SNAPSHOT

select a,b,c,d,e,f from TABLE_6CF where B>1000 and B<2000 and f>1000 and f<2000
2.76s PHOENIX-2.2.0
2.72s PHOENIX-SNAPSHOT

select sum(a),sum(b),sum(c),sum(d) from TABLE_6CF group by K1
11.12s PHOENIX-2.2.0
10.71s PHOENIX-SNAPSHOT

Large Group By

select count(*) from TABLE_6CF group by A
3.77s PHOENIX-2.2.0
3.83s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by B
5.61s PHOENIX-2.2.0
6.07s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by C
5.55s PHOENIX-2.2.0
6.4s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by D
5.71s PHOENIX-2.2.0
8.19s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by E
6s PHOENIX-2.2.0
SQL Exception - Check logs for PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by F
6.24s PHOENIX-2.2.0
SQL Exception - Check logs for PHOENIX-SNAPSHOT

Load Data

LOAD DATA TABLE_6CF [5000000 ROWS]
226.69s PHOENIX-2.2.0
252.65s PHOENIX-SNAPSHOT



Queries by Table

TABLE_6CF


Data is split in 6 column families. Phoenix 1.2+ uses Essential Column Family filter feature which fetches only required columns when filtering rows.

ROWS 5000000 [5M]

DDL CREATE TABLE IF NOT EXISTS $TABLE (K1 CHAR(1) NOT NULL, K2 VARCHAR NOT NULL, CF1.A INTEGER, CF2.B INTEGER, CF3.C INTEGER, CF4.D INTEGER, CF5.E INTEGER, CF6.F INTEGER CONSTRAINT PK PRIMARY KEY (K1,K2)) SPLIT ON ('B','C','D');CREATE TABLE IF NOT EXISTS $TABLE_UPSERTSELECT (K1 CHAR(1) NOT NULL, K2 VARCHAR NOT NULL, CF1.A INTEGER, CF2.B INTEGER, CF3.C INTEGER, CF4.D INTEGER, CF5.E INTEGER, CF6.F INTEGER CONSTRAINT PK PRIMARY KEY (K1,K2)) SPLIT ON ('B','C','D')

DATA GENERATOR
STRING :: Values: A|B|C|D
STRING :: Length: 10 Values: SEQUENTIAL
INTEGER :: Max. Value: 100 Values: RANDOM
INTEGER :: Max. Value: 1000 Values: RANDOM
INTEGER :: Max. Value: 2000 Values: RANDOM
INTEGER :: Max. Value: 5000 Values: RANDOM
INTEGER :: Max. Value: 10000 Values: RANDOM
INTEGER :: Max. Value: 15000 Values: RANDOM

select count(1) from TABLE_6CF where K1 in ('A', 'B', 'C', 'D')
3.41s PHOENIX-2.2.0
3.35s PHOENIX-SNAPSHOT

select count(1) from TABLE_6CF where K1 in ('A', 'C')
3.23s PHOENIX-2.2.0
2.85s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF where f < 1000
2.44s PHOENIX-2.2.0
2.58s PHOENIX-SNAPSHOT

select a,b,c,d,e,f from TABLE_6CF where B>1000 and B<2000 and f>1000 and f<2000
2.76s PHOENIX-2.2.0
2.72s PHOENIX-SNAPSHOT

select sum(a),sum(b),sum(c),sum(d) from TABLE_6CF group by K1
11.12s PHOENIX-2.2.0
10.71s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by A
3.77s PHOENIX-2.2.0
3.83s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by B
5.61s PHOENIX-2.2.0
6.07s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by C
5.55s PHOENIX-2.2.0
6.4s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by D
5.71s PHOENIX-2.2.0
8.19s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by E
6s PHOENIX-2.2.0
SQL Exception - Check logs for PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by F
6.24s PHOENIX-2.2.0
SQL Exception - Check logs for PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF where f < 10000
4.6s PHOENIX-2.2.0
5.25s PHOENIX-SNAPSHOT

LOAD DATA TABLE_6CF [5000000 ROWS]
226.69s PHOENIX-2.2.0
252.65s PHOENIX-SNAPSHOT


Note: Hover over version label to see Phoenix Query Explain Plan.