Troubleshooting query processing #

This section provides suggestions for troubleshooting common scenarios when running queries and experiencing failures, performance issues, or encountering other problems.

Query fails after four hours #

Errors #

  • Query exceeded maximum time limit of …
  • Query terminated.
  • Maximum query processing runtime query_max_run_time exceeded.

Solutions #

  • Run the query on a larger cluster, potentially by changing the size of the current cluster.
  • Change the cluster to use batch mode
  • Update the SQL statement to process less data.