given partition key and secondary index, still require allow_filtering?

[Zao Liu]

Hi,

I created a table, schema like here:

CREATE TABLE profile_new.user_categories_1477899735 (

id bigint,

category int,

score double,

PRIMARY KEY (id, category)

) WITH CLUSTERING ORDER BY (category ASC)

AND bloom_filter_fp_chance = 0.01

AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}

AND comment = ''

AND compaction = {'class':
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32', 'min_threshold': '4'}

AND compression = {'chunk_length_in_kb': '64', 'class':
'org.apache.cassandra.io.compress.LZ4Compressor'}

AND crc_check_chance = 1.0

AND dclocal_read_repair_chance = 0.1

AND default_time_to_live = 0

AND gc_grace_seconds = 864000

AND max_index_interval = 2048

AND memtable_flush_period_in_ms = 0

AND min_index_interval = 128

AND read_repair_chance = 0.0

AND speculative_retry = '99PERCENTILE';

CREATE INDEX user_categories_1477899735_score_idx ON
profile_new.user_categories_1477899735 (score);


cqlsh:profile_new> select * from user_categories_1477899735 where id=3674;


But somehow when I pass partition key and secondary index key, it still
complains:

cqlsh:profile_new> select * from user_categories_1477899735 where id=3674
and score > 0.5;

*InvalidRequest: Error from server: code=2200 [Invalid query]
message="Cannot execute this query as it might involve data filtering and
thus may have unpredictable performance. If you want to execute this query
despite the performance unpredictability, use ALLOW FILTERING"*

cqlsh:profile_new>

Re: Import failure for use python cassandra-driver

[Zao Liu]

Same happen to my ubuntu boxes.

  File "/home/jasonl/.pex/install/cassandra_driver-3.
7.0-cp27-none-linux_x86_64.whl.
ebfb31ab99650d53ad134e0b312c7494296cdd2b/cassandra_driver-3.
7.0-cp27-none-linux_x86_64.whl/cassandra/cqlengine/connection.py", line 20,
in 

from cassandra.cluster import Cluster, _NOT_SET, NoHostAvailable,
UserTypeDoesNotExist

ImportError: /home/jasonl/.pex/install/cassandra_driver-3.
7.0-cp27-none-linux_x86_64.whl.
ebfb31ab99650d53ad134e0b312c7494296cdd2b/cassandra_driver-3.
7.0-cp27-none-linux_x86_64.whl/cassandra/cluster.so: undefined symbol:
PyException_Check


And there is someone asked the same question in stack overflow:

http://stackoverflow.com/questions/40251893/datastax-python-cassandra-driver-build-fails-on-ubuntu#



On Wed, Oct 26, 2016 at 1:49 AM, Zao Liu <zao...@gmail.com> wrote:

> Hi,
>
> Suddenly I start to get this following errors when use python cassandra driver
> 3.7.0 in my macbook pro running OS X EI Capitan. Tries to reinstall the
> package and all the dependencies, unfortunately no luck. I was able to run
> it a few days earlier. Really can't recall what I changed could cause this.
>
>   File "/Library/Python/2.7/site-packages/cassandra/cqlengine/connection.py",
> line 20, in 
> from cassandra.cluster import Cluster, _NOT_SET, NoHostAvailable,
> UserTypeDoesNotExist
> ImportError: dlopen(/Library/Python/2.7/site-packages/cassandra/cluster.so,
> 2): Symbol not found: _PyException_Check
>   Referenced from: /Library/Python/2.7/site-packages/cassandra/cluster.so
>   Expected in: flat namespace
>  in /Library/Python/2.7/site-packages/cassandra/cluster.so
>
> Thanks,
> Jason
>
>
>

Import failure for use python cassandra-driver

[Zao Liu]

Hi,

Suddenly I start to get this following errors when use python cassandra driver
3.7.0 in my macbook pro running OS X EI Capitan. Tries to reinstall the
package and all the dependencies, unfortunately no luck. I was able to run
it a few days earlier. Really can't recall what I changed could cause this.

  File "/Library/Python/2.7/site-packages/cassandra/cqlengine/connection.py",
line 20, in 
from cassandra.cluster import Cluster, _NOT_SET, NoHostAvailable,
UserTypeDoesNotExist
ImportError: dlopen(/Library/Python/2.7/site-packages/cassandra/cluster.so,
2): Symbol not found: _PyException_Check
  Referenced from: /Library/Python/2.7/site-packages/cassandra/cluster.so
  Expected in: flat namespace
 in /Library/Python/2.7/site-packages/cassandra/cluster.so

Thanks,
Jason