[
https://issues.apache.org/jira/browse/CASSANDRA-9664?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14978456#comment-14978456
]
Alan Boudreault edited comment on CASSANDRA-9664 at 10/28/15 1:59 PM:
----------------------------------------------------------------------
Reopening this issue. This change caused an important regression with MV
performance. I'm using mvbench to test with RF=3 and I confirm it's not a
driver issue.
{code}
EC2 RF=3 (i2.2xlarge, also tried on i2.4xlarge)
mvn exec:java -Dexec.args="--num-users 100000 --num-songs 1000000 --num-artists
10000 -n 500000 --endpoint node1"
3.0.0-beta2 (alpha2 java driver)
-----------
total
count = 461601
mean rate = 1923.21 calls/second
1-minute rate = 1937.82 calls/second
5-minute rate = 1424.09 calls/second
15-minute rate = 1058.28 calls/second
min = 1.90 milliseconds
max = 3707.76 milliseconds
mean = 516.42 milliseconds
stddev = 457.41 milliseconds
median = 390.07 milliseconds
75% <= 775.95 milliseconds
95% <= 1417.67 milliseconds
98% <= 1728.05 milliseconds
99% <= 1954.55 milliseconds
99.9% <= 2566.91 milliseconds
3.0.0-rc1 (alpha3 java driver)
---------
total
count = 310373
mean rate = 272.25 calls/second
1-minute rate = 0.00 calls/second
5-minute rate = 45.47 calls/second
15-minute rate = 295.94 calls/second
min = 1.05 milliseconds
max = 10468.98 milliseconds
mean = 492.99 milliseconds
stddev = 510.42 milliseconds
median = 281.02 milliseconds
75% <= 696.25 milliseconds
95% <= 1434.45 milliseconds
98% <= 1820.33 milliseconds
99% <= 2080.37 milliseconds
99.9% <= 4362.08 milliseconds
{code}
[~thobbs] any idea what could make things getting slower?
was (Author: aboudreault):
Reopening this issue. This change caused an important regression with MV
performance. I'm using mvbench to test with RF=3 and I confirm it's not a
driver issue.
{code}
EC2 RF=3 (i2.2xlarge, also tried on i2.4xlarge)
mvn exec:java -Dexec.args="--num-users 100000 --num-songs 1000000 --num-artists
10000 -n 500000 --endpoint node1"
3.0.0-beta2 (alpha2 java driver)
-----------
total
count = 461601
mean rate = 1923.21 calls/second
1-minute rate = 1937.82 calls/second
5-minute rate = 1424.09 calls/second
15-minute rate = 1058.28 calls/second
min = 1.90 milliseconds
max = 3707.76 milliseconds
mean = 516.42 milliseconds
stddev = 457.41 milliseconds
median = 390.07 milliseconds
75% <= 775.95 milliseconds
95% <= 1417.67 milliseconds
98% <= 1728.05 milliseconds
99% <= 1954.55 milliseconds
99.9% <= 2566.91 milliseconds
3.0.0-rc1 (alpha3 java driver)
---------
total
count = 310373
mean rate = 272.25 calls/second
1-minute rate = 0.00 calls/second
5-minute rate = 45.47 calls/second
15-minute rate = 295.94 calls/second
min = 1.05 milliseconds
max = 10468.98 milliseconds
mean = 492.99 milliseconds
stddev = 510.42 milliseconds
median = 281.02 milliseconds
75% <= 696.25 milliseconds
95% <= 1434.45 milliseconds
98% <= 1820.33 milliseconds
99% <= 2080.37 milliseconds
99.9% <= 4362.08 milliseconds
{code}
[~thobbs] any idea what could be wrong?
> Allow MV's select statements to be more complex
> -----------------------------------------------
>
> Key: CASSANDRA-9664
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9664
> Project: Cassandra
> Issue Type: New Feature
> Reporter: Carl Yeksigian
> Assignee: Tyler Hobbs
> Labels: client-impacting, doc-impacting
> Fix For: 3.0.0 rc1
>
>
> [Materialized Views|https://issues.apache.org/jira/browse/CASSANDRA-6477] add
> support for a syntax which includes a {{SELECT}} statement, but only allows
> selection of direct columns, and does not allow any filtering to take place.
> We should add support to the MV {{SELECT}} statement to bring better parity
> with the normal CQL {{SELECT}} statement, specifically simple functions in
> the selected columns, as well as specifying a {{WHERE}} clause.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
