Re: Query timed out after PT2M

2022-02-03 Thread manish khandelwal
It maybe the case you have lots of tombstones in this table which is making reads slow and timeouts during bulk reads. On Fri, Feb 4, 2022, 03:23 Joe Obernberger wrote: > So it turns out that number after PT is increments of 60 seconds. I > changed the timeout to 96, and now I get PT16M (96

Re: Query timed out after PT2M

2022-02-03 Thread Joe Obernberger
So it turns out that number after PT is increments of 60 seconds.  I changed the timeout to 96, and now I get PT16M (96/6).  Since I'm still getting timeouts, something else must be wrong. Exception in thread "main" org.apache.spark.SparkException: Job aborted due to stage failure:

Re: Query timed out after PT2M

2022-02-03 Thread Joe Obernberger
I did find this: https://github.com/datastax/spark-cassandra-connector/blob/master/doc/reference.md And "spark.cassandra.read.timeoutMS" is set to 12. Running a test now, and I think that is it.  Thank you Scott. -Joe On 2/3/2022 3:19 PM, Joe Obernberger wrote: Thank you Scott! I am usin

Re: Query timed out after PT2M

2022-02-03 Thread Joe Obernberger
Thank you Scott! I am using the spark cassandra connector.  Code: SparkSession spark = SparkSession     .builder()     .appName("SparkCassandraApp")     .config("spark.cassandra.connection.host", "chaos")     .config("spark.cassandra.connection.port

Re: Query timed out after PT2M

2022-02-03 Thread C. Scott Andreas
Hi Joe, it looks like "PT2M" may refer to a timeout value that could be set by your Spark job's initialization of the client. I don't see a string matching this in the Cassandra codebase itself, but I do see that this is parseable as a Duration.```jshell> java.time.Duration.parse("PT2M").getSeco

Query timed out after PT2M

2022-02-03 Thread Joe Obernberger
Hi all - using a Cassandra 4.0.1 and a spark job running against a large table (~8 billion rows) and I'm getting this error on the client side: Query timed out after PT2M On the server side I see a lot of messages like: DEBUG [Native-Transport-Requests-39] 2022-02-03 14:39:56,647 ReadCallback.j