Re: Query data through python using IN clause

2020-04-02 Thread Nitan Kainth
Thanks Alex. On Thu, Apr 2, 2020 at 1:39 AM Alex Ott wrote: > Hi > > Working code is below, but I want to warn you - prefer not to use IN with > partition keys - because you'll have different partition key values, > coordinator node will need to perform queries to other hosts that hold > these p

Re: Query data through python using IN clause

2020-04-01 Thread Alex Ott
Hi Working code is below, but I want to warn you - prefer not to use IN with partition keys - because you'll have different partition key values, coordinator node will need to perform queries to other hosts that hold these partition keys, and this slow downs the operation, and adds an additional l

Query data through python using IN clause

2020-04-01 Thread Nitan Kainth
Hi There, I am trying to read data from table as below structure: table1( pk1 bigint, pk2 bigint, ck1 timestamp, value text, primary key((pk1,pk2),ck1); query = session.prepare("select * from table1 where pk IN ? and pk2=0 and ck1 > ? AND ck1 < ?;") temp = 1,2,3 runq = session.execute(query2