使用spring-data-cassandra进行查询
报错日志(已删除日志中in条件参数,原总共1006项):
10:47:00.708[WARN ][cluster10-nio-worker-3] c.d.driver.core.RequestHandler 630 - /192.168.1.211:9042 replied with server error (partition key cartesian product size 1006 is greater than maximum 100), defuncting connection.
10:47:00.720[ERROR][https-jsse-nio-8888-exec-7] c.t.i.j.p.GlobalExceptionHandler 26 - Global Exception Catch :
org.springframework.data.cassandra.CassandraConnectionFailureException: Query; CQL [SELECT * FROM user_info WHERE id IN ('f', ''....);]; All host(s) tried for query failed (tried: /192.168.1.211:9042 (com.datastax.driver.core.exceptions.ServerError: An unexpected error occurred server side on /192.168.1.211:9042: partition key cartesian product size 1006 is greater than maximum 100)); nested exception is com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /192.168.1.211:9042 (com.datastax.driver.core.exceptions.ServerError: An unexpected error occurred server side on /192.168.1.211:9042: partition key cartesian product size 1006 is greater than maximum 100))
at org.springframework.data.cassandra.core.cql.CassandraExceptionTranslator.translate(CassandraExceptionTranslator.java:155) ~[spring-data-cassandra-2.0.8.RELEASE.jar:2.0.8.RELEASE]
at org.springframework.data.cassandra.core.cql.CassandraAccessor.translate(CassandraAccessor.java:334) ~[spring-data-cassandra-2.0.8.RELEASE.jar:2.0.8.RELEASE]
at org.springframework.data.cassandra.core.cql.CqlTemplate.translateException(CqlTemplate.java:732) ~[spring-data-cassandra-2.0.8.RELEASE.jar:2.0.8.RELEASE]
...
Caused by: com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /192.168.1.211:9042 (com.datastax.driver.core.exceptions.ServerError: An unexpected error occurred server side on /192.168.1.211:9042: partition key cartesian product size 1006 is greater than maximum 100))