{"payload":{"allShortcutsEnabled":false,"fileTree":{"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q23a.sf100":{"items":[{"name":"explain.txt","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q23a.sf100/explain.txt","contentType":"file"},{"name":"simplified.txt","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q23a.sf100/simplified.txt","contentType":"file"}],"totalCount":2},"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4":{"items":[{"name":"q1.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q1.sf100","contentType":"directory"},{"name":"q1","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q1","contentType":"directory"},{"name":"q10.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q10.sf100","contentType":"directory"},{"name":"q10","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q10","contentType":"directory"},{"name":"q11.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q11.sf100","contentType":"directory"},{"name":"q11","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q11","contentType":"directory"},{"name":"q12.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q12.sf100","contentType":"directory"},{"name":"q12","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q12","contentType":"directory"},{"name":"q13.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q13.sf100","contentType":"directory"},{"name":"q13","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q13","contentType":"directory"},{"name":"q14a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q14a.sf100","contentType":"directory"},{"name":"q14a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q14a","contentType":"directory"},{"name":"q14b.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q14b.sf100","contentType":"directory"},{"name":"q14b","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q14b","contentType":"directory"},{"name":"q15.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q15.sf100","contentType":"directory"},{"name":"q15","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q15","contentType":"directory"},{"name":"q16.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q16.sf100","contentType":"directory"},{"name":"q16","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q16","contentType":"directory"},{"name":"q17.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q17.sf100","contentType":"directory"},{"name":"q17","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q17","contentType":"directory"},{"name":"q18.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q18.sf100","contentType":"directory"},{"name":"q18","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q18","contentType":"directory"},{"name":"q19.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q19.sf100","contentType":"directory"},{"name":"q19","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q19","contentType":"directory"},{"name":"q2.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q2.sf100","contentType":"directory"},{"name":"q2","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q2","contentType":"directory"},{"name":"q20.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q20.sf100","contentType":"directory"},{"name":"q20","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q20","contentType":"directory"},{"name":"q21.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q21.sf100","contentType":"directory"},{"name":"q21","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q21","contentType":"directory"},{"name":"q22.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q22.sf100","contentType":"directory"},{"name":"q22","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q22","contentType":"directory"},{"name":"q23a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q23a.sf100","contentType":"directory"},{"name":"q23a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q23a","contentType":"directory"},{"name":"q23b.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q23b.sf100","contentType":"directory"},{"name":"q23b","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q23b","contentType":"directory"},{"name":"q24a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q24a.sf100","contentType":"directory"},{"name":"q24a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q24a","contentType":"directory"},{"name":"q24b.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q24b.sf100","contentType":"directory"},{"name":"q24b","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q24b","contentType":"directory"},{"name":"q25.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q25.sf100","contentType":"directory"},{"name":"q25","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q25","contentType":"directory"},{"name":"q26.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q26.sf100","contentType":"directory"},{"name":"q26","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q26","contentType":"directory"},{"name":"q27.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q27.sf100","contentType":"directory"},{"name":"q27","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q27","contentType":"directory"},{"name":"q28.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q28.sf100","contentType":"directory"},{"name":"q28","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q28","contentType":"directory"},{"name":"q29.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q29.sf100","contentType":"directory"},{"name":"q29","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q29","contentType":"directory"},{"name":"q3.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q3.sf100","contentType":"directory"},{"name":"q3","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q3","contentType":"directory"},{"name":"q30.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q30.sf100","contentType":"directory"},{"name":"q30","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q30","contentType":"directory"},{"name":"q31.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q31.sf100","contentType":"directory"},{"name":"q31","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q31","contentType":"directory"},{"name":"q32.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q32.sf100","contentType":"directory"},{"name":"q32","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q32","contentType":"directory"},{"name":"q33.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q33.sf100","contentType":"directory"},{"name":"q33","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q33","contentType":"directory"},{"name":"q34.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q34.sf100","contentType":"directory"},{"name":"q34","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q34","contentType":"directory"},{"name":"q35.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q35.sf100","contentType":"directory"},{"name":"q35","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q35","contentType":"directory"},{"name":"q36.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q36.sf100","contentType":"directory"},{"name":"q36","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q36","contentType":"directory"},{"name":"q37.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q37.sf100","contentType":"directory"},{"name":"q37","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q37","contentType":"directory"},{"name":"q38.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q38.sf100","contentType":"directory"},{"name":"q38","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q38","contentType":"directory"},{"name":"q39a.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q39a.sf100","contentType":"directory"},{"name":"q39a","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q39a","contentType":"directory"},{"name":"q39b.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q39b.sf100","contentType":"directory"},{"name":"q39b","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q39b","contentType":"directory"},{"name":"q4.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q4.sf100","contentType":"directory"},{"name":"q4","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q4","contentType":"directory"},{"name":"q40.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q40.sf100","contentType":"directory"},{"name":"q40","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q40","contentType":"directory"},{"name":"q41.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q41.sf100","contentType":"directory"},{"name":"q41","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q41","contentType":"directory"},{"name":"q42.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q42.sf100","contentType":"directory"},{"name":"q42","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q42","contentType":"directory"},{"name":"q43.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q43.sf100","contentType":"directory"},{"name":"q43","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q43","contentType":"directory"},{"name":"q44.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q44.sf100","contentType":"directory"},{"name":"q44","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q44","contentType":"directory"},{"name":"q45.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q45.sf100","contentType":"directory"},{"name":"q45","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q45","contentType":"directory"},{"name":"q46.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q46.sf100","contentType":"directory"},{"name":"q46","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q46","contentType":"directory"},{"name":"q47.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q47.sf100","contentType":"directory"},{"name":"q47","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q47","contentType":"directory"},{"name":"q48.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q48.sf100","contentType":"directory"},{"name":"q48","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q48","contentType":"directory"},{"name":"q49.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q49.sf100","contentType":"directory"},{"name":"q49","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q49","contentType":"directory"},{"name":"q5.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q5.sf100","contentType":"directory"},{"name":"q5","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q5","contentType":"directory"},{"name":"q50.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q50.sf100","contentType":"directory"},{"name":"q50","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q50","contentType":"directory"},{"name":"q51.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q51.sf100","contentType":"directory"},{"name":"q51","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q51","contentType":"directory"},{"name":"q52.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q52.sf100","contentType":"directory"},{"name":"q52","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q52","contentType":"directory"},{"name":"q53.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q53.sf100","contentType":"directory"},{"name":"q53","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q53","contentType":"directory"},{"name":"q54.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q54.sf100","contentType":"directory"},{"name":"q54","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q54","contentType":"directory"},{"name":"q55.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q55.sf100","contentType":"directory"},{"name":"q55","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q55","contentType":"directory"},{"name":"q56.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q56.sf100","contentType":"directory"},{"name":"q56","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q56","contentType":"directory"},{"name":"q57.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q57.sf100","contentType":"directory"},{"name":"q57","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q57","contentType":"directory"},{"name":"q58.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q58.sf100","contentType":"directory"},{"name":"q58","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q58","contentType":"directory"},{"name":"q59.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q59.sf100","contentType":"directory"},{"name":"q59","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q59","contentType":"directory"},{"name":"q6.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q6.sf100","contentType":"directory"},{"name":"q6","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q6","contentType":"directory"},{"name":"q60.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q60.sf100","contentType":"directory"},{"name":"q60","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q60","contentType":"directory"},{"name":"q61.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q61.sf100","contentType":"directory"},{"name":"q61","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q61","contentType":"directory"},{"name":"q62.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q62.sf100","contentType":"directory"},{"name":"q62","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q62","contentType":"directory"},{"name":"q63.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q63.sf100","contentType":"directory"},{"name":"q63","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q63","contentType":"directory"},{"name":"q64.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q64.sf100","contentType":"directory"},{"name":"q64","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q64","contentType":"directory"},{"name":"q65.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q65.sf100","contentType":"directory"},{"name":"q65","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q65","contentType":"directory"},{"name":"q66.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q66.sf100","contentType":"directory"},{"name":"q66","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q66","contentType":"directory"},{"name":"q67.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q67.sf100","contentType":"directory"},{"name":"q67","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q67","contentType":"directory"},{"name":"q68.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q68.sf100","contentType":"directory"},{"name":"q68","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q68","contentType":"directory"},{"name":"q69.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q69.sf100","contentType":"directory"},{"name":"q69","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q69","contentType":"directory"},{"name":"q7.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q7.sf100","contentType":"directory"},{"name":"q7","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q7","contentType":"directory"},{"name":"q70.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q70.sf100","contentType":"directory"},{"name":"q70","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q70","contentType":"directory"},{"name":"q71.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q71.sf100","contentType":"directory"},{"name":"q71","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q71","contentType":"directory"},{"name":"q72.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q72.sf100","contentType":"directory"},{"name":"q72","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q72","contentType":"directory"},{"name":"q73.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q73.sf100","contentType":"directory"},{"name":"q73","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q73","contentType":"directory"},{"name":"q74.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q74.sf100","contentType":"directory"},{"name":"q74","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q74","contentType":"directory"},{"name":"q75.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q75.sf100","contentType":"directory"},{"name":"q75","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q75","contentType":"directory"},{"name":"q76.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q76.sf100","contentType":"directory"},{"name":"q76","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q76","contentType":"directory"},{"name":"q77.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q77.sf100","contentType":"directory"},{"name":"q77","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q77","contentType":"directory"},{"name":"q78.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q78.sf100","contentType":"directory"},{"name":"q78","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q78","contentType":"directory"},{"name":"q79.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q79.sf100","contentType":"directory"},{"name":"q79","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q79","contentType":"directory"},{"name":"q8.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q8.sf100","contentType":"directory"},{"name":"q8","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q8","contentType":"directory"},{"name":"q80.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q80.sf100","contentType":"directory"},{"name":"q80","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q80","contentType":"directory"},{"name":"q81.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q81.sf100","contentType":"directory"},{"name":"q81","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q81","contentType":"directory"},{"name":"q82.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q82.sf100","contentType":"directory"},{"name":"q82","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q82","contentType":"directory"},{"name":"q83.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q83.sf100","contentType":"directory"},{"name":"q83","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q83","contentType":"directory"},{"name":"q84.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q84.sf100","contentType":"directory"},{"name":"q84","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q84","contentType":"directory"},{"name":"q85.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q85.sf100","contentType":"directory"},{"name":"q85","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q85","contentType":"directory"},{"name":"q86.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q86.sf100","contentType":"directory"},{"name":"q86","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q86","contentType":"directory"},{"name":"q87.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q87.sf100","contentType":"directory"},{"name":"q87","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q87","contentType":"directory"},{"name":"q88.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q88.sf100","contentType":"directory"},{"name":"q88","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q88","contentType":"directory"},{"name":"q89.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q89.sf100","contentType":"directory"},{"name":"q89","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q89","contentType":"directory"},{"name":"q9.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q9.sf100","contentType":"directory"},{"name":"q9","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q9","contentType":"directory"},{"name":"q90.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q90.sf100","contentType":"directory"},{"name":"q90","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q90","contentType":"directory"},{"name":"q91.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q91.sf100","contentType":"directory"},{"name":"q91","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q91","contentType":"directory"},{"name":"q92.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q92.sf100","contentType":"directory"},{"name":"q92","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q92","contentType":"directory"},{"name":"q93.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q93.sf100","contentType":"directory"},{"name":"q93","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q93","contentType":"directory"},{"name":"q94.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q94.sf100","contentType":"directory"},{"name":"q94","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q94","contentType":"directory"},{"name":"q95.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q95.sf100","contentType":"directory"},{"name":"q95","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q95","contentType":"directory"},{"name":"q96.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q96.sf100","contentType":"directory"},{"name":"q96","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q96","contentType":"directory"},{"name":"q97.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q97.sf100","contentType":"directory"},{"name":"q97","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q97","contentType":"directory"},{"name":"q98.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q98.sf100","contentType":"directory"},{"name":"q98","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q98","contentType":"directory"},{"name":"q99.sf100","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q99.sf100","contentType":"directory"},{"name":"q99","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q99","contentType":"directory"}],"totalCount":206},"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":40.105734,"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-v1_4/q23a.sf100/explain.txt","currentUser":null,"blob":{"rawLines":["== Physical Plan ==","* HashAggregate (99)","+- Exchange (98)"," +- * HashAggregate (97)"," +- Union (96)"," :- * Project (59)"," : +- * BroadcastHashJoin Inner BuildRight (58)"," : :- * Project (52)"," : : +- SortMergeJoin LeftSemi (51)"," : : :- * Sort (33)"," : : : +- Exchange (32)"," : : : +- * Project (31)"," : : : +- SortMergeJoin LeftSemi (30)"," : : : :- * Sort (5)"," : : : : +- Exchange (4)"," : : : : +- * Filter (3)"," : : : : +- * ColumnarToRow (2)"," : : : : +- Scan parquet default.catalog_sales (1)"," : : : +- * Sort (29)"," : : : +- * Project (28)"," : : : +- * Filter (27)"," : : : +- * HashAggregate (26)"," : : : +- * HashAggregate (25)"," : : : +- * Project (24)"," : : : +- * SortMergeJoin Inner (23)"," : : : :- * Sort (17)"," : : : : +- Exchange (16)"," : : : : +- * Project (15)"," : : : : +- * BroadcastHashJoin Inner BuildRight (14)"," : : : : :- * Filter (8)"," : : : : : +- * ColumnarToRow (7)"," : : : : : +- Scan parquet default.store_sales (6)"," : : : : +- BroadcastExchange (13)"," : : : : +- * Project (12)"," : : : : +- * Filter (11)"," : : : : +- * ColumnarToRow (10)"," : : : : +- Scan parquet default.date_dim (9)"," : : : +- * Sort (22)"," : : : +- Exchange (21)"," : : : +- * Filter (20)"," : : : +- * ColumnarToRow (19)"," : : : +- Scan parquet default.item (18)"," : : +- * Sort (50)"," : : +- * Project (49)"," : : +- * Filter (48)"," : : +- * HashAggregate (47)"," : : +- * HashAggregate (46)"," : : +- * Project (45)"," : : +- * SortMergeJoin Inner (44)"," : : :- * Sort (38)"," : : : +- Exchange (37)"," : : : +- * Filter (36)"," : : : +- * ColumnarToRow (35)"," : : : +- Scan parquet default.store_sales (34)"," : : +- * Sort (43)"," : : +- Exchange (42)"," : : +- * Filter (41)"," : : +- * ColumnarToRow (40)"," : : +- Scan parquet default.customer (39)"," : +- BroadcastExchange (57)"," : +- * Project (56)"," : +- * Filter (55)"," : +- * ColumnarToRow (54)"," : +- Scan parquet default.date_dim (53)"," +- * Project (95)"," +- * BroadcastHashJoin Inner BuildRight (94)"," :- * Project (92)"," : +- SortMergeJoin LeftSemi (91)"," : :- * Sort (79)"," : : +- Exchange (78)"," : : +- * Project (77)"," : : +- SortMergeJoin LeftSemi (76)"," : : :- * Sort (64)"," : : : +- Exchange (63)"," : : : +- * Filter (62)"," : : : +- * ColumnarToRow (61)"," : : : +- Scan parquet default.web_sales (60)"," : : +- * Sort (75)"," : : +- * Project (74)"," : : +- * Filter (73)"," : : +- * HashAggregate (72)"," : : +- * HashAggregate (71)"," : : +- * Project (70)"," : : +- * SortMergeJoin Inner (69)"," : : :- * Sort (66)"," : : : +- ReusedExchange (65)"," : : +- * Sort (68)"," : : +- ReusedExchange (67)"," : +- * Sort (90)"," : +- * Project (89)"," : +- * Filter (88)"," : +- * HashAggregate (87)"," : +- * HashAggregate (86)"," : +- * Project (85)"," : +- * SortMergeJoin Inner (84)"," : :- * Sort (81)"," : : +- ReusedExchange (80)"," : +- * Sort (83)"," : +- ReusedExchange (82)"," +- ReusedExchange (93)","","","(1) Scan parquet default.catalog_sales","Output [5]: [cs_sold_date_sk#1, cs_bill_customer_sk#2, cs_item_sk#3, cs_quantity#4, cs_list_price#5]","Batched: true","Location [not included in comparison]/{warehouse_dir}/catalog_sales]","PushedFilters: [IsNotNull(cs_sold_date_sk)]","ReadSchema: struct","","(2) ColumnarToRow [codegen id : 1]","Input [5]: [cs_sold_date_sk#1, cs_bill_customer_sk#2, cs_item_sk#3, cs_quantity#4, cs_list_price#5]","","(3) Filter [codegen id : 1]","Input [5]: [cs_sold_date_sk#1, cs_bill_customer_sk#2, cs_item_sk#3, cs_quantity#4, cs_list_price#5]","Condition : isnotnull(cs_sold_date_sk#1)","","(4) Exchange","Input [5]: [cs_sold_date_sk#1, cs_bill_customer_sk#2, cs_item_sk#3, cs_quantity#4, cs_list_price#5]","Arguments: hashpartitioning(cs_item_sk#3, 5), ENSURE_REQUIREMENTS, [id=#6]","","(5) Sort [codegen id : 2]","Input [5]: [cs_sold_date_sk#1, cs_bill_customer_sk#2, cs_item_sk#3, cs_quantity#4, cs_list_price#5]","Arguments: [cs_item_sk#3 ASC NULLS FIRST], false, 0","","(6) Scan parquet default.store_sales","Output [2]: [ss_sold_date_sk#7, ss_item_sk#8]","Batched: true","Location [not included in comparison]/{warehouse_dir}/store_sales]","PushedFilters: [IsNotNull(ss_sold_date_sk), IsNotNull(ss_item_sk)]","ReadSchema: struct","","(7) ColumnarToRow [codegen id : 4]","Input [2]: [ss_sold_date_sk#7, ss_item_sk#8]","","(8) Filter [codegen id : 4]","Input [2]: [ss_sold_date_sk#7, ss_item_sk#8]","Condition : (isnotnull(ss_sold_date_sk#7) AND isnotnull(ss_item_sk#8))","","(9) Scan parquet default.date_dim","Output [3]: [d_date_sk#9, d_date#10, d_year#11]","Batched: true","Location [not included in comparison]/{warehouse_dir}/date_dim]","PushedFilters: [In(d_year, [2000,2001,2002,2003]), IsNotNull(d_date_sk)]","ReadSchema: struct","","(10) ColumnarToRow [codegen id : 3]","Input [3]: [d_date_sk#9, d_date#10, d_year#11]","","(11) Filter [codegen id : 3]","Input [3]: [d_date_sk#9, d_date#10, d_year#11]","Condition : (d_year#11 IN (2000,2001,2002,2003) AND isnotnull(d_date_sk#9))","","(12) Project [codegen id : 3]","Output [2]: [d_date_sk#9, d_date#10]","Input [3]: [d_date_sk#9, d_date#10, d_year#11]","","(13) BroadcastExchange","Input [2]: [d_date_sk#9, d_date#10]","Arguments: HashedRelationBroadcastMode(List(cast(input[0, int, true] as bigint)),false), [id=#12]","","(14) BroadcastHashJoin [codegen id : 4]","Left keys [1]: [ss_sold_date_sk#7]","Right keys [1]: [d_date_sk#9]","Join condition: None","","(15) Project [codegen id : 4]","Output [2]: [ss_item_sk#8, d_date#10]","Input [4]: [ss_sold_date_sk#7, ss_item_sk#8, d_date_sk#9, d_date#10]","","(16) Exchange","Input [2]: [ss_item_sk#8, d_date#10]","Arguments: hashpartitioning(ss_item_sk#8, 5), ENSURE_REQUIREMENTS, [id=#13]","","(17) Sort [codegen id : 5]","Input [2]: [ss_item_sk#8, d_date#10]","Arguments: [ss_item_sk#8 ASC NULLS FIRST], false, 0","","(18) Scan parquet default.item","Output [2]: [i_item_sk#14, i_item_desc#15]","Batched: true","Location [not included in comparison]/{warehouse_dir}/item]","PushedFilters: [IsNotNull(i_item_sk)]","ReadSchema: struct","","(19) ColumnarToRow [codegen id : 6]","Input [2]: [i_item_sk#14, i_item_desc#15]","","(20) Filter [codegen id : 6]","Input [2]: [i_item_sk#14, i_item_desc#15]","Condition : isnotnull(i_item_sk#14)","","(21) Exchange","Input [2]: [i_item_sk#14, i_item_desc#15]","Arguments: hashpartitioning(i_item_sk#14, 5), ENSURE_REQUIREMENTS, [id=#16]","","(22) Sort [codegen id : 7]","Input [2]: [i_item_sk#14, i_item_desc#15]","Arguments: [i_item_sk#14 ASC NULLS FIRST], false, 0","","(23) SortMergeJoin [codegen id : 8]","Left keys [1]: [ss_item_sk#8]","Right keys [1]: [i_item_sk#14]","Join condition: None","","(24) Project [codegen id : 8]","Output [3]: [d_date#10, i_item_sk#14, i_item_desc#15]","Input [4]: [ss_item_sk#8, d_date#10, i_item_sk#14, i_item_desc#15]","","(25) HashAggregate [codegen id : 8]","Input [3]: [d_date#10, i_item_sk#14, i_item_desc#15]","Keys [3]: [substr(i_item_desc#15, 1, 30) AS substr(i_item_desc#15, 1, 30)#17, i_item_sk#14, d_date#10]","Functions [1]: [partial_count(1)]","Aggregate Attributes [1]: [count#18]","Results [4]: [substr(i_item_desc#15, 1, 30)#17, i_item_sk#14, d_date#10, count#19]","","(26) HashAggregate [codegen id : 8]","Input [4]: [substr(i_item_desc#15, 1, 30)#17, i_item_sk#14, d_date#10, count#19]","Keys [3]: [substr(i_item_desc#15, 1, 30)#17, i_item_sk#14, d_date#10]","Functions [1]: [count(1)]","Aggregate Attributes [1]: [count(1)#20]","Results [2]: [i_item_sk#14 AS item_sk#21, count(1)#20 AS count(1)#22]","","(27) Filter [codegen id : 8]","Input [2]: [item_sk#21, count(1)#22]","Condition : (count(1)#22 > 4)","","(28) Project [codegen id : 8]","Output [1]: [item_sk#21]","Input [2]: [item_sk#21, count(1)#22]","","(29) Sort [codegen id : 8]","Input [1]: [item_sk#21]","Arguments: [item_sk#21 ASC NULLS FIRST], false, 0","","(30) SortMergeJoin","Left keys [1]: [cs_item_sk#3]","Right keys [1]: [item_sk#21]","Join condition: None","","(31) Project [codegen id : 9]","Output [4]: [cs_sold_date_sk#1, cs_bill_customer_sk#2, cs_quantity#4, cs_list_price#5]","Input [5]: [cs_sold_date_sk#1, cs_bill_customer_sk#2, cs_item_sk#3, cs_quantity#4, cs_list_price#5]","","(32) Exchange","Input [4]: [cs_sold_date_sk#1, cs_bill_customer_sk#2, cs_quantity#4, cs_list_price#5]","Arguments: hashpartitioning(cs_bill_customer_sk#2, 5), ENSURE_REQUIREMENTS, [id=#23]","","(33) Sort [codegen id : 10]","Input [4]: [cs_sold_date_sk#1, cs_bill_customer_sk#2, cs_quantity#4, cs_list_price#5]","Arguments: [cs_bill_customer_sk#2 ASC NULLS FIRST], false, 0","","(34) Scan parquet default.store_sales","Output [3]: [ss_customer_sk#24, ss_quantity#25, ss_sales_price#26]","Batched: true","Location [not included in comparison]/{warehouse_dir}/store_sales]","PushedFilters: [IsNotNull(ss_customer_sk)]","ReadSchema: struct","","(35) ColumnarToRow [codegen id : 11]","Input [3]: [ss_customer_sk#24, ss_quantity#25, ss_sales_price#26]","","(36) Filter [codegen id : 11]","Input [3]: [ss_customer_sk#24, ss_quantity#25, ss_sales_price#26]","Condition : isnotnull(ss_customer_sk#24)","","(37) Exchange","Input [3]: [ss_customer_sk#24, ss_quantity#25, ss_sales_price#26]","Arguments: hashpartitioning(ss_customer_sk#24, 5), ENSURE_REQUIREMENTS, [id=#27]","","(38) Sort [codegen id : 12]","Input [3]: [ss_customer_sk#24, ss_quantity#25, ss_sales_price#26]","Arguments: [ss_customer_sk#24 ASC NULLS FIRST], false, 0","","(39) Scan parquet default.customer","Output [1]: [c_customer_sk#28]","Batched: true","Location [not included in comparison]/{warehouse_dir}/customer]","PushedFilters: [IsNotNull(c_customer_sk)]","ReadSchema: struct","","(40) ColumnarToRow [codegen id : 13]","Input [1]: [c_customer_sk#28]","","(41) Filter [codegen id : 13]","Input [1]: [c_customer_sk#28]","Condition : isnotnull(c_customer_sk#28)","","(42) Exchange","Input [1]: [c_customer_sk#28]","Arguments: hashpartitioning(c_customer_sk#28, 5), ENSURE_REQUIREMENTS, [id=#29]","","(43) Sort [codegen id : 14]","Input [1]: [c_customer_sk#28]","Arguments: [c_customer_sk#28 ASC NULLS FIRST], false, 0","","(44) SortMergeJoin [codegen id : 15]","Left keys [1]: [ss_customer_sk#24]","Right keys [1]: [c_customer_sk#28]","Join condition: None","","(45) Project [codegen id : 15]","Output [3]: [ss_quantity#25, ss_sales_price#26, c_customer_sk#28]","Input [4]: [ss_customer_sk#24, ss_quantity#25, ss_sales_price#26, c_customer_sk#28]","","(46) HashAggregate [codegen id : 15]","Input [3]: [ss_quantity#25, ss_sales_price#26, c_customer_sk#28]","Keys [1]: [c_customer_sk#28]","Functions [1]: [partial_sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))]","Aggregate Attributes [2]: [sum#30, isEmpty#31]","Results [3]: [c_customer_sk#28, sum#32, isEmpty#33]","","(47) HashAggregate [codegen id : 15]","Input [3]: [c_customer_sk#28, sum#32, isEmpty#33]","Keys [1]: [c_customer_sk#28]","Functions [1]: [sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))]","Aggregate Attributes [1]: [sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))#34]","Results [2]: [c_customer_sk#28, sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))#34 AS sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))#35]","","(48) Filter [codegen id : 15]","Input [2]: [c_customer_sk#28, sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))#35]","Condition : (isnotnull(sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))#35) AND (cast(sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))#35 as decimal(38,8)) > CheckOverflow((0.500000 * promote_precision(cast(Subquery scalar-subquery#36, [id=#37] as decimal(32,6)))), DecimalType(38,8), true)))","","(49) Project [codegen id : 15]","Output [1]: [c_customer_sk#28]","Input [2]: [c_customer_sk#28, sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))#35]","","(50) Sort [codegen id : 15]","Input [1]: [c_customer_sk#28]","Arguments: [c_customer_sk#28 ASC NULLS FIRST], false, 0","","(51) SortMergeJoin","Left keys [1]: [cs_bill_customer_sk#2]","Right keys [1]: [c_customer_sk#28]","Join condition: None","","(52) Project [codegen id : 17]","Output [3]: [cs_sold_date_sk#1, cs_quantity#4, cs_list_price#5]","Input [4]: [cs_sold_date_sk#1, cs_bill_customer_sk#2, cs_quantity#4, cs_list_price#5]","","(53) Scan parquet default.date_dim","Output [3]: [d_date_sk#9, d_year#11, d_moy#38]","Batched: true","Location [not included in comparison]/{warehouse_dir}/date_dim]","PushedFilters: [IsNotNull(d_year), IsNotNull(d_moy), EqualTo(d_year,2000), EqualTo(d_moy,2), IsNotNull(d_date_sk)]","ReadSchema: struct","","(54) ColumnarToRow [codegen id : 16]","Input [3]: [d_date_sk#9, d_year#11, d_moy#38]","","(55) Filter [codegen id : 16]","Input [3]: [d_date_sk#9, d_year#11, d_moy#38]","Condition : ((((isnotnull(d_year#11) AND isnotnull(d_moy#38)) AND (d_year#11 = 2000)) AND (d_moy#38 = 2)) AND isnotnull(d_date_sk#9))","","(56) Project [codegen id : 16]","Output [1]: [d_date_sk#9]","Input [3]: [d_date_sk#9, d_year#11, d_moy#38]","","(57) BroadcastExchange","Input [1]: [d_date_sk#9]","Arguments: HashedRelationBroadcastMode(List(cast(input[0, int, true] as bigint)),false), [id=#39]","","(58) BroadcastHashJoin [codegen id : 17]","Left keys [1]: [cs_sold_date_sk#1]","Right keys [1]: [d_date_sk#9]","Join condition: None","","(59) Project [codegen id : 17]","Output [1]: [CheckOverflow((promote_precision(cast(cast(cs_quantity#4 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(cs_list_price#5 as decimal(12,2)))), DecimalType(18,2), true) AS sales#40]","Input [4]: [cs_sold_date_sk#1, cs_quantity#4, cs_list_price#5, d_date_sk#9]","","(60) Scan parquet default.web_sales","Output [5]: [ws_sold_date_sk#41, ws_item_sk#42, ws_bill_customer_sk#43, ws_quantity#44, ws_list_price#45]","Batched: true","Location [not included in comparison]/{warehouse_dir}/web_sales]","PushedFilters: [IsNotNull(ws_sold_date_sk)]","ReadSchema: struct","","(61) ColumnarToRow [codegen id : 18]","Input [5]: [ws_sold_date_sk#41, ws_item_sk#42, ws_bill_customer_sk#43, ws_quantity#44, ws_list_price#45]","","(62) Filter [codegen id : 18]","Input [5]: [ws_sold_date_sk#41, ws_item_sk#42, ws_bill_customer_sk#43, ws_quantity#44, ws_list_price#45]","Condition : isnotnull(ws_sold_date_sk#41)","","(63) Exchange","Input [5]: [ws_sold_date_sk#41, ws_item_sk#42, ws_bill_customer_sk#43, ws_quantity#44, ws_list_price#45]","Arguments: hashpartitioning(ws_item_sk#42, 5), ENSURE_REQUIREMENTS, [id=#46]","","(64) Sort [codegen id : 19]","Input [5]: [ws_sold_date_sk#41, ws_item_sk#42, ws_bill_customer_sk#43, ws_quantity#44, ws_list_price#45]","Arguments: [ws_item_sk#42 ASC NULLS FIRST], false, 0","","(65) ReusedExchange [Reuses operator id: 16]","Output [2]: [ss_item_sk#8, d_date#10]","","(66) Sort [codegen id : 22]","Input [2]: [ss_item_sk#8, d_date#10]","Arguments: [ss_item_sk#8 ASC NULLS FIRST], false, 0","","(67) ReusedExchange [Reuses operator id: 21]","Output [2]: [i_item_sk#14, i_item_desc#15]","","(68) Sort [codegen id : 24]","Input [2]: [i_item_sk#14, i_item_desc#15]","Arguments: [i_item_sk#14 ASC NULLS FIRST], false, 0","","(69) SortMergeJoin [codegen id : 25]","Left keys [1]: [ss_item_sk#8]","Right keys [1]: [i_item_sk#14]","Join condition: None","","(70) Project [codegen id : 25]","Output [3]: [d_date#10, i_item_sk#14, i_item_desc#15]","Input [4]: [ss_item_sk#8, d_date#10, i_item_sk#14, i_item_desc#15]","","(71) HashAggregate [codegen id : 25]","Input [3]: [d_date#10, i_item_sk#14, i_item_desc#15]","Keys [3]: [substr(i_item_desc#15, 1, 30) AS substr(i_item_desc#15, 1, 30)#47, i_item_sk#14, d_date#10]","Functions [1]: [partial_count(1)]","Aggregate Attributes [1]: [count#48]","Results [4]: [substr(i_item_desc#15, 1, 30)#47, i_item_sk#14, d_date#10, count#49]","","(72) HashAggregate [codegen id : 25]","Input [4]: [substr(i_item_desc#15, 1, 30)#47, i_item_sk#14, d_date#10, count#49]","Keys [3]: [substr(i_item_desc#15, 1, 30)#47, i_item_sk#14, d_date#10]","Functions [1]: [count(1)]","Aggregate Attributes [1]: [count(1)#50]","Results [2]: [i_item_sk#14 AS item_sk#21, count(1)#50 AS count(1)#51]","","(73) Filter [codegen id : 25]","Input [2]: [item_sk#21, count(1)#51]","Condition : (count(1)#51 > 4)","","(74) Project [codegen id : 25]","Output [1]: [item_sk#21]","Input [2]: [item_sk#21, count(1)#51]","","(75) Sort [codegen id : 25]","Input [1]: [item_sk#21]","Arguments: [item_sk#21 ASC NULLS FIRST], false, 0","","(76) SortMergeJoin","Left keys [1]: [ws_item_sk#42]","Right keys [1]: [item_sk#21]","Join condition: None","","(77) Project [codegen id : 26]","Output [4]: [ws_sold_date_sk#41, ws_bill_customer_sk#43, ws_quantity#44, ws_list_price#45]","Input [5]: [ws_sold_date_sk#41, ws_item_sk#42, ws_bill_customer_sk#43, ws_quantity#44, ws_list_price#45]","","(78) Exchange","Input [4]: [ws_sold_date_sk#41, ws_bill_customer_sk#43, ws_quantity#44, ws_list_price#45]","Arguments: hashpartitioning(ws_bill_customer_sk#43, 5), ENSURE_REQUIREMENTS, [id=#52]","","(79) Sort [codegen id : 27]","Input [4]: [ws_sold_date_sk#41, ws_bill_customer_sk#43, ws_quantity#44, ws_list_price#45]","Arguments: [ws_bill_customer_sk#43 ASC NULLS FIRST], false, 0","","(80) ReusedExchange [Reuses operator id: 37]","Output [3]: [ss_customer_sk#24, ss_quantity#25, ss_sales_price#26]","","(81) Sort [codegen id : 29]","Input [3]: [ss_customer_sk#24, ss_quantity#25, ss_sales_price#26]","Arguments: [ss_customer_sk#24 ASC NULLS FIRST], false, 0","","(82) ReusedExchange [Reuses operator id: 42]","Output [1]: [c_customer_sk#28]","","(83) Sort [codegen id : 31]","Input [1]: [c_customer_sk#28]","Arguments: [c_customer_sk#28 ASC NULLS FIRST], false, 0","","(84) SortMergeJoin [codegen id : 32]","Left keys [1]: [ss_customer_sk#24]","Right keys [1]: [c_customer_sk#28]","Join condition: None","","(85) Project [codegen id : 32]","Output [3]: [ss_quantity#25, ss_sales_price#26, c_customer_sk#28]","Input [4]: [ss_customer_sk#24, ss_quantity#25, ss_sales_price#26, c_customer_sk#28]","","(86) HashAggregate [codegen id : 32]","Input [3]: [ss_quantity#25, ss_sales_price#26, c_customer_sk#28]","Keys [1]: [c_customer_sk#28]","Functions [1]: [partial_sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))]","Aggregate Attributes [2]: [sum#53, isEmpty#54]","Results [3]: [c_customer_sk#28, sum#55, isEmpty#56]","","(87) HashAggregate [codegen id : 32]","Input [3]: [c_customer_sk#28, sum#55, isEmpty#56]","Keys [1]: [c_customer_sk#28]","Functions [1]: [sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))]","Aggregate Attributes [1]: [sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))#57]","Results [2]: [c_customer_sk#28, sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))#57 AS sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))#58]","","(88) Filter [codegen id : 32]","Input [2]: [c_customer_sk#28, sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))#58]","Condition : (isnotnull(sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))#58) AND (cast(sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))#58 as decimal(38,8)) > CheckOverflow((0.500000 * promote_precision(cast(ReusedSubquery Subquery scalar-subquery#36, [id=#37] as decimal(32,6)))), DecimalType(38,8), true)))","","(89) Project [codegen id : 32]","Output [1]: [c_customer_sk#28]","Input [2]: [c_customer_sk#28, sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))#58]","","(90) Sort [codegen id : 32]","Input [1]: [c_customer_sk#28]","Arguments: [c_customer_sk#28 ASC NULLS FIRST], false, 0","","(91) SortMergeJoin","Left keys [1]: [ws_bill_customer_sk#43]","Right keys [1]: [c_customer_sk#28]","Join condition: None","","(92) Project [codegen id : 34]","Output [3]: [ws_sold_date_sk#41, ws_quantity#44, ws_list_price#45]","Input [4]: [ws_sold_date_sk#41, ws_bill_customer_sk#43, ws_quantity#44, ws_list_price#45]","","(93) ReusedExchange [Reuses operator id: 57]","Output [1]: [d_date_sk#9]","","(94) BroadcastHashJoin [codegen id : 34]","Left keys [1]: [ws_sold_date_sk#41]","Right keys [1]: [d_date_sk#9]","Join condition: None","","(95) Project [codegen id : 34]","Output [1]: [CheckOverflow((promote_precision(cast(cast(ws_quantity#44 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ws_list_price#45 as decimal(12,2)))), DecimalType(18,2), true) AS sales#59]","Input [4]: [ws_sold_date_sk#41, ws_quantity#44, ws_list_price#45, d_date_sk#9]","","(96) Union","","(97) HashAggregate [codegen id : 35]","Input [1]: [sales#40]","Keys: []","Functions [1]: [partial_sum(sales#40)]","Aggregate Attributes [2]: [sum#60, isEmpty#61]","Results [2]: [sum#62, isEmpty#63]","","(98) Exchange","Input [2]: [sum#62, isEmpty#63]","Arguments: SinglePartition, ENSURE_REQUIREMENTS, [id=#64]","","(99) HashAggregate [codegen id : 36]","Input [2]: [sum#62, isEmpty#63]","Keys: []","Functions [1]: [sum(sales#40)]","Aggregate Attributes [1]: [sum(sales#40)#65]","Results [1]: [sum(sales#40)#65 AS sum(sales)#66]","","===== Subqueries =====","","Subquery:1 Hosting operator id = 48 Hosting Expression = Subquery scalar-subquery#36, [id=#37]","* HashAggregate (123)","+- Exchange (122)"," +- * HashAggregate (121)"," +- * HashAggregate (120)"," +- * HashAggregate (119)"," +- * Project (118)"," +- * SortMergeJoin Inner (117)"," :- * Sort (111)"," : +- Exchange (110)"," : +- * Project (109)"," : +- * BroadcastHashJoin Inner BuildRight (108)"," : :- * Filter (102)"," : : +- * ColumnarToRow (101)"," : : +- Scan parquet default.store_sales (100)"," : +- BroadcastExchange (107)"," : +- * Project (106)"," : +- * Filter (105)"," : +- * ColumnarToRow (104)"," : +- Scan parquet default.date_dim (103)"," +- * Sort (116)"," +- Exchange (115)"," +- * Filter (114)"," +- * ColumnarToRow (113)"," +- Scan parquet default.customer (112)","","","(100) Scan parquet default.store_sales","Output [4]: [ss_sold_date_sk#7, ss_customer_sk#24, ss_quantity#25, ss_sales_price#26]","Batched: true","Location [not included in comparison]/{warehouse_dir}/store_sales]","PushedFilters: [IsNotNull(ss_customer_sk), IsNotNull(ss_sold_date_sk)]","ReadSchema: struct","","(101) ColumnarToRow [codegen id : 2]","Input [4]: [ss_sold_date_sk#7, ss_customer_sk#24, ss_quantity#25, ss_sales_price#26]","","(102) Filter [codegen id : 2]","Input [4]: [ss_sold_date_sk#7, ss_customer_sk#24, ss_quantity#25, ss_sales_price#26]","Condition : (isnotnull(ss_customer_sk#24) AND isnotnull(ss_sold_date_sk#7))","","(103) Scan parquet default.date_dim","Output [2]: [d_date_sk#9, d_year#11]","Batched: true","Location [not included in comparison]/{warehouse_dir}/date_dim]","PushedFilters: [In(d_year, [2000,2001,2002,2003]), IsNotNull(d_date_sk)]","ReadSchema: struct","","(104) ColumnarToRow [codegen id : 1]","Input [2]: [d_date_sk#9, d_year#11]","","(105) Filter [codegen id : 1]","Input [2]: [d_date_sk#9, d_year#11]","Condition : (d_year#11 IN (2000,2001,2002,2003) AND isnotnull(d_date_sk#9))","","(106) Project [codegen id : 1]","Output [1]: [d_date_sk#9]","Input [2]: [d_date_sk#9, d_year#11]","","(107) BroadcastExchange","Input [1]: [d_date_sk#9]","Arguments: HashedRelationBroadcastMode(List(cast(input[0, int, true] as bigint)),false), [id=#67]","","(108) BroadcastHashJoin [codegen id : 2]","Left keys [1]: [ss_sold_date_sk#7]","Right keys [1]: [d_date_sk#9]","Join condition: None","","(109) Project [codegen id : 2]","Output [3]: [ss_customer_sk#24, ss_quantity#25, ss_sales_price#26]","Input [5]: [ss_sold_date_sk#7, ss_customer_sk#24, ss_quantity#25, ss_sales_price#26, d_date_sk#9]","","(110) Exchange","Input [3]: [ss_customer_sk#24, ss_quantity#25, ss_sales_price#26]","Arguments: hashpartitioning(ss_customer_sk#24, 5), ENSURE_REQUIREMENTS, [id=#68]","","(111) Sort [codegen id : 3]","Input [3]: [ss_customer_sk#24, ss_quantity#25, ss_sales_price#26]","Arguments: [ss_customer_sk#24 ASC NULLS FIRST], false, 0","","(112) Scan parquet default.customer","Output [1]: [c_customer_sk#28]","Batched: true","Location [not included in comparison]/{warehouse_dir}/customer]","PushedFilters: [IsNotNull(c_customer_sk)]","ReadSchema: struct","","(113) ColumnarToRow [codegen id : 4]","Input [1]: [c_customer_sk#28]","","(114) Filter [codegen id : 4]","Input [1]: [c_customer_sk#28]","Condition : isnotnull(c_customer_sk#28)","","(115) Exchange","Input [1]: [c_customer_sk#28]","Arguments: hashpartitioning(c_customer_sk#28, 5), ENSURE_REQUIREMENTS, [id=#69]","","(116) Sort [codegen id : 5]","Input [1]: [c_customer_sk#28]","Arguments: [c_customer_sk#28 ASC NULLS FIRST], false, 0","","(117) SortMergeJoin [codegen id : 6]","Left keys [1]: [ss_customer_sk#24]","Right keys [1]: [c_customer_sk#28]","Join condition: None","","(118) Project [codegen id : 6]","Output [3]: [ss_quantity#25, ss_sales_price#26, c_customer_sk#28]","Input [4]: [ss_customer_sk#24, ss_quantity#25, ss_sales_price#26, c_customer_sk#28]","","(119) HashAggregate [codegen id : 6]","Input [3]: [ss_quantity#25, ss_sales_price#26, c_customer_sk#28]","Keys [1]: [c_customer_sk#28]","Functions [1]: [partial_sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))]","Aggregate Attributes [2]: [sum#70, isEmpty#71]","Results [3]: [c_customer_sk#28, sum#72, isEmpty#73]","","(120) HashAggregate [codegen id : 6]","Input [3]: [c_customer_sk#28, sum#72, isEmpty#73]","Keys [1]: [c_customer_sk#28]","Functions [1]: [sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))]","Aggregate Attributes [1]: [sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))#74]","Results [1]: [sum(CheckOverflow((promote_precision(cast(cast(ss_quantity#25 as decimal(10,0)) as decimal(12,2))) * promote_precision(cast(ss_sales_price#26 as decimal(12,2)))), DecimalType(18,2), true))#74 AS csales#75]","","(121) HashAggregate [codegen id : 6]","Input [1]: [csales#75]","Keys: []","Functions [1]: [partial_max(csales#75)]","Aggregate Attributes [1]: [max#76]","Results [1]: [max#77]","","(122) Exchange","Input [1]: [max#77]","Arguments: SinglePartition, ENSURE_REQUIREMENTS, [id=#78]","","(123) HashAggregate [codegen id : 7]","Input [1]: [max#77]","Keys: []","Functions [1]: [max(csales#75)]","Aggregate Attributes [1]: [max(csales#75)#79]","Results [1]: [max(csales#75)#79 AS tpcds_cmax#80]","","Subquery:2 Hosting operator id = 88 Hosting Expression = ReusedSubquery Subquery scalar-subquery#36, [id=#37]"],"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-v1_4/q23a.sf100/explain.txt?raw=true","headerInfo":{"blobSize":"31.1 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":"4859866","siteNavLoginPath":"/login?return_to=https%3A%2F%2Fgithub.com%2Fapache%2Fspark%2Fblob%2Fa235c3b2544aead2b1e3034aacfd361d49ad79b1%2Fsql%2Fcore%2Fsrc%2Ftest%2Fresources%2Ftpcds-plan-stability%2Fapproved-plans-v1_4%2Fq23a.sf100%2Fexplain.txt","isCSV":false,"isRichtext":false,"toc":null,"lineInfo":{"truncatedLoc":"696","truncatedSloc":"566"},"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-v1_4/q23a.sf100/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-v1_4/q23a.sf100/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":"TwydG2QHztJ87RdnmniM9yCNAO3GeuksOL-BhQ9WbWQ0ZRMVYXNnF7xCV_ew5PtTJNixf2BA8b9vfkNHw1srcA"},"/repos/preferences":{"post":"Qv7PEjzseBHnvRcqNTuyL7Vm-OHK7MsPL4q4qrzQxL8R-2l6chYrrReDUQRYNXXT3B6cog6Q9iH8Myj3kOw41w"}}},"title":"spark/sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q23a.sf100/explain.txt at a235c3b2544aead2b1e3034aacfd361d49ad79b1 ยท apache/spark"}