Phoenix Performance Result :: Wed Jan 15 15:09:02 PST 2014

Queries by Category


Large Group By

select count(*) from TABLE_6CF group by A
3.92s PHOENIX-2.2.0
3.81s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by B
5.79s PHOENIX-2.2.0
5.9s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by C
5.87s PHOENIX-2.2.0
6.29s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by D
6.13s PHOENIX-2.2.0
8.14s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by E
6.19s PHOENIX-2.2.0
13.63s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by F
6.48s PHOENIX-2.2.0
97.27s PHOENIX-SNAPSHOT


Load Data

LOAD DATA TABLE_6CF [5000000 ROWS]
229.83s PHOENIX-2.2.0
249.3s 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: 10000 Values: RANDOM
INTEGER :: Max. Value: 100000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 2000000 Values: RANDOM

select count(*) from TABLE_6CF group by A
3.92s PHOENIX-2.2.0
3.81s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by B
5.79s PHOENIX-2.2.0
5.9s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by C
5.87s PHOENIX-2.2.0
6.29s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by D
6.13s PHOENIX-2.2.0
8.14s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by E
6.19s PHOENIX-2.2.0
13.63s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by F
6.48s PHOENIX-2.2.0
97.27s PHOENIX-SNAPSHOT

LOAD DATA TABLE_6CF [5000000 ROWS]
229.83s PHOENIX-2.2.0
249.3s PHOENIX-SNAPSHOT



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