[
https://issues.apache.org/jira/browse/CASSANDRA-6960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
J.B. Langston updated CASSANDRA-6960:
-------------------------------------
Reproduced In: 2.0.5
Description:
Given this table definition:
{code}
CREATE TABLE metric_log_a (
destination_id text,
rate_plan_id int,
metric_name text,
extraction_date 'org.apache.cassandra.db.marshal.TimestampType',
metric_value text,
PRIMARY KEY (destination_id, rate_plan_id, metric_name, extraction_date)
);
{code}
It seems that Cassandra should be able to perform the following query without
ALLOW FILTERING:
{code}
select destination_id, rate_plan_id, metric_name, extraction_date, metric_value
from metric_log_a
where token(destination_id) > ?
and token(destination_id) <= ?
and rate_plan_id=90
and metric_name='minutesOfUse'
and extraction_date >= '2014-03-05'
and extraction_date <= '2014-03-05'
allow filtering;
{code}
However, it will refuse to run unless ALLOW FILTERING is specified.
Summary: Cassandra requires ALLOW FILTERING for a range scan (was:
Cassandra requires allow filtering")
> Cassandra requires ALLOW FILTERING for a range scan
> ---------------------------------------------------
>
> Key: CASSANDRA-6960
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6960
> Project: Cassandra
> Issue Type: Bug
> Reporter: J.B. Langston
>
> Given this table definition:
> {code}
> CREATE TABLE metric_log_a (
> destination_id text,
> rate_plan_id int,
> metric_name text,
> extraction_date 'org.apache.cassandra.db.marshal.TimestampType',
> metric_value text,
> PRIMARY KEY (destination_id, rate_plan_id, metric_name, extraction_date)
> );
> {code}
> It seems that Cassandra should be able to perform the following query without
> ALLOW FILTERING:
> {code}
> select destination_id, rate_plan_id, metric_name, extraction_date,
> metric_value
> from metric_log_a
> where token(destination_id) > ?
> and token(destination_id) <= ?
> and rate_plan_id=90
> and metric_name='minutesOfUse'
> and extraction_date >= '2014-03-05'
> and extraction_date <= '2014-03-05'
> allow filtering;
> {code}
> However, it will refuse to run unless ALLOW FILTERING is specified.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
