== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (9)
+- Project (8)
+- Project (7)
+- Project (6)
+- Project (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `ADRESSES_BAN_CA_10411171`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: text, [value#119513], false
(4) Project
Arguments: [get_json_object(value#119513, $['adresseUtile']) AS adresseUtile#120256, get_json_object(value#119513, $['codeCommune']) AS codeCommune#120257, get_json_object(value#119513, $['codePostal']) AS codePostal#120258, get_json_object(value#119513, $['codeVoie']) AS codeVoie#120259, get_json_object(value#119513, $['codesParcelles']) AS codesParcelles#120260, get_json_object(value#119513, $['destinationPrincipale']) AS destinationPrincipale#120261, get_json_object(value#119513, $['id']) AS id#120262, get_json_object(value#119513, $['libelleAcheminement']) AS libelleAcheminement#120263, get_json_object(value#119513, $['meilleurePosition']) AS meilleurePosition#120264, get_json_object(value#119513, $['nomCommune']) AS nomCommune#120265, get_json_object(value#119513, $['nomVoie']) AS nomVoie#120266, get_json_object(value#119513, $['nomVoieFantoir']) AS nomVoieFantoir#120267, get_json_object(value#119513, $['nomVoieOriginal']) AS nomVoieOriginal#120268, get_json_object(value#119513, $['nomVoieType']) AS nomVoieType#120269, get_json_object(value#119513, $['numero']) AS numero#120270, get_json_object(value#119513, $['numeroComplet']) AS numeroComplet#120271, get_json_object(value#119513, $['positions']) AS positions#120272, get_json_object(value#119513, $['pseudoNumero']) AS pseudoNumero#120273, get_json_object(value#119513, $['repetition']) AS repetition#120274, get_json_object(value#119513, $['tags']) AS tags#120275]
(5) Project
Arguments: [adresseUtile#120256 AS COLL0#120297, codeCommune#120257 AS COLL1#120298, codePostal#120258 AS COLL2#120299, codeVoie#120259 AS COLL3#120300, codesParcelles#120260 AS COLL4#120301, destinationPrincipale#120261 AS COLL5#120302, id#120262 AS COLL6#120303, libelleAcheminement#120263 AS COLL7#120304, meilleurePosition#120264 AS COLL8#120305, nomCommune#120265 AS COLL9#120306, nomVoie#120266 AS COLL10#120307, nomVoieFantoir#120267 AS COLL11#120308, nomVoieOriginal#120268 AS COLL12#120309, nomVoieType#120269 AS COLL13#120310, numero#120270 AS COLL14#120311, numeroComplet#120271 AS COLL15#120312, positions#120272 AS COLL16#120313, pseudoNumero#120273 AS COLL17#120314, repetition#120274 AS COLL18#120315, tags#120275 AS COLL19#120316]
(6) Project
Arguments: [COLL0#120297 AS COLL0#120337, COLL1#120298 AS COLL1#120338, COLL2#120299 AS COLL2#120339, COLL3#120300 AS COLL3#120340, COLL4#120301 AS COLL4#120341, COLL5#120302 AS COLL5#120342, COLL6#120303 AS COLL6#120343, COLL7#120304 AS COLL7#120344, COLL8#120305 AS COLL8#120345, COLL9#120306 AS COLL9#120346, COLL10#120307 AS COLL10#120347, COLL11#120308 AS COLL11#120348, COLL12#120309 AS COLL12#120349, COLL13#120310 AS COLL13#120350, COLL14#120311 AS COLL14#120351, COLL15#120312 AS COLL15#120352, COLL16#120313 AS COLL16#120353, COLL17#120314 AS COLL17#120354, COLL18#120315 AS COLL18#120355, COLL19#120316 AS COLL19#120356]
(7) Project
Arguments: [COLL0#120337, COLL1#120338, COLL2#120339, COLL3#120340, COLL4#120341, COLL5#120342, COLL6#120343, COLL7#120344, COLL8#120345, COLL9#120346, COLL10#120347, COLL11#120348, COLL12#120349, COLL13#120350, COLL14#120351, COLL15#120352, COLL16#120353, COLL17#120354, COLL18#120355, COLL19#120356]
(8) Project
Arguments: [COLL0#120337 AS ADRESSEUTILE_10412#120397, COLL1#120338 AS CODECOMMUNE_10413#120398, COLL2#120339 AS CODEPOSTAL_10414#120399, cast(from_json(ArrayType(StringType,false), COLL4#120341, Some(Etc/UTC)) as array<string>) AS CODESPARCELLES_10416#120417, COLL3#120340 AS CODEVOIE_10415#120401, COLL5#120342 AS DESTINATIONPRIN_10417#120402, COLL6#120343 AS ID_10418#120403, COLL7#120344 AS LIBELLEACHEMINE_10419#120404, COLL8#120345 AS MEILLEUREPOSITI_10420#120405, COLL9#120346 AS NOMCOMMUNE_10421#120406, COLL11#120348 AS NOMVOIEFANTOIR_10423#120407, COLL12#120349 AS NOMVOIEORIGINAL_10424#120408, COLL13#120350 AS NOMVOIETYPE_10425#120409, COLL10#120347 AS NOMVOIE_10422#120410, COLL15#120352 AS NUMEROCOMPLET_10427#120411, COLL14#120351 AS NUMERO_10426#120412, COLL16#120353 AS POSITIONS_10428#120413, COLL17#120354 AS PSEUDONUMERO_10429#120414, COLL18#120355 AS REPETITION_10430#120415, COLL19#120356 AS TAGS_10431#120416]
(9) Project
Arguments: [ADRESSEUTILE_10412#120397, CODECOMMUNE_10413#120398, CODEPOSTAL_10414#120399, CODESPARCELLES_10416#120417, CODEVOIE_10415#120401, DESTINATIONPRIN_10417#120402, ID_10418#120403, LIBELLEACHEMINE_10419#120404, MEILLEUREPOSITI_10420#120405, NOMCOMMUNE_10421#120406, NOMVOIEFANTOIR_10423#120407, NOMVOIEORIGINAL_10424#120408, NOMVOIETYPE_10425#120409, NOMVOIE_10422#120410, NUMEROCOMPLET_10427#120411, NUMERO_10426#120412, POSITIONS_10428#120413, PSEUDONUMERO_10429#120414, REPETITION_10430#120415, TAGS_10431#120416, get_json_object(MEILLEUREPOSITI_10420#120405, cast($.geometry.coordinates[1] as string)) AS COORDINATES_10433#120438, get_json_object(MEILLEUREPOSITI_10420#120405, cast($.geometry.coordinates[0] as string)) AS LONGITUDE_10434#120439]