Hi, I have a scenario.
Hive table "Table1" created with Partition with txn date. A view "VIEW_TABLE1" is created on top of "Table" with the query 'select * from table1'. If I query the view with the where clause using txn_date, will partition pruning happen? Please throw some light how it will behave in HIVE. regards, Rams