cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Peter (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-6776) Secondary Index on Map type isn't returning the expected result
Date Thu, 27 Feb 2014 02:27:19 GMT

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

Peter commented on CASSANDRA-6776:
----------------------------------

thanks for clarifying that. it wasn't clear that index on Maps is either key or value, but
not both. Thinking about how maps work now, it makes sense. After adding KEY to create index
it works fine. Is there documentation on this yet? I realize it's very new, so I looked at
the original ticket for the feature.



> Secondary Index on Map type isn't returning the expected result
> ---------------------------------------------------------------
>
>                 Key: CASSANDRA-6776
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6776
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>         Environment: windows 7 64bit, jdk1.7 64bit, latest code from github today
>            Reporter: Peter
>             Fix For: 2.1
>
>         Attachments: c21-list-indexmap-test.cql, testks-test2.keyword_index-ka-1-Index.db
>
>
> I am attaching the cql script I use to test. The output I get from the query returns
zero rows.
> cqlsh:testks> select * from testks.test2 where keywords CONTAINS KEY 'cool';
> (0 rows)
> cqlsh:testks>
> When I run a query for set<text> it works fine.
> cqlsh:testks> select * from testks.test2 where nicknames CONTAINS 'barb';
>  user_name | birth_year | gender | keywords                   | nicknames           
         | password | session_token | state
> -----------+------------+--------+----------------------------+-------------------------------+----------+---------------+-------
>     user10 |       1968 |      f | {'cool': '3', 'lame': '1'} | {'barb', 'barbara', 'barbie'}
|     null |          null |    co
> (1 rows)
> I exit cqlsh and run nodetool flush. When I look at the index file for keywords index,
it doesn't look right. Seems to be missing entries. The file is also attached.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Mime
View raw message