Phoenix Performance Result :: Wed Jul 17 04:30:12 PDT 2013

---

AGGREGATION_TEST_TABLE
Various server side grouped/un-grouped aggregation functions. Data is pre-split in 9 regions over a 4 region server cluster.

ROWS 4000000 [4M]

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,STATS.ACTIVE_VISITOR INTEGER CONSTRAINT PK PRIMARY KEY (HOST, DOMAIN, FEATURE, DATE)) SPLIT ON ('CSGoogle','CSSalesforce','EUApple','EUGoogle','EUSalesforce','NAApple','NAGoogle','NASalesforce')

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

QUERIES

select count(*) from AGGREGATION_TEST_TABLE 2.22s CURRENT-SNAPSHOT 2.22s LAST-SNAPSHOT 2.12s PHOENIX-1.1 2.3s PHOENIX-1.2.0

select count(1) from AGGREGATION_TEST_TABLE group by HOST 2.29s CURRENT-SNAPSHOT 2.33s LAST-SNAPSHOT 2.25s PHOENIX-1.1 2.38s PHOENIX-1.2.0

select MIN(CORE) from AGGREGATION_TEST_TABLE group by DOMAIN 2.63s CURRENT-SNAPSHOT 2.67s LAST-SNAPSHOT 2.51s PHOENIX-1.1 2.56s PHOENIX-1.2.0

select core, count(1) from AGGREGATION_TEST_TABLE group by CORE 2.5s CURRENT-SNAPSHOT 2.59s LAST-SNAPSHOT 2.57s PHOENIX-1.1 2.55s PHOENIX-1.2.0

select core, host, sum(ACTIVE_VISITOR) from AGGREGATION_TEST_TABLE group by core, host 4.04s CURRENT-SNAPSHOT 4.15s LAST-SNAPSHOT 4.02s PHOENIX-1.1 4.13s PHOENIX-1.2.0

select AVG(DB), MIN(CORE), MAX(ACTIVE_VISITOR) from AGGREGATION_TEST_TABLE where host='CS' and DOMAIN<>'Google.com' 5.43s CURRENT-SNAPSHOT 5.82s LAST-SNAPSHOT 5.12s PHOENIX-1.1 5.7s PHOENIX-1.2.0

select round(date, 'day',50), sum(core)+2 from AGGREGATION_TEST_TABLE where (CORE<10 or CORE>90) group by round(date, 'day',50), host 1.84s CURRENT-SNAPSHOT 1.85s LAST-SNAPSHOT 1.79s PHOENIX-1.1 1.81s PHOENIX-1.2.0

select trunc(date, 'hour', 1000), count(DB), count(ACTIVE_VISITOR) from AGGREGATION_TEST_TABLE where feature='Login' and (core<50 or db<20 or active_visitor > 200) group by trunc(date, 'hour', 1000) 2.62s 200)) SERVER AGGREGATE INTO DISTINCT ROWS BY [ROUND(DATE)] CLIENT MERGE SORT'>CURRENT-SNAPSHOT 2.54s 200)) SERVER AGGREGATE INTO DISTINCT ROWS BY [ROUND(DATE)] CLIENT MERGE SORT'>LAST-SNAPSHOT 3.45s 200)) SERVER AGGREGATE INTO DISTINCT ROWS BY [ROUND(DATE)] CLIENT MERGE SORT'>PHOENIX-1.1 2.46s 200)) SERVER AGGREGATE INTO DISTINCT ROWS BY [ROUND(DATE)] CLIENT MERGE SORT'>PHOENIX-1.2.0

select count(active_visitor) count from AGGREGATION_TEST_TABLE 3.64s CURRENT-SNAPSHOT 3.67s LAST-SNAPSHOT 3.47s PHOENIX-1.1 3.55s PHOENIX-1.2.0

select count(distinct active_visitor) count from AGGREGATION_TEST_TABLE 4.05s CURRENT-SNAPSHOT 4.03s LAST-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select percentile_cont(0.9) within group (order by active_visitor asc) from AGGREGATION_TEST_TABLE 4.03s CURRENT-SNAPSHOT 4.08s LAST-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select percentile_cont(0.1) within group (order by active_visitor desc) from AGGREGATION_TEST_TABLE 4.02s CURRENT-SNAPSHOT 4.06s LAST-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select count(core), count(db), count(active_visitor) from AGGREGATION_TEST_TABLE 5.06s CURRENT-SNAPSHOT 5.17s LAST-SNAPSHOT 4.81s PHOENIX-1.1 5.02s PHOENIX-1.2.0

