{"payload":{"allShortcutsEnabled":false,"fileTree":{"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q16.sf100":{"items":[{"name":"explain.txt","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q16.sf100/explain.txt","contentType":"file"},{"name":"simplified.txt","path":"sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q16.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":87.944905,"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/q16.sf100/explain.txt","currentUser":null,"blob":{"rawLines":["== Physical Plan ==","* Sort (44)","+- * HashAggregate (43)"," +- Exchange (42)"," +- * HashAggregate (41)"," +- * HashAggregate (40)"," +- * HashAggregate (39)"," +- * Project (38)"," +- * BroadcastHashJoin Inner BuildRight (37)"," :- * Project (31)"," : +- * BroadcastHashJoin Inner BuildRight (30)"," : :- * Project (24)"," : : +- * BroadcastHashJoin Inner BuildRight (23)"," : : :- SortMergeJoin LeftAnti (17)"," : : : :- * Project (12)"," : : : : +- SortMergeJoin LeftSemi (11)"," : : : : :- * Sort (5)"," : : : : : +- Exchange (4)"," : : : : : +- * Filter (3)"," : : : : : +- * ColumnarToRow (2)"," : : : : : +- Scan parquet default.catalog_sales (1)"," : : : : +- * Sort (10)"," : : : : +- Exchange (9)"," : : : : +- * Project (8)"," : : : : +- * ColumnarToRow (7)"," : : : : +- Scan parquet default.catalog_sales (6)"," : : : +- * Sort (16)"," : : : +- Exchange (15)"," : : : +- * ColumnarToRow (14)"," : : : +- Scan parquet default.catalog_returns (13)"," : : +- BroadcastExchange (22)"," : : +- * Project (21)"," : : +- * Filter (20)"," : : +- * ColumnarToRow (19)"," : : +- Scan parquet default.customer_address (18)"," : +- BroadcastExchange (29)"," : +- * Project (28)"," : +- * Filter (27)"," : +- * ColumnarToRow (26)"," : +- Scan parquet default.call_center (25)"," +- BroadcastExchange (36)"," +- * Project (35)"," +- * Filter (34)"," +- * ColumnarToRow (33)"," +- Scan parquet default.date_dim (32)","","","(1) Scan parquet default.catalog_sales","Output [7]: [cs_ship_date_sk#1, cs_ship_addr_sk#2, cs_call_center_sk#3, cs_warehouse_sk#4, cs_order_number#5, cs_ext_ship_cost#6, cs_net_profit#7]","Batched: true","Location [not included in comparison]/{warehouse_dir}/catalog_sales]","PushedFilters: [IsNotNull(cs_ship_date_sk), IsNotNull(cs_ship_addr_sk), IsNotNull(cs_call_center_sk)]","ReadSchema: struct","","(2) ColumnarToRow [codegen id : 1]","Input [7]: [cs_ship_date_sk#1, cs_ship_addr_sk#2, cs_call_center_sk#3, cs_warehouse_sk#4, cs_order_number#5, cs_ext_ship_cost#6, cs_net_profit#7]","","(3) Filter [codegen id : 1]","Input [7]: [cs_ship_date_sk#1, cs_ship_addr_sk#2, cs_call_center_sk#3, cs_warehouse_sk#4, cs_order_number#5, cs_ext_ship_cost#6, cs_net_profit#7]","Condition : ((isnotnull(cs_ship_date_sk#1) AND isnotnull(cs_ship_addr_sk#2)) AND isnotnull(cs_call_center_sk#3))","","(4) Exchange","Input [7]: [cs_ship_date_sk#1, cs_ship_addr_sk#2, cs_call_center_sk#3, cs_warehouse_sk#4, cs_order_number#5, cs_ext_ship_cost#6, cs_net_profit#7]","Arguments: hashpartitioning(cs_order_number#5, 5), ENSURE_REQUIREMENTS, [id=#8]","","(5) Sort [codegen id : 2]","Input [7]: [cs_ship_date_sk#1, cs_ship_addr_sk#2, cs_call_center_sk#3, cs_warehouse_sk#4, cs_order_number#5, cs_ext_ship_cost#6, cs_net_profit#7]","Arguments: [cs_order_number#5 ASC NULLS FIRST], false, 0","","(6) Scan parquet default.catalog_sales","Output [2]: [cs_warehouse_sk#4, cs_order_number#5]","Batched: true","Location [not included in comparison]/{warehouse_dir}/catalog_sales]","ReadSchema: struct","","(7) ColumnarToRow [codegen id : 3]","Input [2]: [cs_warehouse_sk#4, cs_order_number#5]","","(8) Project [codegen id : 3]","Output [2]: [cs_warehouse_sk#4 AS cs_warehouse_sk#4#9, cs_order_number#5 AS cs_order_number#5#10]","Input [2]: [cs_warehouse_sk#4, cs_order_number#5]","","(9) Exchange","Input [2]: [cs_warehouse_sk#4#9, cs_order_number#5#10]","Arguments: hashpartitioning(cs_order_number#5#10, 5), ENSURE_REQUIREMENTS, [id=#11]","","(10) Sort [codegen id : 4]","Input [2]: [cs_warehouse_sk#4#9, cs_order_number#5#10]","Arguments: [cs_order_number#5#10 ASC NULLS FIRST], false, 0","","(11) SortMergeJoin","Left keys [1]: [cs_order_number#5]","Right keys [1]: [cs_order_number#5#10]","Join condition: NOT (cs_warehouse_sk#4 = cs_warehouse_sk#4#9)","","(12) Project [codegen id : 5]","Output [6]: [cs_ship_date_sk#1, cs_ship_addr_sk#2, cs_call_center_sk#3, cs_order_number#5, cs_ext_ship_cost#6, cs_net_profit#7]","Input [7]: [cs_ship_date_sk#1, cs_ship_addr_sk#2, cs_call_center_sk#3, cs_warehouse_sk#4, cs_order_number#5, cs_ext_ship_cost#6, cs_net_profit#7]","","(13) Scan parquet default.catalog_returns","Output [1]: [cr_order_number#12]","Batched: true","Location [not included in comparison]/{warehouse_dir}/catalog_returns]","ReadSchema: struct","","(14) ColumnarToRow [codegen id : 6]","Input [1]: [cr_order_number#12]","","(15) Exchange","Input [1]: [cr_order_number#12]","Arguments: hashpartitioning(cr_order_number#12, 5), ENSURE_REQUIREMENTS, [id=#13]","","(16) Sort [codegen id : 7]","Input [1]: [cr_order_number#12]","Arguments: [cr_order_number#12 ASC NULLS FIRST], false, 0","","(17) SortMergeJoin","Left keys [1]: [cs_order_number#5]","Right keys [1]: [cr_order_number#12]","Join condition: None","","(18) Scan parquet default.customer_address","Output [2]: [ca_address_sk#14, ca_state#15]","Batched: true","Location [not included in comparison]/{warehouse_dir}/customer_address]","PushedFilters: [IsNotNull(ca_state), EqualTo(ca_state,GA), IsNotNull(ca_address_sk)]","ReadSchema: struct","","(19) ColumnarToRow [codegen id : 8]","Input [2]: [ca_address_sk#14, ca_state#15]","","(20) Filter [codegen id : 8]","Input [2]: [ca_address_sk#14, ca_state#15]","Condition : ((isnotnull(ca_state#15) AND (ca_state#15 = GA)) AND isnotnull(ca_address_sk#14))","","(21) Project [codegen id : 8]","Output [1]: [ca_address_sk#14]","Input [2]: [ca_address_sk#14, ca_state#15]","","(22) BroadcastExchange","Input [1]: [ca_address_sk#14]","Arguments: HashedRelationBroadcastMode(List(cast(input[0, int, true] as bigint)),false), [id=#16]","","(23) BroadcastHashJoin [codegen id : 11]","Left keys [1]: [cs_ship_addr_sk#2]","Right keys [1]: [ca_address_sk#14]","Join condition: None","","(24) Project [codegen id : 11]","Output [5]: [cs_ship_date_sk#1, cs_call_center_sk#3, cs_order_number#5, cs_ext_ship_cost#6, cs_net_profit#7]","Input [7]: [cs_ship_date_sk#1, cs_ship_addr_sk#2, cs_call_center_sk#3, cs_order_number#5, cs_ext_ship_cost#6, cs_net_profit#7, ca_address_sk#14]","","(25) Scan parquet default.call_center","Output [2]: [cc_call_center_sk#17, cc_county#18]","Batched: true","Location [not included in comparison]/{warehouse_dir}/call_center]","PushedFilters: [IsNotNull(cc_county), EqualTo(cc_county,Williamson County), IsNotNull(cc_call_center_sk)]","ReadSchema: struct","","(26) ColumnarToRow [codegen id : 9]","Input [2]: [cc_call_center_sk#17, cc_county#18]","","(27) Filter [codegen id : 9]","Input [2]: [cc_call_center_sk#17, cc_county#18]","Condition : ((isnotnull(cc_county#18) AND (cc_county#18 = Williamson County)) AND isnotnull(cc_call_center_sk#17))","","(28) Project [codegen id : 9]","Output [1]: [cc_call_center_sk#17]","Input [2]: [cc_call_center_sk#17, cc_county#18]","","(29) BroadcastExchange","Input [1]: [cc_call_center_sk#17]","Arguments: HashedRelationBroadcastMode(List(cast(input[0, int, true] as bigint)),false), [id=#19]","","(30) BroadcastHashJoin [codegen id : 11]","Left keys [1]: [cs_call_center_sk#3]","Right keys [1]: [cc_call_center_sk#17]","Join condition: None","","(31) Project [codegen id : 11]","Output [4]: [cs_ship_date_sk#1, cs_order_number#5, cs_ext_ship_cost#6, cs_net_profit#7]","Input [6]: [cs_ship_date_sk#1, cs_call_center_sk#3, cs_order_number#5, cs_ext_ship_cost#6, cs_net_profit#7, cc_call_center_sk#17]","","(32) Scan parquet default.date_dim","Output [2]: [d_date_sk#20, d_date#21]","Batched: true","Location [not included in comparison]/{warehouse_dir}/date_dim]","PushedFilters: [IsNotNull(d_date), GreaterThanOrEqual(d_date,2002-02-01), LessThanOrEqual(d_date,2002-04-02), IsNotNull(d_date_sk)]","ReadSchema: struct","","(33) ColumnarToRow [codegen id : 10]","Input [2]: [d_date_sk#20, d_date#21]","","(34) Filter [codegen id : 10]","Input [2]: [d_date_sk#20, d_date#21]","Condition : (((isnotnull(d_date#21) AND (d_date#21 >= 11719)) AND (d_date#21 <= 11779)) AND isnotnull(d_date_sk#20))","","(35) Project [codegen id : 10]","Output [1]: [d_date_sk#20]","Input [2]: [d_date_sk#20, d_date#21]","","(36) BroadcastExchange","Input [1]: [d_date_sk#20]","Arguments: HashedRelationBroadcastMode(List(cast(input[0, int, true] as bigint)),false), [id=#22]","","(37) BroadcastHashJoin [codegen id : 11]","Left keys [1]: [cs_ship_date_sk#1]","Right keys [1]: [d_date_sk#20]","Join condition: None","","(38) Project [codegen id : 11]","Output [3]: [cs_order_number#5, cs_ext_ship_cost#6, cs_net_profit#7]","Input [5]: [cs_ship_date_sk#1, cs_order_number#5, cs_ext_ship_cost#6, cs_net_profit#7, d_date_sk#20]","","(39) HashAggregate [codegen id : 11]","Input [3]: [cs_order_number#5, cs_ext_ship_cost#6, cs_net_profit#7]","Keys [1]: [cs_order_number#5]","Functions [2]: [partial_sum(UnscaledValue(cs_ext_ship_cost#6)), partial_sum(UnscaledValue(cs_net_profit#7))]","Aggregate Attributes [2]: [sum(UnscaledValue(cs_ext_ship_cost#6))#23, sum(UnscaledValue(cs_net_profit#7))#24]","Results [3]: [cs_order_number#5, sum#25, sum#26]","","(40) HashAggregate [codegen id : 11]","Input [3]: [cs_order_number#5, sum#25, sum#26]","Keys [1]: [cs_order_number#5]","Functions [2]: [merge_sum(UnscaledValue(cs_ext_ship_cost#6)), merge_sum(UnscaledValue(cs_net_profit#7))]","Aggregate Attributes [2]: [sum(UnscaledValue(cs_ext_ship_cost#6))#23, sum(UnscaledValue(cs_net_profit#7))#24]","Results [3]: [cs_order_number#5, sum#25, sum#26]","","(41) HashAggregate [codegen id : 11]","Input [3]: [cs_order_number#5, sum#25, sum#26]","Keys: []","Functions [3]: [merge_sum(UnscaledValue(cs_ext_ship_cost#6)), merge_sum(UnscaledValue(cs_net_profit#7)), partial_count(distinct cs_order_number#5)]","Aggregate Attributes [3]: [sum(UnscaledValue(cs_ext_ship_cost#6))#23, sum(UnscaledValue(cs_net_profit#7))#24, count(cs_order_number#5)#27]","Results [3]: [sum#25, sum#26, count#28]","","(42) Exchange","Input [3]: [sum#25, sum#26, count#28]","Arguments: SinglePartition, ENSURE_REQUIREMENTS, [id=#29]","","(43) HashAggregate [codegen id : 12]","Input [3]: [sum#25, sum#26, count#28]","Keys: []","Functions [3]: [sum(UnscaledValue(cs_ext_ship_cost#6)), sum(UnscaledValue(cs_net_profit#7)), count(distinct cs_order_number#5)]","Aggregate Attributes [3]: [sum(UnscaledValue(cs_ext_ship_cost#6))#23, sum(UnscaledValue(cs_net_profit#7))#24, count(cs_order_number#5)#27]","Results [3]: [count(cs_order_number#5)#27 AS order count #30, MakeDecimal(sum(UnscaledValue(cs_ext_ship_cost#6))#23,17,2) AS total shipping cost #31, MakeDecimal(sum(UnscaledValue(cs_net_profit#7))#24,17,2) AS total net profit #32]","","(44) Sort [codegen id : 12]","Input [3]: [order count #30, total shipping cost #31, total net profit #32]","Arguments: [order count #30 ASC NULLS FIRST], true, 0"],"stylingDirectives":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[]],"colorizedLines":null,"csv":null,"csvError":null,"dependabotInfo":{"showConfigurationBanner":false,"configFilePath":null,"networkDependabotPath":"/apache/spark/network/updates","dismissConfigurationNoticePath":"/settings/dismiss-notice/dependabot_configuration_notice","configurationNoticeDismissed":null},"displayName":"explain.txt","displayUrl":"https://github.com/apache/spark/blob/a235c3b2544aead2b1e3034aacfd361d49ad79b1/sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q16.sf100/explain.txt?raw=true","headerInfo":{"blobSize":"11.4 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":"1dbc84b","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%2Fq16.sf100%2Fexplain.txt","isCSV":false,"isRichtext":false,"toc":null,"lineInfo":{"truncatedLoc":"250","truncatedSloc":"204"},"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/q16.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/q16.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":"ZYi8e_Y2BUFihyZ-uHKKbl876OZUvZkNJEB13mEM-QR_0GVola4ap9o85xJI21dEAHnRT1f_iKi0RXQLt75LNg"},"/repos/preferences":{"post":"tfiDb84B4l5rM5Q0fkJxqnytDG2YB6tDQ-YZGl9p65hfoag7pSwJQ7rRyOV-0KmHuxD7rp-RuuUZq5fMbxHWGg"}}},"title":"spark/sql/core/src/test/resources/tpcds-plan-stability/approved-plans-v1_4/q16.sf100/explain.txt at a235c3b2544aead2b1e3034aacfd361d49ad79b1 ยท apache/spark"}