Problem Note 68939: Explicit pass-through might fail to complete when you use the BULKUNLOAD=yes option to read in large BigQuery tables
 |  |  |  |  |
Using explicit pass-through to read in large BigQuery tables might result in the job never completing when you use BULKUNLOAD=YES. Some of the Avro files that are used with the option might still exist in the Google Bucket specified with the BL_BUCKET= option or they might all have been moved to SAS when the issue occurs.
A possible workaround is to specify the READBUFF= option with a CONNECT TO statement.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Google BigQuery | Linux for x64 | 9.41 | 9.4 TS1M6 | ||
A fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K2L.html#68939| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2022-03-15 09:04:46 |
| Date Created: | 2022-02-22 10:56:38 |