> > > Select * from test where vin =“ZD41578123DSAFWE12313” and create_date in > (20180416, 20180415, 20180414, 20180413, 20180412………………………………….); > > But this cause the cql query is very long,and I don’t know whether there > is limitation for the length of the cql. > > Please give me some advice,thanks in advance. >
Using the SELECT ... IN syntax means that: - the driver will not be able to route the queries to the nodes which have the partition - a single coordinator must scatter-gather the query and results Break this up into a series of single statements using the executeAsync method and gather the results via something like Futures in Guava or similar.