[jira] [Updated] (CASSANDRA-9116) Indexes lost on upgrading to 2.1.4
[ https://issues.apache.org/jira/browse/CASSANDRA-9116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sam Tunnicliffe updated CASSANDRA-9116: --- Component/s: Configuration > Indexes lost on upgrading to 2.1.4 > -- > > Key: CASSANDRA-9116 > URL: https://issues.apache.org/jira/browse/CASSANDRA-9116 > Project: Cassandra > Issue Type: Bug > Components: Configuration >Reporter: Mark Dewey >Assignee: Sam Tunnicliffe >Priority: Blocker > Fix For: 2.1.5 > > Attachments: 9116.txt > > > How to reproduce: > # Create a 2.0.12 cluster > # Create the following keyspace/table (or something similar, it's primarily > the indexes that matter to this case afaict) > {noformat} > CREATE KEYSPACE tshirts WITH replication = {'class': > 'NetworkTopologyStrategy', 'datacenter1': '1'} AND durable_writes = true; > CREATE TABLE tshirts.tshirtorders ( > store text, > order_time timestamp, > order_number uuid, > color text, > qty int, > size text, > PRIMARY KEY (store, order_time, order_number) > ) WITH CLUSTERING ORDER BY (order_time ASC, order_number ASC) > AND bloom_filter_fp_chance = 0.01 > AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}' > AND comment = '' > AND compaction = {'min_threshold': '4', 'class': > 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', > 'max_threshold': '32'} > AND compression = {'sstable_compression': > 'org.apache.cassandra.io.compress.LZ4Compressor'} > AND dclocal_read_repair_chance = 0.1 > AND default_time_to_live = 0 > AND gc_grace_seconds = 864000 > AND max_index_interval = 2048 > AND memtable_flush_period_in_ms = 0 > AND min_index_interval = 128 > AND read_repair_chance = 0.0 > AND speculative_retry = '99.0PERCENTILE'; > CREATE INDEX color ON tshirts.tshirtorders (color); > CREATE INDEX size ON tshirts.tshirtorders (size); > {noformat} > # Load it with data > # Stop the node (one node cluster is enough to replicate) > # Upgrade the node to 2.1.4 > # Start the node > # Optional: Run nodetool upgradesstables > # Run the following queries: > {noformat} > SELECT * FROM tshirts.tshirtorders WHERE store = 'store 65'; > SELECT store, color, qty, size FROM tshirts.tshirtorders WHERE store = 'store > 65' AND color = 'red'; > {noformat} > No rows containing will appear in the indexed table. > Sample output: > {noformat} > cqlsh> SELECT * FROM tshirts.tshirtorders WHERE store = 'store 65'; > store| order_time | order_number | > color | qty | size > --+--+--++--+-- > store 65 | 2000-01-03 18:20:20+ | 457e60e6-da39-11e4-add3-42010af08298 | >red | 1295 |M > store 65 | 2000-01-04 01:29:21+ | 45947304-da39-11e4-add3-42010af08298 | > grey | 2805 |M > store 65 | 2000-01-04 19:55:51+ | 45d69220-da39-11e4-add3-42010af08298 | > brown | 3380 | XXXL > store 65 | 2000-01-04 22:45:07+ | 45e16894-da39-11e4-add3-42010af08298 | > yellow | 7000 | XXL > store 65 | 2000-01-05 17:09:56+ | 46083bd6-da39-11e4-add3-42010af08298 | > purple | 2440 |S > store 65 | 2000-01-05 19:16:48+ | 460cadd8-da39-11e4-add3-42010af08298 | > green | 5690 |L > store 65 | 2000-01-06 00:26:06+ | 461ccdbc-da39-11e4-add3-42010af08298 | > brown | 9890 |P > store 65 | 2000-01-06 11:35:11+ | 4633aa00-da39-11e4-add3-42010af08298 | > black | 9350 |P > store 65 | 2000-01-07 06:07:20+ | 4658e0ea-da39-11e4-add3-42010af08298 | > black | 1300 |S > store 65 | 2000-01-07 06:47:40+ | 465be93e-da39-11e4-add3-42010af08298 | > purple | 9630 | XL > store 65 | 2000-01-09 12:42:38+ | 46bafdd4-da39-11e4-add3-42010af08298 | > purple | 1470 |M > store 65 | 2000-01-09 19:07:35+ | 46c43e08-da39-11e4-add3-42010af08298 | > pink | 6005 |S > store 65 | 2000-01-10 04:47:56+ | 46d4b170-da39-11e4-add3-42010af08298 | >red | 345 | XL > store 65 | 2000-01-10 20:25:44+ | 46ef7d52-da39-11e4-add3-42010af08298 | > pink | 420 | XXL > store 65 | 2000-01-11 00:55:27+ | 46f7a84c-da39-11e4-add3-42010af08298 | > purple | 9045 |S > store 65 | 2000-01-11 17:54:25+ | 4724ea00-da39-11e4-add3-42010af08298 | > green | 5030 | XXL > store 65 | 2000-01-12 08:21:15+ | 473c0370-da39-11e4-add3-42010af08298 | > white | 2860 | XL > store 65 | 2000-01-12 17:09:19+ | 47497d2a-da39-11e4-add3-42010af08298 | >red | 6425 |L > store 65 | 2000-01-14 07:27:37+ | 478662a8-da39-11e4-add3-42010af08298 | > pink | 330 | XXXL > store 65 | 2000-01-14 11:31:38+ | 478b43cc-da39-11e4-add3-42010af08298 | > pink | 3335 | XXL > store 65 | 2000-01-14 18:55:59+ | 47955a24-d
[jira] [Updated] (CASSANDRA-9116) Indexes lost on upgrading to 2.1.4
[ https://issues.apache.org/jira/browse/CASSANDRA-9116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jonathan Ellis updated CASSANDRA-9116: -- Assignee: Sam Overton > Indexes lost on upgrading to 2.1.4 > -- > > Key: CASSANDRA-9116 > URL: https://issues.apache.org/jira/browse/CASSANDRA-9116 > Project: Cassandra > Issue Type: Bug > Components: Core >Reporter: Mark Dewey >Assignee: Sam Overton >Priority: Blocker > Fix For: 2.1.5 > > > How to reproduce: > # Create a 2.0.12 cluster > # Create the following keyspace/table (or something similar, it's primarily > the indexes that matter to this case afaict) > {noformat} > CREATE KEYSPACE tshirts WITH replication = {'class': > 'NetworkTopologyStrategy', 'datacenter1': '1'} AND durable_writes = true; > CREATE TABLE tshirts.tshirtorders ( > store text, > order_time timestamp, > order_number uuid, > color text, > qty int, > size text, > PRIMARY KEY (store, order_time, order_number) > ) WITH CLUSTERING ORDER BY (order_time ASC, order_number ASC) > AND bloom_filter_fp_chance = 0.01 > AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}' > AND comment = '' > AND compaction = {'min_threshold': '4', 'class': > 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', > 'max_threshold': '32'} > AND compression = {'sstable_compression': > 'org.apache.cassandra.io.compress.LZ4Compressor'} > AND dclocal_read_repair_chance = 0.1 > AND default_time_to_live = 0 > AND gc_grace_seconds = 864000 > AND max_index_interval = 2048 > AND memtable_flush_period_in_ms = 0 > AND min_index_interval = 128 > AND read_repair_chance = 0.0 > AND speculative_retry = '99.0PERCENTILE'; > CREATE INDEX color ON tshirts.tshirtorders (color); > CREATE INDEX size ON tshirts.tshirtorders (size); > {noformat} > # Load it with data > # Stop the node (one node cluster is enough to replicate) > # Upgrade the node to 2.1.4 > # Start the node > # Optional: Run nodetool upgradesstables > # Run the following queries: > {noformat} > SELECT * FROM tshirts.tshirtorders WHERE store = 'store 65'; > SELECT store, color, qty, size FROM tshirts.tshirtorders WHERE store = 'store > 65' AND color = 'red'; > {noformat} > No rows containing will appear in the indexed table. > Sample output: > {noformat} > cqlsh> SELECT * FROM tshirts.tshirtorders WHERE store = 'store 65'; > store| order_time | order_number | > color | qty | size > --+--+--++--+-- > store 65 | 2000-01-03 18:20:20+ | 457e60e6-da39-11e4-add3-42010af08298 | >red | 1295 |M > store 65 | 2000-01-04 01:29:21+ | 45947304-da39-11e4-add3-42010af08298 | > grey | 2805 |M > store 65 | 2000-01-04 19:55:51+ | 45d69220-da39-11e4-add3-42010af08298 | > brown | 3380 | XXXL > store 65 | 2000-01-04 22:45:07+ | 45e16894-da39-11e4-add3-42010af08298 | > yellow | 7000 | XXL > store 65 | 2000-01-05 17:09:56+ | 46083bd6-da39-11e4-add3-42010af08298 | > purple | 2440 |S > store 65 | 2000-01-05 19:16:48+ | 460cadd8-da39-11e4-add3-42010af08298 | > green | 5690 |L > store 65 | 2000-01-06 00:26:06+ | 461ccdbc-da39-11e4-add3-42010af08298 | > brown | 9890 |P > store 65 | 2000-01-06 11:35:11+ | 4633aa00-da39-11e4-add3-42010af08298 | > black | 9350 |P > store 65 | 2000-01-07 06:07:20+ | 4658e0ea-da39-11e4-add3-42010af08298 | > black | 1300 |S > store 65 | 2000-01-07 06:47:40+ | 465be93e-da39-11e4-add3-42010af08298 | > purple | 9630 | XL > store 65 | 2000-01-09 12:42:38+ | 46bafdd4-da39-11e4-add3-42010af08298 | > purple | 1470 |M > store 65 | 2000-01-09 19:07:35+ | 46c43e08-da39-11e4-add3-42010af08298 | > pink | 6005 |S > store 65 | 2000-01-10 04:47:56+ | 46d4b170-da39-11e4-add3-42010af08298 | >red | 345 | XL > store 65 | 2000-01-10 20:25:44+ | 46ef7d52-da39-11e4-add3-42010af08298 | > pink | 420 | XXL > store 65 | 2000-01-11 00:55:27+ | 46f7a84c-da39-11e4-add3-42010af08298 | > purple | 9045 |S > store 65 | 2000-01-11 17:54:25+ | 4724ea00-da39-11e4-add3-42010af08298 | > green | 5030 | XXL > store 65 | 2000-01-12 08:21:15+ | 473c0370-da39-11e4-add3-42010af08298 | > white | 2860 | XL > store 65 | 2000-01-12 17:09:19+ | 47497d2a-da39-11e4-add3-42010af08298 | >red | 6425 |L > store 65 | 2000-01-14 07:27:37+ | 478662a8-da39-11e4-add3-42010af08298 | > pink | 330 | XXXL > store 65 | 2000-01-14 11:31:38+ | 478b43cc-da39-11e4-add3-42010af08298 | > pink | 3335 | XXL > store 65 | 2000-01-14 18:55:59+ | 47955a24-da39-11e4-add3-42010af08298 | > yellow | 500 |P >
[jira] [Updated] (CASSANDRA-9116) Indexes lost on upgrading to 2.1.4
[ https://issues.apache.org/jira/browse/CASSANDRA-9116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jonathan Ellis updated CASSANDRA-9116: -- Assignee: Sam Tunnicliffe (was: Sam Overton) > Indexes lost on upgrading to 2.1.4 > -- > > Key: CASSANDRA-9116 > URL: https://issues.apache.org/jira/browse/CASSANDRA-9116 > Project: Cassandra > Issue Type: Bug > Components: Core >Reporter: Mark Dewey >Assignee: Sam Tunnicliffe >Priority: Blocker > Fix For: 2.1.5 > > > How to reproduce: > # Create a 2.0.12 cluster > # Create the following keyspace/table (or something similar, it's primarily > the indexes that matter to this case afaict) > {noformat} > CREATE KEYSPACE tshirts WITH replication = {'class': > 'NetworkTopologyStrategy', 'datacenter1': '1'} AND durable_writes = true; > CREATE TABLE tshirts.tshirtorders ( > store text, > order_time timestamp, > order_number uuid, > color text, > qty int, > size text, > PRIMARY KEY (store, order_time, order_number) > ) WITH CLUSTERING ORDER BY (order_time ASC, order_number ASC) > AND bloom_filter_fp_chance = 0.01 > AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}' > AND comment = '' > AND compaction = {'min_threshold': '4', 'class': > 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', > 'max_threshold': '32'} > AND compression = {'sstable_compression': > 'org.apache.cassandra.io.compress.LZ4Compressor'} > AND dclocal_read_repair_chance = 0.1 > AND default_time_to_live = 0 > AND gc_grace_seconds = 864000 > AND max_index_interval = 2048 > AND memtable_flush_period_in_ms = 0 > AND min_index_interval = 128 > AND read_repair_chance = 0.0 > AND speculative_retry = '99.0PERCENTILE'; > CREATE INDEX color ON tshirts.tshirtorders (color); > CREATE INDEX size ON tshirts.tshirtorders (size); > {noformat} > # Load it with data > # Stop the node (one node cluster is enough to replicate) > # Upgrade the node to 2.1.4 > # Start the node > # Optional: Run nodetool upgradesstables > # Run the following queries: > {noformat} > SELECT * FROM tshirts.tshirtorders WHERE store = 'store 65'; > SELECT store, color, qty, size FROM tshirts.tshirtorders WHERE store = 'store > 65' AND color = 'red'; > {noformat} > No rows containing will appear in the indexed table. > Sample output: > {noformat} > cqlsh> SELECT * FROM tshirts.tshirtorders WHERE store = 'store 65'; > store| order_time | order_number | > color | qty | size > --+--+--++--+-- > store 65 | 2000-01-03 18:20:20+ | 457e60e6-da39-11e4-add3-42010af08298 | >red | 1295 |M > store 65 | 2000-01-04 01:29:21+ | 45947304-da39-11e4-add3-42010af08298 | > grey | 2805 |M > store 65 | 2000-01-04 19:55:51+ | 45d69220-da39-11e4-add3-42010af08298 | > brown | 3380 | XXXL > store 65 | 2000-01-04 22:45:07+ | 45e16894-da39-11e4-add3-42010af08298 | > yellow | 7000 | XXL > store 65 | 2000-01-05 17:09:56+ | 46083bd6-da39-11e4-add3-42010af08298 | > purple | 2440 |S > store 65 | 2000-01-05 19:16:48+ | 460cadd8-da39-11e4-add3-42010af08298 | > green | 5690 |L > store 65 | 2000-01-06 00:26:06+ | 461ccdbc-da39-11e4-add3-42010af08298 | > brown | 9890 |P > store 65 | 2000-01-06 11:35:11+ | 4633aa00-da39-11e4-add3-42010af08298 | > black | 9350 |P > store 65 | 2000-01-07 06:07:20+ | 4658e0ea-da39-11e4-add3-42010af08298 | > black | 1300 |S > store 65 | 2000-01-07 06:47:40+ | 465be93e-da39-11e4-add3-42010af08298 | > purple | 9630 | XL > store 65 | 2000-01-09 12:42:38+ | 46bafdd4-da39-11e4-add3-42010af08298 | > purple | 1470 |M > store 65 | 2000-01-09 19:07:35+ | 46c43e08-da39-11e4-add3-42010af08298 | > pink | 6005 |S > store 65 | 2000-01-10 04:47:56+ | 46d4b170-da39-11e4-add3-42010af08298 | >red | 345 | XL > store 65 | 2000-01-10 20:25:44+ | 46ef7d52-da39-11e4-add3-42010af08298 | > pink | 420 | XXL > store 65 | 2000-01-11 00:55:27+ | 46f7a84c-da39-11e4-add3-42010af08298 | > purple | 9045 |S > store 65 | 2000-01-11 17:54:25+ | 4724ea00-da39-11e4-add3-42010af08298 | > green | 5030 | XXL > store 65 | 2000-01-12 08:21:15+ | 473c0370-da39-11e4-add3-42010af08298 | > white | 2860 | XL > store 65 | 2000-01-12 17:09:19+ | 47497d2a-da39-11e4-add3-42010af08298 | >red | 6425 |L > store 65 | 2000-01-14 07:27:37+ | 478662a8-da39-11e4-add3-42010af08298 | > pink | 330 | XXXL > store 65 | 2000-01-14 11:31:38+ | 478b43cc-da39-11e4-add3-42010af08298 | > pink | 3335 | XXL > store 65 | 2000-01-14 18:55:59+ | 47955a24-da39-11e4-add3-42010af08298
[jira] [Updated] (CASSANDRA-9116) Indexes lost on upgrading to 2.1.4
[ https://issues.apache.org/jira/browse/CASSANDRA-9116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sam Tunnicliffe updated CASSANDRA-9116: --- Attachment: 9116.txt The problem here is that the logic to locate pre-2.1 sstables is broken for index column families. CASSANDRA-5202 changed the default location to include the cfId, but the check in {{Directories}} which looks for legacy datafiles doesn't consider that index tables are co-located with those of the base CF. One liner patch to fix and a dtest pushed [here|https://github.com/riptano/cassandra-dtest/pull/226] Incidentally, in debugging this issue I noticed that {{system.IndexInfo}} isn't flushed after we mark an index as built, which means we may unnecessarily rebuild indexes following a disorderly shutdown. I've opened CASSANDRA-9128 for that. > Indexes lost on upgrading to 2.1.4 > -- > > Key: CASSANDRA-9116 > URL: https://issues.apache.org/jira/browse/CASSANDRA-9116 > Project: Cassandra > Issue Type: Bug > Components: Core >Reporter: Mark Dewey >Assignee: Sam Tunnicliffe >Priority: Blocker > Fix For: 2.1.5 > > Attachments: 9116.txt > > > How to reproduce: > # Create a 2.0.12 cluster > # Create the following keyspace/table (or something similar, it's primarily > the indexes that matter to this case afaict) > {noformat} > CREATE KEYSPACE tshirts WITH replication = {'class': > 'NetworkTopologyStrategy', 'datacenter1': '1'} AND durable_writes = true; > CREATE TABLE tshirts.tshirtorders ( > store text, > order_time timestamp, > order_number uuid, > color text, > qty int, > size text, > PRIMARY KEY (store, order_time, order_number) > ) WITH CLUSTERING ORDER BY (order_time ASC, order_number ASC) > AND bloom_filter_fp_chance = 0.01 > AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}' > AND comment = '' > AND compaction = {'min_threshold': '4', 'class': > 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', > 'max_threshold': '32'} > AND compression = {'sstable_compression': > 'org.apache.cassandra.io.compress.LZ4Compressor'} > AND dclocal_read_repair_chance = 0.1 > AND default_time_to_live = 0 > AND gc_grace_seconds = 864000 > AND max_index_interval = 2048 > AND memtable_flush_period_in_ms = 0 > AND min_index_interval = 128 > AND read_repair_chance = 0.0 > AND speculative_retry = '99.0PERCENTILE'; > CREATE INDEX color ON tshirts.tshirtorders (color); > CREATE INDEX size ON tshirts.tshirtorders (size); > {noformat} > # Load it with data > # Stop the node (one node cluster is enough to replicate) > # Upgrade the node to 2.1.4 > # Start the node > # Optional: Run nodetool upgradesstables > # Run the following queries: > {noformat} > SELECT * FROM tshirts.tshirtorders WHERE store = 'store 65'; > SELECT store, color, qty, size FROM tshirts.tshirtorders WHERE store = 'store > 65' AND color = 'red'; > {noformat} > No rows containing will appear in the indexed table. > Sample output: > {noformat} > cqlsh> SELECT * FROM tshirts.tshirtorders WHERE store = 'store 65'; > store| order_time | order_number | > color | qty | size > --+--+--++--+-- > store 65 | 2000-01-03 18:20:20+ | 457e60e6-da39-11e4-add3-42010af08298 | >red | 1295 |M > store 65 | 2000-01-04 01:29:21+ | 45947304-da39-11e4-add3-42010af08298 | > grey | 2805 |M > store 65 | 2000-01-04 19:55:51+ | 45d69220-da39-11e4-add3-42010af08298 | > brown | 3380 | XXXL > store 65 | 2000-01-04 22:45:07+ | 45e16894-da39-11e4-add3-42010af08298 | > yellow | 7000 | XXL > store 65 | 2000-01-05 17:09:56+ | 46083bd6-da39-11e4-add3-42010af08298 | > purple | 2440 |S > store 65 | 2000-01-05 19:16:48+ | 460cadd8-da39-11e4-add3-42010af08298 | > green | 5690 |L > store 65 | 2000-01-06 00:26:06+ | 461ccdbc-da39-11e4-add3-42010af08298 | > brown | 9890 |P > store 65 | 2000-01-06 11:35:11+ | 4633aa00-da39-11e4-add3-42010af08298 | > black | 9350 |P > store 65 | 2000-01-07 06:07:20+ | 4658e0ea-da39-11e4-add3-42010af08298 | > black | 1300 |S > store 65 | 2000-01-07 06:47:40+ | 465be93e-da39-11e4-add3-42010af08298 | > purple | 9630 | XL > store 65 | 2000-01-09 12:42:38+ | 46bafdd4-da39-11e4-add3-42010af08298 | > purple | 1470 |M > store 65 | 2000-01-09 19:07:35+ | 46c43e08-da39-11e4-add3-42010af08298 | > pink | 6005 |S > store 65 | 2000-01-10 04:47:56+ | 46d4b170-da39-11e4-add3-42010af08298 | >red | 345 | XL > store 65 | 2000-01-10 20:25:44+ | 46ef7d52-da39-11e4-add3-42010af08298 | > pink | 420 | XXL > store 65 | 2000-01-11 00:55:2
[jira] [Updated] (CASSANDRA-9116) Indexes lost on upgrading to 2.1.4
[ https://issues.apache.org/jira/browse/CASSANDRA-9116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Yeschenko updated CASSANDRA-9116: - Reviewer: Yuki Morishita > Indexes lost on upgrading to 2.1.4 > -- > > Key: CASSANDRA-9116 > URL: https://issues.apache.org/jira/browse/CASSANDRA-9116 > Project: Cassandra > Issue Type: Bug > Components: Core >Reporter: Mark Dewey >Assignee: Sam Tunnicliffe >Priority: Blocker > Fix For: 2.1.5 > > Attachments: 9116.txt > > > How to reproduce: > # Create a 2.0.12 cluster > # Create the following keyspace/table (or something similar, it's primarily > the indexes that matter to this case afaict) > {noformat} > CREATE KEYSPACE tshirts WITH replication = {'class': > 'NetworkTopologyStrategy', 'datacenter1': '1'} AND durable_writes = true; > CREATE TABLE tshirts.tshirtorders ( > store text, > order_time timestamp, > order_number uuid, > color text, > qty int, > size text, > PRIMARY KEY (store, order_time, order_number) > ) WITH CLUSTERING ORDER BY (order_time ASC, order_number ASC) > AND bloom_filter_fp_chance = 0.01 > AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}' > AND comment = '' > AND compaction = {'min_threshold': '4', 'class': > 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', > 'max_threshold': '32'} > AND compression = {'sstable_compression': > 'org.apache.cassandra.io.compress.LZ4Compressor'} > AND dclocal_read_repair_chance = 0.1 > AND default_time_to_live = 0 > AND gc_grace_seconds = 864000 > AND max_index_interval = 2048 > AND memtable_flush_period_in_ms = 0 > AND min_index_interval = 128 > AND read_repair_chance = 0.0 > AND speculative_retry = '99.0PERCENTILE'; > CREATE INDEX color ON tshirts.tshirtorders (color); > CREATE INDEX size ON tshirts.tshirtorders (size); > {noformat} > # Load it with data > # Stop the node (one node cluster is enough to replicate) > # Upgrade the node to 2.1.4 > # Start the node > # Optional: Run nodetool upgradesstables > # Run the following queries: > {noformat} > SELECT * FROM tshirts.tshirtorders WHERE store = 'store 65'; > SELECT store, color, qty, size FROM tshirts.tshirtorders WHERE store = 'store > 65' AND color = 'red'; > {noformat} > No rows containing will appear in the indexed table. > Sample output: > {noformat} > cqlsh> SELECT * FROM tshirts.tshirtorders WHERE store = 'store 65'; > store| order_time | order_number | > color | qty | size > --+--+--++--+-- > store 65 | 2000-01-03 18:20:20+ | 457e60e6-da39-11e4-add3-42010af08298 | >red | 1295 |M > store 65 | 2000-01-04 01:29:21+ | 45947304-da39-11e4-add3-42010af08298 | > grey | 2805 |M > store 65 | 2000-01-04 19:55:51+ | 45d69220-da39-11e4-add3-42010af08298 | > brown | 3380 | XXXL > store 65 | 2000-01-04 22:45:07+ | 45e16894-da39-11e4-add3-42010af08298 | > yellow | 7000 | XXL > store 65 | 2000-01-05 17:09:56+ | 46083bd6-da39-11e4-add3-42010af08298 | > purple | 2440 |S > store 65 | 2000-01-05 19:16:48+ | 460cadd8-da39-11e4-add3-42010af08298 | > green | 5690 |L > store 65 | 2000-01-06 00:26:06+ | 461ccdbc-da39-11e4-add3-42010af08298 | > brown | 9890 |P > store 65 | 2000-01-06 11:35:11+ | 4633aa00-da39-11e4-add3-42010af08298 | > black | 9350 |P > store 65 | 2000-01-07 06:07:20+ | 4658e0ea-da39-11e4-add3-42010af08298 | > black | 1300 |S > store 65 | 2000-01-07 06:47:40+ | 465be93e-da39-11e4-add3-42010af08298 | > purple | 9630 | XL > store 65 | 2000-01-09 12:42:38+ | 46bafdd4-da39-11e4-add3-42010af08298 | > purple | 1470 |M > store 65 | 2000-01-09 19:07:35+ | 46c43e08-da39-11e4-add3-42010af08298 | > pink | 6005 |S > store 65 | 2000-01-10 04:47:56+ | 46d4b170-da39-11e4-add3-42010af08298 | >red | 345 | XL > store 65 | 2000-01-10 20:25:44+ | 46ef7d52-da39-11e4-add3-42010af08298 | > pink | 420 | XXL > store 65 | 2000-01-11 00:55:27+ | 46f7a84c-da39-11e4-add3-42010af08298 | > purple | 9045 |S > store 65 | 2000-01-11 17:54:25+ | 4724ea00-da39-11e4-add3-42010af08298 | > green | 5030 | XXL > store 65 | 2000-01-12 08:21:15+ | 473c0370-da39-11e4-add3-42010af08298 | > white | 2860 | XL > store 65 | 2000-01-12 17:09:19+ | 47497d2a-da39-11e4-add3-42010af08298 | >red | 6425 |L > store 65 | 2000-01-14 07:27:37+ | 478662a8-da39-11e4-add3-42010af08298 | > pink | 330 | XXXL > store 65 | 2000-01-14 11:31:38+ | 478b43cc-da39-11e4-add3-42010af08298 | > pink | 3335 | XXL > store 65 | 2000-01-14 18:55:59+ | 47955a24-da39-11e