I am trying to refresh an analytical view created with partition. Is it possible to refresh an analytical view for specific partition?
I have the following objects, trying to refresh selectively one parition say av1.part1.
create analytical view av1
partitioned by (synthetical_col1)
stored as parquet as
CREATE VIEW logical_view1
select ‘part1’ as synthetical_col1,
other…columns from table1
select ‘part2’ as synthetical_col1,
other…columns from table2
Running the logical view as a whole is hitting the memory limit due to union condition present in the logical view. Want to see a way to sequentially materializing the subqueries Please let me know if its possible.