Apache Phoenix Performance Result :: Mon Feb 10 12:07:35 PST 2014

---

Queries by Category

---

JOIN

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

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

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

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

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

select count(*) from RHS10K 0.1s PHOENIX-SNAPSHOT

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

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

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

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

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

---

Load Data

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

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

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

LOAD DATA RHS10K [10000 ROWS] 0.4s PHOENIX-SNAPSHOT

LOAD DATA RHS1K [1000 ROWS] 0.09s 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 6.83s PHOENIX-SNAPSHOT

LOAD DATA LHS20M [20000000 ROWS] 775.44s 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=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(column1) from LHS5M 4.14s PHOENIX-SNAPSHOT

LOAD DATA LHS5M [5000000 ROWS] 190.67s 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.12s PHOENIX-SNAPSHOT

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

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

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

---

RHS10K

ROWS 10000 [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 RHS10K 0.1s PHOENIX-SNAPSHOT

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

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

LOAD DATA RHS10K [10000 ROWS] 0.4s 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.09s PHOENIX-SNAPSHOT

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

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

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

---

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