== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (16)
+- SubqueryAlias (15)
+- View (14)
+- Project (13)
+- Project (12)
+- Project (11)
+- Project (10)
+- Filter (9)
+- Project (8)
+- Project (7)
+- Project (6)
+- SubqueryAlias (5)
+- View (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `tmp_913ca869cd14473c8cc93f9c1576208f`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [_CODE_INSEE#2565, _DEPARTEMENT_CODE#2566, _DEPARTEMENT_NOM#2567, _EPCI_CODE#2568, _EPCI_NOM#2569, _NOM#2570, _REGION_CODE#2571, _REGION_NOM#2572], false
(4) View
Arguments: `ATMO_COMMUNE_264109167`, true
(5) SubqueryAlias
Arguments: ATMO_COMMUNE_264109167
(6) Project
Arguments: [_CODE_INSEE#2565 AS ATMO_COMMUNE_264109__CODE_INSEE#2589, _DEPARTEMENT_CODE#2566 AS ATMO_COMMUNE_264109__DEPARTEMENT_CODE#2590, _DEPARTEMENT_NOM#2567 AS ATMO_COMMUNE_264109__DEPARTEMENT_NOM#2591, _EPCI_CODE#2568 AS ATMO_COMMUNE_264109__EPCI_CODE#2592, _EPCI_NOM#2569 AS ATMO_COMMUNE_264109__EPCI_NOM#2593, _NOM#2570 AS ATMO_COMMUNE_264109__NOM#2594, _REGION_CODE#2571 AS ATMO_COMMUNE_264109__REGION_CODE#2595, _REGION_NOM#2572 AS ATMO_COMMUNE_264109__REGION_NOM#2596]
(7) Project
Arguments: [cast(ATMO_COMMUNE_264109__CODE_INSEE#2589 as string) AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#2613, cast(ATMO_COMMUNE_264109__DEPARTEMENT_CODE#2590 as string) AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#2614, cast(ATMO_COMMUNE_264109__DEPARTEMENT_NOM#2591 as string) AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#2615, cast(ATMO_COMMUNE_264109__EPCI_CODE#2592 as string) AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#2616, cast(ATMO_COMMUNE_264109__EPCI_NOM#2593 as string) AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#2617, cast(ATMO_COMMUNE_264109__NOM#2594 as string) AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#2618, cast(ATMO_COMMUNE_264109__REGION_CODE#2595 as string) AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#2619, cast(ATMO_COMMUNE_264109__REGION_NOM#2596 as string) AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#2620]
(8) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#2613 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#2629, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#2614 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#2630, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#2615 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#2631, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#2616 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#2632, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#2617 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#2633, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#2618 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#2634, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#2619 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#2635, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#2620 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#2636]
(9) Filter
Arguments: (COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#2629 <=> cast(38397 as string))
(10) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#2629 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#2645, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#2630 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#2646, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#2631 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#2647, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#2632 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#2648, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#2633 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#2649, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#2634 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#2650, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#2635 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#2651, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#2636 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#2652]
(11) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#2645 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#2661, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#2646 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#2662, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#2647 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#2663, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#2648 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#2664, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#2649 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#2665, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#2650 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#2666, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#2651 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#2667, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#2652 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#2668]
(12) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#2661, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#2662, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#2663, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#2664, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#2665, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#2666, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#2667, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#2668, http_get(str_join(array(cast(https://api.atmo-aura.fr/api/v1/communes/ as string), COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#2661, cast(/indices/atmo?api_token=df1f9022ccb116228552b54b45d14f70&date_calcul=now as string)), cast( as string))) AS COL_85A4A615_EB20_46BE_8D82_57672471139A#2677]
(13) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#2661 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#2687, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#2662 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#2688, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#2663 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#2689, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#2664 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#2690, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#2665 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#2691, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#2666 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#2692, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#2667 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#2693, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#2668 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#2694, COL_85A4A615_EB20_46BE_8D82_57672471139A#2677 AS COL_85A4A615_EB20_46BE_8D82_57672471139A#2695]
(14) View
Arguments: `ATMO_POLLUANT_264118167`, true
(15) SubqueryAlias
Arguments: ATMO_POLLUANT_264118167
(16) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#2687, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#2688, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#2689, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#2690, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#2691, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#2692, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#2693, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#2694, COL_85A4A615_EB20_46BE_8D82_57672471139A#2695]