[jira] [Commented] (CASSANDRA-6776) Secondary Index on Map type isn't returning the expected result

["Peter (JIRA)" <ji...@apache.org>]

    [ 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)