Apache Phoenix Performance Result :: Tue May 20 11:48:20 PDT 2014
Test Suite: ORDER_BY

Queries by Category

Aggregation

select count(*) from ORDERBY_TABLE_20M
29.87s V3.0.0-INCUBATING-RELEASE-HBASE-0.94.14-SECURITY

select count(*) from ORDERBY_TABLE_40M
28.9s V3.0.0-INCUBATING-RELEASE-HBASE-0.94.14-SECURITY

Group by

select host, domain from ORDERBY_TABLE_20M order by HOST,DB,ACTIVE_VISITOR
SQL Exception - Check logs for V3.0.0-INCUBATING-RELEASE-HBASE-0.94.14-SECURITY

select host, domain from ORDERBY_TABLE_40M order by HOST,DB,ACTIVE_VISITOR
SQL Exception - Check logs for V3.0.0-INCUBATING-RELEASE-HBASE-0.94.14-SECURITY

Load Data

LOAD DATA ORDERBY_TABLE_20M [20000000 ROWS]
1152.17s V3.0.0-INCUBATING-RELEASE-HBASE-0.94.14-SECURITY

LOAD DATA ORDERBY_TABLE_40M [40000000 ROWS]
2182.52s V3.0.0-INCUBATING-RELEASE-HBASE-0.94.14-SECURITY



Queries by Table

ORDERBY_TABLE_20M


Table used for various aggregation functions

ROWS 20000000 [20M]

DDL CREATE TABLE $TABLE (HOST CHAR(2) NOT NULL,DOMAIN VARCHAR NOT NULL,FEATURE VARCHAR NOT NULL,DATE DATE NOT NULL,USAGE.CORE BIGINT,USAGE.DB BIGINT,USAGE.ACTIVE_VISITOR INTEGER CONSTRAINT PK PRIMARY KEY (HOST, DOMAIN, FEATURE, DATE))

DATA GENERATOR
STRING :: Values: NA|CS|EU
STRING :: Values: Salesforce.com|Apple.com|Google.com|Yelp.com
STRING :: Values: Login|Report|Dashboard|Sales|UI
DATE :: Values: SEQUENTIAL
INTEGER :: Max. Value: 100 Values: RANDOM
INTEGER :: Max. Value: 2000 Values: RANDOM
INTEGER :: Max. Value: 10000 Values: RANDOM

select count(*) from ORDERBY_TABLE_20M
29.87s V3.0.0-INCUBATING-RELEASE-HBASE-0.94.14-SECURITY

select host, domain from ORDERBY_TABLE_20M order by HOST,DB,ACTIVE_VISITOR
SQL Exception - Check logs for V3.0.0-INCUBATING-RELEASE-HBASE-0.94.14-SECURITY

LOAD DATA ORDERBY_TABLE_20M [20000000 ROWS]
1152.17s V3.0.0-INCUBATING-RELEASE-HBASE-0.94.14-SECURITY

ORDERBY_TABLE_40M


Table used for various aggregation functions

ROWS 40000000 [40M]

DDL CREATE TABLE $TABLE (HOST CHAR(2) NOT NULL,DOMAIN VARCHAR NOT NULL,FEATURE VARCHAR NOT NULL,DATE DATE NOT NULL,USAGE.CORE BIGINT,USAGE.DB BIGINT,USAGE.ACTIVE_VISITOR INTEGER CONSTRAINT PK PRIMARY KEY (HOST, DOMAIN, FEATURE, DATE))

DATA GENERATOR
STRING :: Values: NA|CS|EU
STRING :: Values: Salesforce.com|Apple.com|Google.com|Yelp.com
STRING :: Values: Login|Report|Dashboard|Sales|UI
DATE :: Values: SEQUENTIAL
INTEGER :: Max. Value: 100 Values: RANDOM
INTEGER :: Max. Value: 2000 Values: RANDOM
INTEGER :: Max. Value: 10000 Values: RANDOM

select count(*) from ORDERBY_TABLE_40M
28.9s V3.0.0-INCUBATING-RELEASE-HBASE-0.94.14-SECURITY

select host, domain from ORDERBY_TABLE_40M order by HOST,DB,ACTIVE_VISITOR
SQL Exception - Check logs for V3.0.0-INCUBATING-RELEASE-HBASE-0.94.14-SECURITY

LOAD DATA ORDERBY_TABLE_40M [40000000 ROWS]
2182.52s V3.0.0-INCUBATING-RELEASE-HBASE-0.94.14-SECURITY


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