== Physical Plan ==
AdaptiveSparkPlan (44)
+- == Final Plan ==
Execute InsertIntoHadoopFsRelationCommand (3)
+- WriteFiles (2)
+- LocalTableScan (1)
+- == Initial Plan ==
Execute InsertIntoHadoopFsRelationCommand (43)
+- WriteFiles (42)
+- Project (41)
+- Generate (40)
+- Project (39)
+- Project (38)
+- Project (37)
+- SortMergeJoin Inner (36)
:- Sort (30)
: +- Project (29)
: +- Project (28)
: +- ObjectHashAggregate (27)
: +- Exchange (26)
: +- ObjectHashAggregate (25)
: +- Project (24)
: +- SortMergeJoin LeftOuter (23)
: :- Sort (17)
: : +- Exchange (16)
: : +- Project (15)
: : +- CartesianProduct Inner (14)
: : :- CartesianProduct Inner (10)
: : : :- Project (6)
: : : : +- Filter (5)
: : : : +- Scan parquet (4)
: : : +- Project (9)
: : : +- Filter (8)
: : : +- Scan csv (7)
: : +- Project (13)
: : +- Filter (12)
: : +- Scan csv (11)
: +- Sort (22)
: +- Exchange (21)
: +- Project (20)
: +- Filter (19)
: +- Scan parquet (18)
+- Sort (35)
+- Exchange (34)
+- Project (33)
+- Filter (32)
+- Scan parquet (31)
(1) LocalTableScan
Output [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#638190, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#638430, COL_D6EF6DFC_79A6_470E_BA52_073402820059#638305, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#638432, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#638287]
Arguments: <empty>, [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#638190, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#638430, COL_D6EF6DFC_79A6_470E_BA52_073402820059#638305, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#638432, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#638287]
(2) WriteFiles
Input [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#638190, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#638430, COL_D6EF6DFC_79A6_470E_BA52_073402820059#638305, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#638432, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#638287]
(3) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR7_SUN_SUF_188384, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR7_SUN_SUF_188384], Overwrite, [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247, COL_680B8808_CA1F_43BB_9FD6_545FE101582E, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE, COL_D6EF6DFC_79A6_470E_BA52_073402820059, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24]
(4) Scan parquet
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#636533, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#636535, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#636570, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#636581]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_188400]
PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990:string,COL_60F0AF6F_D3F7_485E_B349_92A30BE52743:string,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A:string>
(5) Filter
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#636533, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#636535, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#636570, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#636581]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#636533)
(6) Project
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#636533 AS COL_DB984266_CA2D_46A3_97EF_B562B2758847#636912, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#636535 AS COL_332A283C_1564_41E0_AC8C_5944B976139C#636914, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#636570 AS COL_C6711610_DFEE_4846_8053_60113001EF1E#636947, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#636581 AS COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#636949]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#636533, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#636535, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#636570, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#636581]
(7) Scan csv
Output [2]: [REGLES#636426, APPLICABLE#636427]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_187903/REGLES-A-TTT new BESANCON 050226.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUF-SUN), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>
(8) Filter
Input [2]: [REGLES#636426, APPLICABLE#636427]
Condition : ((isnotnull(REGLES#636426) AND (RC-SUF-SUN = REGLES#636426)) AND (APPLICABLE#636427 <=> O))
(9) Project
Output: []
Input [2]: [REGLES#636426, APPLICABLE#636427]
(10) CartesianProduct
Join type: Inner
Join condition: None
(11) Scan csv
Output [1]: [REGLES#637080]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_187903/REGLES-A-TTT new BESANCON 050226.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUN-AUTO)]
ReadSchema: struct<REGLES:string>
(12) Filter
Input [1]: [REGLES#637080]
Condition : (isnotnull(REGLES#637080) AND (RC-SUN-AUTO = REGLES#637080))
(13) Project
Output [1]: [REGLES#637080 AS REGLES_A_APPLIQ_188031_REGLES_188032#637077]
Input [1]: [REGLES#637080]
(14) CartesianProduct
Join type: Inner
Join condition: None
(15) Project
Output [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#636912, COL_332A283C_1564_41E0_AC8C_5944B976139C#636914, COL_C6711610_DFEE_4846_8053_60113001EF1E#636947, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#636949, REGLES_A_APPLIQ_188031_REGLES_188032#637077 AS COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#637284]
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#636912, COL_332A283C_1564_41E0_AC8C_5944B976139C#636914, COL_C6711610_DFEE_4846_8053_60113001EF1E#636947, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#636949, REGLES_A_APPLIQ_188031_REGLES_188032#637077]
(16) Exchange
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#636912, COL_332A283C_1564_41E0_AC8C_5944B976139C#636914, COL_C6711610_DFEE_4846_8053_60113001EF1E#636947, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#636949, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#637284]
Arguments: hashpartitioning(COL_332A283C_1564_41E0_AC8C_5944B976139C#636914, 10), ENSURE_REQUIREMENTS, [plan_id=399635]
(17) Sort
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#636912, COL_332A283C_1564_41E0_AC8C_5944B976139C#636914, COL_C6711610_DFEE_4846_8053_60113001EF1E#636947, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#636949, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#637284]
Arguments: [COL_332A283C_1564_41E0_AC8C_5944B976139C#636914 ASC NULLS FIRST], false, 0
(18) Scan parquet
Output [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#636525, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#636527]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_G_ACTES_AUTO_188217]
PushedFilters: [IsNotNull(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D)]
ReadSchema: struct<COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D:string,COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3:string>
(19) Filter
Input [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#636525, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#636527]
Condition : isnotnull(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#636525)
(20) Project
Output [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#636525 AS 00_G_ACTES_AUTO_188217_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#637329, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#636527 AS 00_G_ACTES_AUTO_188217_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#637331]
Input [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#636525, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#636527]
(21) Exchange
Input [2]: [00_G_ACTES_AUTO_188217_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#637329, 00_G_ACTES_AUTO_188217_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#637331]
Arguments: hashpartitioning(00_G_ACTES_AUTO_188217_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#637329, 10), ENSURE_REQUIREMENTS, [plan_id=399636]
(22) Sort
Input [2]: [00_G_ACTES_AUTO_188217_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#637329, 00_G_ACTES_AUTO_188217_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#637331]
Arguments: [00_G_ACTES_AUTO_188217_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#637329 ASC NULLS FIRST], false, 0
(23) SortMergeJoin
Left keys [1]: [COL_332A283C_1564_41E0_AC8C_5944B976139C#636914]
Right keys [1]: [00_G_ACTES_AUTO_188217_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#637329]
Join type: LeftOuter
Join condition: None
(24) Project
Output [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#636912, str_if_with_rule((COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#637284 <=> RC-SUN-AUTO), 00_G_ACTES_AUTO_188217_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#637331, COL_C6711610_DFEE_4846_8053_60113001EF1E#636947) AS COL_C6711610_DFEE_4846_8053_60113001EF1E#637730, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#636949]
Input [7]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#636912, COL_332A283C_1564_41E0_AC8C_5944B976139C#636914, COL_C6711610_DFEE_4846_8053_60113001EF1E#636947, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#636949, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#637284, 00_G_ACTES_AUTO_188217_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#637329, 00_G_ACTES_AUTO_188217_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#637331]
(25) ObjectHashAggregate
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#636912, COL_C6711610_DFEE_4846_8053_60113001EF1E#637730, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#636949]
Keys [1]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#636912]
Functions [2]: [partial_collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#637730, 0, 0), partial_collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#636949, 0, 0)]
Aggregate Attributes [2]: [buf#638164, buf#638586]
Results [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#636912, buf#638166, buf#638587]
(26) Exchange
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#636912, buf#638166, buf#638587]
Arguments: hashpartitioning(COL_DB984266_CA2D_46A3_97EF_B562B2758847#636912, 10), ENSURE_REQUIREMENTS, [plan_id=399643]
(27) ObjectHashAggregate
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#636912, buf#638166, buf#638587]
Keys [1]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#636912]
Functions [2]: [collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#637730, 0, 0), collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#636949, 0, 0)]
Aggregate Attributes [2]: [collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#637730, 0, 0)#637797, collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#636949, 0, 0)#637799]
Results [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#636912 AS COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#637730, 0, 0)#637797 AS COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#637824, collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#636949, 0, 0)#637799 AS COL_0C310DCD_05AD_4BBA_8349_158B28256935#637825]
(28) Project
Output [4]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#637824, COL_0C310DCD_05AD_4BBA_8349_158B28256935#637825, str_list_get(COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#637824, 0) AS COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#637843]
Input [3]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#637824, COL_0C310DCD_05AD_4BBA_8349_158B28256935#637825]
(29) Project
Output [5]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, str_if_with_rule((NOT (COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#637843 <=> ) AND isnotnull(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#637843)), str_extract_by_str(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#637843, !, LEFT), null) AS COL_151BF080_3A49_4756_B3C3_4D50864EA325#637880, str_extract_by_str(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#637843, !, RIGHT) AS COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#637881, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#637824, COL_0C310DCD_05AD_4BBA_8349_158B28256935#637825]
Input [4]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#637824, COL_0C310DCD_05AD_4BBA_8349_158B28256935#637825, COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#637843]
(30) Sort
Input [5]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_151BF080_3A49_4756_B3C3_4D50864EA325#637880, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#637881, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#637824, COL_0C310DCD_05AD_4BBA_8349_158B28256935#637825]
Arguments: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822 ASC NULLS FIRST], false, 0
(31) Scan parquet
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#636460, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#636464, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#636484]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_188182]
PushedFilters: [IsNotNull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8)]
ReadSchema: struct<COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8:string,COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5:string>
(32) Filter
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#636460, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#636464, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#636484]
Condition : isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#636464)
(33) Project
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#636460 AS 03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#637931, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#636464 AS 03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#637935, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#636484 AS 03_PIVOT_INFORM_188182_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#637955]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#636460, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#636464, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#636484]
(34) Exchange
Input [3]: [03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#637931, 03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#637935, 03_PIVOT_INFORM_188182_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#637955]
Arguments: hashpartitioning(03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#637935, 10), ENSURE_REQUIREMENTS, [plan_id=399649]
(35) Sort
Input [3]: [03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#637931, 03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#637935, 03_PIVOT_INFORM_188182_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#637955]
Arguments: [03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#637935 ASC NULLS FIRST], false, 0
(36) SortMergeJoin
Left keys [1]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822]
Right keys [1]: [03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#637935]
Join type: Inner
Join condition: ((size(str_split(str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(str_if_with_rule(NOT (03_PIVOT_INFORM_188182_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#637955 <=> ), str_extract_by_str(03_PIVOT_INFORM_188182_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#637955, !, LEFT), null)), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#637880)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#637880), array(str_if_with_rule(NOT (03_PIVOT_INFORM_188182_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#637955 <=> ), str_extract_by_str(03_PIVOT_INFORM_188182_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#637955, !, LEFT), null))), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,), ,), true) > 0) AND isnotnull(str_split(str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(str_if_with_rule(NOT (03_PIVOT_INFORM_188182_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#637955 <=> ), str_extract_by_str(03_PIVOT_INFORM_188182_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#637955, !, LEFT), null)), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#637880)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#637880), array(str_if_with_rule(NOT (03_PIVOT_INFORM_188182_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#637955 <=> ), str_extract_by_str(03_PIVOT_INFORM_188182_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#637955, !, LEFT), null))), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,), ,)))
(37) Project
Output [9]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_151BF080_3A49_4756_B3C3_4D50864EA325#637880, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#637881, 03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#637931 AS COL_680B8808_CA1F_43BB_9FD6_545FE101582E#638190, 03_PIVOT_INFORM_188182_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#637955 AS COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#638191, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#637824, COL_0C310DCD_05AD_4BBA_8349_158B28256935#637825, str_if_with_rule(NOT (03_PIVOT_INFORM_188182_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#637955 <=> ), str_extract_by_str(03_PIVOT_INFORM_188182_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#637955, !, LEFT), null) AS COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#638204, str_extract_by_str(03_PIVOT_INFORM_188182_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#637955, !, RIGHT) AS COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#638215]
Input [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_151BF080_3A49_4756_B3C3_4D50864EA325#637880, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#637881, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#637824, COL_0C310DCD_05AD_4BBA_8349_158B28256935#637825, 03_PIVOT_INFORM_188182_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#637931, 03_PIVOT_INFORM_188182_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#637935, 03_PIVOT_INFORM_188182_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#637955]
(38) Project
Output [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#637881, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#638190, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#638191, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#637824, COL_0C310DCD_05AD_4BBA_8349_158B28256935#637825, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#638215, str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#638204), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#637880)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#637880), array(COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#638204)), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,) AS COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#638256]
Input [9]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_151BF080_3A49_4756_B3C3_4D50864EA325#637880, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#637881, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#638190, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#638191, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#637824, COL_0C310DCD_05AD_4BBA_8349_158B28256935#637825, COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#638204, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#638215]
(39) Project
Output [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#637881, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#638190, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#638215, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#638256, str_split(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#638256, ,) AS COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#638271, str_join(array(str_join(array(str_remove_extend(str_list_as_str(COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#637824), [[,],,]), Déduit des Infos Patient), ), str_join(array(Présent dans le RSF , COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#638191), ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_0C310DCD_05AD_4BBA_8349_158B28256935#637825)), : )), - ) AS COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#638287]
Input [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#637881, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#638190, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#638191, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#637824, COL_0C310DCD_05AD_4BBA_8349_158B28256935#637825, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#638215, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#638256]
(40) Generate
Input [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#637881, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#638190, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#638215, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#638256, COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#638271, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#638287]
Arguments: explode(COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#638271), [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#637881, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#638190, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#638215, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#638256, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#638287], false, [COL_D6EF6DFC_79A6_470E_BA52_073402820059#638305]
(41) Project
Output [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#638190, str_create(RC-SUF-SUN) AS COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#638430, COL_D6EF6DFC_79A6_470E_BA52_073402820059#638305, str_if_with_rule(CASE WHEN isnull(Contains(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#638256, ,)) THEN false ELSE Contains(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#638256, ,) END, str_concat(array(Switch de forfait , COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#638256, @, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#638215)), str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#638305, -)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#638305, -) END, str_concat(array(Suppression de Forfait@, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#638215)), str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#638305, +)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#638305, +) END, str_concat(array(Ajout de forfait@, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#637881)), null))) AS COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#638432, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#638287]
Input [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#637881, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#638190, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#638215, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#638256, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#638287, COL_D6EF6DFC_79A6_470E_BA52_073402820059#638305]
(42) WriteFiles
Input [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#637822, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#638190, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#638430, COL_D6EF6DFC_79A6_470E_BA52_073402820059#638305, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#638432, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#638287]
(43) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR7_SUN_SUF_188384, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR7_SUN_SUF_188384], Overwrite, [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247, COL_680B8808_CA1F_43BB_9FD6_545FE101582E, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE, COL_D6EF6DFC_79A6_470E_BA52_073402820059, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24]
(44) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true