{"payload":{"allShortcutsEnabled":false,"fileTree":{"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q98":{"items":[{"name":"explain.txt","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q98/explain.txt","contentType":"file"},{"name":"simplified.txt","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q98/simplified.txt","contentType":"file"}],"totalCount":2},"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7":{"items":[{"name":"q10a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q10a.sf100","contentType":"directory"},{"name":"q10a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q10a","contentType":"directory"},{"name":"q11.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q11.sf100","contentType":"directory"},{"name":"q11","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q11","contentType":"directory"},{"name":"q12.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q12.sf100","contentType":"directory"},{"name":"q12","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q12","contentType":"directory"},{"name":"q14.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q14.sf100","contentType":"directory"},{"name":"q14","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q14","contentType":"directory"},{"name":"q14a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q14a.sf100","contentType":"directory"},{"name":"q14a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q14a","contentType":"directory"},{"name":"q18a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q18a.sf100","contentType":"directory"},{"name":"q18a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q18a","contentType":"directory"},{"name":"q20.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q20.sf100","contentType":"directory"},{"name":"q20","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q20","contentType":"directory"},{"name":"q22.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q22.sf100","contentType":"directory"},{"name":"q22","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q22","contentType":"directory"},{"name":"q22a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q22a.sf100","contentType":"directory"},{"name":"q22a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q22a","contentType":"directory"},{"name":"q24.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q24.sf100","contentType":"directory"},{"name":"q24","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q24","contentType":"directory"},{"name":"q27a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q27a.sf100","contentType":"directory"},{"name":"q27a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q27a","contentType":"directory"},{"name":"q34.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q34.sf100","contentType":"directory"},{"name":"q34","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q34","contentType":"directory"},{"name":"q35.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q35.sf100","contentType":"directory"},{"name":"q35","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q35","contentType":"directory"},{"name":"q35a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q35a.sf100","contentType":"directory"},{"name":"q35a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q35a","contentType":"directory"},{"name":"q36a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q36a.sf100","contentType":"directory"},{"name":"q36a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q36a","contentType":"directory"},{"name":"q47.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q47.sf100","contentType":"directory"},{"name":"q47","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q47","contentType":"directory"},{"name":"q49.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q49.sf100","contentType":"directory"},{"name":"q49","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q49","contentType":"directory"},{"name":"q51a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q51a.sf100","contentType":"directory"},{"name":"q51a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q51a","contentType":"directory"},{"name":"q57.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q57.sf100","contentType":"directory"},{"name":"q57","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q57","contentType":"directory"},{"name":"q5a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q5a.sf100","contentType":"directory"},{"name":"q5a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q5a","contentType":"directory"},{"name":"q6.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q6.sf100","contentType":"directory"},{"name":"q6","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q6","contentType":"directory"},{"name":"q64.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q64.sf100","contentType":"directory"},{"name":"q64","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q64","contentType":"directory"},{"name":"q67a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q67a.sf100","contentType":"directory"},{"name":"q67a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q67a","contentType":"directory"},{"name":"q70a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q70a.sf100","contentType":"directory"},{"name":"q70a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q70a","contentType":"directory"},{"name":"q72.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q72.sf100","contentType":"directory"},{"name":"q72","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q72","contentType":"directory"},{"name":"q74.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q74.sf100","contentType":"directory"},{"name":"q74","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q74","contentType":"directory"},{"name":"q75.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q75.sf100","contentType":"directory"},{"name":"q75","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q75","contentType":"directory"},{"name":"q77a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q77a.sf100","contentType":"directory"},{"name":"q77a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q77a","contentType":"directory"},{"name":"q78.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q78.sf100","contentType":"directory"},{"name":"q78","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q78","contentType":"directory"},{"name":"q80a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q80a.sf100","contentType":"directory"},{"name":"q80a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q80a","contentType":"directory"},{"name":"q86a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q86a.sf100","contentType":"directory"},{"name":"q86a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q86a","contentType":"directory"},{"name":"q98.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q98.sf100","contentType":"directory"},{"name":"q98","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q98","contentType":"directory"}],"totalCount":64},"sql/core/src/test/resources/tpcds-plan-stability":{"items":[{"name":"approved-plans-modified","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-modified","contentType":"directory"},{"name":"approved-plans-v1_4","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4","contentType":"directory"},{"name":"approved-plans-v2_7","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7","contentType":"directory"}],"totalCount":3},"sql/core/src/test/resources":{"items":[{"name":"META-INF","path":"sql/core/src/test/resources/META-INF","contentType":"directory"},{"name":"spark-events","path":"sql/core/src/test/resources/spark-events","contentType":"directory"},{"name":"sql-functions","path":"sql/core/src/test/resources/sql-functions","contentType":"directory"},{"name":"sql-tests","path":"sql/core/src/test/resources/sql-tests","contentType":"directory"},{"name":"ssb","path":"sql/core/src/test/resources/ssb","contentType":"directory"},{"name":"structured-streaming","path":"sql/core/src/test/resources/structured-streaming","contentType":"directory"},{"name":"test-data","path":"sql/core/src/test/resources/test-data","contentType":"directory"},{"name":"tpcds-modifiedQueries","path":"sql/core/src/test/resources/tpcds-modifiedQueries","contentType":"directory"},{"name":"tpcds-plan-stability","path":"sql/core/src/test/resources/tpcds-plan-stability","contentType":"directory"},{"name":"tpcds-v2.7.0","path":"sql/core/src/test/resources/tpcds-v2.7.0","contentType":"directory"},{"name":"tpcds","path":"sql/core/src/test/resources/tpcds","contentType":"directory"},{"name":"tpch","path":"sql/core/src/test/resources/tpch","contentType":"directory"},{"name":"SPARK-33084.jar","path":"sql/core/src/test/resources/SPARK-33084.jar","contentType":"file"},{"name":"hive-site.xml","path":"sql/core/src/test/resources/hive-site.xml","contentType":"file"},{"name":"log4j.properties","path":"sql/core/src/test/resources/log4j.properties","contentType":"file"},{"name":"sample.json","path":"sql/core/src/test/resources/sample.json","contentType":"file"},{"name":"test_script.py","path":"sql/core/src/test/resources/test_script.py","contentType":"file"}],"totalCount":17},"sql/core/src/test":{"items":[{"name":"avro","path":"sql/core/src/test/avro","contentType":"directory"},{"name":"gen-java","path":"sql/core/src/test/gen-java","contentType":"directory"},{"name":"java","path":"sql/core/src/test/java","contentType":"directory"},{"name":"resources","path":"sql/core/src/test/resources","contentType":"directory"},{"name":"scala","path":"sql/core/src/test/scala","contentType":"directory"},{"name":"scripts","path":"sql/core/src/test/scripts","contentType":"directory"},{"name":"thrift","path":"sql/core/src/test/thrift","contentType":"directory"},{"name":"README.md","path":"sql/core/src/test/README.md","contentType":"file"}],"totalCount":8},"sql/core/src":{"items":[{"name":"main","path":"sql/core/src/main","contentType":"directory"},{"name":"test","path":"sql/core/src/test","contentType":"directory"}],"totalCount":2},"sql/core":{"items":[{"name":"benchmarks","path":"sql/core/benchmarks","contentType":"directory"},{"name":"src","path":"sql/core/src","contentType":"directory"},{"name":"pom.xml","path":"sql/core/pom.xml","contentType":"file"}],"totalCount":3},"sql":{"items":[{"name":"catalyst","path":"sql/catalyst","contentType":"directory"},{"name":"core","path":"sql/core","contentType":"directory"},{"name":"hive-thriftserver","path":"sql/hive-thriftserver","contentType":"directory"},{"name":"hive","path":"sql/hive","contentType":"directory"},{"name":"README.md","path":"sql/README.md","contentType":"file"},{"name":"create-docs.sh","path":"sql/create-docs.sh","contentType":"file"},{"name":"gen-sql-api-docs.py","path":"sql/gen-sql-api-docs.py","contentType":"file"},{"name":"gen-sql-config-docs.py","path":"sql/gen-sql-config-docs.py","contentType":"file"},{"name":"gen-sql-functions-docs.py","path":"sql/gen-sql-functions-docs.py","contentType":"file"},{"name":"mkdocs.yml","path":"sql/mkdocs.yml","contentType":"file"}],"totalCount":10},"":{"items":[{"name":".github","path":".github","contentType":"directory"},{"name":"R","path":"R","contentType":"directory"},{"name":"assembly","path":"assembly","contentType":"directory"},{"name":"bin","path":"bin","contentType":"directory"},{"name":"binder","path":"binder","contentType":"directory"},{"name":"build","path":"build","contentType":"directory"},{"name":"common","path":"common","contentType":"directory"},{"name":"conf","path":"conf","contentType":"directory"},{"name":"core","path":"core","contentType":"directory"},{"name":"data","path":"data","contentType":"directory"},{"name":"dev","path":"dev","contentType":"directory"},{"name":"docs","path":"docs","contentType":"directory"},{"name":"examples","path":"examples","contentType":"directory"},{"name":"external","path":"external","contentType":"directory"},{"name":"graphx","path":"graphx","contentType":"directory"},{"name":"hadoop-cloud","path":"hadoop-cloud","contentType":"directory"},{"name":"launcher","path":"launcher","contentType":"directory"},{"name":"licenses-binary","path":"licenses-binary","contentType":"directory"},{"name":"licenses","path":"licenses","contentType":"directory"},{"name":"mllib-local","path":"mllib-local","contentType":"directory"},{"name":"mllib","path":"mllib","contentType":"directory"},{"name":"project","path":"project","contentType":"directory"},{"name":"python","path":"python","contentType":"directory"},{"name":"repl","path":"repl","contentType":"directory"},{"name":"resource-managers","path":"resource-managers","contentType":"directory"},{"name":"sbin","path":"sbin","contentType":"directory"},{"name":"sql","path":"sql","contentType":"directory"},{"name":"streaming","path":"streaming","contentType":"directory"},{"name":"tools","path":"tools","contentType":"directory"},{"name":".asf.yaml","path":".asf.yaml","contentType":"file"},{"name":".gitattributes","path":".gitattributes","contentType":"file"},{"name":".gitignore","path":".gitignore","contentType":"file"},{"name":".sbtopts","path":".sbtopts","contentType":"file"},{"name":"CONTRIBUTING.md","path":"CONTRIBUTING.md","contentType":"file"},{"name":"LICENSE","path":"LICENSE","contentType":"file"},{"name":"LICENSE-binary","path":"LICENSE-binary","contentType":"file"},{"name":"NOTICE","path":"NOTICE","contentType":"file"},{"name":"NOTICE-binary","path":"NOTICE-binary","contentType":"file"},{"name":"README.md","path":"README.md","contentType":"file"},{"name":"appveyor.yml","path":"appveyor.yml","contentType":"file"},{"name":"pom.xml","path":"pom.xml","contentType":"file"},{"name":"scalastyle-config.xml","path":"scalastyle-config.xml","contentType":"file"}],"totalCount":42}},"fileTreeProcessingTime":22.591432,"foldersToFetch":[],"repo":{"id":17165658,"defaultBranch":"master","name":"spark","ownerLogin":"apache","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2014-02-25T08:00:08.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/47359?v=4","public":true,"private":false,"isOrgOwned":true},"symbolsExpanded":false,"treeExpanded":true,"refInfo":{"name":"a235c3b2544aead2b1e3034aacfd361d49ad79b1","listCacheKey":"v0:1709628414.0","canEdit":false,"refType":"tree","currentOid":"a235c3b2544aead2b1e3034aacfd361d49ad79b1"},"path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q98/explain.txt","currentUser":null,"blob":{"rawLines":["== Physical Plan ==","* Sort (25)","+- Exchange (24)"," +- * Project (23)"," +- Window (22)"," +- * Sort (21)"," +- Exchange (20)"," +- * HashAggregate (19)"," +- Exchange (18)"," +- * HashAggregate (17)"," +- * Project (16)"," +- * BroadcastHashJoin Inner BuildRight (15)"," :- * Project (9)"," : +- * BroadcastHashJoin Inner BuildRight (8)"," : :- * Filter (3)"," : : +- * ColumnarToRow (2)"," : : +- Scan parquet default.store_sales (1)"," : +- BroadcastExchange (7)"," : +- * Filter (6)"," : +- * ColumnarToRow (5)"," : +- Scan parquet default.item (4)"," +- BroadcastExchange (14)"," +- * Project (13)"," +- * Filter (12)"," +- * ColumnarToRow (11)"," +- Scan parquet default.date_dim (10)","","","(1) Scan parquet default.store_sales","Output [3]: [ss_sold_date_sk#1, ss_item_sk#2, ss_ext_sales_price#3]","Batched: true","Location [not included in comparison]/{warehouse_dir}/store_sales]","PushedFilters: [IsNotNull(ss_item_sk), IsNotNull(ss_sold_date_sk)]","ReadSchema: struct","","(2) ColumnarToRow [codegen id : 3]","Input [3]: [ss_sold_date_sk#1, ss_item_sk#2, ss_ext_sales_price#3]","","(3) Filter [codegen id : 3]","Input [3]: [ss_sold_date_sk#1, ss_item_sk#2, ss_ext_sales_price#3]","Condition : (isnotnull(ss_item_sk#2) AND isnotnull(ss_sold_date_sk#1))","","(4) Scan parquet default.item","Output [6]: [i_item_sk#4, i_item_id#5, i_item_desc#6, i_current_price#7, i_class#8, i_category#9]","Batched: true","Location [not included in comparison]/{warehouse_dir}/item]","PushedFilters: [In(i_category, [Sports,Books,Home]), IsNotNull(i_item_sk)]","ReadSchema: struct","","(5) ColumnarToRow [codegen id : 1]","Input [6]: [i_item_sk#4, i_item_id#5, i_item_desc#6, i_current_price#7, i_class#8, i_category#9]","","(6) Filter [codegen id : 1]","Input [6]: [i_item_sk#4, i_item_id#5, i_item_desc#6, i_current_price#7, i_class#8, i_category#9]","Condition : (i_category#9 IN (Sports,Books,Home) AND isnotnull(i_item_sk#4))","","(7) BroadcastExchange","Input [6]: [i_item_sk#4, i_item_id#5, i_item_desc#6, i_current_price#7, i_class#8, i_category#9]","Arguments: HashedRelationBroadcastMode(List(cast(input[0, int, false] as bigint)),false), [id=#10]","","(8) BroadcastHashJoin [codegen id : 3]","Left keys [1]: [ss_item_sk#2]","Right keys [1]: [i_item_sk#4]","Join condition: None","","(9) Project [codegen id : 3]","Output [7]: [ss_sold_date_sk#1, ss_ext_sales_price#3, i_item_id#5, i_item_desc#6, i_current_price#7, i_class#8, i_category#9]","Input [9]: [ss_sold_date_sk#1, ss_item_sk#2, ss_ext_sales_price#3, i_item_sk#4, i_item_id#5, i_item_desc#6, i_current_price#7, i_class#8, i_category#9]","","(10) Scan parquet default.date_dim","Output [2]: [d_date_sk#11, d_date#12]","Batched: true","Location [not included in comparison]/{warehouse_dir}/date_dim]","PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,1999-02-22), LessThanOrEqual(d_date,1999-03-24), IsNotNull(d_date_sk)]","ReadSchema: struct","","(11) ColumnarToRow [codegen id : 2]","Input [2]: [d_date_sk#11, d_date#12]","","(12) Filter [codegen id : 2]","Input [2]: [d_date_sk#11, d_date#12]","Condition : (((isnotnull(d_date#12) AND (d_date#12 >= 10644)) AND (d_date#12 <= 10674)) AND isnotnull(d_date_sk#11))","","(13) Project [codegen id : 2]","Output [1]: [d_date_sk#11]","Input [2]: [d_date_sk#11, d_date#12]","","(14) BroadcastExchange","Input [1]: [d_date_sk#11]","Arguments: HashedRelationBroadcastMode(List(cast(input[0, int, true] as bigint)),false), [id=#13]","","(15) BroadcastHashJoin [codegen id : 3]","Left keys [1]: [ss_sold_date_sk#1]","Right keys [1]: [d_date_sk#11]","Join condition: None","","(16) Project [codegen id : 3]","Output [6]: [ss_ext_sales_price#3, i_item_id#5, i_item_desc#6, i_current_price#7, i_class#8, i_category#9]","Input [8]: [ss_sold_date_sk#1, ss_ext_sales_price#3, i_item_id#5, i_item_desc#6, i_current_price#7, i_class#8, i_category#9, d_date_sk#11]","","(17) HashAggregate [codegen id : 3]","Input [6]: [ss_ext_sales_price#3, i_item_id#5, i_item_desc#6, i_current_price#7, i_class#8, i_category#9]","Keys [5]: [i_item_id#5, i_item_desc#6, i_category#9, i_class#8, i_current_price#7]","Functions [1]: [partial_sum(UnscaledValue(ss_ext_sales_price#3))]","Aggregate Attributes [1]: [sum#14]","Results [6]: [i_item_id#5, i_item_desc#6, i_category#9, i_class#8, i_current_price#7, sum#15]","","(18) Exchange","Input [6]: [i_item_id#5, i_item_desc#6, i_category#9, i_class#8, i_current_price#7, sum#15]","Arguments: hashpartitioning(i_item_id#5, i_item_desc#6, i_category#9, i_class#8, i_current_price#7, 5), ENSURE_REQUIREMENTS, [id=#16]","","(19) HashAggregate [codegen id : 4]","Input [6]: [i_item_id#5, i_item_desc#6, i_category#9, i_class#8, i_current_price#7, sum#15]","Keys [5]: [i_item_id#5, i_item_desc#6, i_category#9, i_class#8, i_current_price#7]","Functions [1]: [sum(UnscaledValue(ss_ext_sales_price#3))]","Aggregate Attributes [1]: [sum(UnscaledValue(ss_ext_sales_price#3))#17]","Results [8]: [i_item_id#5, i_item_desc#6, i_category#9, i_class#8, i_current_price#7, MakeDecimal(sum(UnscaledValue(ss_ext_sales_price#3))#17,17,2) AS itemrevenue#18, MakeDecimal(sum(UnscaledValue(ss_ext_sales_price#3))#17,17,2) AS _w0#19, MakeDecimal(sum(UnscaledValue(ss_ext_sales_price#3))#17,17,2) AS _w1#20]","","(20) Exchange","Input [8]: [i_item_id#5, i_item_desc#6, i_category#9, i_class#8, i_current_price#7, itemrevenue#18, _w0#19, _w1#20]","Arguments: hashpartitioning(i_class#8, 5), ENSURE_REQUIREMENTS, [id=#21]","","(21) Sort [codegen id : 5]","Input [8]: [i_item_id#5, i_item_desc#6, i_category#9, i_class#8, i_current_price#7, itemrevenue#18, _w0#19, _w1#20]","Arguments: [i_class#8 ASC NULLS FIRST], false, 0","","(22) Window","Input [8]: [i_item_id#5, i_item_desc#6, i_category#9, i_class#8, i_current_price#7, itemrevenue#18, _w0#19, _w1#20]","Arguments: [sum(_w1#20) windowspecdefinition(i_class#8, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS _we0#22], [i_class#8]","","(23) Project [codegen id : 6]","Output [7]: [i_item_id#5, i_item_desc#6, i_category#9, i_class#8, i_current_price#7, itemrevenue#18, CheckOverflow((promote_precision(cast(CheckOverflow((promote_precision(_w0#19) * 100.00), DecimalType(21,2), true) as decimal(27,2))) / promote_precision(_we0#22)), DecimalType(38,17), true) AS revenueratio#23]","Input [9]: [i_item_id#5, i_item_desc#6, i_category#9, i_class#8, i_current_price#7, itemrevenue#18, _w0#19, _w1#20, _we0#22]","","(24) Exchange","Input [7]: [i_item_id#5, i_item_desc#6, i_category#9, i_class#8, i_current_price#7, itemrevenue#18, revenueratio#23]","Arguments: rangepartitioning(i_category#9 ASC NULLS FIRST, i_class#8 ASC NULLS FIRST, i_item_id#5 ASC NULLS FIRST, i_item_desc#6 ASC NULLS FIRST, revenueratio#23 ASC NULLS FIRST, 5), ENSURE_REQUIREMENTS, [id=#24]","","(25) Sort [codegen id : 7]","Input [7]: [i_item_id#5, i_item_desc#6, i_category#9, i_class#8, i_current_price#7, itemrevenue#18, revenueratio#23]","Arguments: [i_category#9 ASC NULLS FIRST, i_class#8 ASC NULLS FIRST, i_item_id#5 ASC NULLS FIRST, i_item_desc#6 ASC NULLS FIRST, revenueratio#23 ASC NULLS FIRST], true, 0"],"stylingDirectives":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"colorizedLines":null,"csv":null,"csvError":null,"dependabotInfo":{"showConfigurationBanner":false,"configFilePath":null,"networkDependabotPath":"/apache/spark/network/updates","dismissConfigurationNoticePath":"/settings/dismiss-notice/dependabot_configuration_notice","configurationNoticeDismissed":null},"displayName":"explain.txt","displayUrl":"https://github.com/apache/spark/blob/a235c3b2544aead2b1e3034aacfd361d49ad79b1/sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q98/explain.txt?raw=true","headerInfo":{"blobSize":"7.45 KB","deleteTooltip":"You must be signed in to make or propose changes","editTooltip":"You must be signed in to make or propose changes","ghDesktopPath":null,"isGitLfs":false,"onBranch":false,"shortPath":"ddbe439","siteNavLoginPath":"/login?return_to=https%3A%2F%2Fgithub.com%2Fapache%2Fspark%2Fblob%2Fa235c3b2544aead2b1e3034aacfd361d49ad79b1%2Fsql%2Fcore%2Fsrc%2Ftest%2Fresources%2Ftpcds-plan-stability%2Fapproved-plans-v2_7%2Fq98%2Fexplain.txt","isCSV":false,"isRichtext":false,"toc":null,"lineInfo":{"truncatedLoc":"142","truncatedSloc":"115"},"mode":"file"},"image":false,"isCodeownersFile":null,"isPlain":false,"isValidLegacyIssueTemplate":false,"issueTemplate":null,"discussionTemplate":null,"language":"Text","languageID":372,"large":false,"planSupportInfo":{"repoIsFork":null,"repoOwnedByCurrentUser":null,"requestFullPath":"/apache/spark/blob/a235c3b2544aead2b1e3034aacfd361d49ad79b1/sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q98/explain.txt","showFreeOrgGatedFeatureMessage":null,"showPlanSupportBanner":null,"upgradeDataAttributes":null,"upgradePath":null},"publishBannersInfo":{"dismissActionNoticePath":"/settings/dismiss-notice/publish_action_from_dockerfile","releasePath":"/apache/spark/releases/new?marketplace=true","showPublishActionBanner":false},"rawBlobUrl":"https://github.com/apache/spark/raw/a235c3b2544aead2b1e3034aacfd361d49ad79b1/sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q98/explain.txt","renderImageOrRaw":false,"richText":null,"renderedFileInfo":null,"shortPath":null,"symbolsEnabled":true,"tabSize":8,"topBannersInfo":{"overridingGlobalFundingFile":false,"globalPreferredFundingPath":null,"showInvalidCitationWarning":false,"citationHelpUrl":"https://docs.github.com/github/creating-cloning-and-archiving-repositories/creating-a-repository-on-github/about-citation-files","actionsOnboardingTip":null},"truncated":false,"viewable":true,"workflowRedirectUrl":null,"symbols":{"timed_out":false,"not_analyzed":true,"symbols":[]}},"copilotInfo":null,"copilotAccessAllowed":false,"csrf_tokens":{"/apache/spark/branches":{"post":"oKNldH_8afEq3oiuzaqEiLGuPlDg3e5wQc2DYrTRt_-x6fMGiK8D2lSvaxT6cyvKGLDsyQsux6qMf-VtrVawhw"},"/repos/preferences":{"post":"3PhBWLvF0nPioQ3RMVyFJ-AWnxYZ5DN8uRteRMznAiKTxS09wbmLd3GkymMYRlBPJ3adw-dwgEQVyFibOhJ_dg"}}},"title":"spark/sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v2_7/q98/explain.txt at a235c3b2544aead2b1e3034aacfd361d49ad79b1 ยท apache/spark"}