readable_external_table_timeout

readable_external_table_timeout

When an SQL query reads from an external table, the parameter value specifies the amount of time in seconds that Greenplum Database waits before cancelling the query when data stops being returned from the external table.

The default value of 0, specifies no time out. Greenplum Database does not cancel the query.

If queries that use gpfdist run a long time and then return the error "intermittent network connectivity issues",you can specify a value for ternal_table_timeout. If no data is returned by gpfdist for the specified length of time, Greenplum Database cancels the query. master system reload

Value Range Default Set Classifications
integer >= 0 0 master

system

reload