{"payload":{"allShortcutsEnabled":false,"fileTree":{"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q78":{"items":[{"name":"explain.txt","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q78/explain.txt","contentType":"file"},{"name":"simplified.txt","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q78/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":60.163949,"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/q78/explain.txt","currentUser":null,"blob":{"rawLines":["== Physical Plan ==","TakeOrderedAndProject (60)","+- * Project (59)"," +- * BroadcastHashJoin Inner BuildRight (58)"," :- * Project (39)"," : +- * BroadcastHashJoin Inner BuildRight (38)"," : :- * HashAggregate (19)"," : : +- Exchange (18)"," : : +- * HashAggregate (17)"," : : +- * Project (16)"," : : +- * BroadcastHashJoin Inner BuildRight (15)"," : : :- * Project (10)"," : : : +- * Filter (9)"," : : : +- * BroadcastHashJoin LeftOuter BuildRight (8)"," : : : :- * Filter (3)"," : : : : +- * ColumnarToRow (2)"," : : : : +- Scan parquet default.store_sales (1)"," : : : +- BroadcastExchange (7)"," : : : +- * Filter (6)"," : : : +- * ColumnarToRow (5)"," : : : +- Scan parquet default.store_returns (4)"," : : +- BroadcastExchange (14)"," : : +- * Filter (13)"," : : +- * ColumnarToRow (12)"," : : +- Scan parquet default.date_dim (11)"," : +- BroadcastExchange (37)"," : +- * Filter (36)"," : +- * HashAggregate (35)"," : +- Exchange (34)"," : +- * HashAggregate (33)"," : +- * Project (32)"," : +- * BroadcastHashJoin Inner BuildRight (31)"," : :- * Project (29)"," : : +- * Filter (28)"," : : +- * BroadcastHashJoin LeftOuter BuildRight (27)"," : : :- * Filter (22)"," : : : +- * ColumnarToRow (21)"," : : : +- Scan parquet default.web_sales (20)"," : : +- BroadcastExchange (26)"," : : +- * Filter (25)"," : : +- * ColumnarToRow (24)"," : : +- Scan parquet default.web_returns (23)"," : +- ReusedExchange (30)"," +- BroadcastExchange (57)"," +- * Filter (56)"," +- * HashAggregate (55)"," +- Exchange (54)"," +- * HashAggregate (53)"," +- * Project (52)"," +- * BroadcastHashJoin Inner BuildRight (51)"," :- * Project (49)"," : +- * Filter (48)"," : +- * BroadcastHashJoin LeftOuter BuildRight (47)"," : :- * Filter (42)"," : : +- * ColumnarToRow (41)"," : : +- Scan parquet default.catalog_sales (40)"," : +- BroadcastExchange (46)"," : +- * Filter (45)"," : +- * ColumnarToRow (44)"," : +- Scan parquet default.catalog_returns (43)"," +- ReusedExchange (50)","","","(1) Scan parquet default.store_sales","Output [7]: [ss_sold_date_sk#1, ss_item_sk#2, ss_customer_sk#3, ss_ticket_number#4, ss_quantity#5, ss_wholesale_cost#6, ss_sales_price#7]","Batched: true","Location [not included in comparison]/{warehouse_dir}/store_sales]","PushedFilters: [IsNotNull(ss_sold_date_sk), IsNotNull(ss_item_sk), IsNotNull(ss_customer_sk)]","ReadSchema: struct","","(2) ColumnarToRow [codegen id : 3]","Input [7]: [ss_sold_date_sk#1, ss_item_sk#2, ss_customer_sk#3, ss_ticket_number#4, ss_quantity#5, ss_wholesale_cost#6, ss_sales_price#7]","","(3) Filter [codegen id : 3]","Input [7]: [ss_sold_date_sk#1, ss_item_sk#2, ss_customer_sk#3, ss_ticket_number#4, ss_quantity#5, ss_wholesale_cost#6, ss_sales_price#7]","Condition : ((isnotnull(ss_sold_date_sk#1) AND isnotnull(ss_item_sk#2)) AND isnotnull(ss_customer_sk#3))","","(4) Scan parquet default.store_returns","Output [2]: [sr_item_sk#8, sr_ticket_number#9]","Batched: true","Location [not included in comparison]/{warehouse_dir}/store_returns]","PushedFilters: [IsNotNull(sr_ticket_number), IsNotNull(sr_item_sk)]","ReadSchema: struct","","(5) ColumnarToRow [codegen id : 1]","Input [2]: [sr_item_sk#8, sr_ticket_number#9]","","(6) Filter [codegen id : 1]","Input [2]: [sr_item_sk#8, sr_ticket_number#9]","Condition : (isnotnull(sr_ticket_number#9) AND isnotnull(sr_item_sk#8))","","(7) BroadcastExchange","Input [2]: [sr_item_sk#8, sr_ticket_number#9]","Arguments: HashedRelationBroadcastMode(List(input[1, bigint, false], input[0, bigint, false]),false), [id=#10]","","(8) BroadcastHashJoin [codegen id : 3]","Left keys [2]: [cast(ss_ticket_number#4 as bigint), cast(ss_item_sk#2 as bigint)]","Right keys [2]: [sr_ticket_number#9, sr_item_sk#8]","Join condition: None","","(9) Filter [codegen id : 3]","Input [9]: [ss_sold_date_sk#1, ss_item_sk#2, ss_customer_sk#3, ss_ticket_number#4, ss_quantity#5, ss_wholesale_cost#6, ss_sales_price#7, sr_item_sk#8, sr_ticket_number#9]","Condition : isnull(sr_ticket_number#9)","","(10) Project [codegen id : 3]","Output [6]: [ss_sold_date_sk#1, ss_item_sk#2, ss_customer_sk#3, ss_quantity#5, ss_wholesale_cost#6, ss_sales_price#7]","Input [9]: [ss_sold_date_sk#1, ss_item_sk#2, ss_customer_sk#3, ss_ticket_number#4, ss_quantity#5, ss_wholesale_cost#6, ss_sales_price#7, sr_item_sk#8, sr_ticket_number#9]","","(11) Scan parquet default.date_dim","Output [2]: [d_date_sk#11, d_year#12]","Batched: true","Location [not included in comparison]/{warehouse_dir}/date_dim]","PushedFilters: [IsNotNull(d_year), EqualTo(d_year,2000), IsNotNull(d_date_sk)]","ReadSchema: struct","","(12) ColumnarToRow [codegen id : 2]","Input [2]: [d_date_sk#11, d_year#12]","","(13) Filter [codegen id : 2]","Input [2]: [d_date_sk#11, d_year#12]","Condition : ((isnotnull(d_year#12) AND (d_year#12 = 2000)) AND isnotnull(d_date_sk#11))","","(14) BroadcastExchange","Input [2]: [d_date_sk#11, d_year#12]","Arguments: HashedRelationBroadcastMode(List(cast(input[0, int, false] 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_item_sk#2, ss_customer_sk#3, ss_quantity#5, ss_wholesale_cost#6, ss_sales_price#7, d_year#12]","Input [8]: [ss_sold_date_sk#1, ss_item_sk#2, ss_customer_sk#3, ss_quantity#5, ss_wholesale_cost#6, ss_sales_price#7, d_date_sk#11, d_year#12]","","(17) HashAggregate [codegen id : 3]","Input [6]: [ss_item_sk#2, ss_customer_sk#3, ss_quantity#5, ss_wholesale_cost#6, ss_sales_price#7, d_year#12]","Keys [3]: [d_year#12, ss_item_sk#2, ss_customer_sk#3]","Functions [3]: [partial_sum(ss_quantity#5), partial_sum(UnscaledValue(ss_wholesale_cost#6)), partial_sum(UnscaledValue(ss_sales_price#7))]","Aggregate Attributes [3]: [sum#14, sum#15, sum#16]","Results [6]: [d_year#12, ss_item_sk#2, ss_customer_sk#3, sum#17, sum#18, sum#19]","","(18) Exchange","Input [6]: [d_year#12, ss_item_sk#2, ss_customer_sk#3, sum#17, sum#18, sum#19]","Arguments: hashpartitioning(d_year#12, ss_item_sk#2, ss_customer_sk#3, 5), ENSURE_REQUIREMENTS, [id=#20]","","(19) HashAggregate [codegen id : 12]","Input [6]: [d_year#12, ss_item_sk#2, ss_customer_sk#3, sum#17, sum#18, sum#19]","Keys [3]: [d_year#12, ss_item_sk#2, ss_customer_sk#3]","Functions [3]: [sum(ss_quantity#5), sum(UnscaledValue(ss_wholesale_cost#6)), sum(UnscaledValue(ss_sales_price#7))]","Aggregate Attributes [3]: [sum(ss_quantity#5)#21, sum(UnscaledValue(ss_wholesale_cost#6))#22, sum(UnscaledValue(ss_sales_price#7))#23]","Results [6]: [d_year#12 AS ss_sold_year#24, ss_item_sk#2, ss_customer_sk#3, sum(ss_quantity#5)#21 AS ss_qty#25, MakeDecimal(sum(UnscaledValue(ss_wholesale_cost#6))#22,17,2) AS ss_wc#26, MakeDecimal(sum(UnscaledValue(ss_sales_price#7))#23,17,2) AS ss_sp#27]","","(20) Scan parquet default.web_sales","Output [7]: [ws_sold_date_sk#28, ws_item_sk#29, ws_bill_customer_sk#30, ws_order_number#31, ws_quantity#32, ws_wholesale_cost#33, ws_sales_price#34]","Batched: true","Location [not included in comparison]/{warehouse_dir}/web_sales]","PushedFilters: [IsNotNull(ws_sold_date_sk), IsNotNull(ws_item_sk), IsNotNull(ws_bill_customer_sk)]","ReadSchema: struct","","(21) ColumnarToRow [codegen id : 6]","Input [7]: [ws_sold_date_sk#28, ws_item_sk#29, ws_bill_customer_sk#30, ws_order_number#31, ws_quantity#32, ws_wholesale_cost#33, ws_sales_price#34]","","(22) Filter [codegen id : 6]","Input [7]: [ws_sold_date_sk#28, ws_item_sk#29, ws_bill_customer_sk#30, ws_order_number#31, ws_quantity#32, ws_wholesale_cost#33, ws_sales_price#34]","Condition : ((isnotnull(ws_sold_date_sk#28) AND isnotnull(ws_item_sk#29)) AND isnotnull(ws_bill_customer_sk#30))","","(23) Scan parquet default.web_returns","Output [2]: [wr_item_sk#35, wr_order_number#36]","Batched: true","Location [not included in comparison]/{warehouse_dir}/web_returns]","PushedFilters: [IsNotNull(wr_order_number), IsNotNull(wr_item_sk)]","ReadSchema: struct","","(24) ColumnarToRow [codegen id : 4]","Input [2]: [wr_item_sk#35, wr_order_number#36]","","(25) Filter [codegen id : 4]","Input [2]: [wr_item_sk#35, wr_order_number#36]","Condition : (isnotnull(wr_order_number#36) AND isnotnull(wr_item_sk#35))","","(26) BroadcastExchange","Input [2]: [wr_item_sk#35, wr_order_number#36]","Arguments: HashedRelationBroadcastMode(List(input[1, bigint, false], input[0, bigint, false]),false), [id=#37]","","(27) BroadcastHashJoin [codegen id : 6]","Left keys [2]: [cast(ws_order_number#31 as bigint), cast(ws_item_sk#29 as bigint)]","Right keys [2]: [wr_order_number#36, wr_item_sk#35]","Join condition: None","","(28) Filter [codegen id : 6]","Input [9]: [ws_sold_date_sk#28, ws_item_sk#29, ws_bill_customer_sk#30, ws_order_number#31, ws_quantity#32, ws_wholesale_cost#33, ws_sales_price#34, wr_item_sk#35, wr_order_number#36]","Condition : isnull(wr_order_number#36)","","(29) Project [codegen id : 6]","Output [6]: [ws_sold_date_sk#28, ws_item_sk#29, ws_bill_customer_sk#30, ws_quantity#32, ws_wholesale_cost#33, ws_sales_price#34]","Input [9]: [ws_sold_date_sk#28, ws_item_sk#29, ws_bill_customer_sk#30, ws_order_number#31, ws_quantity#32, ws_wholesale_cost#33, ws_sales_price#34, wr_item_sk#35, wr_order_number#36]","","(30) ReusedExchange [Reuses operator id: 14]","Output [2]: [d_date_sk#11, d_year#12]","","(31) BroadcastHashJoin [codegen id : 6]","Left keys [1]: [ws_sold_date_sk#28]","Right keys [1]: [d_date_sk#11]","Join condition: None","","(32) Project [codegen id : 6]","Output [6]: [ws_item_sk#29, ws_bill_customer_sk#30, ws_quantity#32, ws_wholesale_cost#33, ws_sales_price#34, d_year#12]","Input [8]: [ws_sold_date_sk#28, ws_item_sk#29, ws_bill_customer_sk#30, ws_quantity#32, ws_wholesale_cost#33, ws_sales_price#34, d_date_sk#11, d_year#12]","","(33) HashAggregate [codegen id : 6]","Input [6]: [ws_item_sk#29, ws_bill_customer_sk#30, ws_quantity#32, ws_wholesale_cost#33, ws_sales_price#34, d_year#12]","Keys [3]: [d_year#12, ws_item_sk#29, ws_bill_customer_sk#30]","Functions [3]: [partial_sum(ws_quantity#32), partial_sum(UnscaledValue(ws_wholesale_cost#33)), partial_sum(UnscaledValue(ws_sales_price#34))]","Aggregate Attributes [3]: [sum#38, sum#39, sum#40]","Results [6]: [d_year#12, ws_item_sk#29, ws_bill_customer_sk#30, sum#41, sum#42, sum#43]","","(34) Exchange","Input [6]: [d_year#12, ws_item_sk#29, ws_bill_customer_sk#30, sum#41, sum#42, sum#43]","Arguments: hashpartitioning(d_year#12, ws_item_sk#29, ws_bill_customer_sk#30, 5), ENSURE_REQUIREMENTS, [id=#44]","","(35) HashAggregate [codegen id : 7]","Input [6]: [d_year#12, ws_item_sk#29, ws_bill_customer_sk#30, sum#41, sum#42, sum#43]","Keys [3]: [d_year#12, ws_item_sk#29, ws_bill_customer_sk#30]","Functions [3]: [sum(ws_quantity#32), sum(UnscaledValue(ws_wholesale_cost#33)), sum(UnscaledValue(ws_sales_price#34))]","Aggregate Attributes [3]: [sum(ws_quantity#32)#45, sum(UnscaledValue(ws_wholesale_cost#33))#46, sum(UnscaledValue(ws_sales_price#34))#47]","Results [6]: [d_year#12 AS ws_sold_year#48, ws_item_sk#29, ws_bill_customer_sk#30 AS ws_customer_sk#49, sum(ws_quantity#32)#45 AS ws_qty#50, MakeDecimal(sum(UnscaledValue(ws_wholesale_cost#33))#46,17,2) AS ws_wc#51, MakeDecimal(sum(UnscaledValue(ws_sales_price#34))#47,17,2) AS ws_sp#52]","","(36) Filter [codegen id : 7]","Input [6]: [ws_sold_year#48, ws_item_sk#29, ws_customer_sk#49, ws_qty#50, ws_wc#51, ws_sp#52]","Condition : (coalesce(ws_qty#50, 0) > 0)","","(37) BroadcastExchange","Input [6]: [ws_sold_year#48, ws_item_sk#29, ws_customer_sk#49, ws_qty#50, ws_wc#51, ws_sp#52]","Arguments: HashedRelationBroadcastMode(List(input[0, int, true], input[1, int, true], input[2, int, true]),false), [id=#53]","","(38) BroadcastHashJoin [codegen id : 12]","Left keys [3]: [ss_sold_year#24, ss_item_sk#2, ss_customer_sk#3]","Right keys [3]: [ws_sold_year#48, ws_item_sk#29, ws_customer_sk#49]","Join condition: None","","(39) Project [codegen id : 12]","Output [9]: [ss_sold_year#24, ss_item_sk#2, ss_customer_sk#3, ss_qty#25, ss_wc#26, ss_sp#27, ws_qty#50, ws_wc#51, ws_sp#52]","Input [12]: [ss_sold_year#24, ss_item_sk#2, ss_customer_sk#3, ss_qty#25, ss_wc#26, ss_sp#27, ws_sold_year#48, ws_item_sk#29, ws_customer_sk#49, ws_qty#50, ws_wc#51, ws_sp#52]","","(40) Scan parquet default.catalog_sales","Output [7]: [cs_sold_date_sk#54, cs_bill_customer_sk#55, cs_item_sk#56, cs_order_number#57, cs_quantity#58, cs_wholesale_cost#59, cs_sales_price#60]","Batched: true","Location [not included in comparison]/{warehouse_dir}/catalog_sales]","PushedFilters: [IsNotNull(cs_sold_date_sk), IsNotNull(cs_item_sk), IsNotNull(cs_bill_customer_sk)]","ReadSchema: struct","","(41) ColumnarToRow [codegen id : 10]","Input [7]: [cs_sold_date_sk#54, cs_bill_customer_sk#55, cs_item_sk#56, cs_order_number#57, cs_quantity#58, cs_wholesale_cost#59, cs_sales_price#60]","","(42) Filter [codegen id : 10]","Input [7]: [cs_sold_date_sk#54, cs_bill_customer_sk#55, cs_item_sk#56, cs_order_number#57, cs_quantity#58, cs_wholesale_cost#59, cs_sales_price#60]","Condition : ((isnotnull(cs_sold_date_sk#54) AND isnotnull(cs_item_sk#56)) AND isnotnull(cs_bill_customer_sk#55))","","(43) Scan parquet default.catalog_returns","Output [2]: [cr_item_sk#61, cr_order_number#62]","Batched: true","Location [not included in comparison]/{warehouse_dir}/catalog_returns]","PushedFilters: [IsNotNull(cr_order_number), IsNotNull(cr_item_sk)]","ReadSchema: struct","","(44) ColumnarToRow [codegen id : 8]","Input [2]: [cr_item_sk#61, cr_order_number#62]","","(45) Filter [codegen id : 8]","Input [2]: [cr_item_sk#61, cr_order_number#62]","Condition : (isnotnull(cr_order_number#62) AND isnotnull(cr_item_sk#61))","","(46) BroadcastExchange","Input [2]: [cr_item_sk#61, cr_order_number#62]","Arguments: HashedRelationBroadcastMode(List((shiftleft(cast(input[1, int, false] as bigint), 32) | (cast(input[0, int, false] as bigint) & 4294967295))),false), [id=#63]","","(47) BroadcastHashJoin [codegen id : 10]","Left keys [2]: [cs_order_number#57, cs_item_sk#56]","Right keys [2]: [cr_order_number#62, cr_item_sk#61]","Join condition: None","","(48) Filter [codegen id : 10]","Input [9]: [cs_sold_date_sk#54, cs_bill_customer_sk#55, cs_item_sk#56, cs_order_number#57, cs_quantity#58, cs_wholesale_cost#59, cs_sales_price#60, cr_item_sk#61, cr_order_number#62]","Condition : isnull(cr_order_number#62)","","(49) Project [codegen id : 10]","Output [6]: [cs_sold_date_sk#54, cs_bill_customer_sk#55, cs_item_sk#56, cs_quantity#58, cs_wholesale_cost#59, cs_sales_price#60]","Input [9]: [cs_sold_date_sk#54, cs_bill_customer_sk#55, cs_item_sk#56, cs_order_number#57, cs_quantity#58, cs_wholesale_cost#59, cs_sales_price#60, cr_item_sk#61, cr_order_number#62]","","(50) ReusedExchange [Reuses operator id: 14]","Output [2]: [d_date_sk#11, d_year#12]","","(51) BroadcastHashJoin [codegen id : 10]","Left keys [1]: [cs_sold_date_sk#54]","Right keys [1]: [d_date_sk#11]","Join condition: None","","(52) Project [codegen id : 10]","Output [6]: [cs_bill_customer_sk#55, cs_item_sk#56, cs_quantity#58, cs_wholesale_cost#59, cs_sales_price#60, d_year#12]","Input [8]: [cs_sold_date_sk#54, cs_bill_customer_sk#55, cs_item_sk#56, cs_quantity#58, cs_wholesale_cost#59, cs_sales_price#60, d_date_sk#11, d_year#12]","","(53) HashAggregate [codegen id : 10]","Input [6]: [cs_bill_customer_sk#55, cs_item_sk#56, cs_quantity#58, cs_wholesale_cost#59, cs_sales_price#60, d_year#12]","Keys [3]: [d_year#12, cs_item_sk#56, cs_bill_customer_sk#55]","Functions [3]: [partial_sum(cs_quantity#58), partial_sum(UnscaledValue(cs_wholesale_cost#59)), partial_sum(UnscaledValue(cs_sales_price#60))]","Aggregate Attributes [3]: [sum#64, sum#65, sum#66]","Results [6]: [d_year#12, cs_item_sk#56, cs_bill_customer_sk#55, sum#67, sum#68, sum#69]","","(54) Exchange","Input [6]: [d_year#12, cs_item_sk#56, cs_bill_customer_sk#55, sum#67, sum#68, sum#69]","Arguments: hashpartitioning(d_year#12, cs_item_sk#56, cs_bill_customer_sk#55, 5), ENSURE_REQUIREMENTS, [id=#70]","","(55) HashAggregate [codegen id : 11]","Input [6]: [d_year#12, cs_item_sk#56, cs_bill_customer_sk#55, sum#67, sum#68, sum#69]","Keys [3]: [d_year#12, cs_item_sk#56, cs_bill_customer_sk#55]","Functions [3]: [sum(cs_quantity#58), sum(UnscaledValue(cs_wholesale_cost#59)), sum(UnscaledValue(cs_sales_price#60))]","Aggregate Attributes [3]: [sum(cs_quantity#58)#71, sum(UnscaledValue(cs_wholesale_cost#59))#72, sum(UnscaledValue(cs_sales_price#60))#73]","Results [6]: [d_year#12 AS cs_sold_year#74, cs_item_sk#56, cs_bill_customer_sk#55 AS cs_customer_sk#75, sum(cs_quantity#58)#71 AS cs_qty#76, MakeDecimal(sum(UnscaledValue(cs_wholesale_cost#59))#72,17,2) AS cs_wc#77, MakeDecimal(sum(UnscaledValue(cs_sales_price#60))#73,17,2) AS cs_sp#78]","","(56) Filter [codegen id : 11]","Input [6]: [cs_sold_year#74, cs_item_sk#56, cs_customer_sk#75, cs_qty#76, cs_wc#77, cs_sp#78]","Condition : (coalesce(cs_qty#76, 0) > 0)","","(57) BroadcastExchange","Input [6]: [cs_sold_year#74, cs_item_sk#56, cs_customer_sk#75, cs_qty#76, cs_wc#77, cs_sp#78]","Arguments: HashedRelationBroadcastMode(List(input[0, int, true], input[1, int, true], input[2, int, true]),false), [id=#79]","","(58) BroadcastHashJoin [codegen id : 12]","Left keys [3]: [ss_sold_year#24, ss_item_sk#2, ss_customer_sk#3]","Right keys [3]: [cs_sold_year#74, cs_item_sk#56, cs_customer_sk#75]","Join condition: None","","(59) Project [codegen id : 12]","Output [12]: [round((cast(ss_qty#25 as double) / cast(coalesce((ws_qty#50 + cs_qty#76), 1) as double)), 2) AS ratio#80, ss_qty#25 AS store_qty#81, ss_wc#26 AS store_wholesale_cost#82, ss_sp#27 AS store_sales_price#83, (coalesce(ws_qty#50, 0) + coalesce(cs_qty#76, 0)) AS other_chan_qty#84, CheckOverflow((promote_precision(cast(coalesce(ws_wc#51, 0.00) as decimal(18,2))) + promote_precision(cast(coalesce(cs_wc#77, 0.00) as decimal(18,2)))), DecimalType(18,2), true) AS other_chan_wholesale_cost#85, CheckOverflow((promote_precision(cast(coalesce(ws_sp#52, 0.00) as decimal(18,2))) + promote_precision(cast(coalesce(cs_sp#78, 0.00) as decimal(18,2)))), DecimalType(18,2), true) AS other_chan_sales_price#86, ss_qty#25, ss_wc#26, ss_sp#27, ws_qty#50, cs_qty#76]","Input [15]: [ss_sold_year#24, ss_item_sk#2, ss_customer_sk#3, ss_qty#25, ss_wc#26, ss_sp#27, ws_qty#50, ws_wc#51, ws_sp#52, cs_sold_year#74, cs_item_sk#56, cs_customer_sk#75, cs_qty#76, cs_wc#77, cs_sp#78]","","(60) TakeOrderedAndProject","Input [12]: [ratio#80, store_qty#81, store_wholesale_cost#82, store_sales_price#83, other_chan_qty#84, other_chan_wholesale_cost#85, other_chan_sales_price#86, ss_qty#25, ss_wc#26, ss_sp#27, ws_qty#50, cs_qty#76]","Arguments: 100, [ratio#80 ASC NULLS FIRST, ss_qty#25 DESC NULLS LAST, ss_wc#26 DESC NULLS LAST, ss_sp#27 DESC NULLS LAST, other_chan_qty#84 ASC NULLS FIRST, other_chan_wholesale_cost#85 ASC NULLS FIRST, other_chan_sales_price#86 ASC NULLS FIRST, round((cast(ss_qty#25 as double) / cast(coalesce((ws_qty#50 + cs_qty#76), 1) as double)), 2) ASC NULLS FIRST], [ratio#80, store_qty#81, store_wholesale_cost#82, store_sales_price#83, other_chan_qty#84, other_chan_wholesale_cost#85, other_chan_sales_price#86]"],"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/q78/explain.txt?raw=true","headerInfo":{"blobSize":"20 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":"c3034d8","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%2Fq78%2Fexplain.txt","isCSV":false,"isRichtext":false,"toc":null,"lineInfo":{"truncatedLoc":"341","truncatedSloc":"279"},"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/q78/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/q78/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":"OameC8-kRy4QmNlzaBYB8h_XHDdG52Cg6SXUf1qEQ__EHOAds_NvfNk2qora2JOGfpPifEyUJAokIAAMKpnTEg"},"/repos/preferences":{"post":"qkhDKxy5pEbsoUB7kWm_0TsNXuG59sVSRyUoADJd_5aqJJn66Y-Dowg6o1Nush1JXF-FNybKevuxEGi0XX4grA"}}},"title":"spark/sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q78/explain.txt at a235c3b2544aead2b1e3034aacfd361d49ad79b1 ยท apache/spark"}