Problem Note 65573: Reading in a BigQuery table might result in an error or slow performance
 |  |  |  |  |
When you read from a Google BigQuery table that includes a variable defined as a Boolean data type, a performance issue or an internal error similar to the following might occur:
ERROR: googleapi: Error 500: An internal error occurred
When a table contains a Boolean data type, any Read buffering performed is determined by the engine and not by any value provided in the READBUFF= option.
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.4 | 9.4 | 9.4 TS1M6 | 9.4 TS1M7 |
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | V.03.04 | 2020.1 | Viya | Viya |
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesA fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H5A.html#65573| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-04-17 15:37:17 |
| Date Created: | 2020-02-17 13:39:55 |