Phoenix Performance Result :: Fri Jan 17 11:18:22 PST 2014

Queries by Category


Aggregation

select count(*) from TABLE_6CF
3.68s PHOENIX-SNAPSHOT


Large Group By

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

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

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

select count(*) from TABLE_6CF group by D
SQL Exception - Check logs for 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]
263.74s 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: 10000 Values: RANDOM
INTEGER :: Max. Value: 50000 Values: RANDOM
INTEGER :: Max. Value: 100000 Values: RANDOM
INTEGER :: Max. Value: 200000 Values: RANDOM
INTEGER :: Max. Value: 300000 Values: RANDOM
INTEGER :: Max. Value: 400000 Values: RANDOM

select count(*) from TABLE_6CF
3.68s PHOENIX-SNAPSHOT

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

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

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

select count(*) from TABLE_6CF group by D
SQL Exception - Check logs for 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 TABLE_6CF [5000000 ROWS]
263.74s PHOENIX-SNAPSHOT



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