[
https://issues.apache.org/jira/browse/SPARK-49507?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yuming Wang resolved SPARK-49507.
---------------------------------
Resolution: Fixed
> Fix Expected only partition pruning predicates exception
> --------------------------------------------------------
>
> Key: SPARK-49507
> URL: https://issues.apache.org/jira/browse/SPARK-49507
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 3.5.0, 4.0.0, 3.5.3
> Reporter: Yuming Wang
> Assignee: Tongwei
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0, 3.5.6
>
>
> How to reproduce:
> {code:scala}
> sql("CREATE TABLE t (ID BIGINT, DT STRING) USING parquet PARTITIONED BY (DT)")
> sql("set spark.sql.hive.metastorePartitionPruningFastFallback=true")
> sql("select * from t where dt=20240820").show
> {code}
> {noformat}
> org.apache.spark.sql.AnalysisException: Expected only partition pruning
> predicates: List(isnotnull(DT#21), (cast(DT#21 as bigint) = 20240820)).
> at
> org.apache.spark.sql.errors.QueryCompilationErrors$.nonPartitionPruningPredicatesNotExpectedError(QueryCompilationErrors.scala:2414)
> at
> org.apache.spark.sql.catalyst.catalog.ExternalCatalogUtils$.generatePartitionPredicateByFilter(ExternalCatalo
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
