[
https://issues.apache.org/jira/browse/CASSANDRA-12447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15673731#comment-15673731
]
Alex Petrov edited comment on CASSANDRA-12447 at 11/17/16 1:27 PM:
-------------------------------------------------------------------
I hope I understood the issue you're describing correctly (title says restrict
static column but actual restriction is on pk, so I'm not completely certain).
Static columns are stored on the "partition level", and will be same for any
row in this partition. You can achieve the same thing by dropping clustering
column restriction and using `limit 1` (for example).
was (Author: ifesdjeen):
I hope I understood the issue you're describing correctly (title says restrict
static column but actual restriction is on pk, so I'm not completely certain).
Static columns are stored on the "partition level", and will be same for any
clustering in this partition. You can achieve the same thing by dropping
clustering column restriction and using `limit 1` (for example).
> Invalid Query : cannot restrict static Column
> ---------------------------------------------
>
> Key: CASSANDRA-12447
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12447
> Project: Cassandra
> Issue Type: Bug
> Environment: cassandra 2.1.13
> Reporter: ZhaoYang
> Priority: Minor
>
> Invalid Query Error: Cannot restrict clustering columns when selecting only
> static columns.
> Define a table with PartitionKey, ClusteringKey, 1 static Column, 1 normal
> column.
> "Select PartitionKey from ks.cf where PartitionKey=? and ClusteringKey=?"
> will throw the above error..
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
