[ https://issues.apache.org/jira/browse/SPARK-32659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wenchen Fan reassigned SPARK-32659: ----------------------------------- Assignee: Yuming Wang > Fix the data issue of inserted DPP on non-atomic type > ----------------------------------------------------- > > Key: SPARK-32659 > URL: https://issues.apache.org/jira/browse/SPARK-32659 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 3.0.0 > Reporter: Yuming Wang > Assignee: Yuming Wang > Priority: Major > Labels: correctness > > DPP has data issue when pruning on non-atomic type. for example: > {noformat} > spark.range(1000) > .select(col("id"), col("id").as("k")) > .write > .partitionBy("k") > .format("parquet") > .mode("overwrite") > .saveAsTable("df1"); > spark.range(100) > .select(col("id"), col("id").as("k")) > .write > .partitionBy("k") > .format("parquet") > .mode("overwrite") > .saveAsTable("df2") > spark.sql("set > spark.sql.optimizer.dynamicPartitionPruning.fallbackFilterRatio=2") > spark.sql("set > spark.sql.optimizer.dynamicPartitionPruning.reuseBroadcastOnly=false") > spark.sql("SELECT df1.id, df2.k FROM df1 JOIN df2 ON struct(df1.k) = > struct(df2.k) AND df2.id < 2").show > {noformat} > It should return two records, but it returns empty. -- 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