Re: Will partition pruning will happen on HIVE views?

2018-01-23 Thread Furcy Pin
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

Will partition pruning will happen on HIVE views?

2018-01-23 Thread Ramasubramanian Narayanan
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