Hi, Have you tried to change the page size? I think cqlsh use a page size of 100 and the java driver use 5000 as default, sometimes this can make a difference.
/Tommy On tis, 2019-04-16 at 23:38 -0700, Dinesh Joshi wrote: More info with detailed explanation: https://protect2.fireeye.com/url?k=20fb8817-7c71a48f-20fbc88c-0cc47ad93eae-422600ad004bede1&u=https://www.instaclustr.com/apache-cassandra-scalability-allow-filtering-partition-keys/ Dinesh On Apr 16, 2019, at 11:24 PM, Mahesh Daksha <daks...@gmail.com<mailto:daks...@gmail.com>> wrote: Hi, how much data you are trying to read in the single query? is it large in size or normal text data. Looking at the exception it seems the node is unable to deliver data within stipulated time. I have faced similar issue with the response data in huge in size (some binary data). But it was solved as we spread the data across multiple rows. Thanks, Mahesh Daksha On Wed, Apr 17, 2019 at 11:42 AM Krishnanand Khambadkone <kkhambadk...@yahoo.com.invalid<mailto:kkhambadk...@yahoo.com.invalid>> wrote: Hi, I have a single instance cassandra server. I am trying to execute a query with ALLOW FILTERING option. When I run this same query from cqlsh it runs fine but when I try to execute the query through the java driver it throws this exception. I have increased all the timeouts in cassandra.yaml file and also included the read timeout option in the SimpleStetement query I am running. Any idea how I can fix this issue. Caused by: com.datastax.driver.core.exceptions.ReadTimeoutException: Cassandra timeout during read query at consistency LOCAL_ONE (1 responses were required but only 0 replica responded) --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org<mailto:user-unsubscr...@cassandra.apache.org> For additional commands, e-mail: user-h...@cassandra.apache.org<mailto:user-h...@cassandra.apache.org>