Problem Note 63914: Using the OBS= option can result in long fetch times with SAS/ACCESS® Interface to Amazon Redshift
 |  |  |  |  |
When you use the OBS= option to limit returned observations, it is possible for a select * query to be passed to the Amazon Redshift database. This issue occurs even though the OBS limitation is still honored in SAS®. This processing can cause a performance impact because it processes the entire select * query from the database perspective.
To work around this issue, you must apply an updated driver. This driver allows for the query to pass a LIMIT clause to the database, thus preventing the full table from being processed.
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 | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Amazon Redshift | Microsoft® Windows® for x64 | 9.4 TS1M6 | |
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M6 | |||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M6 | |||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M6 | |||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M6 | |||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M6 | |||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M6 | |||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M6 | |||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M6 | |||
| Microsoft Windows 10 | 9.4 TS1M6 | |||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M6 | |||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M6 | |||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M6 | |||
| Microsoft Windows Server 2012 Std | 9.4 TS1M6 | |||
| Microsoft Windows Server 2016 | 9.4 TS1M6 | |||
| Microsoft Windows Server 2019 | 9.4 TS1M6 | |||
| Windows 7 Enterprise 32 bit | 9.4 TS1M6 | |||
| Windows 7 Enterprise x64 | 9.4 TS1M6 | |||
| Windows 7 Home Premium 32 bit | 9.4 TS1M6 | |||
| Windows 7 Home Premium x64 | 9.4 TS1M6 | |||
| Windows 7 Professional 32 bit | 9.4 TS1M6 | |||
| Windows 7 Professional x64 | 9.4 TS1M6 | |||
| Windows 7 Ultimate 32 bit | 9.4 TS1M6 | |||
| Windows 7 Ultimate x64 | 9.4 TS1M6 | |||
| 64-bit Enabled AIX | 9.4 TS1M6 | |||
| 64-bit Enabled Solaris | 9.4 TS1M6 | |||
| HP-UX IPF | 9.4 TS1M6 | |||
| Linux for x64 | 9.4 TS1M6 | |||
| Solaris for x64 | 9.4 TS1M6 | |||
A fix for this issue for DataDirect ODBC Driver for Amazon Redshift 9.43 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E8C.html#63914A fix for this issue for DataDirect ODBC Driver for Amazon Redshift 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E8B.html#63914A fix for this issue for DataDirect ODBC Driver for Amazon Redshift 9.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A6E.html#63914| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2022-02-23 14:03:39 |
| Date Created: | 2019-03-26 14:20:10 |