Phoenix SNAPSHOT Performance

Phoenix Performance Result :: Wed Jan 15 12:51:47 PST 2014

Queries by Category

Aggregation with filter no non-pk

select count(*) from TABLE_6CF where f < 10000

4.71s PHOENIX-2.2.0

4.6s PHOENIX-SNAPSHOT

ColumnFamilies-Single

select count(1) from TABLE_6CF where K1 in ('A', 'B', 'C', 'D')

3.36s PHOENIX-2.2.0

3.25s PHOENIX-SNAPSHOT

select count(1) from TABLE_6CF where K1 in ('A', 'C')

3.2s PHOENIX-2.2.0

3.11s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF where f < 1000

2.45s PHOENIX-2.2.0

2.51s PHOENIX-SNAPSHOT

select a,b,c,d,e,f from TABLE_6CF where B>1000 and B<2000 and f>1000 and f<2000

2.9s PHOENIX-2.2.0

2.63s PHOENIX-SNAPSHOT

select sum(a),sum(b),sum(c),sum(d) from TABLE_6CF group by K1

11.31s PHOENIX-2.2.0

10.21s PHOENIX-SNAPSHOT

Large Group By

select count(*) from TABLE_6CF group by A

3.81s PHOENIX-2.2.0

3.66s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by B

5.67s PHOENIX-2.2.0

5.79s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by C

5.7s PHOENIX-2.2.0

6.42s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by D

5.94s PHOENIX-2.2.0

8.01s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by E

6.15s PHOENIX-2.2.0

13.45s PHOENIX-SNAPSHOT

select count(*) from TABLE_6CF group by F

6.46s PHOENIX-2.2.0

93.71s PHOENIX-SNAPSHOT

Load Data

LOAD DATA TABLE_6CF [5000000 ROWS]

232.41s PHOENIX-2.2.0

249.12s 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: 50000 Values: RANDOM
INTEGER :: Max. Value: 100000 Values: RANDOM
INTEGER :: Max. Value: 200000 Values: RANDOM