Phoenix Performance Result :: Tue Jul 16 18:35:25 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.42s CURRENT-SNAPSHOT 2.19s LAST-SNAPSHOT 2.2s PHOENIX-1.1 2.2s PHOENIX-1.2.0

select count(1) from AGGREGATION_TEST_TABLE group by HOST 2.44s CURRENT-SNAPSHOT 2.27s LAST-SNAPSHOT 2.27s PHOENIX-1.1 2.34s PHOENIX-1.2.0

select MIN(CORE) from AGGREGATION_TEST_TABLE group by DOMAIN 2.72s CURRENT-SNAPSHOT 2.55s LAST-SNAPSHOT 2.58s PHOENIX-1.1 2.63s PHOENIX-1.2.0

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

select core, host, sum(ACTIVE_VISITOR) from AGGREGATION_TEST_TABLE group by core, host 4.28s CURRENT-SNAPSHOT 4.14s LAST-SNAPSHOT 4.09s PHOENIX-1.1 4.18s PHOENIX-1.2.0

select AVG(DB), MIN(CORE), MAX(ACTIVE_VISITOR) from AGGREGATION_TEST_TABLE where host='CS' and DOMAIN<>'Google.com' 5.98s CURRENT-SNAPSHOT 5.7s LAST-SNAPSHOT 5.29s PHOENIX-1.1 5.37s 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.9s CURRENT-SNAPSHOT 1.84s LAST-SNAPSHOT 1.78s PHOENIX-1.1 1.84s 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.65s 200)) SERVER AGGREGATE INTO DISTINCT ROWS BY [ROUND(DATE)] CLIENT MERGE SORT'>CURRENT-SNAPSHOT 2.58s 200)) SERVER AGGREGATE INTO DISTINCT ROWS BY [ROUND(DATE)] CLIENT MERGE SORT'>LAST-SNAPSHOT 3.49s 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.83s CURRENT-SNAPSHOT 3.52s LAST-SNAPSHOT 3.54s PHOENIX-1.1 3.57s PHOENIX-1.2.0

select count(distinct active_visitor) count from AGGREGATION_TEST_TABLE 4.19s CURRENT-SNAPSHOT 4.06s 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.22s CURRENT-SNAPSHOT 4.06s 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.16s CURRENT-SNAPSHOT 3.99s 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.27s CURRENT-SNAPSHOT 4.88s LAST-SNAPSHOT 4.92s PHOENIX-1.1 4.98s PHOENIX-1.2.0

select count(distinct core), count(distinct db), count(distinct active_visitor) from AGGREGATION_TEST_TABLE 6.06s CURRENT-SNAPSHOT 5.79s 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 6.13s CURRENT-SNAPSHOT 5.85s 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.93s CURRENT-SNAPSHOT 3.66s LAST-SNAPSHOT 3.76s PHOENIX-1.1 3.82s PHOENIX-1.2.0

select core, count(distinct db) count from AGGREGATION_TEST_TABLE group by CORE 5.28s CURRENT-SNAPSHOT 5.04s 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.32s CURRENT-SNAPSHOT 5.12s 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.44s CURRENT-SNAPSHOT 1.47s LAST-SNAPSHOT 2.76s PHOENIX-1.1 1.37s PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core < 50 and active_visitor < 5000 1.56s CURRENT-SNAPSHOT 1.56s LAST-SNAPSHOT 3.35s PHOENIX-1.1 1.47s PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core < 100 and active_visitor < 10000 1.6s CURRENT-SNAPSHOT 1.62s LAST-SNAPSHOT 4.6s PHOENIX-1.1 1.5s PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core > 90 1.52s CURRENT-SNAPSHOT 1.56s LAST-SNAPSHOT 1.5s PHOENIX-1.1 1.53s PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core > 50 2.18s CURRENT-SNAPSHOT 2.14s LAST-SNAPSHOT 2.11s PHOENIX-1.1 2.16s PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core > 0 2.92s CURRENT-SNAPSHOT 2.79s LAST-SNAPSHOT 2.76s PHOENIX-1.1 2.87s PHOENIX-1.2.0

