[
https://issues.apache.org/jira/browse/CASSANDRA-1861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jonathan Ellis resolved CASSANDRA-1861.
---------------------------------------
Resolution: Invalid
start column X isn't "columns starting with X", it's "columns greater than or
equal to X"
> multiget_slice does not return correct columns based on column slice
> --------------------------------------------------------------------
>
> Key: CASSANDRA-1861
> URL: https://issues.apache.org/jira/browse/CASSANDRA-1861
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Affects Versions: 0.7.0 rc 2
> Reporter: chirag patel
> Priority: Critical
>
> We are using Random Partitioner.
> We are trying to do a multiget_slice on a column family which is sorted by
> UTF8Type and it does not behave as expected.
> ColumnFamily: RecordIndexes
> Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
> Row cache size / save period: 0.0/0
> Key cache size / save period: 200000.0/3600
> Memtable thresholds: 0.29062499999999997/62/60
> GC grace seconds: 864000
> Compaction min/max thresholds: 4/32
> Read repair chance: 1.0
> So RECORDINDEXES CF has 1 key with 3 columns as shown below.
> In [6]: RECORDINDEXES.get('testkey')
> Out[6]: {u'A_1.2.3.4_1': '1', u'N_edited.test.com_1': '1', u'P_45653_1': '1'}
> When I do a multiget_slice with column_start as "N_edi.test.com._" and finish
> column as 'P_', I should not get any thing as there is no column starting
> with "N_edi.test.com._" as column name, but I do get one column back which is
> incorrect.
> ***********************************
> In [11]: RECORDINDEXES.get('testkey',
> column_start='N_edi.test.com._',column_finish='P_')
> Out[11]: {u'N_edited.test.com_1': '1'}
> ***********************************
> Some more invalid results
> ***********************************
> In [9]: RECORDINDEXES.get('testkey', column_start='NS_',column_finish='P_')
> Out[9]: {u'N_edited.test.com_1': '1'}
> In [10]:
> In [16]: RECORDINDEXES.get('testkey', column_start='NS',column_finish='P_')
> Out[16]: {u'N_edited.test.com_1': '1'}
> In [17]:
> ***********************************
> I tried this with hector client library as well, so its the same result.
> Can anybody please look into this?
> This is blocking issue for us as our data retrieval heavily depends on
> multiget_slice query.
> FYI: beta3 release also had this problem, so we upgraded to rc2 and still
> seeing the same problem.
> Thanks,
> -Chirag.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
