FedSQL on the SAS© Viya™ platform supports new data types and proprietary extensions, optimizing queries with multi-threaded algorithms for large-scale operations. It can be submitted via the SAS© Compute Server or the CAS Server. With the Compute Server, FedSQL supports the same statements as in SAS© 9.4 and uses PROC FEDSQL to access data via SAS© libraries. On the CAS Server, only CREATE TABLE (with AS expression), SELECT, and DROP TABLE are supported, with full implicit SQL pass-through support and limited explicit pass-through via the CONNECTION TO component. Data processed on the CAS Server uses CAS data types.
Related Code Examples : Data Access
| Sujet / Mot-clé | Lien vers la ressource |
|---|---|
| CODE Default SAS Libraries | en/sampleCode/DEFAUL96F3 |
| CODE SAS Library Concatenation | en/sampleCode/SASLIB2620 |
| CODE Examples: Using a SAS Engine to Process External Data | en/sampleCode/EXAMPL6713 |
| CODE Examples: Sorting and Displaying Descriptor Information for Data Sets | en/sampleCode/EXAMPL8D3C |
| CODE Examples: Reading and Creating CAS Tables | en/sampleCode/EXAMPLC610 |
| CODE Examples: Managing SAS Libraries | en/sampleCode/EXAMPLAEBF |
| CODE Examples: Accessing Data Without Using a Libref | en/sampleCode/EXAMPL0158 |
| CODE Examples: Accessing Data Using a Libref | en/sampleCode/EXAMPL086A |
| CODE Reading an ORC Table from ADLS | en/sampleCode/READIN4410 |
| CODE Example: Create a Parquet table in Google Cloud Storage | en/sampleCode/EXAMPLD377 |
