[jira] [Created] (HIVE-21477) Support ppd when a partition key is casted

["Sébastien BARNOUD (JIRA)" <ji...@apache.org>]

Sébastien BARNOUD created HIVE-21477:
----------------------------------------

             Summary: Support ppd when a partition key is casted
                 Key: HIVE-21477
                 URL: https://issues.apache.org/jira/browse/HIVE-21477
             Project: Hive
          Issue Type: Wish
          Components: Hive
            Reporter: Sébastien BARNOUD


When a query contains a cast on the field belonging to the partition key of a table, the Predicate Push Down for this field isn't used. In my opinion, as all field in the partition key are serialized as string, it could be supported.

 

Example:

Create table demo (value int) partitioned by (uid string);

Create view demo_view as select *, cast(uid as bigint) as id from demo;

 

select * from demo_view where id = 1;

 

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)