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

Sachin Janani commented on CASSANDRA-8103:
------------------------------------------

After adding support for secondary index on static column I am facing one 
problem that quering using static column causes null value for regular and 
clustering column.I think [~slebresne] had faced the same problem for Cassandra 
#[6561|https://issues.apache.org/jira/browse/CASSANDRA-6561 ].Following are the 
details of the problem:

{code}
create table test(a int,b int,c text static,d text,primary key(a,b));
create index test_index ON test (c) ;
insert into test values(1,2,'abc','pqr');
select * from test where c='abc';


 a    |     b| c | d
------+------+---+---------
    1 |      | 2 | null
        
{code}
Any inputs will be very helpful.

> Secondary Indices for Static Columns
> ------------------------------------
>
>                 Key: CASSANDRA-8103
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8103
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: Core
>            Reporter: Ron Cohen
>             Fix For: 3.1
>
>
> We should add secondary index support for static columns.  



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to