select count(distinct core), count(distinct db), count(distinct active_visitor) from AGGREGATION_TEST_TABLE 5.79s CURRENT-SNAPSHOT 5.89s LAST-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select percentile_cont(0.5) within group (order by core asc), percentile_cont(0.5) within group (order by db asc), percentile_cont(0.5) within group (order by active_visitor asc) from AGGREGATION_TEST_TABLE 5.82s CURRENT-SNAPSHOT 5.86s LAST-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select core, count(db) count from AGGREGATION_TEST_TABLE group by CORE 3.68s CURRENT-SNAPSHOT 3.83s LAST-SNAPSHOT 3.68s PHOENIX-1.1 3.71s PHOENIX-1.2.0

select core, count(distinct db) count from AGGREGATION_TEST_TABLE group by CORE 5.14s CURRENT-SNAPSHOT 5.18s LAST-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select core, percentile_cont(0.9999) within group (order by db asc) from AGGREGATION_TEST_TABLE group by CORE 5.21s CURRENT-SNAPSHOT 5.17s LAST-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core < 10 and active_visitor < 1000 1.52s CURRENT-SNAPSHOT 1.46s LAST-SNAPSHOT 2.65s PHOENIX-1.1 1.38s PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core < 50 and active_visitor < 5000 1.6s CURRENT-SNAPSHOT 1.5s LAST-SNAPSHOT 3.17s PHOENIX-1.1 1.43s PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core < 100 and active_visitor < 10000 1.67s CURRENT-SNAPSHOT 1.56s LAST-SNAPSHOT 4.38s PHOENIX-1.1 1.47s PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core > 90 1.61s CURRENT-SNAPSHOT 1.54s LAST-SNAPSHOT 1.46s PHOENIX-1.1 1.5s PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core > 50 2.31s CURRENT-SNAPSHOT 2.15s LAST-SNAPSHOT 2.02s PHOENIX-1.1 2.11s PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core > 0 3s CURRENT-SNAPSHOT 2.82s LAST-SNAPSHOT 2.62s PHOENIX-1.1 2.77s PHOENIX-1.2.0

LOAD DATA [4000000 ROWS] 127.69s CURRENT-SNAPSHOT 128.04s LAST-SNAPSHOT 122.3s PHOENIX-1.1 148.7s PHOENIX-1.2.0

---

IN_LIKE_TABLE
Phoenix 1.2+ uses skip scan that gives significant performance improvement for IN/LIKE queries.

ROWS 4000000 [4M]

DDL CREATE TABLE IF NOT EXISTS $TABLE (K1 CHAR(1) NOT NULL, K2 VARCHAR NOT NULL, CF.A INTEGER, CF.B VARCHAR, CF.C VARCHAR CONSTRAINT PK PRIMARY KEY (K1,K2)) SPLIT ON ('B','C','D','E','F','G','H','I')

DATA GENERATOR
STRING :: Values: A|B|C|D|E|F|G|H|I
STRING :: Length: 10 Values: SEQUENTIAL
INTEGER :: Max. Value: 1000000 Values: RANDOM
STRING :: Length: 50 Values: RANDOM
STRING :: Length: 50 Values: RANDOM

QUERIES

select count(1) from IN_LIKE_TABLE where K1 in ('Z', 'D', 'F', 'X') 1.24s CURRENT-SNAPSHOT 1.14s LAST-SNAPSHOT 1.28s PHOENIX-1.1 1.18s PHOENIX-1.2.0

select * from IN_LIKE_TABLE where K1 in ('A','B') and K2 in ('xxx1000000','xxx2000000','xxx2000001') 0.01s CURRENT-SNAPSHOT 0.01s LAST-SNAPSHOT 1.72s PHOENIX-1.1 0.01s PHOENIX-1.2.0

select * from IN_LIKE_TABLE where K1 in ('A', 'C', 'E', 'F', 'H') and K2 like 'xxxxxx1%' 0.01s CURRENT-SNAPSHOT 0.01s LAST-SNAPSHOT 7.86s PHOENIX-1.1 0.02s PHOENIX-1.2.0

select count(*) from IN_LIKE_TABLE where K1 in ('X','A','B','C','D','E','F','G','H','I','Z') and K2 like '%1%' 1.86s CURRENT-SNAPSHOT 1.81s LAST-SNAPSHOT 1.64s PHOENIX-1.1 1.85s PHOENIX-1.2.0

