Phoenix Performance Result :: Fri Jan 17 11:31:19 PST 2014

Queries by Category


Aggregation

select count(*) from TABLE_6CF
3.58s PHOENIX-2.2.0


Large Group By

select count(*) from TABLE_6CF group by A
5.22s PHOENIX-2.2.0

select count(*) from TABLE_6CF group by B
8.13s PHOENIX-2.2.0

select count(*) from TABLE_6CF group by C
11.05s PHOENIX-2.2.0

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

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

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


Load Data

LOAD DATA TABLE_6CF [5000000 ROWS]
232.76s PHOENIX-2.2.0




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.58s PHOENIX-2.2.0

select count(*) from TABLE_6CF group by A
5.22s PHOENIX-2.2.0

select count(*) from TABLE_6CF group by B
8.13s PHOENIX-2.2.0

select count(*) from TABLE_6CF group by C
11.05s PHOENIX-2.2.0

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

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

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

LOAD DATA TABLE_6CF [5000000 ROWS]
232.76s PHOENIX-2.2.0



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