yaooqinn commented on a change in pull request #31012:
URL: https://github.com/apache/spark/pull/31012#discussion_r560053593
##########
File path:
sql/core/src/test/resources/tpcds-plan-stability/approved-plans-modified/q10.sf100/explain.txt
##########
@@ -200,87 +207,115 @@ Left keys [1]: [c_customer_sk#1]
Right keys [1]: [customer_sk#18]
Join condition: None
-(35) Project [codegen id : 12]
+(35) Project [codegen id : 11]
Output [2]: [c_current_cdemo_sk#2, c_current_addr_sk#3]
Input [3]: [c_customer_sk#1, c_current_cdemo_sk#2, c_current_addr_sk#3]
-(36) Scan parquet default.customer_address
-Output [2]: [ca_address_sk#20, ca_county#21]
+(36) Exchange
+Input [2]: [c_current_cdemo_sk#2, c_current_addr_sk#3]
+Arguments: hashpartitioning(c_current_addr_sk#3, 5), ENSURE_REQUIREMENTS,
[id=#20]
+
+(37) Sort [codegen id : 12]
+Input [2]: [c_current_cdemo_sk#2, c_current_addr_sk#3]
+Arguments: [c_current_addr_sk#3 ASC NULLS FIRST], false, 0
+
+(38) Scan parquet default.customer_address
+Output [2]: [ca_address_sk#21, ca_county#22]
Batched: true
Location [not included in comparison]/{warehouse_dir}/customer_address]
-PushedFilters: [In(ca_county, [Walker County,Richland County,Gaines
County,Douglas County,Dona Ana County]), IsNotNull(ca_address_sk)]
+PushedFilters: [IsNotNull(ca_address_sk)]
ReadSchema: struct<ca_address_sk:int,ca_county:string>
-(37) ColumnarToRow [codegen id : 11]
-Input [2]: [ca_address_sk#20, ca_county#21]
+(39) ColumnarToRow [codegen id : 13]
+Input [2]: [ca_address_sk#21, ca_county#22]
-(38) Filter [codegen id : 11]
-Input [2]: [ca_address_sk#20, ca_county#21]
-Condition : (ca_county#21 IN (Walker County,Richland County,Gaines
County,Douglas County,Dona Ana County) AND isnotnull(ca_address_sk#20))
+(40) Filter [codegen id : 13]
+Input [2]: [ca_address_sk#21, ca_county#22]
+Condition : (staticinvoke(class
org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType,
varcharTypeReadSideCheck, ca_county#22, 30, false, true) IN (Walker
County,Richland County,Gaines County,Douglas County,Dona Ana County) AND
isnotnull(ca_address_sk#21))
Review comment:
not looks pretty
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
