Ozéias Sant'ana created CASSANDRA-8073:
------------------------------------------
Summary: Exception filtering data in a collection and compound
primary key
Key: CASSANDRA-8073
URL: https://issues.apache.org/jira/browse/CASSANDRA-8073
Project: Cassandra
Issue Type: Bug
Components: Core
Environment: Mac OS, DataStax 2.1.0 Cassandra server
Reporter: Ozéias Sant'ana
Attachments: example.cql.sql
I'm trying to query using compound primary key and then collection. Is possible
to use partition key in the query, but as soon as you include the clustering
column will receive a timeout.
{code:sql}
SELECT * FROM playlists WHERE user_id = 91d8eb60-4db1-11e4-b217-f96a8b2e7d2e
AND tags CONTAINS 'blues';
user_id | id |
song_order | album | artist | song_id |
tags | title
--------------------------------------+--------------------------------------+------------+--------------+--------+--------------------------------------+------------------------------------------------+-----------
91d8eb60-4db1-11e4-b217-f96a8b2e7d2e | 62c36092-82a1-3a00-93d1-46196ee77204 |
1 | Tres Hombres | ZZ Top | a3e64f8f-bd44-4f28-b8d9-6938726e34d4 |
{'blues', 'boogie rock', 'rock', 'rock blues'} | La Grange
(1 rows)
{code}
{code:sql}
SELECT * FROM playlists WHERE user_id = 91d8eb60-4db1-11e4-b217-f96a8b2e7d2e
AND id = 62c36092-82a1-3a00-93d1-46196ee77204 AND tags CONTAINS 'blues';
errors={}, last_host=127.0.0.1
{code}
See below the log:
{code:none}
WARN [SharedPool-Worker-2] 2014-10-07 10:23:56,437
AbstractTracingAwareExecutorService.java:167 - Uncaught exception on thread
Thread[SharedPool-Worker-2,5,main]: {}
java.lang.RuntimeException: java.lang.NullPointerException
at
org.apache.cassandra.service.StorageProxy$DroppableRunnable.run(StorageProxy.java:2047)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
~[na:1.7.0_67]
at
org.apache.cassandra.concurrent.AbstractTracingAwareExecutorService$FutureTask.run(AbstractTracingAwareExecutorService.java:163)
~[apache-cassandra-2.1.0.jar:2.1.0]
at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:103)
[apache-cassandra-2.1.0.jar:2.1.0]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_67]
Caused by: java.lang.NullPointerException: null
at org.apache.cassandra.db.marshal.Int32Type.compare(Int32Type.java:38)
~[apache-cassandra-2.1.0.jar:2.1.0]
at org.apache.cassandra.db.marshal.Int32Type.compare(Int32Type.java:28)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.composites.AbstractCType.compare(AbstractCType.java:136)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.composites.AbstractCType.compare(AbstractCType.java:40)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.AtomicBTreeColumns$3.compare(AtomicBTreeColumns.java:234)
~[apache-cassandra-2.1.0.jar:2.1.0]
at org.apache.cassandra.utils.btree.BTree.find(BTree.java:277)
~[apache-cassandra-2.1.0.jar:2.1.0]
at org.apache.cassandra.utils.btree.Path.find(Path.java:122)
~[apache-cassandra-2.1.0.jar:2.1.0]
at org.apache.cassandra.utils.btree.Cursor._reset(Cursor.java:107)
~[apache-cassandra-2.1.0.jar:2.1.0]
at org.apache.cassandra.utils.btree.Cursor.reset(Cursor.java:91)
~[apache-cassandra-2.1.0.jar:2.1.0]
at org.apache.cassandra.utils.btree.BTree.slice(BTree.java:238)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.AtomicBTreeColumns.slice(AtomicBTreeColumns.java:453)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.AtomicBTreeColumns.iterator(AtomicBTreeColumns.java:283)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.filter.SliceQueryFilter.getColumnIterator(SliceQueryFilter.java:138)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.filter.QueryFilter.getIterator(QueryFilter.java:57)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.CollationController.collectAllData(CollationController.java:206)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.CollationController.getTopLevelColumns(CollationController.java:59)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.ColumnFamilyStore.getTopLevelColumns(ColumnFamilyStore.java:1872)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.ColumnFamilyStore.getColumnFamily(ColumnFamilyStore.java:1680)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.index.composites.CompositesSearcher$1.computeNext(CompositesSearcher.java:183)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.index.composites.CompositesSearcher$1.computeNext(CompositesSearcher.java:121)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:143)
~[guava-16.0.jar:na]
at
com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:138)
~[guava-16.0.jar:na]
at
org.apache.cassandra.db.ColumnFamilyStore.filter(ColumnFamilyStore.java:2076)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.index.composites.CompositesSearcher.search(CompositesSearcher.java:68)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.index.SecondaryIndexManager.search(SecondaryIndexManager.java:579)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.ColumnFamilyStore.search(ColumnFamilyStore.java:2064)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.db.PagedRangeCommand.executeLocally(PagedRangeCommand.java:114)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.service.StorageProxy$LocalRangeSliceRunnable.runMayThrow(StorageProxy.java:1382)
~[apache-cassandra-2.1.0.jar:2.1.0]
at
org.apache.cassandra.service.StorageProxy$DroppableRunnable.run(StorageProxy.java:2044)
~[apache-cassandra-2.1.0.jar:2.1.0]
... 4 common frames omitted
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
