SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 65571: Loading data into CAS from BigQuery might result in the QUALIFIER= option not being honored

DetailsHotfixAboutRate It

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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Data Connector to Google BigQueryLinux for x64V.03.042020.1ViyaViya
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.