Problem Note 68312: "CLI prepare error....unknown data type" occurs when you read a Google BigQuery table that contains a variable with the BIGNUMERIC data type
 |  |  |  |  |
SAS/ACCESS® Interface to Google BigQuery does not support the BIGNUMERIC data type. When you attempt to read in a BigQuery table that contains a variable that is defined with a BIGNUMERIC data type, an error similar to the following occurs:
The same error might occur with a Google BigQuery table that contains a variable that is defined as a NUMERIC data type. For more information about this issue, see SAS Note 64859, "CLI prepare error....unknown data type" occurs when you read a Google BigQuery table that contains a variable with the NUMERIC data type.
The only workaround is to use explicit pass-through to read the table, either not selecting the column or casting the column to a supported data type.
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 | Stable 2024.04 | Viya | Viya |
| SAS System | SAS/ACCESS Interface to Google BigQuery | Linux for x64 | 9.4 TS1M6 | |||
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | V.03.04 | Stable 2024.04 | Viya | Viya |
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#68312| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2024-05-13 09:36:29 |
| Date Created: | 2021-08-25 12:36:49 |