A SAS Viya analyst runs PROC FEDSQL to query a table stored in a Hadoop Hive database registered as a caslib. Which type of processing does PROC FEDSQL enable for this query?
Select an answer to reveal the explanation.
Short Explanation
Here's the deal — PROC FEDSQL pushes the query down to Hive or brings it into CAS memory, so you only move the result set or use in-memory processing. You don't pull the whole Hive table to your client.
Full Explanation
PROC FEDSQL is SAS Viya's federated SQL engine. For a Hive table registered as a caslib, it can push the SQL query down to the Hive engine for predicate pushdown and retrieve only the result set, or load data into CAS for in-memory distributed processing, minimizing data movement. The option saying it downloads the entire Hive table to the SAS client machine is wrong because federated processing avoids moving entire tables to the client. The option saying it converts Hive SQL to SAS DATA step code and runs on the SAS Workspace Server is wrong because FEDSQL does not transpile to DATA step code. The option saying it requires the Hive table to be exported to CSV before PROC FEDSQL can access it is wrong because PROC FEDSQL can query Hive tables directly through the caslib connection.