CODEWITHSUNDEEP
cassandrapentahokettlecql3connection-timeout
Helping Hand..
Helping Hand..

Reputation: 2440

cassandra is giving timeout exception in pentaho kettle

i am using cassandra nosql database for transformation in pentaho data integration.

At the time of manually checking the connection it will connect but while executing the transformation it is giving me timeout exception..

i increased the "request_timeout" but problem is still their. and as per my knowledge data in the cassandra database is increasing then only facing such problems.

so is it some problem with PDI tool or because of cassandra database it-self?

And how can i resolve this problem?

Upvotes: 0

Views: 813

Answers (1)

Fabiano
Fabiano

Reputation: 5199

In cassandra.yaml, you need to increase the parameter read_request_timeout_in_ms to a higher number like 20000. The default number is 10000, and for selects with a huge limit and 10 or 20 columns, you may expect TimeoutException.

Increasing this value will make cassandra wait more for query completion.

I tried this in my database and it worked.

Upvotes: 1

Related Questions