Apache Phoenix Performance Result :: Mon Feb 10 13:42:48 PST 2014
Queries by Category
JOIN
select count(column1) from LHS20M
|
select count(column1) from LHS5M
|
select count(*) from RHS1K
| select count(*) from LHS5M JOIN RHS1K on RHS1K.mypk = LHS5M.column1
|
select count(*) from LHS20M JOIN RHS1K on RHS1K.mypk = LHS20M.column1
|
select count(*) from RHS500K
| 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 |
|
select count(*) from RHS750K
| select count(*) from LHS5M JOIN RHS750K on RHS750K.mypk = LHS5M.column1| SQL Exception - Check logs for PHOENIX-SNAPSHOT |
|
select count(*) from LHS20M JOIN RHS750K on RHS750K.mypk = LHS20M.column1| SQL Exception - Check logs for PHOENIX-SNAPSHOT |
|
Load Data
LOAD DATA LHS20M [20000000 ROWS]
|
LOAD DATA LHS5M [5000000 ROWS]
|
LOAD DATA RHS1K [1000 ROWS]
|
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
| LOAD DATA LHS20M [20000000 ROWS]
|
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
| LOAD DATA LHS5M [5000000 ROWS]
|
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
| select count(*) from LHS5M JOIN RHS100K on RHS100K.mypk = LHS5M.column1
|
select count(*) from LHS20M JOIN RHS100K on RHS100K.mypk = LHS20M.column1
|
LOAD DATA RHS100K [100000 ROWS]
|
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
| select count(*) from LHS5M JOIN RHS1K on RHS1K.mypk = LHS5M.column1
|
select count(*) from LHS20M JOIN RHS1K on RHS1K.mypk = LHS20M.column1
|
LOAD DATA RHS1K [1000 ROWS]
|
RHS200K
ROWS 200000 [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 RHS200K
| select count(*) from LHS5M JOIN RHS200K on RHS200K.mypk = LHS5M.column1
|
select count(*) from LHS20M JOIN RHS200K on RHS200K.mypk = LHS20M.column1
|
LOAD DATA RHS200K [200000 ROWS]
|
RHS300K
ROWS 300000 [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 RHS300K
| select count(*) from LHS5M JOIN RHS300K on RHS300K.mypk = LHS5M.column1
|
select count(*) from LHS20M JOIN RHS300K on RHS300K.mypk = LHS20M.column1
|
LOAD DATA RHS300K [300000 ROWS]
|
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
| 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]
|
RHS750K
ROWS 750000 [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 RHS750K
| select count(*) from LHS5M JOIN RHS750K on RHS750K.mypk = LHS5M.column1| SQL Exception - Check logs for PHOENIX-SNAPSHOT |
|
select count(*) from LHS20M JOIN RHS750K on RHS750K.mypk = LHS20M.column1| SQL Exception - Check logs for PHOENIX-SNAPSHOT |
|
LOAD DATA RHS750K [750000 ROWS]
|
Note: Hover over version label to see Phoenix Query Explain Plan.