LOAD DATA [4000000 ROWS] 126.32s CURRENT-SNAPSHOT 129.48s LAST-SNAPSHOT 118.63s PHOENIX-1.1 146.71s 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.25s CURRENT-SNAPSHOT 1.13s LAST-SNAPSHOT 1.2s PHOENIX-1.1 1.17s 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.76s 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.74s 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.91s CURRENT-SNAPSHOT 1.82s LAST-SNAPSHOT 1.59s PHOENIX-1.1 1.82s 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.88s CURRENT-SNAPSHOT 1.87s LAST-SNAPSHOT 1.66s PHOENIX-1.1 1.8s PHOENIX-1.2.0

LOAD DATA [4000000 ROWS] 101.01s CURRENT-SNAPSHOT 99.02s LAST-SNAPSHOT 97.78s PHOENIX-1.1 124.92s 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.21s CURRENT-SNAPSHOT 1.13s LAST-SNAPSHOT 1.12s PHOENIX-1.1 1.09s PHOENIX-1.2.0

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

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

select core, count(1) from INDEXED_TEST_TABLE group by CORE 5.23s CURRENT-SNAPSHOT 4.94s LAST-SNAPSHOT 1.35s PHOENIX-1.1 1.3s PHOENIX-1.2.0

select core, host, sum(ACTIVE_VISITOR) from INDEXED_TEST_TABLE group by core, host 2.28s CURRENT-SNAPSHOT 2.08s LAST-SNAPSHOT 2.12s PHOENIX-1.1 2.09s PHOENIX-1.2.0

select AVG(DB), MIN(CORE), MAX(ACTIVE_VISITOR) from INDEXED_TEST_TABLE where host='CS' and DOMAIN<>'Google.com' 2.82s CURRENT-SNAPSHOT 2.89s LAST-SNAPSHOT 2.62s PHOENIX-1.1 2.69s 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.93s 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.38s 200)) SERVER AGGREGATE INTO DISTINCT ROWS BY [ROUND(DATE)] CLIENT MERGE SORT'>CURRENT-SNAPSHOT 1.26s 200)) SERVER AGGREGATE INTO DISTINCT ROWS BY [ROUND(DATE)] CLIENT MERGE SORT'>LAST-SNAPSHOT 1.72s 200)) SERVER AGGREGATE INTO DISTINCT ROWS BY [ROUND(DATE)] CLIENT MERGE SORT'>PHOENIX-1.1 1.2s 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.98s CURRENT-SNAPSHOT 1.75s LAST-SNAPSHOT 1.74s PHOENIX-1.1 1.73s PHOENIX-1.2.0

select count(distinct active_visitor) count from INDEXED_TEST_TABLE 2.2s CURRENT-SNAPSHOT 2.05s 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.2s CURRENT-SNAPSHOT 2.04s 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.21s CURRENT-SNAPSHOT 2.04s 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.76s CURRENT-SNAPSHOT 2.49s LAST-SNAPSHOT 2.42s PHOENIX-1.1 2.43s PHOENIX-1.2.0

select count(distinct core), count(distinct db), count(distinct active_visitor) from INDEXED_TEST_TABLE 3.18s CURRENT-SNAPSHOT 2.97s 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.18s CURRENT-SNAPSHOT 2.99s 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.54s CURRENT-SNAPSHOT 5.49s LAST-SNAPSHOT 1.88s PHOENIX-1.1 1.86s PHOENIX-1.2.0