select count(*) from IN_LIKE_TABLE where (K1 in ('A','E','F','G','H','I','Z') or K1 like 'E%') and (K2 like '%xx1%' or K2 like '%xxxxxx2%') 1.87s CURRENT-SNAPSHOT 1.84s LAST-SNAPSHOT 1.67s PHOENIX-1.1 1.84s PHOENIX-1.2.0

LOAD DATA [4000000 ROWS] 99.51s CURRENT-SNAPSHOT 99.39s LAST-SNAPSHOT 97.25s PHOENIX-1.1 129.75s PHOENIX-1.2.0

---

INDEXED_TEST_TABLE
Indexing test. Phoenix 2.0+ feature. Data is pre-split in 9 regions over a 4 region server cluster.

ROWS 2000000 [2M]

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,STATS.ACTIVE_VISITOR INTEGER CONSTRAINT PK PRIMARY KEY (HOST, DOMAIN, FEATURE, DATE)) IMMUTABLE_ROWS=true SPLIT ON ('CSGoogle','CSSalesforce','EUApple','EUGoogle','EUSalesforce','NAApple','NAGoogle','NASalesforce');CREATE INDEX INDEX_CORE ON $TABLE (CORE);CREATE INDEX INDEX_DB ON $TABLE (DB);CREATE INDEX INDEX_ACTIVE_VISITOR ON $TABLE (ACTIVE_VISITOR);CREATE INDEX INDEX_ALL ON $TABLE (CORE,DB,ACTIVE_VISITOR);

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

QUERIES

select count(*) from INDEXED_TEST_TABLE 1.17s CURRENT-SNAPSHOT 1.12s LAST-SNAPSHOT 1.1s PHOENIX-1.1 1.12s PHOENIX-1.2.0

select count(1) from INDEXED_TEST_TABLE group by HOST 1.24s CURRENT-SNAPSHOT 1.16s LAST-SNAPSHOT 1.17s PHOENIX-1.1 1.18s PHOENIX-1.2.0

select MIN(CORE) from INDEXED_TEST_TABLE group by DOMAIN 1.4s CURRENT-SNAPSHOT 1.34s LAST-SNAPSHOT 1.35s PHOENIX-1.1 1.36s PHOENIX-1.2.0

select core, count(1) from INDEXED_TEST_TABLE group by CORE 5.1s CURRENT-SNAPSHOT 4.69s LAST-SNAPSHOT 1.36s PHOENIX-1.1 1.32s PHOENIX-1.2.0

select core, host, sum(ACTIVE_VISITOR) from INDEXED_TEST_TABLE group by core, host 2.21s CURRENT-SNAPSHOT 2.06s LAST-SNAPSHOT 2.17s PHOENIX-1.1 2.13s PHOENIX-1.2.0

select AVG(DB), MIN(CORE), MAX(ACTIVE_VISITOR) from INDEXED_TEST_TABLE where host='CS' and DOMAIN<>'Google.com' 2.9s CURRENT-SNAPSHOT 2.7s LAST-SNAPSHOT 2.62s PHOENIX-1.1 2.98s PHOENIX-1.2.0

select round(date, 'day',50), sum(core)+2 from INDEXED_TEST_TABLE where (CORE<10 or CORE>90) group by round(date, 'day',50), host 0.01s CURRENT-SNAPSHOT 0.01s LAST-SNAPSHOT 0.93s PHOENIX-1.1 0.97s PHOENIX-1.2.0

select trunc(date, 'hour', 1000), count(DB), count(ACTIVE_VISITOR) from INDEXED_TEST_TABLE where feature='Login' and (core<50 or db<20 or active_visitor > 200) group by trunc(date, 'hour', 1000) 1.23s 200)) SERVER AGGREGATE INTO DISTINCT ROWS BY [ROUND(DATE)] CLIENT MERGE SORT'>CURRENT-SNAPSHOT 1.23s 200)) SERVER AGGREGATE INTO DISTINCT ROWS BY [ROUND(DATE)] CLIENT MERGE SORT'>LAST-SNAPSHOT 1.74s 200)) SERVER AGGREGATE INTO DISTINCT ROWS BY [ROUND(DATE)] CLIENT MERGE SORT'>PHOENIX-1.1 1.27s 200)) SERVER AGGREGATE INTO DISTINCT ROWS BY [ROUND(DATE)] CLIENT MERGE SORT'>PHOENIX-1.2.0

select count(active_visitor) count from INDEXED_TEST_TABLE 1.88s CURRENT-SNAPSHOT 1.74s LAST-SNAPSHOT 1.79s PHOENIX-1.1 1.79s PHOENIX-1.2.0

