Phoenix Performance Result :: Wed Jan 15 17:33:21 PST 2014
Queries by Category

Large Group By

select count(*) from TABLE_6CF group by A
4.54s PHOENIX-2.2.0
11.51s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by B
7.08s PHOENIX-2.2.0
155.77s PHOENIX-SNAPSHOT

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

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

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

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

Load Data

LOAD DATA TABLE_6CF [5000000 ROWS]
232.92s PHOENIX-2.2.0
250.39s 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: 20000 Values: RANDOM
INTEGER :: Max. Value: 30000 Values: RANDOM
INTEGER :: Max. Value: 40000 Values: RANDOM
INTEGER :: Max. Value: 50000 Values: RANDOM
INTEGER :: Max. Value: 100000 Values: RANDOM

select count(*) from TABLE_6CF group by A
4.54s PHOENIX-2.2.0
11.51s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by B
7.08s PHOENIX-2.2.0
155.77s PHOENIX-SNAPSHOT

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

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

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

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

LOAD DATA TABLE_6CF [5000000 ROWS]
232.92s PHOENIX-2.2.0
250.39s PHOENIX-SNAPSHOT


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