Hello everyone,
I'm working with SAS VA on SAS Viya 4, and I need to create a report that queries data directly from Hive without loading the entire table into CAS.
The table is very large grows daily and is partitioned by year, month, and day. I want users to be able to select parameters (year, month, day) in the report and the query should retrieve only the relevant partitions instead of scanning the whole table.
If anyone has worked on a similar case, could you please share the steps to achieve this? Thanks.
... View more
