digraph G {
0 [labelType="html" label="<br><b>TakeOrderedAndProject</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n702 ms (128 ms, 140 ms, 154 ms (stage 369.0: task 460))";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 4,038"];
4 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 5,919<br>number of input batches: 5"];
}
5 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 5<br>scan time total (min, med, max (stageId: taskId))<br>175 ms (24 ms, 34 ms, 46 ms (stage 369.0: task 460))<br>metadata time: 0 ms<br>size of files read: 88.8 KiB<br>number of output rows: 5,919"];
2->0;
3->2;
4->3;
5->4;
}
6
TakeOrderedAndProject(limit=500000, orderBy=[COL_9CA3A2C9_C741_4067_B8CD_BC41E46A6493#43172 ASC NULLS FIRST,COL_1C44CF13_DB2C_4B0E_912F_D92D4DEA3440#43173 ASC NULLS FIRST,COL_01740B0B_7212_4354_966D_94F0D9D6D120#43174 ASC NULLS FIRST], output=[COL_9CA3A2C9_C741_4067_B8CD_BC41E46A6493#43172,COL_1C44CF13_DB2C_4B0E_912F_D92D4DEA3440#43173,COL_01740B0B_7212_4354_966D_94F0D9D6D120#43174,COL_249077ED_C869_438E_8A20_00B7C81FB35C#43175,COL_D1EFD93B_9924_4FA2_AE1D_47E046421D43#43176,COL_7C19A9C8_200E_4F30_8653_A765933EE583#43177,COL_CF5201E7_DA4F_4116_8F6F_AB81256E4E9D#43178,COL_D66F7627_BD1F_4630_9D10_D1F00CFA730B#43179,COL_2B6D61FE_F0A8_4C77_AFE1_2B919C010A89#43180,COL_4498191A_A211_4B25_9AC0_FAFD5EEF36DB#43181,COL_4AD97EBF_F492_497E_8186_6B07D2518CD3#43182,COL_AD9370FC_15AF_4CC6_871A_776E37CEB119#43183,COL_737A8C60_A3C1_4A84_B48A_7AEF0F829D23#43184,COL_22689869_DA9A_4677_A879_52516F5342E1#43185,COL_A8F43E3A_F2A9_41F6_826D_603C4EC931DF#43186,COL_52A7B9F1_289C_49C4_B676_7F4DC1324E5A#43187])
Project [COL_159DC463_4996_4B78_9FEC_CC984BA3E731#42728 AS COL_9CA3A2C9_C741_4067_B8CD_BC41E46A6493#43172, COL_22832518_AFA9_495B_AD52_CC616378D16D#42729 AS COL_1C44CF13_DB2C_4B0E_912F_D92D4DEA3440#43173, COL_2C3EE9C5_1A5A_4828_A57B_1A0309BF3CC9#42730 AS COL_01740B0B_7212_4354_966D_94F0D9D6D120#43174, COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42731 AS COL_249077ED_C869_438E_8A20_00B7C81FB35C#43175, COL_8CCBF2E5_47D8_4A51_BB3D_FF2503C928B3#42732 AS COL_D1EFD93B_9924_4FA2_AE1D_47E046421D43#43176, COL_30932C43_D3FD_4AD3_BFC3_A41EAE9071E4#42733 AS COL_7C19A9C8_200E_4F30_8653_A765933EE583#43177, COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42734 AS COL_CF5201E7_DA4F_4116_8F6F_AB81256E4E9D#43178, COL_969644EA_9245_4D2F_B985_FFA83A591910#42735 AS COL_D66F7627_BD1F_4630_9D10_D1F00CFA730B#43179, COL_4ADAA58D_EB1D_4B61_AB8C_07043AA6A9A6#42736 AS COL_2B6D61FE_F0A8_4C77_AFE1_2B919C010A89#43180, COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42737 AS COL_4498191A_A211_4B25_9AC0_FAFD5EEF36DB#43181, COL_F0391FB9_833D_4445_9DF1_DDE2092461C8#42738 AS COL_4AD97EBF_F492_497E_8186_6B07D2518CD3#43182, COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42739 AS COL_AD9370FC_15AF_4CC6_871A_776E37CEB119#43183, COL_C3A1E34C_FD52_40F9_8F3B_3571D0AECB78#42740 AS COL_737A8C60_A3C1_4A84_B48A_7AEF0F829D23#43184, COL_9BFF7A7F_9A6B_4EE9_8038_8E344F2C29E5#42741 AS COL_22689869_DA9A_4677_A879_52516F5342E1#43185, COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42745 AS COL_A8F43E3A_F2A9_41F6_826D_603C4EC931DF#43186, COL_120007F7_9D33_41AB_B1F5_FDB2D3B9D9BC#42742 AS COL_52A7B9F1_289C_49C4_B676_7F4DC1324E5A#43187]
Filter NOT (str_remove_accent(upper(COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42745)) <=> 2)
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_159DC463_4996_4B78_9FEC_CC984BA3E731#42728,COL_22832518_AFA9_495B_AD52_CC616378D16D#42729,COL_2C3EE9C5_1A5A_4828_A57B_1A0309BF3CC9#42730,COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42731,COL_8CCBF2E5_47D8_4A51_BB3D_FF2503C928B3#42732,COL_30932C43_D3FD_4AD3_BFC3_A41EAE9071E4#42733,COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42734,COL_969644EA_9245_4D2F_B985_FFA83A591910#42735,COL_4ADAA58D_EB1D_4B61_AB8C_07043AA6A9A6#42736,COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42737,COL_F0391FB9_833D_4445_9DF1_DDE2092461C8#42738,COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42739,COL_C3A1E34C_FD52_40F9_8F3B_3571D0AECB78#42740,COL_9BFF7A7F_9A6B_4EE9_8038_8E344F2C29E5#42741,COL_120007F7_9D33_41AB_B1F5_FDB2D3B9D9BC#42742,COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42745] Batched: true, DataFilters: [NOT (str_remove_accent(upper(COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42745)) <=> 2)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/RHA_2021_CSARR__57211], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_159DC463_4996_4B78_9FEC_CC984BA3E731:string,COL_22832518_AFA9_495B_AD52_CC616378D16D:s...
== Physical Plan ==
TakeOrderedAndProject (5)
+- * Project (4)
+- * Filter (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
(1) Scan parquet
Output [16]: [COL_159DC463_4996_4B78_9FEC_CC984BA3E731#42728, COL_22832518_AFA9_495B_AD52_CC616378D16D#42729, COL_2C3EE9C5_1A5A_4828_A57B_1A0309BF3CC9#42730, COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42731, COL_8CCBF2E5_47D8_4A51_BB3D_FF2503C928B3#42732, COL_30932C43_D3FD_4AD3_BFC3_A41EAE9071E4#42733, COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42734, COL_969644EA_9245_4D2F_B985_FFA83A591910#42735, COL_4ADAA58D_EB1D_4B61_AB8C_07043AA6A9A6#42736, COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42737, COL_F0391FB9_833D_4445_9DF1_DDE2092461C8#42738, COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42739, COL_C3A1E34C_FD52_40F9_8F3B_3571D0AECB78#42740, COL_9BFF7A7F_9A6B_4EE9_8038_8E344F2C29E5#42741, COL_120007F7_9D33_41AB_B1F5_FDB2D3B9D9BC#42742, COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42745]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/RHA_2021_CSARR__57211]
ReadSchema: struct<COL_159DC463_4996_4B78_9FEC_CC984BA3E731:string,COL_22832518_AFA9_495B_AD52_CC616378D16D:string,COL_2C3EE9C5_1A5A_4828_A57B_1A0309BF3CC9:string,COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94:string,COL_8CCBF2E5_47D8_4A51_BB3D_FF2503C928B3:string,COL_30932C43_D3FD_4AD3_BFC3_A41EAE9071E4:string,COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0:string,COL_969644EA_9245_4D2F_B985_FFA83A591910:int,COL_4ADAA58D_EB1D_4B61_AB8C_07043AA6A9A6:string,COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80:string,COL_F0391FB9_833D_4445_9DF1_DDE2092461C8:int,COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6:double,COL_C3A1E34C_FD52_40F9_8F3B_3571D0AECB78:string,COL_9BFF7A7F_9A6B_4EE9_8038_8E344F2C29E5:string,COL_120007F7_9D33_41AB_B1F5_FDB2D3B9D9BC:string,COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD:string>
(2) ColumnarToRow [codegen id : 1]
Input [16]: [COL_159DC463_4996_4B78_9FEC_CC984BA3E731#42728, COL_22832518_AFA9_495B_AD52_CC616378D16D#42729, COL_2C3EE9C5_1A5A_4828_A57B_1A0309BF3CC9#42730, COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42731, COL_8CCBF2E5_47D8_4A51_BB3D_FF2503C928B3#42732, COL_30932C43_D3FD_4AD3_BFC3_A41EAE9071E4#42733, COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42734, COL_969644EA_9245_4D2F_B985_FFA83A591910#42735, COL_4ADAA58D_EB1D_4B61_AB8C_07043AA6A9A6#42736, COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42737, COL_F0391FB9_833D_4445_9DF1_DDE2092461C8#42738, COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42739, COL_C3A1E34C_FD52_40F9_8F3B_3571D0AECB78#42740, COL_9BFF7A7F_9A6B_4EE9_8038_8E344F2C29E5#42741, COL_120007F7_9D33_41AB_B1F5_FDB2D3B9D9BC#42742, COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42745]
(3) Filter [codegen id : 1]
Input [16]: [COL_159DC463_4996_4B78_9FEC_CC984BA3E731#42728, COL_22832518_AFA9_495B_AD52_CC616378D16D#42729, COL_2C3EE9C5_1A5A_4828_A57B_1A0309BF3CC9#42730, COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42731, COL_8CCBF2E5_47D8_4A51_BB3D_FF2503C928B3#42732, COL_30932C43_D3FD_4AD3_BFC3_A41EAE9071E4#42733, COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42734, COL_969644EA_9245_4D2F_B985_FFA83A591910#42735, COL_4ADAA58D_EB1D_4B61_AB8C_07043AA6A9A6#42736, COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42737, COL_F0391FB9_833D_4445_9DF1_DDE2092461C8#42738, COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42739, COL_C3A1E34C_FD52_40F9_8F3B_3571D0AECB78#42740, COL_9BFF7A7F_9A6B_4EE9_8038_8E344F2C29E5#42741, COL_120007F7_9D33_41AB_B1F5_FDB2D3B9D9BC#42742, COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42745]
Condition : NOT (str_remove_accent(upper(COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42745)) <=> 2)
(4) Project [codegen id : 1]
Output [16]: [COL_159DC463_4996_4B78_9FEC_CC984BA3E731#42728 AS COL_9CA3A2C9_C741_4067_B8CD_BC41E46A6493#43172, COL_22832518_AFA9_495B_AD52_CC616378D16D#42729 AS COL_1C44CF13_DB2C_4B0E_912F_D92D4DEA3440#43173, COL_2C3EE9C5_1A5A_4828_A57B_1A0309BF3CC9#42730 AS COL_01740B0B_7212_4354_966D_94F0D9D6D120#43174, COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42731 AS COL_249077ED_C869_438E_8A20_00B7C81FB35C#43175, COL_8CCBF2E5_47D8_4A51_BB3D_FF2503C928B3#42732 AS COL_D1EFD93B_9924_4FA2_AE1D_47E046421D43#43176, COL_30932C43_D3FD_4AD3_BFC3_A41EAE9071E4#42733 AS COL_7C19A9C8_200E_4F30_8653_A765933EE583#43177, COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42734 AS COL_CF5201E7_DA4F_4116_8F6F_AB81256E4E9D#43178, COL_969644EA_9245_4D2F_B985_FFA83A591910#42735 AS COL_D66F7627_BD1F_4630_9D10_D1F00CFA730B#43179, COL_4ADAA58D_EB1D_4B61_AB8C_07043AA6A9A6#42736 AS COL_2B6D61FE_F0A8_4C77_AFE1_2B919C010A89#43180, COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42737 AS COL_4498191A_A211_4B25_9AC0_FAFD5EEF36DB#43181, COL_F0391FB9_833D_4445_9DF1_DDE2092461C8#42738 AS COL_4AD97EBF_F492_497E_8186_6B07D2518CD3#43182, COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42739 AS COL_AD9370FC_15AF_4CC6_871A_776E37CEB119#43183, COL_C3A1E34C_FD52_40F9_8F3B_3571D0AECB78#42740 AS COL_737A8C60_A3C1_4A84_B48A_7AEF0F829D23#43184, COL_9BFF7A7F_9A6B_4EE9_8038_8E344F2C29E5#42741 AS COL_22689869_DA9A_4677_A879_52516F5342E1#43185, COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42745 AS COL_A8F43E3A_F2A9_41F6_826D_603C4EC931DF#43186, COL_120007F7_9D33_41AB_B1F5_FDB2D3B9D9BC#42742 AS COL_52A7B9F1_289C_49C4_B676_7F4DC1324E5A#43187]
Input [16]: [COL_159DC463_4996_4B78_9FEC_CC984BA3E731#42728, COL_22832518_AFA9_495B_AD52_CC616378D16D#42729, COL_2C3EE9C5_1A5A_4828_A57B_1A0309BF3CC9#42730, COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42731, COL_8CCBF2E5_47D8_4A51_BB3D_FF2503C928B3#42732, COL_30932C43_D3FD_4AD3_BFC3_A41EAE9071E4#42733, COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42734, COL_969644EA_9245_4D2F_B985_FFA83A591910#42735, COL_4ADAA58D_EB1D_4B61_AB8C_07043AA6A9A6#42736, COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42737, COL_F0391FB9_833D_4445_9DF1_DDE2092461C8#42738, COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42739, COL_C3A1E34C_FD52_40F9_8F3B_3571D0AECB78#42740, COL_9BFF7A7F_9A6B_4EE9_8038_8E344F2C29E5#42741, COL_120007F7_9D33_41AB_B1F5_FDB2D3B9D9BC#42742, COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42745]
(5) TakeOrderedAndProject
Input [16]: [COL_9CA3A2C9_C741_4067_B8CD_BC41E46A6493#43172, COL_1C44CF13_DB2C_4B0E_912F_D92D4DEA3440#43173, COL_01740B0B_7212_4354_966D_94F0D9D6D120#43174, COL_249077ED_C869_438E_8A20_00B7C81FB35C#43175, COL_D1EFD93B_9924_4FA2_AE1D_47E046421D43#43176, COL_7C19A9C8_200E_4F30_8653_A765933EE583#43177, COL_CF5201E7_DA4F_4116_8F6F_AB81256E4E9D#43178, COL_D66F7627_BD1F_4630_9D10_D1F00CFA730B#43179, COL_2B6D61FE_F0A8_4C77_AFE1_2B919C010A89#43180, COL_4498191A_A211_4B25_9AC0_FAFD5EEF36DB#43181, COL_4AD97EBF_F492_497E_8186_6B07D2518CD3#43182, COL_AD9370FC_15AF_4CC6_871A_776E37CEB119#43183, COL_737A8C60_A3C1_4A84_B48A_7AEF0F829D23#43184, COL_22689869_DA9A_4677_A879_52516F5342E1#43185, COL_A8F43E3A_F2A9_41F6_826D_603C4EC931DF#43186, COL_52A7B9F1_289C_49C4_B676_7F4DC1324E5A#43187]
Arguments: 500000, [COL_9CA3A2C9_C741_4067_B8CD_BC41E46A6493#43172 ASC NULLS FIRST, COL_1C44CF13_DB2C_4B0E_912F_D92D4DEA3440#43173 ASC NULLS FIRST, COL_01740B0B_7212_4354_966D_94F0D9D6D120#43174 ASC NULLS FIRST], [COL_9CA3A2C9_C741_4067_B8CD_BC41E46A6493#43172, COL_1C44CF13_DB2C_4B0E_912F_D92D4DEA3440#43173, COL_01740B0B_7212_4354_966D_94F0D9D6D120#43174, COL_249077ED_C869_438E_8A20_00B7C81FB35C#43175, COL_D1EFD93B_9924_4FA2_AE1D_47E046421D43#43176, COL_7C19A9C8_200E_4F30_8653_A765933EE583#43177, COL_CF5201E7_DA4F_4116_8F6F_AB81256E4E9D#43178, COL_D66F7627_BD1F_4630_9D10_D1F00CFA730B#43179, COL_2B6D61FE_F0A8_4C77_AFE1_2B919C010A89#43180, COL_4498191A_A211_4B25_9AC0_FAFD5EEF36DB#43181, COL_4AD97EBF_F492_497E_8186_6B07D2518CD3#43182, COL_AD9370FC_15AF_4CC6_871A_776E37CEB119#43183, COL_737A8C60_A3C1_4A84_B48A_7AEF0F829D23#43184, COL_22689869_DA9A_4677_A879_52516F5342E1#43185, COL_A8F43E3A_F2A9_41F6_826D_603C4EC931DF#43186, COL_52A7B9F1_289C_49C4_B676_7F4DC1324E5A#43187]