Apache Phoenix Performance Result :: Mon Mar 03 03:16:06 PST 2014
Queries by Category

COUNT

select count(column1) from LHS20M
15.89s PHOENIX-SNAPSHOT

select count(column1) from LHS5M
3.18s PHOENIX-SNAPSHOT

select count(*) from RHS100K
0.14s PHOENIX-SNAPSHOT

select count(*) from RHS1K
0.06s PHOENIX-SNAPSHOT

select count(*) from RHS250K
0.22s PHOENIX-SNAPSHOT

select count(*) from RHS500K
0.4s PHOENIX-SNAPSHOT

JOIN - LHS10M

select count(*) from LHS20M JOIN RHS100K on RHS100K.mypk = LHS20M.column1
SQL Exception - Check logs for PHOENIX-SNAPSHOT

select count(*) from LHS20M JOIN RHS1K on RHS1K.mypk = LHS20M.column1
14.46s PHOENIX-SNAPSHOT

select count(*) from LHS20M JOIN RHS250K on RHS250K.mypk = LHS20M.column1
SQL Exception - Check logs for PHOENIX-SNAPSHOT

select count(*) from LHS20M JOIN RHS500K on RHS500K.mypk = LHS20M.column1
SQL Exception - Check logs for PHOENIX-SNAPSHOT

JOIN - LHS5M

select count(*) from LHS5M JOIN RHS100K on RHS100K.mypk = LHS5M.column1
SQL Exception - Check logs for PHOENIX-SNAPSHOT

select count(*) from LHS5M JOIN RHS1K on RHS1K.mypk = LHS5M.column1
3.46s PHOENIX-SNAPSHOT

select count(*) from LHS5M JOIN RHS250K on RHS250K.mypk = LHS5M.column1
SQL Exception - Check logs for PHOENIX-SNAPSHOT

select count(*) from LHS5M JOIN RHS500K on RHS500K.mypk = LHS5M.column1
SQL Exception - Check logs for PHOENIX-SNAPSHOT

Load Data

LOAD DATA LHS20M [20000000 ROWS]
1147.05s PHOENIX-SNAPSHOT

LOAD DATA LHS5M [5000000 ROWS]
305.3s PHOENIX-SNAPSHOT

LOAD DATA RHS100K [100000 ROWS]
5.66s PHOENIX-SNAPSHOT

LOAD DATA RHS1K [1000 ROWS]
0.09s PHOENIX-SNAPSHOT

LOAD DATA RHS250K [250000 ROWS]
14.56s PHOENIX-SNAPSHOT

LOAD DATA RHS500K [500000 ROWS]
29.99s PHOENIX-SNAPSHOT



Queries by Table

LHS20M




ROWS 20000000 [20M]

DDL CREATE TABLE IF NOT EXISTS $TABLE (mypk CHAR(10) NOT NULL PRIMARY KEY,CF.column1 char(10),CF.column2 char(10),CF.column3 char(10)) SALT_BUCKETS=16;

DATA GENERATOR
STRING :: Length: 10 Values: SEQUENTIAL
STRING :: Length: 10 Values: SEQUENTIAL
STRING :: Length: 10 Max. Value: 1000 Values: RANDOM
STRING :: Length: 10 Max. Value: 10000 Values: RANDOM

select count(column1) from LHS20M
15.89s PHOENIX-SNAPSHOT

LOAD DATA LHS20M [20000000 ROWS]
1147.05s PHOENIX-SNAPSHOT

LHS5M




ROWS 5000000 [5M]

DDL CREATE TABLE IF NOT EXISTS $TABLE (mypk CHAR(10) NOT NULL PRIMARY KEY,CF.column1 char(10),CF.column2 char(10),CF.column3 char(10)) SALT_BUCKETS=16;

DATA GENERATOR
STRING :: Length: 10 Values: SEQUENTIAL
STRING :: Length: 10 Values: SEQUENTIAL
STRING :: Length: 10 Max. Value: 1000 Values: RANDOM
STRING :: Length: 10 Max. Value: 10000 Values: RANDOM

select count(column1) from LHS5M
3.18s PHOENIX-SNAPSHOT

LOAD DATA LHS5M [5000000 ROWS]
305.3s PHOENIX-SNAPSHOT

RHS100K




ROWS 100000 [0M]

