Problem Note 68500: Performance problems occur when reading data from Hadoop using PROC FEDSQL in a SAS® Cloud Analytic Services (CAS) session
 |  |  |  |  |
When a user uses the FEDSQL procedure to read data via the SAS® Data Connector to Hadoop in a CAS session, the query passes a CREATE VIEW statement in order to retrieve the requested data. Sometimes, the user who is trying to read the data does not have the proper permissions to create views in the database. In this scenario, the queries might take a long time to complete or might never complete. Therefore, this method of reading data can cause performance problems when reading large tables.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
After you apply the hot fix, queries will be generated with an EXPLAIN plan prepended to the query. This behavior prevents a CREATE VIEW query from being passed to the Hadoop database.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Connector to Hadoop | Linux for x64 | V.03.05 | 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-12-07 14:47:55 |
| Date Created: | 2021-10-12 13:07:52 |