[
https://issues.apache.org/jira/browse/CASSANDRA-9724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14616869#comment-14616869
]
Tyler Hobbs commented on CASSANDRA-9724:
----------------------------------------
[~slebresne] it's not trivial, but it is possible. It should take a day or
less of work.
> Aggregate appears to be causing query to be executed multiple times
> -------------------------------------------------------------------
>
> Key: CASSANDRA-9724
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9724
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Reporter: Christopher Batey
> Assignee: Robert Stupp
> Attachments: 9724.txt, data.zip
>
>
> Not sure if this is intended behaviour.
> Example table:
> {noformat}
> CREATE TABLE raw_weather_data (
> wsid text, // Composite of Air Force Datsav3 station number
> and NCDC WBAN number
> year int, // Year collected
> month int, // Month collected
> day int, // Day collected
> hour int, // Hour collected
> temperature double, // Air temperature (degrees Celsius)
> dewpoint double, // Dew point temperature (degrees Celsius)
> pressure double, // Sea level pressure (hectopascals)
> wind_direction int, // Wind direction in degrees. 0-359
> wind_speed double, // Wind speed (meters per second)
> sky_condition int, // Total cloud cover (coded, see format
> documentation)
> sky_condition_text text, // Non-coded sky conditions
> one_hour_precip double, // One-hour accumulated liquid precipitation
> (millimeters)
> six_hour_precip double, // Six-hour accumulated liquid precipitation
> (millimeters)
> PRIMARY KEY ((wsid), year, month, day, hour)
> ) WITH CLUSTERING ORDER BY (year DESC, month DESC, day DESC, hour DESC);
> {noformat}
> 1 node cluster 2.2rc1. Trace for: select temperature from raw_weather_data
> where wsid = '725030:14732' and year = 2008;
> {noformat}
> activity
> | timestamp | source
> | source_elapsed
> ---------------------------------------------------------------------------------------------------------------------+----------------------------+-----------+----------------
>
> Execute CQL3 query | 2015-07-03 09:53:25.002000 |
> 127.0.0.1 | 0
> Parsing select temperature from raw_weather_data where wsid = '725030:14732'
> and year = 2008; [SharedPool-Worker-1] | 2015-07-03 09:53:25.002000 |
> 127.0.0.1 | 109
>
> Preparing statement [SharedPool-Worker-1] | 2015-07-03 09:53:25.002000 |
> 127.0.0.1 | 193
> Executing single-partition query on
> raw_weather_data [SharedPool-Worker-2] | 2015-07-03 09:53:25.002000 |
> 127.0.0.1 | 519
> Acquiring
> sstable references [SharedPool-Worker-2] | 2015-07-03 09:53:25.002000 |
> 127.0.0.1 | 544
> Merging
> memtable tombstones [SharedPool-Worker-2] | 2015-07-03 09:53:25.002000 |
> 127.0.0.1 | 558
> Skipped 0/0 non-slice-intersecting sstables, included 0
> due to tombstones [SharedPool-Worker-2] | 2015-07-03 09:53:25.002001 |
> 127.0.0.1 | 600
> Merging data from
> memtables and 0 sstables [SharedPool-Worker-2] | 2015-07-03 09:53:25.002001 |
> 127.0.0.1 | 612
> Read 92 live and
> 0 tombstone cells [SharedPool-Worker-2] | 2015-07-03 09:53:25.003000 |
> 127.0.0.1 | 848
>
> Request complete | 2015-07-03 09:53:25.003680 |
> 127.0.0.1 | 1680
> {noformat}
> However once i include the min function i get: select min(temperature) from
> raw_weather_data where wsid = '725030:14732' and year = 2008;
> {noformat}
> activity
> | timestamp |
> source | source_elapsed
> --------------------------------------------------------------------------------------------------------------------------+----------------------------+-----------+----------------
>
> Execute CQL3 query | 2015-07-03 09:56:15.904000 |
> 127.0.0.1 | 0
> Parsing select min(temperature) from raw_weather_data where wsid =
> '725030:14732' and year = 2008; [SharedPool-Worker-1] | 2015-07-03
> 09:56:15.904000 | 127.0.0.1 | 108
>
> Preparing statement [SharedPool-Worker-1] | 2015-07-03 09:56:15.904000 |
> 127.0.0.1 | 201
> Executing single-partition
> query on raw_weather_data [SharedPool-Worker-2] | 2015-07-03 09:56:15.904000
> | 127.0.0.1 | 599
>
> Acquiring sstable references [SharedPool-Worker-2] | 2015-07-03
> 09:56:15.904000 | 127.0.0.1 | 625
>
> Merging memtable tombstones [SharedPool-Worker-2] | 2015-07-03
> 09:56:15.904000 | 127.0.0.1 | 639
> Skipped 0/0 non-slice-intersecting sstables,
> included 0 due to tombstones [SharedPool-Worker-2] | 2015-07-03
> 09:56:15.904001 | 127.0.0.1 | 681
> Merging data from
> memtables and 0 sstables [SharedPool-Worker-2] | 2015-07-03 09:56:15.904001 |
> 127.0.0.1 | 692
> Read 101 live
> and 0 tombstone cells [SharedPool-Worker-2] | 2015-07-03 09:56:15.905000 |
> 127.0.0.1 | 1007
> Executing single-partition
> query on raw_weather_data [SharedPool-Worker-3] | 2015-07-03 09:56:15.906000
> | 127.0.0.1 | 2258
>
> Acquiring sstable references [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.906000 | 127.0.0.1 | 2292
>
> Merging memtable tombstones [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.906000 | 127.0.0.1 | 2366
> Skipped 0/0 non-slice-intersecting sstables,
> included 0 due to tombstones [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.906000 | 127.0.0.1 | 2417
> Merging data from
> memtables and 0 sstables [SharedPool-Worker-3] | 2015-07-03 09:56:15.906000 |
> 127.0.0.1 | 2431
> Read 102 live
> and 0 tombstone cells [SharedPool-Worker-3] | 2015-07-03 09:56:15.906000 |
> 127.0.0.1 | 2824
> Executing single-partition
> query on raw_weather_data [SharedPool-Worker-3] | 2015-07-03 09:56:15.908000
> | 127.0.0.1 | 4224
>
> Acquiring sstable references [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.908000 | 127.0.0.1 | 4250
>
> Merging memtable tombstones [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.908000 | 127.0.0.1 | 4263
> Skipped 0/0 non-slice-intersecting sstables,
> included 0 due to tombstones [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.908000 | 127.0.0.1 | 4298
> Merging data from
> memtables and 0 sstables [SharedPool-Worker-3] | 2015-07-03 09:56:15.908000 |
> 127.0.0.1 | 4309
> Read 102 live
> and 0 tombstone cells [SharedPool-Worker-3] | 2015-07-03 09:56:15.908000 |
> 127.0.0.1 | 4571
> Executing single-partition
> query on raw_weather_data [SharedPool-Worker-2] | 2015-07-03 09:56:15.909000
> | 127.0.0.1 | 5358
>
> Acquiring sstable references [SharedPool-Worker-2] | 2015-07-03
> 09:56:15.909000 | 127.0.0.1 | 5381
>
> Merging memtable tombstones [SharedPool-Worker-2] | 2015-07-03
> 09:56:15.909000 | 127.0.0.1 | 5396
> Skipped 0/0 non-slice-intersecting sstables,
> included 0 due to tombstones [SharedPool-Worker-2] | 2015-07-03
> 09:56:15.909000 | 127.0.0.1 | 5426
> Merging data from
> memtables and 0 sstables [SharedPool-Worker-2] | 2015-07-03 09:56:15.909000 |
> 127.0.0.1 | 5437
> Read 102 live
> and 0 tombstone cells [SharedPool-Worker-2] | 2015-07-03 09:56:15.909000 |
> 127.0.0.1 | 5691
> Executing single-partition
> query on raw_weather_data [SharedPool-Worker-3] | 2015-07-03 09:56:15.911000
> | 127.0.0.1 | 7233
>
> Acquiring sstable references [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.911000 | 127.0.0.1 | 7260
>
> Merging memtable tombstones [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.911000 | 127.0.0.1 | 7273
> Skipped 0/0 non-slice-intersecting sstables,
> included 0 due to tombstones [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.911000 | 127.0.0.1 | 7307
> Merging data from
> memtables and 0 sstables [SharedPool-Worker-3] | 2015-07-03 09:56:15.911000 |
> 127.0.0.1 | 7318
> Read 102 live
> and 0 tombstone cells [SharedPool-Worker-3] | 2015-07-03 09:56:15.911000 |
> 127.0.0.1 | 7586
> Executing single-partition
> query on raw_weather_data [SharedPool-Worker-3] | 2015-07-03 09:56:15.913000
> | 127.0.0.1 | 9155
>
> Acquiring sstable references [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.913000 | 127.0.0.1 | 9184
>
> Merging memtable tombstones [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.913000 | 127.0.0.1 | 9238
> Skipped 0/0 non-slice-intersecting sstables,
> included 0 due to tombstones [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.913000 | 127.0.0.1 | 9280
> Merging data from
> memtables and 0 sstables [SharedPool-Worker-3] | 2015-07-03 09:56:15.913000 |
> 127.0.0.1 | 9292
> Read 102 live
> and 0 tombstone cells [SharedPool-Worker-3] | 2015-07-03 09:56:15.913000 |
> 127.0.0.1 | 9568
> Executing single-partition
> query on raw_weather_data [SharedPool-Worker-3] | 2015-07-03 09:56:15.915000
> | 127.0.0.1 | 11083
>
> Acquiring sstable references [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.915000 | 127.0.0.1 | 11115
>
> Merging memtable tombstones [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.915000 | 127.0.0.1 | 11128
> Skipped 0/0 non-slice-intersecting sstables,
> included 0 due to tombstones [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.915000 | 127.0.0.1 | 11163
> Merging data from
> memtables and 0 sstables [SharedPool-Worker-3] | 2015-07-03 09:56:15.915000 |
> 127.0.0.1 | 11174
> Read 102 live
> and 0 tombstone cells [SharedPool-Worker-3] | 2015-07-03 09:56:15.915000 |
> 127.0.0.1 | 11446
> Executing single-partition
> query on raw_weather_data [SharedPool-Worker-3] | 2015-07-03 09:56:15.917000
> | 127.0.0.1 | 13027
>
> Acquiring sstable references [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.917000 | 127.0.0.1 | 13058
>
> Merging memtable tombstones [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.917000 | 127.0.0.1 | 13079
> Skipped 0/0 non-slice-intersecting sstables,
> included 0 due to tombstones [SharedPool-Worker-3] | 2015-07-03
> 09:56:15.917000 | 127.0.0.1 | 13113
> Merging data from
> memtables and 0 sstables [SharedPool-Worker-3] | 2015-07-03 09:56:15.917000 |
> 127.0.0.1 | 13124
> Read 102 live
> and 0 tombstone cells [SharedPool-Worker-3] | 2015-07-03 09:56:15.917000 |
> 127.0.0.1 | 13399
> Executing single-partition
> query on raw_weather_data [SharedPool-Worker-2] | 2015-07-03 09:56:15.919000
> | 127.0.0.1 | 14862
>
> Acquiring sstable references [SharedPool-Worker-2] | 2015-07-03
> 09:56:15.919000 | 127.0.0.1 | 14888
>
> Merging memtable tombstones [SharedPool-Worker-2] | 2015-07-03
> 09:56:15.919000 | 127.0.0.1 | 14901
> Skipped 0/0 non-slice-intersecting sstables,
> included 0 due to tombstones [SharedPool-Worker-2] | 2015-07-03
> 09:56:15.919000 | 127.0.0.1 | 14938
> Merging data from
> memtables and 0 sstables [SharedPool-Worker-2] | 2015-07-03 09:56:15.919000 |
> 127.0.0.1 | 14949
> Read 102 live
> and 0 tombstone cells [SharedPool-Worker-2] | 2015-07-03 09:56:15.919000 |
> 127.0.0.1 | 15231
> Executing single-partition
> query on raw_weather_data [SharedPool-Worker-2] | 2015-07-03 09:56:15.920000
> | 127.0.0.1 | 16665
>
> Acquiring sstable references [SharedPool-Worker-2] | 2015-07-03
> 09:56:15.920000 | 127.0.0.1 | 16693
>
> Merging memtable tombstones [SharedPool-Worker-2] | 2015-07-03
> 09:56:15.920000 | 127.0.0.1 | 16706
> Skipped 0/0 non-slice-intersecting sstables,
> included 0 due to tombstones [SharedPool-Worker-2] | 2015-07-03
> 09:56:15.920000 | 127.0.0.1 | 16751
> Merging data from
> memtables and 0 sstables [SharedPool-Worker-2] | 2015-07-03 09:56:15.920000 |
> 127.0.0.1 | 16763
> Read 92 live
> and 0 tombstone cells [SharedPool-Worker-2] | 2015-07-03 09:56:15.921000 |
> 127.0.0.1 | 16992
>
> Request complete | 2015-07-03 09:56:15.922382 |
> 127.0.0.1 | 18382
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
