== 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#531155, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#531536, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#531774, COL_D6EF6DFC_79A6_470E_BA52_073402820059#531649, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#531776, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#531631]
Arguments: <empty>, [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#531536, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#531774, COL_D6EF6DFC_79A6_470E_BA52_073402820059#531649, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#531776, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#531631]
(2) WriteFiles
Input [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#531536, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#531774, COL_D6EF6DFC_79A6_470E_BA52_073402820059#531649, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#531776, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#531631]
(3) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR7_SUN_SUF_225818, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR7_SUN_SUF_225818], 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#529791, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#529793, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#529828, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#529839]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_225863]
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#529791, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#529793, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#529828, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#529839]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#529791)
(6) Project
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#529791 AS COL_DB984266_CA2D_46A3_97EF_B562B2758847#530266, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#529793 AS COL_332A283C_1564_41E0_AC8C_5944B976139C#530268, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#529828 AS COL_C6711610_DFEE_4846_8053_60113001EF1E#530301, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#529839 AS COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#530303]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#529791, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#529793, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#529828, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#529839]
(7) Scan csv
Output [2]: [REGLES#529772, APPLICABLE#529773]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_225515/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUF-SUN), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>
(8) Filter
Input [2]: [REGLES#529772, APPLICABLE#529773]
Condition : ((isnotnull(REGLES#529772) AND (RC-SUF-SUN = REGLES#529772)) AND (APPLICABLE#529773 <=> O))
(9) Project
Output: []
Input [2]: [REGLES#529772, APPLICABLE#529773]
(10) CartesianProduct
Join type: Inner
Join condition: None
(11) Scan csv
Output [1]: [REGLES#530434]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_225515/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUN-AUTO)]
ReadSchema: struct<REGLES:string>
(12) Filter
Input [1]: [REGLES#530434]
Condition : (isnotnull(REGLES#530434) AND (RC-SUN-AUTO = REGLES#530434))
(13) Project
Output [1]: [REGLES#530434 AS REGLES_A_APPLIQ_225642_REGLES_225643#530431]
Input [1]: [REGLES#530434]
(14) CartesianProduct
Join type: Inner
Join condition: None
(15) Project
Output [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#530266, COL_332A283C_1564_41E0_AC8C_5944B976139C#530268, COL_C6711610_DFEE_4846_8053_60113001EF1E#530301, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#530303, REGLES_A_APPLIQ_225642_REGLES_225643#530431 AS COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#530640]
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#530266, COL_332A283C_1564_41E0_AC8C_5944B976139C#530268, COL_C6711610_DFEE_4846_8053_60113001EF1E#530301, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#530303, REGLES_A_APPLIQ_225642_REGLES_225643#530431]
(16) Exchange
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#530266, COL_332A283C_1564_41E0_AC8C_5944B976139C#530268, COL_C6711610_DFEE_4846_8053_60113001EF1E#530301, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#530303, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#530640]
Arguments: hashpartitioning(COL_332A283C_1564_41E0_AC8C_5944B976139C#530268, 10), ENSURE_REQUIREMENTS, [plan_id=323232]
(17) Sort
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#530266, COL_332A283C_1564_41E0_AC8C_5944B976139C#530268, COL_C6711610_DFEE_4846_8053_60113001EF1E#530301, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#530303, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#530640]
Arguments: [COL_332A283C_1564_41E0_AC8C_5944B976139C#530268 ASC NULLS FIRST], false, 0
(18) Scan parquet
Output [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#529985, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#529987]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_G_ACTES_AUTO_226072]
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#529985, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#529987]
Condition : isnotnull(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#529985)
(20) Project
Output [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#529985 AS 00_G_ACTES_AUTO_226072_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#530685, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#529987 AS 00_G_ACTES_AUTO_226072_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#530687]
Input [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#529985, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#529987]
(21) Exchange
Input [2]: [00_G_ACTES_AUTO_226072_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#530685, 00_G_ACTES_AUTO_226072_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#530687]
Arguments: hashpartitioning(00_G_ACTES_AUTO_226072_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#530685, 10), ENSURE_REQUIREMENTS, [plan_id=323233]
(22) Sort
Input [2]: [00_G_ACTES_AUTO_226072_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#530685, 00_G_ACTES_AUTO_226072_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#530687]
Arguments: [00_G_ACTES_AUTO_226072_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#530685 ASC NULLS FIRST], false, 0
(23) SortMergeJoin
Left keys [1]: [COL_332A283C_1564_41E0_AC8C_5944B976139C#530268]
Right keys [1]: [00_G_ACTES_AUTO_226072_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#530685]
Join type: LeftOuter
Join condition: None
(24) Project
Output [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#530266, str_if_with_rule((COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#530640 <=> RC-SUN-AUTO), 00_G_ACTES_AUTO_226072_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#530687, COL_C6711610_DFEE_4846_8053_60113001EF1E#530301) AS COL_C6711610_DFEE_4846_8053_60113001EF1E#531071, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#530303]
Input [7]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#530266, COL_332A283C_1564_41E0_AC8C_5944B976139C#530268, COL_C6711610_DFEE_4846_8053_60113001EF1E#530301, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#530303, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#530640, 00_G_ACTES_AUTO_226072_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#530685, 00_G_ACTES_AUTO_226072_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#530687]
(25) ObjectHashAggregate
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#530266, COL_C6711610_DFEE_4846_8053_60113001EF1E#531071, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#530303]
Keys [1]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#530266]
Functions [2]: [partial_collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#531071, 0, 0), partial_collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#530303, 0, 0)]
Aggregate Attributes [2]: [buf#531510, buf#531800]
Results [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#530266, buf#531512, buf#531801]
(26) Exchange
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#530266, buf#531512, buf#531801]
Arguments: hashpartitioning(COL_DB984266_CA2D_46A3_97EF_B562B2758847#530266, 10), ENSURE_REQUIREMENTS, [plan_id=323240]
(27) ObjectHashAggregate
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#530266, buf#531512, buf#531801]
Keys [1]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#530266]
Functions [2]: [collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#531071, 0, 0), collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#530303, 0, 0)]
Aggregate Attributes [2]: [collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#531071, 0, 0)#531137, collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#530303, 0, 0)#531139]
Results [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#530266 AS COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#531071, 0, 0)#531137 AS COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#531157, collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#530303, 0, 0)#531139 AS COL_0C310DCD_05AD_4BBA_8349_158B28256935#531158]
(28) Project
Output [4]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#531157, COL_0C310DCD_05AD_4BBA_8349_158B28256935#531158, str_list_get(COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#531157, 0) AS COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#531163]
Input [3]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#531157, COL_0C310DCD_05AD_4BBA_8349_158B28256935#531158]
(29) Project
Output [5]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, str_if_with_rule((NOT (COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#531163 <=> ) AND isnotnull(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#531163)), str_extract_by_str(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#531163, !, LEFT), null) AS COL_151BF080_3A49_4756_B3C3_4D50864EA325#531200, str_extract_by_str(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#531163, !, RIGHT) AS COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#531201, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#531157, COL_0C310DCD_05AD_4BBA_8349_158B28256935#531158]
Input [4]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#531157, COL_0C310DCD_05AD_4BBA_8349_158B28256935#531158, COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#531163]
(30) Sort
Input [5]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_151BF080_3A49_4756_B3C3_4D50864EA325#531200, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#531201, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#531157, COL_0C310DCD_05AD_4BBA_8349_158B28256935#531158]
Arguments: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155 ASC NULLS FIRST], false, 0
(31) Scan parquet
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#529903, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#529907, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#529927]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_225663]
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#529903, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#529907, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#529927]
Condition : isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#529907)
(33) Project
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#529903 AS 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#531249, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#529907 AS 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#531253, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#529927 AS 03_PIVOT_INFORM_225663_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#531273]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#529903, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#529907, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#529927]
(34) Exchange
Input [3]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#531249, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#531253, 03_PIVOT_INFORM_225663_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#531273]
Arguments: hashpartitioning(03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#531253, 10), ENSURE_REQUIREMENTS, [plan_id=323246]
(35) Sort
Input [3]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#531249, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#531253, 03_PIVOT_INFORM_225663_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#531273]
Arguments: [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#531253 ASC NULLS FIRST], false, 0
(36) SortMergeJoin
Left keys [1]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155]
Right keys [1]: [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#531253]
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_225663_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#531273 <=> ), str_extract_by_str(03_PIVOT_INFORM_225663_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#531273, !, LEFT), null)), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#531200)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#531200), array(str_if_with_rule(NOT (03_PIVOT_INFORM_225663_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#531273 <=> ), str_extract_by_str(03_PIVOT_INFORM_225663_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#531273, !, 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_225663_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#531273 <=> ), str_extract_by_str(03_PIVOT_INFORM_225663_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#531273, !, LEFT), null)), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#531200)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#531200), array(str_if_with_rule(NOT (03_PIVOT_INFORM_225663_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#531273 <=> ), str_extract_by_str(03_PIVOT_INFORM_225663_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#531273, !, LEFT), null))), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,), ,)))
(37) Project
Output [9]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_151BF080_3A49_4756_B3C3_4D50864EA325#531200, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#531201, 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#531249 AS COL_680B8808_CA1F_43BB_9FD6_545FE101582E#531536, 03_PIVOT_INFORM_225663_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#531273 AS COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#531537, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#531157, COL_0C310DCD_05AD_4BBA_8349_158B28256935#531158, str_if_with_rule(NOT (03_PIVOT_INFORM_225663_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#531273 <=> ), str_extract_by_str(03_PIVOT_INFORM_225663_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#531273, !, LEFT), null) AS COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#531550, str_extract_by_str(03_PIVOT_INFORM_225663_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#531273, !, RIGHT) AS COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#531561]
Input [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_151BF080_3A49_4756_B3C3_4D50864EA325#531200, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#531201, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#531157, COL_0C310DCD_05AD_4BBA_8349_158B28256935#531158, 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#531249, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#531253, 03_PIVOT_INFORM_225663_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#531273]
(38) Project
Output [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#531201, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#531536, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#531537, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#531157, COL_0C310DCD_05AD_4BBA_8349_158B28256935#531158, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#531561, str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#531550), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#531200)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#531200), array(COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#531550)), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,) AS COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#531600]
Input [9]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_151BF080_3A49_4756_B3C3_4D50864EA325#531200, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#531201, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#531536, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#531537, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#531157, COL_0C310DCD_05AD_4BBA_8349_158B28256935#531158, COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#531550, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#531561]
(39) Project
Output [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#531201, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#531536, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#531561, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#531600, str_split(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#531600, ,) AS COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#531615, str_join(array(str_join(array(str_remove_extend(str_list_as_str(COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#531157), [[,],,]), Déduit des Infos Patient), ), str_join(array(Présent dans le RSF , COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#531537), ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_0C310DCD_05AD_4BBA_8349_158B28256935#531158)), : )), - ) AS COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#531631]
Input [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#531201, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#531536, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#531537, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#531157, COL_0C310DCD_05AD_4BBA_8349_158B28256935#531158, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#531561, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#531600]
(40) Generate
Input [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#531201, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#531536, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#531561, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#531600, COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#531615, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#531631]
Arguments: explode(COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#531615), [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#531201, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#531536, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#531561, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#531600, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#531631], false, [COL_D6EF6DFC_79A6_470E_BA52_073402820059#531649]
(41) Project
Output [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#531536, str_create(RC-SUF-SUN) AS COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#531774, COL_D6EF6DFC_79A6_470E_BA52_073402820059#531649, str_if_with_rule(CASE WHEN isnull(Contains(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#531600, ,)) THEN false ELSE Contains(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#531600, ,) END, str_concat(array(Switch de forfait , COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#531600, @, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#531561)), str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#531649, -)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#531649, -) END, str_concat(array(Suppression de Forfait@, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#531561)), str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#531649, +)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#531649, +) END, str_concat(array(Ajout de forfait@, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#531201)), null))) AS COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#531776, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#531631]
Input [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#531201, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#531536, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#531561, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#531600, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#531631, COL_D6EF6DFC_79A6_470E_BA52_073402820059#531649]
(42) WriteFiles
Input [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#531155, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#531536, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#531774, COL_D6EF6DFC_79A6_470E_BA52_073402820059#531649, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#531776, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#531631]
(43) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR7_SUN_SUF_225818, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR7_SUN_SUF_225818], 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