Hi, I might be wrong, but I would expect views to work as a simple
replacement at the query level (like a subquery or a CTE).
This means that partition pruning should work as long as predicate pushdown
properly works.
For your specific use case, it should be easy enough to test, and you can
use an EXPLAIN DEPENDENCY to see if the partition pruning is correct.
2018-01-23 14:39 GMT+01:00 Ramasubramanian Narayanan <
ramasubramanian.naraya...@gmail.com>:
> 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
>
