Problem Note 65571: Loading data into CAS from BigQuery might result in the QUALIFIER= option not being honored
 |  |  |  |  |
The qualifier specified via the TABLE_QUALIFIER= option in the CASLIB statement might not be honored when you load a BigQuery table into CAS using one of the following methods:
- the loadTable action with the CAS procedure
- the loadTable statement with the CASUTIL procedure
This issue occurs when you do not use the NUMREADNODES= option or the WHERE= or VARS= options/statements.
The workaround is to include a WHERE= option/statement similar to the following:
WHERE = "1=1"
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Connector to Google BigQuery | 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=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-03-31 05:46:58 |
| Date Created: | 2020-02-17 11:04:52 |