== Parsed Logical Plan ==
InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/BASE_INSEE_PERS_21802, false, Parquet, [path=file:///data/output/cache/parquet/datablock/BASE_INSEE_PERS_21802], Overwrite, [COL_6335C019_5574_4384_9DF0_52A3633FA003, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55, COL_FE9C9A74_804A_455A_8730_A79C680C46FA, COL_E841813D_AC74_4154_9681_2401BF551CEB, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2, COL_894EC6EE_C475_4057_9220_CD3490C6C246, COL_BE212348_11C6_412B_A80B_97C0091C8459, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99, COL_B9C166B6_7C93_44BB_B249_608260D22E08, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3, COL_043C0997_E848_48D4_A718_CB0593090678, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2, COL_B829870E_F72A_4AB4_B459_5E652FDB6B94, COL_D12C726C_7641_4F64_93D3_B32FD2A5044A]
+- Repartition 10, true
+- Project [COL_6335C019_5574_4384_9DF0_52A3633FA003#14512 AS COL_6335C019_5574_4384_9DF0_52A3633FA003#14697, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513 AS COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14698, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514 AS COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14699, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515 AS COL_E841813D_AC74_4154_9681_2401BF551CEB#14700, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516 AS COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14701, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517 AS COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14702, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518 AS COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14703, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519 AS COL_894EC6EE_C475_4057_9220_CD3490C6C246#14704, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520 AS COL_BE212348_11C6_412B_A80B_97C0091C8459#14705, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521 AS COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14706, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522 AS COL_B9C166B6_7C93_44BB_B249_608260D22E08#14707, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535 AS COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14708, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549 AS COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14709, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14564 AS COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14710, COL_043C0997_E848_48D4_A718_CB0593090678#14580 AS COL_043C0997_E848_48D4_A718_CB0593090678#14711, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#14597 AS COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#14712, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#14615 AS COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#14713, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#14634 AS COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#14714, COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#14654 AS COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#14715, COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#14675 AS COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#14716]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14564, COL_043C0997_E848_48D4_A718_CB0593090678#14580, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#14597, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#14615, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#14634, COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#14654, str_concat(struct(col1, str_extract(COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, cast(RIGHT as string), cast(2 as bigint)), col2, cast(/ as string), col3, str_extract_by_index(COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, cast(4 as int), cast(6 as int)), col4, cast(/ as string), col5, str_extract(COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, cast(LEFT as string), cast(4 as bigint)))) AS COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#14675]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14564, COL_043C0997_E848_48D4_A718_CB0593090678#14580, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#14597, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#14615, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#14634, str_concat(struct(col1, str_extract(COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, cast(RIGHT as string), cast(2 as bigint)), col2, cast(/ as string), col3, str_extract_by_index(COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, cast(4 as int), cast(6 as int)), col4, cast(/ as string), col5, str_extract(COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, cast(LEFT as string), cast(4 as bigint)))) AS COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#14654]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14564, COL_043C0997_E848_48D4_A718_CB0593090678#14580, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#14597, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#14615, str_extract(COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, cast(LEFT as string), cast(1 as bigint)) AS COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#14634]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14564, COL_043C0997_E848_48D4_A718_CB0593090678#14580, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#14597, str_extract(COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, cast(LEFT as string), cast(1 as bigint)) AS COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#14615]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14564, COL_043C0997_E848_48D4_A718_CB0593090678#14580, str_if_with_rule(NOT CASE WHEN isnull(StartsWith(COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, cast(97 as string))) THEN false ELSE StartsWith(COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, cast(97 as string)) END, str_extract(COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, cast(LEFT as string), cast(2 as bigint)), str_extract(COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, cast(LEFT as string), cast(3 as bigint))) AS COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#14597]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14564, str_if_with_rule(NOT CASE WHEN isnull(StartsWith(COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, cast(97 as string))) THEN false ELSE StartsWith(COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, cast(97 as string)) END, str_extract(COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, cast(LEFT as string), cast(2 as bigint)), str_extract(COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, cast(LEFT as string), cast(3 as bigint))) AS COL_043C0997_E848_48D4_A718_CB0593090678#14580]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549, size(COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, true) AS COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14564]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, str_list_get(COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, cast(1 as bigint)) AS COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, str_list_get(COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, cast(0 as bigint)) AS COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14487 AS COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14488 AS COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14489 AS COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14490 AS COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14491 AS COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14492 AS COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14493 AS COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14494 AS COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14495 AS COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14496 AS COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14497 AS COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14498 AS COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522]
+- Project [cast(BASE_INSEE_PERS_21778_LIGNE_INSEE_21779#14451 as string) AS COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14487, cast(BASE_INSEE_PERS_21778_NOM_NAISSANCE_21780#14452 as string) AS COL_6335C019_5574_4384_9DF0_52A3633FA003#14488, cast(BASE_INSEE_PERS_21778_PRENOM_S_21781#14453 as string) AS COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14489, cast(BASE_INSEE_PERS_21778_SEXE_21782#14454 as string) AS COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14490, cast(BASE_INSEE_PERS_21778_DATE_NAISSANCE_21783#14455 as string) AS COL_E841813D_AC74_4154_9681_2401BF551CEB#14491, cast(BASE_INSEE_PERS_21778_LIEU_NAISSANCE__21784#14456 as string) AS COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14492, cast(BASE_INSEE_PERS_21778_COMMUNE_NAISSAN_21785#14457 as string) AS COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14493, cast(BASE_INSEE_PERS_21778_PAYS_NAISSANCE_21786#14458 as string) AS COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14494, cast(BASE_INSEE_PERS_21778_DATE_DECES_21787#14459 as string) AS COL_894EC6EE_C475_4057_9220_CD3490C6C246#14495, cast(BASE_INSEE_PERS_21778_LIEU_DECES_CP_21788#14460 as string) AS COL_BE212348_11C6_412B_A80B_97C0091C8459#14496, cast(BASE_INSEE_PERS_21778_N_ACTE_DECES_21789#14461 as string) AS COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14497, cast(BASE_INSEE_PERS_21778_LISTE_PRENOM_21790#14462 as array<string>) AS COL_B9C166B6_7C93_44BB_B249_608260D22E08#14498]
+- Project [LIGNE_INSEE_21779#14415 AS BASE_INSEE_PERS_21778_LIGNE_INSEE_21779#14451, NOM_NAISSANCE_21780#14416 AS BASE_INSEE_PERS_21778_NOM_NAISSANCE_21780#14452, PRENOM_S_21781#14417 AS BASE_INSEE_PERS_21778_PRENOM_S_21781#14453, SEXE_21782#14418 AS BASE_INSEE_PERS_21778_SEXE_21782#14454, DATE_NAISSANCE_21783#14419 AS BASE_INSEE_PERS_21778_DATE_NAISSANCE_21783#14455, LIEU_NAISSANCE__21784#14420 AS BASE_INSEE_PERS_21778_LIEU_NAISSANCE__21784#14456, COMMUNE_NAISSAN_21785#14421 AS BASE_INSEE_PERS_21778_COMMUNE_NAISSAN_21785#14457, PAYS_NAISSANCE_21786#14422 AS BASE_INSEE_PERS_21778_PAYS_NAISSANCE_21786#14458, DATE_DECES_21787#14423 AS BASE_INSEE_PERS_21778_DATE_DECES_21787#14459, LIEU_DECES_CP_21788#14424 AS BASE_INSEE_PERS_21778_LIEU_DECES_CP_21788#14460, N_ACTE_DECES_21789#14425 AS BASE_INSEE_PERS_21778_N_ACTE_DECES_21789#14461, LISTE_PRENOM_21790#14426 AS BASE_INSEE_PERS_21778_LISTE_PRENOM_21790#14462]
+- SubqueryAlias BASE_INSEE_PERS_21778114
+- Relation[LIGNE_INSEE_21779#14415,NOM_NAISSANCE_21780#14416,PRENOM_S_21781#14417,SEXE_21782#14418,DATE_NAISSANCE_21783#14419,LIEU_NAISSANCE__21784#14420,COMMUNE_NAISSAN_21785#14421,PAYS_NAISSANCE_21786#14422,DATE_DECES_21787#14423,LIEU_DECES_CP_21788#14424,N_ACTE_DECES_21789#14425,LISTE_PRENOM_21790#14426] parquet
== Analyzed Logical Plan ==
InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/BASE_INSEE_PERS_21802, false, Parquet, [path=file:///data/output/cache/parquet/datablock/BASE_INSEE_PERS_21802], Overwrite, [COL_6335C019_5574_4384_9DF0_52A3633FA003, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55, COL_FE9C9A74_804A_455A_8730_A79C680C46FA, COL_E841813D_AC74_4154_9681_2401BF551CEB, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2, COL_894EC6EE_C475_4057_9220_CD3490C6C246, COL_BE212348_11C6_412B_A80B_97C0091C8459, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99, COL_B9C166B6_7C93_44BB_B249_608260D22E08, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3, COL_043C0997_E848_48D4_A718_CB0593090678, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2, COL_B829870E_F72A_4AB4_B459_5E652FDB6B94, COL_D12C726C_7641_4F64_93D3_B32FD2A5044A]
+- Repartition 10, true
+- Project [COL_6335C019_5574_4384_9DF0_52A3633FA003#14512 AS COL_6335C019_5574_4384_9DF0_52A3633FA003#14697, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513 AS COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14698, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514 AS COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14699, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515 AS COL_E841813D_AC74_4154_9681_2401BF551CEB#14700, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516 AS COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14701, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517 AS COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14702, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518 AS COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14703, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519 AS COL_894EC6EE_C475_4057_9220_CD3490C6C246#14704, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520 AS COL_BE212348_11C6_412B_A80B_97C0091C8459#14705, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521 AS COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14706, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522 AS COL_B9C166B6_7C93_44BB_B249_608260D22E08#14707, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535 AS COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14708, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549 AS COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14709, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14564 AS COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14710, COL_043C0997_E848_48D4_A718_CB0593090678#14580 AS COL_043C0997_E848_48D4_A718_CB0593090678#14711, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#14597 AS COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#14712, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#14615 AS COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#14713, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#14634 AS COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#14714, COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#14654 AS COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#14715, COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#14675 AS COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#14716]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14564, COL_043C0997_E848_48D4_A718_CB0593090678#14580, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#14597, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#14615, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#14634, COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#14654, str_concat(struct(col1, str_extract(COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, cast(RIGHT as string), cast(2 as bigint)), col2, cast(/ as string), col3, str_extract_by_index(COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, cast(4 as int), cast(6 as int)), col4, cast(/ as string), col5, str_extract(COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, cast(LEFT as string), cast(4 as bigint)))) AS COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#14675]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14564, COL_043C0997_E848_48D4_A718_CB0593090678#14580, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#14597, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#14615, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#14634, str_concat(struct(col1, str_extract(COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, cast(RIGHT as string), cast(2 as bigint)), col2, cast(/ as string), col3, str_extract_by_index(COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, cast(4 as int), cast(6 as int)), col4, cast(/ as string), col5, str_extract(COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, cast(LEFT as string), cast(4 as bigint)))) AS COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#14654]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14564, COL_043C0997_E848_48D4_A718_CB0593090678#14580, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#14597, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#14615, str_extract(COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, cast(LEFT as string), cast(1 as bigint)) AS COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#14634]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14564, COL_043C0997_E848_48D4_A718_CB0593090678#14580, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#14597, str_extract(COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, cast(LEFT as string), cast(1 as bigint)) AS COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#14615]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14564, COL_043C0997_E848_48D4_A718_CB0593090678#14580, str_if_with_rule(NOT CASE WHEN isnull(StartsWith(COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, cast(97 as string))) THEN false ELSE StartsWith(COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, cast(97 as string)) END, str_extract(COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, cast(LEFT as string), cast(2 as bigint)), str_extract(COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, cast(LEFT as string), cast(3 as bigint))) AS COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#14597]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14564, str_if_with_rule(NOT CASE WHEN isnull(StartsWith(COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, cast(97 as string))) THEN false ELSE StartsWith(COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, cast(97 as string)) END, str_extract(COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, cast(LEFT as string), cast(2 as bigint)), str_extract(COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, cast(LEFT as string), cast(3 as bigint))) AS COL_043C0997_E848_48D4_A718_CB0593090678#14580]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549, size(COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, true) AS COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14564]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535, str_list_get(COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, cast(1 as bigint)) AS COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14549]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, str_list_get(COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522, cast(0 as bigint)) AS COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14535]
+- Project [COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14487 AS COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14511, COL_6335C019_5574_4384_9DF0_52A3633FA003#14488 AS COL_6335C019_5574_4384_9DF0_52A3633FA003#14512, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14489 AS COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14513, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14490 AS COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14514, COL_E841813D_AC74_4154_9681_2401BF551CEB#14491 AS COL_E841813D_AC74_4154_9681_2401BF551CEB#14515, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14492 AS COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14516, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14493 AS COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14517, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14494 AS COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14518, COL_894EC6EE_C475_4057_9220_CD3490C6C246#14495 AS COL_894EC6EE_C475_4057_9220_CD3490C6C246#14519, COL_BE212348_11C6_412B_A80B_97C0091C8459#14496 AS COL_BE212348_11C6_412B_A80B_97C0091C8459#14520, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14497 AS COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14521, COL_B9C166B6_7C93_44BB_B249_608260D22E08#14498 AS COL_B9C166B6_7C93_44BB_B249_608260D22E08#14522]
+- Project [cast(BASE_INSEE_PERS_21778_LIGNE_INSEE_21779#14451 as string) AS COL_6BBFA7C7_F6CC_49B6_AD8A_FFCB311D339E#14487, cast(BASE_INSEE_PERS_21778_NOM_NAISSANCE_21780#14452 as string) AS COL_6335C019_5574_4384_9DF0_52A3633FA003#14488, cast(BASE_INSEE_PERS_21778_PRENOM_S_21781#14453 as string) AS COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14489, cast(BASE_INSEE_PERS_21778_SEXE_21782#14454 as string) AS COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14490, cast(BASE_INSEE_PERS_21778_DATE_NAISSANCE_21783#14455 as string) AS COL_E841813D_AC74_4154_9681_2401BF551CEB#14491, cast(BASE_INSEE_PERS_21778_LIEU_NAISSANCE__21784#14456 as string) AS COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14492, cast(BASE_INSEE_PERS_21778_COMMUNE_NAISSAN_21785#14457 as string) AS COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14493, cast(BASE_INSEE_PERS_21778_PAYS_NAISSANCE_21786#14458 as string) AS COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14494, cast(BASE_INSEE_PERS_21778_DATE_DECES_21787#14459 as string) AS COL_894EC6EE_C475_4057_9220_CD3490C6C246#14495, cast(BASE_INSEE_PERS_21778_LIEU_DECES_CP_21788#14460 as string) AS COL_BE212348_11C6_412B_A80B_97C0091C8459#14496, cast(BASE_INSEE_PERS_21778_N_ACTE_DECES_21789#14461 as string) AS COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14497, cast(BASE_INSEE_PERS_21778_LISTE_PRENOM_21790#14462 as array<string>) AS COL_B9C166B6_7C93_44BB_B249_608260D22E08#14498]
+- Project [LIGNE_INSEE_21779#14415 AS BASE_INSEE_PERS_21778_LIGNE_INSEE_21779#14451, NOM_NAISSANCE_21780#14416 AS BASE_INSEE_PERS_21778_NOM_NAISSANCE_21780#14452, PRENOM_S_21781#14417 AS BASE_INSEE_PERS_21778_PRENOM_S_21781#14453, SEXE_21782#14418 AS BASE_INSEE_PERS_21778_SEXE_21782#14454, DATE_NAISSANCE_21783#14419 AS BASE_INSEE_PERS_21778_DATE_NAISSANCE_21783#14455, LIEU_NAISSANCE__21784#14420 AS BASE_INSEE_PERS_21778_LIEU_NAISSANCE__21784#14456, COMMUNE_NAISSAN_21785#14421 AS BASE_INSEE_PERS_21778_COMMUNE_NAISSAN_21785#14457, PAYS_NAISSANCE_21786#14422 AS BASE_INSEE_PERS_21778_PAYS_NAISSANCE_21786#14458, DATE_DECES_21787#14423 AS BASE_INSEE_PERS_21778_DATE_DECES_21787#14459, LIEU_DECES_CP_21788#14424 AS BASE_INSEE_PERS_21778_LIEU_DECES_CP_21788#14460, N_ACTE_DECES_21789#14425 AS BASE_INSEE_PERS_21778_N_ACTE_DECES_21789#14461, LISTE_PRENOM_21790#14426 AS BASE_INSEE_PERS_21778_LISTE_PRENOM_21790#14462]
+- SubqueryAlias BASE_INSEE_PERS_21778114
+- Relation[LIGNE_INSEE_21779#14415,NOM_NAISSANCE_21780#14416,PRENOM_S_21781#14417,SEXE_21782#14418,DATE_NAISSANCE_21783#14419,LIEU_NAISSANCE__21784#14420,COMMUNE_NAISSAN_21785#14421,PAYS_NAISSANCE_21786#14422,DATE_DECES_21787#14423,LIEU_DECES_CP_21788#14424,N_ACTE_DECES_21789#14425,LISTE_PRENOM_21790#14426] parquet
== Optimized Logical Plan ==
InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/BASE_INSEE_PERS_21802, false, Parquet, [path=file:///data/output/cache/parquet/datablock/BASE_INSEE_PERS_21802], Overwrite, [COL_6335C019_5574_4384_9DF0_52A3633FA003, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55, COL_FE9C9A74_804A_455A_8730_A79C680C46FA, COL_E841813D_AC74_4154_9681_2401BF551CEB, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2, COL_894EC6EE_C475_4057_9220_CD3490C6C246, COL_BE212348_11C6_412B_A80B_97C0091C8459, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99, COL_B9C166B6_7C93_44BB_B249_608260D22E08, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3, COL_043C0997_E848_48D4_A718_CB0593090678, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2, COL_B829870E_F72A_4AB4_B459_5E652FDB6B94, COL_D12C726C_7641_4F64_93D3_B32FD2A5044A]
+- Repartition 10, true
+- Project [NOM_NAISSANCE_21780#14416 AS COL_6335C019_5574_4384_9DF0_52A3633FA003#14697, PRENOM_S_21781#14417 AS COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14698, SEXE_21782#14418 AS COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14699, DATE_NAISSANCE_21783#14419 AS COL_E841813D_AC74_4154_9681_2401BF551CEB#14700, LIEU_NAISSANCE__21784#14420 AS COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14701, COMMUNE_NAISSAN_21785#14421 AS COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14702, PAYS_NAISSANCE_21786#14422 AS COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14703, DATE_DECES_21787#14423 AS COL_894EC6EE_C475_4057_9220_CD3490C6C246#14704, LIEU_DECES_CP_21788#14424 AS COL_BE212348_11C6_412B_A80B_97C0091C8459#14705, N_ACTE_DECES_21789#14425 AS COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14706, LISTE_PRENOM_21790#14426 AS COL_B9C166B6_7C93_44BB_B249_608260D22E08#14707, str_list_get(LISTE_PRENOM_21790#14426, 0) AS COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14708, str_list_get(LISTE_PRENOM_21790#14426, 1) AS COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14709, size(LISTE_PRENOM_21790#14426, true) AS COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14710, str_if_with_rule(NOT CASE WHEN isnull(StartsWith(LIEU_DECES_CP_21788#14424, 97)) THEN false ELSE StartsWith(LIEU_DECES_CP_21788#14424, 97) END, str_extract(LIEU_DECES_CP_21788#14424, LEFT, 2), str_extract(LIEU_DECES_CP_21788#14424, LEFT, 3)) AS COL_043C0997_E848_48D4_A718_CB0593090678#14711, str_if_with_rule(NOT CASE WHEN isnull(StartsWith(LIEU_NAISSANCE__21784#14420, 97)) THEN false ELSE StartsWith(LIEU_NAISSANCE__21784#14420, 97) END, str_extract(LIEU_NAISSANCE__21784#14420, LEFT, 2), str_extract(LIEU_NAISSANCE__21784#14420, LEFT, 3)) AS COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#14712, str_extract(NOM_NAISSANCE_21780#14416, LEFT, 1) AS COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#14713, str_extract(str_list_get(LISTE_PRENOM_21790#14426, 0), LEFT, 1) AS COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#14714, str_concat(struct(col1, str_extract(DATE_NAISSANCE_21783#14419, RIGHT, 2), col2, /, col3, str_extract_by_index(DATE_NAISSANCE_21783#14419, 4, 6), col4, /, col5, str_extract(DATE_NAISSANCE_21783#14419, LEFT, 4))) AS COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#14715, str_concat(struct(col1, str_extract(DATE_DECES_21787#14423, RIGHT, 2), col2, /, col3, str_extract_by_index(DATE_DECES_21787#14423, 4, 6), col4, /, col5, str_extract(DATE_DECES_21787#14423, LEFT, 4))) AS COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#14716]
+- Relation[LIGNE_INSEE_21779#14415,NOM_NAISSANCE_21780#14416,PRENOM_S_21781#14417,SEXE_21782#14418,DATE_NAISSANCE_21783#14419,LIEU_NAISSANCE__21784#14420,COMMUNE_NAISSAN_21785#14421,PAYS_NAISSANCE_21786#14422,DATE_DECES_21787#14423,LIEU_DECES_CP_21788#14424,N_ACTE_DECES_21789#14425,LISTE_PRENOM_21790#14426] parquet
== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/BASE_INSEE_PERS_21802, false, Parquet, [path=file:///data/output/cache/parquet/datablock/BASE_INSEE_PERS_21802], Overwrite, [COL_6335C019_5574_4384_9DF0_52A3633FA003, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55, COL_FE9C9A74_804A_455A_8730_A79C680C46FA, COL_E841813D_AC74_4154_9681_2401BF551CEB, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2, COL_894EC6EE_C475_4057_9220_CD3490C6C246, COL_BE212348_11C6_412B_A80B_97C0091C8459, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99, COL_B9C166B6_7C93_44BB_B249_608260D22E08, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3, COL_043C0997_E848_48D4_A718_CB0593090678, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2, COL_B829870E_F72A_4AB4_B459_5E652FDB6B94, COL_D12C726C_7641_4F64_93D3_B32FD2A5044A]
+- AdaptiveSparkPlan isFinalPlan=true
+- ShuffleQueryStage 0
+- Exchange RoundRobinPartitioning(10), false, [id=#1310]
+- *(1) Project [NOM_NAISSANCE_21780#14416 AS COL_6335C019_5574_4384_9DF0_52A3633FA003#14697, PRENOM_S_21781#14417 AS COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#14698, SEXE_21782#14418 AS COL_FE9C9A74_804A_455A_8730_A79C680C46FA#14699, DATE_NAISSANCE_21783#14419 AS COL_E841813D_AC74_4154_9681_2401BF551CEB#14700, LIEU_NAISSANCE__21784#14420 AS COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#14701, COMMUNE_NAISSAN_21785#14421 AS COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#14702, PAYS_NAISSANCE_21786#14422 AS COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#14703, DATE_DECES_21787#14423 AS COL_894EC6EE_C475_4057_9220_CD3490C6C246#14704, LIEU_DECES_CP_21788#14424 AS COL_BE212348_11C6_412B_A80B_97C0091C8459#14705, N_ACTE_DECES_21789#14425 AS COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#14706, LISTE_PRENOM_21790#14426 AS COL_B9C166B6_7C93_44BB_B249_608260D22E08#14707, str_list_get(LISTE_PRENOM_21790#14426, 0) AS COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#14708, str_list_get(LISTE_PRENOM_21790#14426, 1) AS COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#14709, size(LISTE_PRENOM_21790#14426, true) AS COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#14710, str_if_with_rule(NOT CASE WHEN isnull(StartsWith(LIEU_DECES_CP_21788#14424, 97)) THEN false ELSE StartsWith(LIEU_DECES_CP_21788#14424, 97) END, str_extract(LIEU_DECES_CP_21788#14424, LEFT, 2), str_extract(LIEU_DECES_CP_21788#14424, LEFT, 3)) AS COL_043C0997_E848_48D4_A718_CB0593090678#14711, str_if_with_rule(NOT CASE WHEN isnull(StartsWith(LIEU_NAISSANCE__21784#14420, 97)) THEN false ELSE StartsWith(LIEU_NAISSANCE__21784#14420, 97) END, str_extract(LIEU_NAISSANCE__21784#14420, LEFT, 2), str_extract(LIEU_NAISSANCE__21784#14420, LEFT, 3)) AS COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#14712, str_extract(NOM_NAISSANCE_21780#14416, LEFT, 1) AS COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#14713, str_extract(str_list_get(LISTE_PRENOM_21790#14426, 0), LEFT, 1) AS COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#14714, str_concat(struct(col1, str_extract(DATE_NAISSANCE_21783#14419, RIGHT, 2), col2, /, col3, str_extract_by_index(DATE_NAISSANCE_21783#14419, 4, 6), col4, /, col5, str_extract(DATE_NAISSANCE_21783#14419, LEFT, 4))) AS COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#14715, str_concat(struct(col1, str_extract(DATE_DECES_21787#14423, RIGHT, 2), col2, /, col3, str_extract_by_index(DATE_DECES_21787#14423, 4, 6), col4, /, col5, str_extract(DATE_DECES_21787#14423, LEFT, 4))) AS COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#14716]
+- FileScan parquet [NOM_NAISSANCE_21780#14416,PRENOM_S_21781#14417,SEXE_21782#14418,DATE_NAISSANCE_21783#14419,LIEU_NAISSANCE__21784#14420,COMMUNE_NAISSAN_21785#14421,PAYS_NAISSANCE_21786#14422,DATE_DECES_21787#14423,LIEU_DECES_CP_21788#14424,N_ACTE_DECES_21789#14425,LISTE_PRENOM_21790#14426] Batched: false, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/uet/BASE_INSEE_PERS_21778], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<NOM_NAISSANCE_21780:string,PRENOM_S_21781:string,SEXE_21782:string,DATE_NAISSANCE_21783:st...
