== 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_331619167`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [_FICHIER#121762, _NOM_DE_FICHIER#121763], false
(4) View
Arguments: `DOCUMENT_331395167`, true
(5) SubqueryAlias
Arguments: DOCUMENT_331395167
(6) Project
Arguments: [_FICHIER#121762 AS DOCUMENT_331395__FICHIER#121939, _NOM_DE_FICHIER#121763 AS DOCUMENT_331395__NOM_DE_FICHIER#121940]
(7) Project
Arguments: [cast(DOCUMENT_331395__NOM_DE_FICHIER#121940 as string) AS COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121945, cast(DOCUMENT_331395__FICHIER#121939 as binary) AS COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121946]
(8) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121945 AS COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121949, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121946 AS COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121950]
(9) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121949, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121950, from_json(ArrayType(StringType,false), to_json(bin_content_words(cast(pdf as string), COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121950), Some(Etc/UTC)), Some(Etc/UTC)) AS COL_8D79A787_F26C_4B94_A6EC_8189C5CE45A2#121953]
(10) Generate
Arguments: explode(COL_8D79A787_F26C_4B94_A6EC_8189C5CE45A2#121953), false, [COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121958]
(11) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121949, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121950, COL_8D79A787_F26C_4B94_A6EC_8189C5CE45A2#121953, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121958]
(12) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121949, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121950, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121958]
(13) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121949 AS COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121966, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121950 AS COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121967, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121958 AS COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121968]
(14) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121966 AS COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121972, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121967 AS COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121973, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121968 AS COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121974]
(15) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121972, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121973, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121974, get_json_object(COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121974, cast($.term as string)) AS COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121978]
(16) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121972, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121973, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121974, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121978, str_to_integer(get_json_object(COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121974, cast($.term_number_in_text as string))) AS COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121983]
(17) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121972, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121973, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121974, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121978, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121983, str_to_integer(get_json_object(COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121974, cast($.sentence_number_in_text as string))) AS COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121989]
(18) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121972 AS COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121996, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121973 AS COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121997, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121974 AS COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121998, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121978 AS COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121999, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#121983 AS COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#122000, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#121989 AS COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122001]
(19) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#121996 AS COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#122008, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#121997 AS COL_42AC1384_F7C6_41DD_8140_F501F18025B6#122009, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#121998 AS COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#122010, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#121999 AS COL_D326E6FD_A618_4276_A1FA_F483C4A46298#122011, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#122000 AS COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#122012, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122001 AS COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122013]
(20) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#122008, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#122009, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#122010, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#122011, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#122012, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122013, 1 AS CONST#122022]
(21) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#122008, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#122009, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#122010, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#122011, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#122012, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122013, CONST#122022, ARRAY_TO_STR_BEFORE_CONCAT(COL_D326E6FD_A618_4276_A1FA_F483C4A46298#122011) AS _w0#122034]
(22) Window
Arguments: [concatwithseparatorudaf(_w0#122034, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@7e021d09, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#122008, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122013, CONST#122022 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#122033], [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#122008, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122013], [CONST#122022 DESC NULLS LAST]
(23) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#122008, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#122009, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#122010, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#122011, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#122012, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122013, CONST#122022, _w0#122034, COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#122033, COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#122033]
(24) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#122008, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#122009, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#122010, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#122011, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#122012, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122013, CONST#122022, COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#122033]
(25) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#122008, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#122009, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#122010, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#122011, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#122012, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122013, COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#122033]
(26) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#122008 AS COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#122065, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#122009 AS COL_42AC1384_F7C6_41DD_8140_F501F18025B6#122066, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#122010 AS COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#122067, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#122011 AS COL_D326E6FD_A618_4276_A1FA_F483C4A46298#122068, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#122012 AS COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#122069, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122013 AS COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122070, COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#122033 AS COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#122071]
(27) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#122065 AS COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#122079, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#122066 AS COL_42AC1384_F7C6_41DD_8140_F501F18025B6#122080, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#122067 AS COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#122081, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#122068 AS COL_D326E6FD_A618_4276_A1FA_F483C4A46298#122082, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#122069 AS COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#122083, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122070 AS COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122084, COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#122071 AS COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#122085]
(28) Project
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#122079, COL_42AC1384_F7C6_41DD_8140_F501F18025B6#122080, COL_4180689C_D343_4FC4_A328_E4E828A0E6CD#122081, COL_D326E6FD_A618_4276_A1FA_F483C4A46298#122082, COL_CE6812AD_4958_4FD2_9039_8EF20DF97CA7#122083, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122084, COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#122085, str_replace(COL_8CD8BD74_2A92_496E_A91B_AEC72D10ED2B#122085, cast(| as string), cast( as string)) AS COL_5DA9DDDB_6754_457A_8DB5_E5924C9A8467#122093]
(29) Aggregate
Arguments: [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#122079, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122084, COL_5DA9DDDB_6754_457A_8DB5_E5924C9A8467#122093], [COL_C5AAA034_D543_482D_838A_9EB70F8DF2A5#122079 AS COL_5CE86268_8E19_4A53_9935_985331F31B08#122102, COL_00E55315_0253_4512_A9A3_5A2E4A2B77AF#122084 AS COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#122103, COL_5DA9DDDB_6754_457A_8DB5_E5924C9A8467#122093 AS COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#122104, 1 AS NULL_1#122113]
(30) Project
Arguments: [COL_5CE86268_8E19_4A53_9935_985331F31B08#122102, COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#122103, COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#122104]
(31) Project
Arguments: [COL_5CE86268_8E19_4A53_9935_985331F31B08#122102 AS COL_5CE86268_8E19_4A53_9935_985331F31B08#122121, COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#122103 AS COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#122122, COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#122104 AS COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#122123]
(32) Project
Arguments: [COL_5CE86268_8E19_4A53_9935_985331F31B08#122121 AS COL_5CE86268_8E19_4A53_9935_985331F31B08#122127, COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#122122 AS COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#122128, COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#122123 AS COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#122129]
(33) LogicalRelation
Arguments: csv, [IPP#121885, Séjour#121886, Document#121887], false
(34) Project
Arguments: [IPP#121885 AS IPP#121894, Séjour#121886 AS Séjour#121895, Document#121887 AS Document#121896]
(35) Project
Arguments: [IPP#121894, Séjour#121895, Document#121896]
(36) Project
Arguments: [Document#121896 AS _DOCUMENT#121904, IPP#121894 AS _IPP#121905, Séjour#121895 AS _S_JOUR#121906]
(37) Project
Arguments: [_DOCUMENT#121904, _IPP#121905, _S_JOUR#121906]
(38) View
Arguments: `LISTE_DOCUMENT__331640167`, true
(39) SubqueryAlias
Arguments: LISTE_DOCUMENT__331640167
(40) Project
Arguments: [_DOCUMENT#121904 AS LISTE_DOCUMENT__331640__DOCUMENT#121919, _IPP#121905 AS LISTE_DOCUMENT__331640__IPP#121920, _S_JOUR#121906 AS LISTE_DOCUMENT__331640__S_JOUR#121921]
(41) Project
Arguments: [cast(LISTE_DOCUMENT__331640__IPP#121920 as string) AS COL_99D1E2E6_1B06_4D50_BFA1_BF45EFDDD5C0#121931, cast(LISTE_DOCUMENT__331640__S_JOUR#121921 as string) AS COL_7386F5B7_2029_4CD3_B486_A07376A49163#121932, cast(LISTE_DOCUMENT__331640__DOCUMENT#121919 as string) AS COL_3DE778B7_19E2_4C70_90F1_5EEA17EB280E#121933]
(42) View
Arguments: `DB_LISTE_DOCUME_331644167`, true
(43) SubqueryAlias
Arguments: DB_LISTE_DOCUME_331644167
(44) Project
Arguments: [COL_99D1E2E6_1B06_4D50_BFA1_BF45EFDDD5C0#121931 AS DB_LISTE_DOCUME_331644_COL_99D1E2E6_1B06_4D50_BFA1_BF45EFDDD5C0#122136, COL_7386F5B7_2029_4CD3_B486_A07376A49163#121932 AS DB_LISTE_DOCUME_331644_COL_7386F5B7_2029_4CD3_B486_A07376A49163#122137, COL_3DE778B7_19E2_4C70_90F1_5EEA17EB280E#121933 AS DB_LISTE_DOCUME_331644_COL_3DE778B7_19E2_4C70_90F1_5EEA17EB280E#122138]
(45) Join
Arguments: LeftOuter, (COL_5CE86268_8E19_4A53_9935_985331F31B08#122127 = DB_LISTE_DOCUME_331644_COL_3DE778B7_19E2_4C70_90F1_5EEA17EB280E#122138)
(46) Project
Arguments: [COL_5CE86268_8E19_4A53_9935_985331F31B08#122127, COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#122128, COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#122129, DB_LISTE_DOCUME_331644_COL_99D1E2E6_1B06_4D50_BFA1_BF45EFDDD5C0#122136 AS COL_059A9961_A986_4FC3_9A13_1F6D7DD97477#122154, DB_LISTE_DOCUME_331644_COL_7386F5B7_2029_4CD3_B486_A07376A49163#122137 AS COL_003E6CF8_51D5_425B_8AA5_01DDA0569C1C#122155]
(47) Project
Arguments: [COL_5CE86268_8E19_4A53_9935_985331F31B08#122127 AS COL_5CE86268_8E19_4A53_9935_985331F31B08#122161, COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#122128 AS COL_060C5BD6_3C1B_4348_8453_E2A220EA4E4D#122162, COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#122129 AS COL_8F3355B5_46DB_4ABF_BF70_D5B295BC12EC#122163, COL_059A9961_A986_4FC3_9A13_1F6D7DD97477#122154 AS COL_059A9961_A986_4FC3_9A13_1F6D7DD97477#122164, COL_003E6CF8_51D5_425B_8AA5_01DDA0569C1C#122155 AS COL_003E6CF8_51D5_425B_8AA5_01DDA0569C1C#122165]