== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (47)
+- Project (46)
+- Join (45)
:- Project (32)
: +- Project (31)
: +- Project (30)
: +- Aggregate (29)
: +- Project (28)
: +- Project (27)
: +- Project (26)
: +- Project (25)
: +- Project (24)
: +- Project (23)
: +- Window (22)
: +- Project (21)
: +- Project (20)
: +- Project (19)
: +- Project (18)
: +- Project (17)
: +- Project (16)
: +- Project (15)
: +- Project (14)
: +- Project (13)
: +- Project (12)
: +- Project (11)
: +- Generate (10)
: +- Project (9)
: +- Project (8)
: +- Project (7)
: +- Project (6)
: +- SubqueryAlias (5)
: +- View (4)
: +- LogicalRelation (3)
+- Project (44)
+- SubqueryAlias (43)
+- View (42)
+- Project (41)
+- Project (40)
+- SubqueryAlias (39)
+- View (38)
+- Project (37)
+- Project (36)
+- Project (35)
+- Project (34)
+- LogicalRelation (33)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `PHRASE_DU_DOCUM_331619173`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [_FICHIER#121177, _NOM_DE_FICHIER#121178], false
(4) View
Arguments: `DOCUMENT_331395173`, true
(5) SubqueryAlias
Arguments: DOCUMENT_331395173
(6) Project
Arguments: [_FICHIER#121177 AS DOCUMENT_331395__FICHIER#121246, _NOM_DE_FICHIER#121178 AS DOCUMENT_331395__NOM_DE_FICHIER#121247]
(7) Project
Arguments: [cast(DOCUMENT_331395__NOM_DE_FICHIER#121247 as string) AS COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121252, cast(DOCUMENT_331395__FICHIER#121246 as binary) AS COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121253]
(8) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121252 AS COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121256, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121253 AS COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121257]
(9) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121256, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121257, from_json(ArrayType(StringType,false), to_json(bin_content_words(cast(pdf as string), COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121257), Some(Etc/UTC)), Some(Etc/UTC)) AS COL_8D79A787_F26C_4B94_A6EC_8189C5CE45A2#121260]
(10) Generate
Arguments: explode(COL_8D79A787_F26C_4B94_A6EC_8189C5CE45A2#121260), false, [COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121265]
(11) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121256, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121257, COL_8D79A787_F26C_4B94_A6EC_8189C5CE45A2#121260, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121265]
(12) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121256, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121257, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121265]
(13) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121256 AS COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121273, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121257 AS COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121274, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121265 AS COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121275]
(14) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121273 AS COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121279, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121274 AS COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121280, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121275 AS COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121281]
(15) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121279, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121280, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121281, get_json_object(COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121281, cast($.term as string)) AS COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121285]
(16) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121279, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121280, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121281, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121285, str_to_integer(get_json_object(COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121281, cast($.term_number_in_text as string))) AS COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121290]
(17) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121279, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121280, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121281, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121285, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121290, str_to_integer(get_json_object(COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121281, cast($.sentence_number_in_text as string))) AS COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121296]
(18) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121279 AS COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121303, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121280 AS COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121304, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121281 AS COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121305, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121285 AS COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121306, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121290 AS COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121307, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121296 AS COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121308]
(19) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121303 AS COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121315, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121304 AS COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121316, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121305 AS COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121317, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121306 AS COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121318, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121307 AS COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121319, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121308 AS COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121320]
(20) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121315, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121316, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121317, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121318, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121319, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121320, 1 AS CONST#121329]
(21) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121315, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121316, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121317, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121318, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121319, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121320, CONST#121329, ARRAY_TO_STR_BEFORE_CONCAT(COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121318) AS _w0#121341]
(22) Window
Arguments: [concatwithseparatorudaf(_w0#121341, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@1cc8a327, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121315, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121320, CONST#121329 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#121340], [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121315, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121320], [CONST#121329 DESC NULLS LAST]
(23) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121315, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121316, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121317, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121318, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121319, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121320, CONST#121329, _w0#121341, COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#121340, COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#121340]
(24) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121315, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121316, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121317, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121318, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121319, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121320, CONST#121329, COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#121340]
(25) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121315, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121316, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121317, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121318, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121319, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121320, COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#121340]
(26) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121315 AS COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121372, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121316 AS COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121373, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121317 AS COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121374, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121318 AS COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121375, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121319 AS COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121376, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121320 AS COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121377, COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#121340 AS COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#121378]
(27) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121372 AS COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121386, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121373 AS COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121387, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121374 AS COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121388, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121375 AS COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121389, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121376 AS COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121390, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121377 AS COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121391, COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#121378 AS COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#121392]
(28) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121386, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121387, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121388, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121389, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121390, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121391, COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#121392, str_replace(COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#121392, cast(| as string), cast( as string)) AS COL_5DA9DDDB_6754_457A_8DB5_E5924C9A8467#121400]
(29) Aggregate
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121386, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121391, COL_5DA9DDDB_6754_457A_8DB5_E5924C9A8467#121400], [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121386 AS COL_5CE86268_8E19_4A53_9935_985331F31B08#121409, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121391 AS COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#121410, COL_5DA9DDDB_6754_457A_8DB5_E5924C9A8467#121400 AS COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#121411, 1 AS NULL_1#121420]
(30) Project
Arguments: [COL_5CE86268_8E19_4A53_9935_985331F31B08#121409, COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#121410, COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#121411]
(31) Project
Arguments: [COL_5CE86268_8E19_4A53_9935_985331F31B08#121409 AS COL_5CE86268_8E19_4A53_9935_985331F31B08#121428, COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#121410 AS COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#121429, COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#121411 AS COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#121430]
(32) Project
Arguments: [COL_5CE86268_8E19_4A53_9935_985331F31B08#121428 AS COL_5CE86268_8E19_4A53_9935_985331F31B08#121434, COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#121429 AS COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#121435, COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#121430 AS COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#121436]
(33) LogicalRelation
Arguments: csv, [IPP#121198, Séjour#121199, Document#121200], false
(34) Project
Arguments: [IPP#121198 AS IPP#121207, Séjour#121199 AS Séjour#121208, Document#121200 AS Document#121209]
(35) Project
Arguments: [IPP#121207, Séjour#121208, Document#121209]
(36) Project
Arguments: [Document#121209 AS _DOCUMENT#121217, IPP#121207 AS _IPP#121218, Séjour#121208 AS _S_JOUR#121219]
(37) Project
Arguments: [_DOCUMENT#121217, _IPP#121218, _S_JOUR#121219]
(38) View
Arguments: `LISTE_DOCUMENT__331640173`, true
(39) SubqueryAlias
Arguments: LISTE_DOCUMENT__331640173
(40) Project
Arguments: [_DOCUMENT#121217 AS LISTE_DOCUMENT__331640__DOCUMENT#121229, _IPP#121218 AS LISTE_DOCUMENT__331640__IPP#121230, _S_JOUR#121219 AS LISTE_DOCUMENT__331640__S_JOUR#121231]
(41) Project
Arguments: [cast(LISTE_DOCUMENT__331640__IPP#121230 as string) AS COL_99D1E2E6_1B06_4D50_BFA1_BF45EFDDD5C0#121238, cast(LISTE_DOCUMENT__331640__S_JOUR#121231 as string) AS COL_7386F5B7_2029_4CD3_B486_A07376A49163#121239, cast(LISTE_DOCUMENT__331640__DOCUMENT#121229 as string) AS COL_3DE778B7_19E2_4C70_90F1_5EEA17EB280E#121240]
(42) View
Arguments: `DB_LISTE_DOCUME_331644173`, true
(43) SubqueryAlias
Arguments: DB_LISTE_DOCUME_331644173
(44) Project
Arguments: [COL_99D1E2E6_1B06_4D50_BFA1_BF45EFDDD5C0#121238 AS DB_LISTE_DOCUME_331644_COL_99D1E2E6_1B06_4D50_BFA1_BF45EFDDD5C0#121443, COL_7386F5B7_2029_4CD3_B486_A07376A49163#121239 AS DB_LISTE_DOCUME_331644_COL_7386F5B7_2029_4CD3_B486_A07376A49163#121444, COL_3DE778B7_19E2_4C70_90F1_5EEA17EB280E#121240 AS DB_LISTE_DOCUME_331644_COL_3DE778B7_19E2_4C70_90F1_5EEA17EB280E#121445]
(45) Join
Arguments: LeftOuter, (COL_5CE86268_8E19_4A53_9935_985331F31B08#121434 = DB_LISTE_DOCUME_331644_COL_3DE778B7_19E2_4C70_90F1_5EEA17EB280E#121445)
(46) Project
Arguments: [COL_5CE86268_8E19_4A53_9935_985331F31B08#121434, COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#121435, COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#121436, DB_LISTE_DOCUME_331644_COL_99D1E2E6_1B06_4D50_BFA1_BF45EFDDD5C0#121443 AS COL_059A9961_A986_4FC3_9A13_1F6D7DD97477#121461, DB_LISTE_DOCUME_331644_COL_7386F5B7_2029_4CD3_B486_A07376A49163#121444 AS COL_003E6CF8_51D5_425B_8AA5_01DDA0569C1C#121462]
(47) Project
Arguments: [COL_5CE86268_8E19_4A53_9935_985331F31B08#121434 AS COL_5CE86268_8E19_4A53_9935_985331F31B08#121468, COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#121435 AS COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#121469, COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#121436 AS COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#121470, COL_059A9961_A986_4FC3_9A13_1F6D7DD97477#121461 AS COL_059A9961_A986_4FC3_9A13_1F6D7DD97477#121471, COL_003E6CF8_51D5_425B_8AA5_01DDA0569C1C#121462 AS COL_003E6CF8_51D5_425B_8AA5_01DDA0569C1C#121472]