Fully managed cloud. 30-day FREE full featured trial. Start Now
cancel
Showing results for 
Search instead for 
Did you mean: 

Whre can I set the timeout parameter in virtual schema

kochjoe
SQL-Fighter

Hi there,

we are using different virtual schemas to connect to remote data (S3 and another Exasol) and sporadically run into a timeout. Is there a parameter where I can enlarge the timeout setting for virtual schemas?

Any help is appreciated.

3 REPLIES 3

exa-Jakob
Team Exasol
Team Exasol

Hi,

could you share an error-message?

kochjoe
SQL-Fighter

Hi @exa-Jakob,

I get this error message when running into a timeout: SQL Error [42636]: ETL-4101: Inserting data failed with error 'Query terminated because timeout has been reached.'

This message I get for example when reading data from AWS Athena via a virtual schema. When I recall correctly I get this message also from a virtual schema from a remote Exasol. Can we use connection timeout parameter within jdbc signature in Athena when creating the connection in Exasol?

exa-Jakob
Team Exasol
Team Exasol

Hi @kochjoe ,

that message is new to me. However, I would expect that it comes from the Exasol DB / importer since it states that inserting failed. Also, the term query indicates it's not related to S3.

So maybe it's the generic Exasol query timeout (see ALTER SESSION doc)

However, that's just a guess. If you need additional help please open a support ticket.