Hi Nate,
Thanks for your reply!
Is there other way to design this table to meet this requirement?
Best Regards,
倪项菲/ David Ni
中移德电网络科技有限公司
Virtue Intelligent Network Ltd, co.
Add: 2003,20F No.35 Luojia creative city,Luoyu Road,Wuhan,HuBei
Mob: +86 13797007811|Tel: + 86 27 5024 2516
发件人: Nate McCall <n...@thelastpickle.com>
发送时间: 2018年4月17日 7:12
收件人: Cassandra Users <user@cassandra.apache.org>
主题: Re: Time serial column family design
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.