select count(distinct active_visitor) count from INDEXED_TEST_TABLE 2.11s CURRENT-SNAPSHOT 1.98s LAST-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select percentile_cont(0.9) within group (order by active_visitor asc) from INDEXED_TEST_TABLE 2.13s CURRENT-SNAPSHOT 1.99s LAST-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select percentile_cont(0.1) within group (order by active_visitor desc) from INDEXED_TEST_TABLE 2.12s CURRENT-SNAPSHOT 2s LAST-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select count(core), count(db), count(active_visitor) from INDEXED_TEST_TABLE 2.59s CURRENT-SNAPSHOT 2.43s LAST-SNAPSHOT 2.46s PHOENIX-1.1 2.53s PHOENIX-1.2.0

select count(distinct core), count(distinct db), count(distinct active_visitor) from INDEXED_TEST_TABLE 3.05s CURRENT-SNAPSHOT 2.9s LAST-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select percentile_cont(0.5) within group (order by core asc), percentile_cont(0.5) within group (order by db asc), percentile_cont(0.5) within group (order by active_visitor asc) from INDEXED_TEST_TABLE 3.07s CURRENT-SNAPSHOT 2.92s LAST-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select core, count(db) count from INDEXED_TEST_TABLE group by CORE 5.9s CURRENT-SNAPSHOT 5.35s LAST-SNAPSHOT 1.92s PHOENIX-1.1 1.84s PHOENIX-1.2.0

select core, count(distinct db) count from INDEXED_TEST_TABLE group by CORE 5.87s CURRENT-SNAPSHOT 5.27s LAST-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select core, percentile_cont(0.9999) within group (order by db asc) from INDEXED_TEST_TABLE group by CORE 6.53s CURRENT-SNAPSHOT 5.84s LAST-SNAPSHOT N/A for PHOENIX-1.1 N/A for PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core < 10 and active_visitor < 1000 0.6s CURRENT-SNAPSHOT 0.53s LAST-SNAPSHOT 1.39s PHOENIX-1.1 0.74s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core < 50 and active_visitor < 5000 3.22s CURRENT-SNAPSHOT 2.76s LAST-SNAPSHOT 1.66s PHOENIX-1.1 0.75s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core < 100 and active_visitor < 10000 6.85s CURRENT-SNAPSHOT 5.58s LAST-SNAPSHOT 2.36s PHOENIX-1.1 0.77s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core > 90 0.46s CURRENT-SNAPSHOT 0.41s LAST-SNAPSHOT 0.74s PHOENIX-1.1 0.8s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core > 50 2.36s CURRENT-SNAPSHOT 2.13s LAST-SNAPSHOT 1.06s PHOENIX-1.1 1.09s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core > 0 4.71s CURRENT-SNAPSHOT 4.28s LAST-SNAPSHOT 1.39s PHOENIX-1.1 1.39s PHOENIX-1.2.0

LOAD DATA [2000000 ROWS] 278.05s CURRENT-SNAPSHOT 276.01s LAST-SNAPSHOT 60.03s PHOENIX-1.1 80.17s PHOENIX-1.2.0

---

CF_TABLE_14CF
Data is split in 14 column families. Phoenix 1.2+ uses Essential Column Family filter feature which fetches only required columns when filtering rows.

ROWS 4000000 [4M]

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, CF7.G INTEGER, CF8.H INTEGER, CF9.I INTEGER, CF10.J INTEGER, CF11.K INTEGER, CF12.L INTEGER, CF13.M INTEGER, CF14.N 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: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM

QUERIES

select count(1) from CF_TABLE_14CF where K1 in ('A', 'B', 'C', 'D') 3.45s CURRENT-SNAPSHOT 3.31s LAST-SNAPSHOT 3.3s PHOENIX-1.1 3.28s PHOENIX-1.2.0

select count(1) from CF_TABLE_14CF where K1 in ('A', 'C') 3.34s CURRENT-SNAPSHOT 3.28s LAST-SNAPSHOT 3.29s PHOENIX-1.1 3.23s PHOENIX-1.2.0

select count(*) from CF_TABLE_14CF where N < 1000 1.76s CURRENT-SNAPSHOT 1.72s LAST-SNAPSHOT 4.77s PHOENIX-1.1 1.73s PHOENIX-1.2.0

select a,b,c,d,e,f,g,h,i,j,k,l,m,n from CF_TABLE_14CF where (B>1000 and B<2000) and (M>1000 and M<2000) 2.59s CURRENT-SNAPSHOT 2.41s LAST-SNAPSHOT 128.18s PHOENIX-1.1 2.4s PHOENIX-1.2.0