DDL CREATE TABLE IF NOT EXISTS $TABLE (mypk CHAR(10) NOT NULL PRIMARY KEY,CF.column1 char(10),CF.column2 char(10),CF.column3 char(10)) SALT_BUCKETS=4;

DATA GENERATOR
STRING :: Length: 10 Values: SEQUENTIAL
STRING :: Length: 10 Values: SEQUENTIAL
STRING :: Length: 10 Max. Value: 1000 Values: RANDOM
STRING :: Length: 10 Max. Value: 10000 Values: RANDOM

select count(*) from RHS100K
0.14s PHOENIX-SNAPSHOT

select count(*) from LHS5M JOIN RHS100K on RHS100K.mypk = LHS5M.column1
SQL Exception - Check logs for PHOENIX-SNAPSHOT

select count(*) from LHS20M JOIN RHS100K on RHS100K.mypk = LHS20M.column1
SQL Exception - Check logs for PHOENIX-SNAPSHOT

LOAD DATA RHS100K [100000 ROWS]
5.66s PHOENIX-SNAPSHOT

RHS1K




ROWS 1000 [0M]

DDL CREATE TABLE IF NOT EXISTS $TABLE (mypk CHAR(10) NOT NULL PRIMARY KEY,CF.column1 char(10),CF.column2 char(10),CF.column3 char(10)) SALT_BUCKETS=4;

DATA GENERATOR
STRING :: Length: 10 Values: SEQUENTIAL
STRING :: Length: 10 Values: SEQUENTIAL
STRING :: Length: 10 Max. Value: 1000 Values: RANDOM
STRING :: Length: 10 Max. Value: 10000 Values: RANDOM

select count(*) from RHS1K
0.06s PHOENIX-SNAPSHOT

select count(*) from LHS5M JOIN RHS1K on RHS1K.mypk = LHS5M.column1
3.46s PHOENIX-SNAPSHOT

select count(*) from LHS20M JOIN RHS1K on RHS1K.mypk = LHS20M.column1
14.46s PHOENIX-SNAPSHOT

LOAD DATA RHS1K [1000 ROWS]
0.09s PHOENIX-SNAPSHOT

RHS250K




ROWS 250000 [0M]

DDL CREATE TABLE IF NOT EXISTS $TABLE (mypk CHAR(10) NOT NULL PRIMARY KEY,CF.column1 char(10),CF.column2 char(10),CF.column3 char(10)) SALT_BUCKETS=4;

DATA GENERATOR
STRING :: Length: 10 Values: SEQUENTIAL
STRING :: Length: 10 Values: SEQUENTIAL
STRING :: Length: 10 Max. Value: 1000 Values: RANDOM
STRING :: Length: 10 Max. Value: 10000 Values: RANDOM

select count(*) from RHS250K
0.22s PHOENIX-SNAPSHOT

select count(*) from LHS5M JOIN RHS250K on RHS250K.mypk = LHS5M.column1
SQL Exception - Check logs for PHOENIX-SNAPSHOT

select count(*) from LHS20M JOIN RHS250K on RHS250K.mypk = LHS20M.column1
SQL Exception - Check logs for PHOENIX-SNAPSHOT

LOAD DATA RHS250K [250000 ROWS]
14.56s PHOENIX-SNAPSHOT

RHS500K




ROWS 500000 [0M]

DDL CREATE TABLE IF NOT EXISTS $TABLE (mypk CHAR(10) NOT NULL PRIMARY KEY,CF.column1 char(10),CF.column2 char(10),CF.column3 char(10)) SALT_BUCKETS=4;

DATA GENERATOR
STRING :: Length: 10 Values: SEQUENTIAL
STRING :: Length: 10 Values: SEQUENTIAL
STRING :: Length: 10 Max. Value: 1000 Values: RANDOM
STRING :: Length: 10 Max. Value: 10000 Values: RANDOM

select count(*) from RHS500K
0.4s PHOENIX-SNAPSHOT

select count(*) from LHS5M JOIN RHS500K on RHS500K.mypk = LHS5M.column1
SQL Exception - Check logs for PHOENIX-SNAPSHOT

select count(*) from LHS20M JOIN RHS500K on RHS500K.mypk = LHS20M.column1
SQL Exception - Check logs for PHOENIX-SNAPSHOT

LOAD DATA RHS500K [500000 ROWS]
29.99s PHOENIX-SNAPSHOT


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