Are you looking this to be equivalent to (PK1=1 AND PK2=2) or are you looking for (PK1 IN (1,2) AND PK2 IN (1,2)) or something else?
Cheers Ben On Thu, 9 Feb 2017 at 20:09 Benjamin Roth <benjamin.r...@jaumo.com> wrote: > Hi Guys, > > CQL says this is not allowed: > > DELETE FROM ks.cf WHERE (pk1, pk2) IN ((1, 2)); > > 1. Is there a reason for it? There shouldn't be a performance penalty, it > is a PK lookup, the same thing works with a single pk column > 2. Is there a known workaround for it? > > It would be much of a help to have it for daily business, IMHO it's a > waste of resources to run multiple queries just to fetch a bunch of records > by a PK. > > Thanks in advance for any reply > > -- > Benjamin Roth > Prokurist > > Jaumo GmbH · www.jaumo.com > Wehrstraße 46 · 73035 Göppingen · Germany > Phone +49 7161 304880-6 <+49%207161%203048806> · Fax +49 7161 304880-1 > <+49%207161%203048801> > AG Ulm · HRB 731058 · Managing Director: Jens Kammerer > -- ———————— Ben Slater Chief Product Officer Instaclustr: Cassandra + Spark - Managed | Consulting | Support +61 437 929 798