select sum(a),sum(e),sum(j),sum(n) from CF_TABLE_14CF group by K1 11.27s CURRENT-SNAPSHOT 10.44s LAST-SNAPSHOT 9.86s PHOENIX-1.1 10.4s PHOENIX-1.2.0

LOAD DATA [4000000 ROWS] 200.37s CURRENT-SNAPSHOT 204.08s LAST-SNAPSHOT 192.35s PHOENIX-1.1 263.02s PHOENIX-1.2.0

---

SALTED_TABLE
This is Phoenix 1.2+ feature. Data is split in 4 regions equal to number of region servers in test cluster by adding salted byte to each key.

ROWS 4000000 [4M]

DDL CREATE TABLE $TABLE (K1 CHAR(1) NOT NULL, K2 VARCHAR NOT NULL, CFA.A VARCHAR, CFA.B CHAR(100), CFA.C INTEGER, CFB.D INTEGER CONSTRAINT PK PRIMARY KEY (K1,K2)) SALT_BUCKETS=4

DATA GENERATOR
STRING :: Values: A|B|C|D
STRING :: Length: 10 Values: SEQUENTIAL
STRING :: Length: 100 Values: RANDOM
STRING :: Length: 100 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM

QUERIES

select count(1) from SALTED_TABLE where K1 in ('A', 'B', 'C', 'D') 1.79s CURRENT-SNAPSHOT 1.87s LAST-SNAPSHOT 5.59s PHOENIX-1.1 1.93s PHOENIX-1.2.0

select count(*) from SALTED_TABLE where D < 1000 0.91s CURRENT-SNAPSHOT 0.92s LAST-SNAPSHOT 7.82s PHOENIX-1.1 0.9s PHOENIX-1.2.0

select avg(c),avg(d) from SALTED_TABLE group by K1 4.24s CURRENT-SNAPSHOT 3.99s LAST-SNAPSHOT 11.3s PHOENIX-1.1 4.11s PHOENIX-1.2.0

LOAD DATA [4000000 ROWS] 128.7s CURRENT-SNAPSHOT 129.69s LAST-SNAPSHOT 175.94s PHOENIX-1.1 158.62s PHOENIX-1.2.0

---

CF_TABLE_1CF
Same data as in 14 column family table but this one only has a single column family. Performance should be worse in most cases.

ROWS 4000000 [4M]

DDL CREATE TABLE IF NOT EXISTS $TABLE (K1 CHAR(1) NOT NULL, K2 VARCHAR NOT NULL, CF.A INTEGER, CF.B INTEGER, CF.C INTEGER, CF.D INTEGER, CF.E INTEGER, CF.F INTEGER, CF.G INTEGER, CF.H INTEGER, CF.I INTEGER, CF.J INTEGER, CF.K INTEGER, CF.L INTEGER, CF.M INTEGER, CF.N 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: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM

QUERIES

select count(1) from CF_TABLE_1CF where K1 in ('A', 'B', 'C', 'D') 4.23s CURRENT-SNAPSHOT 4.2s LAST-SNAPSHOT 4.2s PHOENIX-1.1 4.15s PHOENIX-1.2.0

select count(1) from CF_TABLE_1CF where K1 in ('A', 'C') 3.99s CURRENT-SNAPSHOT 3.93s LAST-SNAPSHOT 4.18s PHOENIX-1.1 4.07s PHOENIX-1.2.0

select count(*) from CF_TABLE_1CF where N < 1000 5.63s CURRENT-SNAPSHOT 5.49s LAST-SNAPSHOT 5.24s PHOENIX-1.1 5.63s PHOENIX-1.2.0

select a,b,c,d,e,f,g,h,i,j,k,l,m,n from CF_TABLE_1CF where B>1000 and B<2000 and M>1000 and M<2000 6.73s CURRENT-SNAPSHOT 6.63s LAST-SNAPSHOT 24.15s PHOENIX-1.1 6.62s PHOENIX-1.2.0

select sum(a),sum(e),sum(j),sum(n) from CF_TABLE_1CF group by K1 12.26s CURRENT-SNAPSHOT 11.78s LAST-SNAPSHOT 11.43s PHOENIX-1.1 11.94s PHOENIX-1.2.0

LOAD DATA [4000000 ROWS] 172.12s CURRENT-SNAPSHOT 174.54s LAST-SNAPSHOT 162.94s PHOENIX-1.1 224.08s PHOENIX-1.2.0

---

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