select core, count(distinct db) count from INDEXED_TEST_TABLE group by CORE 5.6s CURRENT-SNAPSHOT 5.5s 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.13s CURRENT-SNAPSHOT 6.07s 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.53s CURRENT-SNAPSHOT 0.53s LAST-SNAPSHOT 1.35s PHOENIX-1.1 0.68s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core < 50 and active_visitor < 5000 2.81s CURRENT-SNAPSHOT 2.78s LAST-SNAPSHOT 1.65s PHOENIX-1.1 0.73s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core < 100 and active_visitor < 10000 5.9s CURRENT-SNAPSHOT 5.78s LAST-SNAPSHOT 2.27s PHOENIX-1.1 0.75s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core > 90 0.46s CURRENT-SNAPSHOT 0.45s LAST-SNAPSHOT 0.76s PHOENIX-1.1 0.75s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core > 50 2.41s CURRENT-SNAPSHOT 2.32s LAST-SNAPSHOT 1.04s PHOENIX-1.1 1.06s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core > 0 4.82s CURRENT-SNAPSHOT 4.62s LAST-SNAPSHOT 1.38s PHOENIX-1.1 1.4s PHOENIX-1.2.0

LOAD DATA [2000000 ROWS] 272.46s CURRENT-SNAPSHOT 279.89s LAST-SNAPSHOT 59.55s PHOENIX-1.1 81.3s 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.46s CURRENT-SNAPSHOT 3.32s LAST-SNAPSHOT 3.31s PHOENIX-1.1 3.21s PHOENIX-1.2.0

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

select count(*) from CF_TABLE_14CF where N < 1000 1.83s CURRENT-SNAPSHOT 1.73s LAST-SNAPSHOT 4.78s PHOENIX-1.1 1.7s 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.54s CURRENT-SNAPSHOT 2.37s LAST-SNAPSHOT 124s PHOENIX-1.1 2.3s PHOENIX-1.2.0

select sum(a),sum(e),sum(j),sum(n) from CF_TABLE_14CF group by K1 10.54s CURRENT-SNAPSHOT 10.3s LAST-SNAPSHOT 9.76s PHOENIX-1.1 10.03s PHOENIX-1.2.0

LOAD DATA [4000000 ROWS] 201.7s CURRENT-SNAPSHOT 205.28s LAST-SNAPSHOT 196.07s PHOENIX-1.1 264.32s 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') 2.3s CURRENT-SNAPSHOT 1.88s LAST-SNAPSHOT 5.71s PHOENIX-1.1 1.81s PHOENIX-1.2.0

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

select avg(c),avg(d) from SALTED_TABLE group by K1 4.07s CURRENT-SNAPSHOT 3.98s LAST-SNAPSHOT 10.94s PHOENIX-1.1 4.05s PHOENIX-1.2.0

LOAD DATA [4000000 ROWS] 129.26s CURRENT-SNAPSHOT 127.92s LAST-SNAPSHOT 181.98s PHOENIX-1.1 161.58s 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.04s LAST-SNAPSHOT 4.2s PHOENIX-1.1 4.06s PHOENIX-1.2.0

select count(1) from CF_TABLE_1CF where K1 in ('A', 'C') 4.23s CURRENT-SNAPSHOT 4.04s LAST-SNAPSHOT 4.13s PHOENIX-1.1 4.01s PHOENIX-1.2.0

select count(*) from CF_TABLE_1CF where N < 1000 5.69s CURRENT-SNAPSHOT 5.44s LAST-SNAPSHOT 5.39s PHOENIX-1.1 5.49s 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.84s CURRENT-SNAPSHOT 6.56s LAST-SNAPSHOT 24.93s PHOENIX-1.1 6.59s PHOENIX-1.2.0

select sum(a),sum(e),sum(j),sum(n) from CF_TABLE_1CF group by K1 12.39s CURRENT-SNAPSHOT 11.88s LAST-SNAPSHOT 12.05s PHOENIX-1.1 12.16s PHOENIX-1.2.0

LOAD DATA [4000000 ROWS] 172.3s CURRENT-SNAPSHOT 176.13s LAST-SNAPSHOT 161.54s PHOENIX-1.1 219.63s PHOENIX-1.2.0

---

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