== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (23)
+- Project (22)
+- Aggregate (21)
+- Filter (20)
+- Project (19)
+- Project (18)
+- Project (17)
+- Project (16)
+- Project (15)
+- Project (14)
+- SubqueryAlias (13)
+- View (12)
+- Aggregate (11)
+- Project (10)
+- SubqueryAlias (9)
+- View (8)
+- Project (7)
+- Project (6)
+- Project (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `GEOCODAGE_ADRES_405357174`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Adresse-Source#124068, adresse#124069, longitude#124070, latitude#124071, result_score#124072, result_score_next#124073, result_label#124074, result_type#124075, result_id#124076, result_banId#124077, result_housenumber#124078, result_name#124079, result_street#124080, result_postcode#124081, result_city#124082, result_context#124083, result_citycode#124084, result_oldcitycode#124085, result_oldcity#124086, result_district#124087, result_status#124088], false
(4) Project
Arguments: [Adresse-Source#124068 AS Adresse-Source#124131, adresse#124069 AS adresse#124132, longitude#124070 AS longitude#124133, latitude#124071 AS latitude#124134, result_score#124072 AS result_score#124135, result_score_next#124073 AS result_score_next#124136, result_label#124074 AS result_label#124137, result_type#124075 AS result_type#124138, result_id#124076 AS result_id#124139, result_banId#124077 AS result_banId#124140, result_housenumber#124078 AS result_housenumber#124141, result_name#124079 AS result_name#124142, result_street#124080 AS result_street#124143, result_postcode#124081 AS result_postcode#124144, result_city#124082 AS result_city#124145, result_context#124083 AS result_context#124146, result_citycode#124084 AS result_citycode#124147, result_oldcitycode#124085 AS result_oldcitycode#124148, result_oldcity#124086 AS result_oldcity#124149, result_district#124087 AS result_district#124150, result_status#124088 AS result_status#124151]
(5) Project
Arguments: [Adresse-Source#124131, adresse#124132, longitude#124133, latitude#124134, result_score#124135, result_score_next#124136, result_label#124137, result_type#124138, result_id#124139, result_banId#124140, result_housenumber#124141, result_name#124142, result_street#124143, result_postcode#124144, result_city#124145, result_context#124146, result_citycode#124147, result_oldcitycode#124148, result_oldcity#124149, result_district#124150, result_status#124151]
(6) Project
Arguments: [adresse#124132 AS _ADRESSE#124195, Adresse-Source#124131 AS _ADRESSE_SOURCE#124196, latitude#124134 AS _LATITUDE#124197, longitude#124133 AS _LONGITUDE#124198, result_banId#124140 AS _RESULT_BANID#124199, result_city#124145 AS _RESULT_CITY#124200, result_citycode#124147 AS _RESULT_CITYCODE#124201, result_context#124146 AS _RESULT_CONTEXT#124202, result_district#124150 AS _RESULT_DISTRICT#124203, result_housenumber#124141 AS _RESULT_HOUSENUMBER#124204, result_id#124139 AS _RESULT_ID#124205, result_label#124137 AS _RESULT_LABEL#124206, result_name#124142 AS _RESULT_NAME#124207, result_oldcity#124149 AS _RESULT_OLDCITY#124208, result_oldcitycode#124148 AS _RESULT_OLDCITYCODE#124209, result_postcode#124144 AS _RESULT_POSTCODE#124210, result_score#124135 AS _RESULT_SCORE#124211, result_score_next#124136 AS _RESULT_SCORE_NEXT#124212, result_status#124151 AS _RESULT_STATUS#124213, result_street#124143 AS _RESULT_STREET#124214, result_type#124138 AS _RESULT_TYPE#124215]
(7) Project
Arguments: [_ADRESSE#124195, _ADRESSE_SOURCE#124196, _LATITUDE#124197, _LONGITUDE#124198, _RESULT_BANID#124199, _RESULT_CITY#124200, _RESULT_CITYCODE#124201, _RESULT_CONTEXT#124202, _RESULT_DISTRICT#124203, _RESULT_HOUSENUMBER#124204, _RESULT_ID#124205, _RESULT_LABEL#124206, _RESULT_NAME#124207, _RESULT_OLDCITY#124208, _RESULT_OLDCITYCODE#124209, _RESULT_POSTCODE#124210, _RESULT_SCORE#124211, _RESULT_SCORE_NEXT#124212, _RESULT_STATUS#124213, _RESULT_STREET#124214, _RESULT_TYPE#124215]
(8) View
Arguments: `EBD11643_88BE_4D27_9625_B39544C01CCE`, true
(9) SubqueryAlias
Arguments: EBD11643_88BE_4D27_9625_B39544C01CCE
(10) Project
Arguments: [_ADRESSE#124195, _ADRESSE_SOURCE#124196, _LATITUDE#124197, _LONGITUDE#124198, _RESULT_BANID#124199, _RESULT_CITY#124200, _RESULT_CITYCODE#124201, _RESULT_CONTEXT#124202, _RESULT_DISTRICT#124203, _RESULT_HOUSENUMBER#124204, _RESULT_ID#124205, _RESULT_LABEL#124206, _RESULT_NAME#124207, _RESULT_OLDCITY#124208, _RESULT_OLDCITYCODE#124209, _RESULT_POSTCODE#124210, _RESULT_SCORE#124211, _RESULT_SCORE_NEXT#124212, _RESULT_STATUS#124213, _RESULT_STREET#124214, _RESULT_TYPE#124215]
(11) Aggregate
Arguments: [_ADRESSE#124195, _ADRESSE_SOURCE#124196, _LATITUDE#124197, _LONGITUDE#124198, _RESULT_BANID#124199, _RESULT_CITY#124200, _RESULT_CITYCODE#124201, _RESULT_CONTEXT#124202, _RESULT_DISTRICT#124203, _RESULT_HOUSENUMBER#124204, _RESULT_ID#124205, _RESULT_LABEL#124206, _RESULT_NAME#124207, _RESULT_OLDCITY#124208, _RESULT_OLDCITYCODE#124209, _RESULT_POSTCODE#124210, _RESULT_SCORE#124211, _RESULT_SCORE_NEXT#124212, _RESULT_STATUS#124213, _RESULT_STREET#124214, _RESULT_TYPE#124215], [_ADRESSE#124195, _ADRESSE_SOURCE#124196, _LATITUDE#124197, _LONGITUDE#124198, _RESULT_BANID#124199, _RESULT_CITY#124200, _RESULT_CITYCODE#124201, _RESULT_CONTEXT#124202, _RESULT_DISTRICT#124203, _RESULT_HOUSENUMBER#124204, _RESULT_ID#124205, _RESULT_LABEL#124206, _RESULT_NAME#124207, _RESULT_OLDCITY#124208, _RESULT_OLDCITYCODE#124209, _RESULT_POSTCODE#124210, _RESULT_SCORE#124211, _RESULT_SCORE_NEXT#124212, _RESULT_STATUS#124213, _RESULT_STREET#124214, _RESULT_TYPE#124215]
(12) View
Arguments: `GEOCODAGE_ADRES_405311174`, true
(13) SubqueryAlias
Arguments: GEOCODAGE_ADRES_405311174
(14) Project
Arguments: [_ADRESSE#124195 AS GEOCODAGE_ADRES_405311__ADRESSE#124363, _ADRESSE_SOURCE#124196 AS GEOCODAGE_ADRES_405311__ADRESSE_SOURCE#124364, _LATITUDE#124197 AS GEOCODAGE_ADRES_405311__LATITUDE#124365, _LONGITUDE#124198 AS GEOCODAGE_ADRES_405311__LONGITUDE#124366, _RESULT_BANID#124199 AS GEOCODAGE_ADRES_405311__RESULT_BANID#124367, _RESULT_CITY#124200 AS GEOCODAGE_ADRES_405311__RESULT_CITY#124368, _RESULT_CITYCODE#124201 AS GEOCODAGE_ADRES_405311__RESULT_CITYCODE#124369, _RESULT_CONTEXT#124202 AS GEOCODAGE_ADRES_405311__RESULT_CONTEXT#124370, _RESULT_DISTRICT#124203 AS GEOCODAGE_ADRES_405311__RESULT_DISTRICT#124371, _RESULT_HOUSENUMBER#124204 AS GEOCODAGE_ADRES_405311__RESULT_HOUSENUMBER#124372, _RESULT_ID#124205 AS GEOCODAGE_ADRES_405311__RESULT_ID#124373, _RESULT_LABEL#124206 AS GEOCODAGE_ADRES_405311__RESULT_LABEL#124374, _RESULT_NAME#124207 AS GEOCODAGE_ADRES_405311__RESULT_NAME#124375, _RESULT_OLDCITY#124208 AS GEOCODAGE_ADRES_405311__RESULT_OLDCITY#124376, _RESULT_OLDCITYCODE#124209 AS GEOCODAGE_ADRES_405311__RESULT_OLDCITYCODE#124377, _RESULT_POSTCODE#124210 AS GEOCODAGE_ADRES_405311__RESULT_POSTCODE#124378, _RESULT_SCORE#124211 AS GEOCODAGE_ADRES_405311__RESULT_SCORE#124379, _RESULT_SCORE_NEXT#124212 AS GEOCODAGE_ADRES_405311__RESULT_SCORE_NEXT#124380, _RESULT_STATUS#124213 AS GEOCODAGE_ADRES_405311__RESULT_STATUS#124381, _RESULT_STREET#124214 AS GEOCODAGE_ADRES_405311__RESULT_STREET#124382, _RESULT_TYPE#124215 AS GEOCODAGE_ADRES_405311__RESULT_TYPE#124383]
(15) Project
Arguments: [cast(GEOCODAGE_ADRES_405311__ADRESSE_SOURCE#124364 as string) AS COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#124426, cast(GEOCODAGE_ADRES_405311__ADRESSE#124363 as string) AS COL_2DCAB171_4DC3_4FDF_BDFC_4BC6BBA61CCD#124427, cast(GEOCODAGE_ADRES_405311__LONGITUDE#124366 as string) AS COL_68C7380E_A06B_4E73_B822_4A6D7405F431#124428, cast(GEOCODAGE_ADRES_405311__LATITUDE#124365 as string) AS COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#124429, cast(GEOCODAGE_ADRES_405311__RESULT_SCORE#124379 as string) AS COL_6BBB7243_DC90_4317_93AB_4B32FCFDCB82#124430, cast(GEOCODAGE_ADRES_405311__RESULT_SCORE_NEXT#124380 as string) AS COL_51F0552F_5461_4F95_9369_DE2FB6ED96D2#124431, cast(GEOCODAGE_ADRES_405311__RESULT_LABEL#124374 as string) AS COL_A15D4877_E91C_4A8A_B95F_CB50DD9C9863#124432, cast(GEOCODAGE_ADRES_405311__RESULT_TYPE#124383 as string) AS COL_4EC4EB88_3FE3_4EEE_A104_05FCD19E8728#124433, cast(GEOCODAGE_ADRES_405311__RESULT_ID#124373 as string) AS COL_2FBC62E0_DFC9_44D0_982B_59A6130C0DD5#124434, cast(GEOCODAGE_ADRES_405311__RESULT_BANID#124367 as string) AS COL_5EF0A1CD_5C92_4783_A1DF_8BD8C86600C1#124435, cast(GEOCODAGE_ADRES_405311__RESULT_HOUSENUMBER#124372 as string) AS COL_72CCEA3B_D3D2_480C_A833_EF34BAB927E1#124436, cast(GEOCODAGE_ADRES_405311__RESULT_NAME#124375 as string) AS COL_A8EC511A_D4CC_4D87_9766_A2D0C12F5D79#124437, cast(GEOCODAGE_ADRES_405311__RESULT_STREET#124382 as string) AS COL_5CBA85C6_4B18_49F0_B26B_358B97B24063#124438, cast(GEOCODAGE_ADRES_405311__RESULT_POSTCODE#124378 as string) AS COL_7EFC84B5_BC35_4E3C_9688_A74C947DA135#124439, cast(GEOCODAGE_ADRES_405311__RESULT_CITY#124368 as string) AS COL_664ABC20_EB27_4F11_8B7F_94877D0CCDFA#124440, cast(GEOCODAGE_ADRES_405311__RESULT_CONTEXT#124370 as string) AS COL_45403618_5C38_43F9_870D_0FF74BD7CC3C#124441, cast(GEOCODAGE_ADRES_405311__RESULT_CITYCODE#124369 as string) AS COL_B22E36C6_46FC_4134_BE6C_845631DBC617#124442, cast(GEOCODAGE_ADRES_405311__RESULT_OLDCITYCODE#124377 as string) AS COL_4127ED61_E800_46AE_B28F_B6A59C9C2B87#124443, cast(GEOCODAGE_ADRES_405311__RESULT_OLDCITY#124376 as string) AS COL_B4F6A985_30A4_41D1_9416_00C75E847AAA#124444, cast(GEOCODAGE_ADRES_405311__RESULT_DISTRICT#124371 as string) AS COL_FDDD636A_FA96_4AC0_9150_E8A6F2A0ABD4#124445, cast(GEOCODAGE_ADRES_405311__RESULT_STATUS#124381 as string) AS COL_642B0BB8_B25C_4BD0_96E5_C05E6943A1FC#124446]
(16) Project
Arguments: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#124426 AS COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#124468, COL_2DCAB171_4DC3_4FDF_BDFC_4BC6BBA61CCD#124427 AS COL_2DCAB171_4DC3_4FDF_BDFC_4BC6BBA61CCD#124469, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#124428 AS COL_68C7380E_A06B_4E73_B822_4A6D7405F431#124470, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#124429 AS COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#124471, COL_6BBB7243_DC90_4317_93AB_4B32FCFDCB82#124430 AS COL_6BBB7243_DC90_4317_93AB_4B32FCFDCB82#124472, COL_51F0552F_5461_4F95_9369_DE2FB6ED96D2#124431 AS COL_51F0552F_5461_4F95_9369_DE2FB6ED96D2#124473, COL_A15D4877_E91C_4A8A_B95F_CB50DD9C9863#124432 AS COL_A15D4877_E91C_4A8A_B95F_CB50DD9C9863#124474, COL_4EC4EB88_3FE3_4EEE_A104_05FCD19E8728#124433 AS COL_4EC4EB88_3FE3_4EEE_A104_05FCD19E8728#124475, COL_2FBC62E0_DFC9_44D0_982B_59A6130C0DD5#124434 AS COL_2FBC62E0_DFC9_44D0_982B_59A6130C0DD5#124476, COL_5EF0A1CD_5C92_4783_A1DF_8BD8C86600C1#124435 AS COL_5EF0A1CD_5C92_4783_A1DF_8BD8C86600C1#124477, COL_72CCEA3B_D3D2_480C_A833_EF34BAB927E1#124436 AS COL_72CCEA3B_D3D2_480C_A833_EF34BAB927E1#124478, COL_A8EC511A_D4CC_4D87_9766_A2D0C12F5D79#124437 AS COL_A8EC511A_D4CC_4D87_9766_A2D0C12F5D79#124479, COL_5CBA85C6_4B18_49F0_B26B_358B97B24063#124438 AS COL_5CBA85C6_4B18_49F0_B26B_358B97B24063#124480, COL_7EFC84B5_BC35_4E3C_9688_A74C947DA135#124439 AS COL_7EFC84B5_BC35_4E3C_9688_A74C947DA135#124481, COL_664ABC20_EB27_4F11_8B7F_94877D0CCDFA#124440 AS COL_664ABC20_EB27_4F11_8B7F_94877D0CCDFA#124482, COL_45403618_5C38_43F9_870D_0FF74BD7CC3C#124441 AS COL_45403618_5C38_43F9_870D_0FF74BD7CC3C#124483, COL_B22E36C6_46FC_4134_BE6C_845631DBC617#124442 AS COL_B22E36C6_46FC_4134_BE6C_845631DBC617#124484, COL_4127ED61_E800_46AE_B28F_B6A59C9C2B87#124443 AS COL_4127ED61_E800_46AE_B28F_B6A59C9C2B87#124485, COL_B4F6A985_30A4_41D1_9416_00C75E847AAA#124444 AS COL_B4F6A985_30A4_41D1_9416_00C75E847AAA#124486, COL_FDDD636A_FA96_4AC0_9150_E8A6F2A0ABD4#124445 AS COL_FDDD636A_FA96_4AC0_9150_E8A6F2A0ABD4#124487, COL_642B0BB8_B25C_4BD0_96E5_C05E6943A1FC#124446 AS COL_642B0BB8_B25C_4BD0_96E5_C05E6943A1FC#124488]
(17) Project
Arguments: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#124468, COL_2DCAB171_4DC3_4FDF_BDFC_4BC6BBA61CCD#124469, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#124470, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#124471, COL_6BBB7243_DC90_4317_93AB_4B32FCFDCB82#124472, COL_51F0552F_5461_4F95_9369_DE2FB6ED96D2#124473, COL_A15D4877_E91C_4A8A_B95F_CB50DD9C9863#124474, COL_4EC4EB88_3FE3_4EEE_A104_05FCD19E8728#124475, COL_2FBC62E0_DFC9_44D0_982B_59A6130C0DD5#124476, COL_5EF0A1CD_5C92_4783_A1DF_8BD8C86600C1#124477, COL_72CCEA3B_D3D2_480C_A833_EF34BAB927E1#124478, COL_A8EC511A_D4CC_4D87_9766_A2D0C12F5D79#124479, COL_5CBA85C6_4B18_49F0_B26B_358B97B24063#124480, COL_7EFC84B5_BC35_4E3C_9688_A74C947DA135#124481, COL_664ABC20_EB27_4F11_8B7F_94877D0CCDFA#124482, COL_45403618_5C38_43F9_870D_0FF74BD7CC3C#124483, COL_B22E36C6_46FC_4134_BE6C_845631DBC617#124484, COL_4127ED61_E800_46AE_B28F_B6A59C9C2B87#124485, COL_B4F6A985_30A4_41D1_9416_00C75E847AAA#124486, COL_FDDD636A_FA96_4AC0_9150_E8A6F2A0ABD4#124487, COL_642B0BB8_B25C_4BD0_96E5_C05E6943A1FC#124488, str_remove_space(COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#124468, cast(ONLY_ONE as string)) AS COL_86364CC8_6EAF_418B_970F_668E7B61E663#124510]
(18) Project
Arguments: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#124468 AS COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#124533, COL_2DCAB171_4DC3_4FDF_BDFC_4BC6BBA61CCD#124469 AS COL_2DCAB171_4DC3_4FDF_BDFC_4BC6BBA61CCD#124534, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#124470 AS COL_68C7380E_A06B_4E73_B822_4A6D7405F431#124535, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#124471 AS COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#124536, COL_6BBB7243_DC90_4317_93AB_4B32FCFDCB82#124472 AS COL_6BBB7243_DC90_4317_93AB_4B32FCFDCB82#124537, COL_51F0552F_5461_4F95_9369_DE2FB6ED96D2#124473 AS COL_51F0552F_5461_4F95_9369_DE2FB6ED96D2#124538, COL_A15D4877_E91C_4A8A_B95F_CB50DD9C9863#124474 AS COL_A15D4877_E91C_4A8A_B95F_CB50DD9C9863#124539, COL_4EC4EB88_3FE3_4EEE_A104_05FCD19E8728#124475 AS COL_4EC4EB88_3FE3_4EEE_A104_05FCD19E8728#124540, COL_2FBC62E0_DFC9_44D0_982B_59A6130C0DD5#124476 AS COL_2FBC62E0_DFC9_44D0_982B_59A6130C0DD5#124541, COL_5EF0A1CD_5C92_4783_A1DF_8BD8C86600C1#124477 AS COL_5EF0A1CD_5C92_4783_A1DF_8BD8C86600C1#124542, COL_72CCEA3B_D3D2_480C_A833_EF34BAB927E1#124478 AS COL_72CCEA3B_D3D2_480C_A833_EF34BAB927E1#124543, COL_A8EC511A_D4CC_4D87_9766_A2D0C12F5D79#124479 AS COL_A8EC511A_D4CC_4D87_9766_A2D0C12F5D79#124544, COL_5CBA85C6_4B18_49F0_B26B_358B97B24063#124480 AS COL_5CBA85C6_4B18_49F0_B26B_358B97B24063#124545, COL_7EFC84B5_BC35_4E3C_9688_A74C947DA135#124481 AS COL_7EFC84B5_BC35_4E3C_9688_A74C947DA135#124546, COL_664ABC20_EB27_4F11_8B7F_94877D0CCDFA#124482 AS COL_664ABC20_EB27_4F11_8B7F_94877D0CCDFA#124547, COL_45403618_5C38_43F9_870D_0FF74BD7CC3C#124483 AS COL_45403618_5C38_43F9_870D_0FF74BD7CC3C#124548, COL_B22E36C6_46FC_4134_BE6C_845631DBC617#124484 AS COL_B22E36C6_46FC_4134_BE6C_845631DBC617#124549, COL_4127ED61_E800_46AE_B28F_B6A59C9C2B87#124485 AS COL_4127ED61_E800_46AE_B28F_B6A59C9C2B87#124550, COL_B4F6A985_30A4_41D1_9416_00C75E847AAA#124486 AS COL_B4F6A985_30A4_41D1_9416_00C75E847AAA#124551, COL_FDDD636A_FA96_4AC0_9150_E8A6F2A0ABD4#124487 AS COL_FDDD636A_FA96_4AC0_9150_E8A6F2A0ABD4#124552, COL_642B0BB8_B25C_4BD0_96E5_C05E6943A1FC#124488 AS COL_642B0BB8_B25C_4BD0_96E5_C05E6943A1FC#124553, COL_86364CC8_6EAF_418B_970F_668E7B61E663#124510 AS COL_86364CC8_6EAF_418B_970F_668E7B61E663#124554]
(19) Project
Arguments: [COL_86364CC8_6EAF_418B_970F_668E7B61E663#124554 AS COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#124577, COL_2DCAB171_4DC3_4FDF_BDFC_4BC6BBA61CCD#124534 AS COL_2DCAB171_4DC3_4FDF_BDFC_4BC6BBA61CCD#124578, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#124535 AS COL_68C7380E_A06B_4E73_B822_4A6D7405F431#124579, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#124536 AS COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#124580, COL_6BBB7243_DC90_4317_93AB_4B32FCFDCB82#124537 AS COL_6BBB7243_DC90_4317_93AB_4B32FCFDCB82#124581, COL_51F0552F_5461_4F95_9369_DE2FB6ED96D2#124538 AS COL_51F0552F_5461_4F95_9369_DE2FB6ED96D2#124582, COL_A15D4877_E91C_4A8A_B95F_CB50DD9C9863#124539 AS COL_A15D4877_E91C_4A8A_B95F_CB50DD9C9863#124583, COL_4EC4EB88_3FE3_4EEE_A104_05FCD19E8728#124540 AS COL_4EC4EB88_3FE3_4EEE_A104_05FCD19E8728#124584, COL_2FBC62E0_DFC9_44D0_982B_59A6130C0DD5#124541 AS COL_2FBC62E0_DFC9_44D0_982B_59A6130C0DD5#124585, COL_5EF0A1CD_5C92_4783_A1DF_8BD8C86600C1#124542 AS COL_5EF0A1CD_5C92_4783_A1DF_8BD8C86600C1#124586, COL_72CCEA3B_D3D2_480C_A833_EF34BAB927E1#124543 AS COL_72CCEA3B_D3D2_480C_A833_EF34BAB927E1#124587, COL_A8EC511A_D4CC_4D87_9766_A2D0C12F5D79#124544 AS COL_A8EC511A_D4CC_4D87_9766_A2D0C12F5D79#124588, COL_5CBA85C6_4B18_49F0_B26B_358B97B24063#124545 AS COL_5CBA85C6_4B18_49F0_B26B_358B97B24063#124589, COL_7EFC84B5_BC35_4E3C_9688_A74C947DA135#124546 AS COL_7EFC84B5_BC35_4E3C_9688_A74C947DA135#124590, COL_664ABC20_EB27_4F11_8B7F_94877D0CCDFA#124547 AS COL_664ABC20_EB27_4F11_8B7F_94877D0CCDFA#124591, COL_45403618_5C38_43F9_870D_0FF74BD7CC3C#124548 AS COL_45403618_5C38_43F9_870D_0FF74BD7CC3C#124592, COL_B22E36C6_46FC_4134_BE6C_845631DBC617#124549 AS COL_B22E36C6_46FC_4134_BE6C_845631DBC617#124593, COL_4127ED61_E800_46AE_B28F_B6A59C9C2B87#124550 AS COL_4127ED61_E800_46AE_B28F_B6A59C9C2B87#124594, COL_B4F6A985_30A4_41D1_9416_00C75E847AAA#124551 AS COL_B4F6A985_30A4_41D1_9416_00C75E847AAA#124595, COL_FDDD636A_FA96_4AC0_9150_E8A6F2A0ABD4#124552 AS COL_FDDD636A_FA96_4AC0_9150_E8A6F2A0ABD4#124596, COL_642B0BB8_B25C_4BD0_96E5_C05E6943A1FC#124553 AS COL_642B0BB8_B25C_4BD0_96E5_C05E6943A1FC#124597, COL_86364CC8_6EAF_418B_970F_668E7B61E663#124554 AS COL_86364CC8_6EAF_418B_970F_668E7B61E663#124598]
(20) Filter
Arguments: isnotnull(COL_68C7380E_A06B_4E73_B822_4A6D7405F431#124579)
(21) Aggregate
Arguments: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#124577, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#124579, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#124580], [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#124577 AS COL_A3E44F2E_A7EB_4429_938D_3141121BC654#124621, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#124579 AS COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#124622, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#124580 AS COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#124623, 1 AS NULL_1#124646]
(22) Project
Arguments: [COL_A3E44F2E_A7EB_4429_938D_3141121BC654#124621, COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#124622, COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#124623]
(23) Project
Arguments: [COL_A3E44F2E_A7EB_4429_938D_3141121BC654#124621 AS COL_A3E44F2E_A7EB_4429_938D_3141121BC654#124654, COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#124622 AS COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#124655, COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#124623 AS COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#124656]