Support Questions
Find answers, ask questions, and share your expertise

Create Hive partitioned view by date by aggregating a table already partitioned by date and hour

New Contributor

My original_table already partioned by (date, hour). I created a view like

create view test_view
partitioned on (date)
as
select id, count(*), date
from original_table
group by id, date

but partition pruning doesn't work on my created view. How can I create view so that partition pruning will work?

0 REPLIES 0