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

Aggregation with filter no non-pk

select count(*) from TABLE_6CF where f < 10000
4.58s PHOENIX-SNAPSHOT

ColumnFamilies-Single

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

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

select count(*) from TABLE_6CF where f < 1000
2.79s 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.81s PHOENIX-SNAPSHOT

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

Large Group By

select count(*) from TABLE_6CF group by A
3.63s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by B
5.77s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by C
6.25s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by D
8.02s PHOENIX-SNAPSHOT

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

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

Load Data

LOAD DATA TABLE_6CF [5000000 ROWS]
262.7s 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.28s PHOENIX-SNAPSHOT

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

select count(*) from TABLE_6CF where f < 1000
2.79s 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.81s PHOENIX-SNAPSHOT

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

select count(*) from TABLE_6CF group by A
3.63s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by B
5.77s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by C
6.25s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by D
8.02s PHOENIX-SNAPSHOT

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

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

select count(*) from TABLE_6CF where f < 10000
4.58s PHOENIX-SNAPSHOT

LOAD DATA TABLE_6CF [5000000 ROWS]
262.7s PHOENIX-SNAPSHOT


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