Yuming Wang created SPARK-33584:
-----------------------------------

             Summary: Partition predicate pushdown into Hive metastore support 
cast string type to date type
                 Key: SPARK-33584
                 URL: https://issues.apache.org/jira/browse/SPARK-33584
             Project: Spark
          Issue Type: Sub-task
          Components: SQL
    Affects Versions: 3.1.0
            Reporter: Yuming Wang
            Assignee: Yuming Wang


{code:scala}
spark.sql("create table t1(id string) partitioned by (part string) stored as 
parquet")
spark.sql("insert into t1 values('1', '2019-01-01')")
spark.sql("insert into t1 values('2', '2019-01-02')")
spark.sql("select * from t1 where  part = date '2019-01-01' ").show
{code}

We can pushdown {{cast(part as date) = date '2019-01-01' }} to Hive metastore.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to