A performance issue or a Google BigQuery error might occur when the following is true about an SQL or FEDSQL procedure query:
- involves the join of two or more Google BigQuery tables
- includes a WHERE clause that contains multiple sub-setting conditions that are separated by both AND and OR operators
- the LIBNAME statement or statements that are referenced in the query includes the DRIVER_TRACEFILE= option
The error might look similar to the following:
ERROR: During read: googleapi: Error 400: Operation timed out after 6.0 hours. Consider reducing the amount of work performed by your operation so that it can complete within this limit., timeout, Dump stack trace & continue.
Also, incorrect results might occur if the query includes parentheses around the OR conditions.
The workaround is to remove the DRIVER_TRACEFILE= option from the LIBNAME statements.