Phoenix SNAPSHOT Performance

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