cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alex Petrov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-12447) Invalid Query : cannot restrict static Column
Date Thu, 17 Nov 2016 13:27:58 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-12447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15673731#comment-15673731
] 

Alex Petrov commented on CASSANDRA-12447:
-----------------------------------------

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)

Mime
View raw message