== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (13)
+- SubqueryAlias (12)
+- View (11)
+- Project (10)
+- Filter (9)
+- Project (8)
+- Project (7)
+- Project (6)
+- SubqueryAlias (5)
+- View (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `tmp_7da268f023934c11937cf78b46cb5da3`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [CR_ANNONCE_437424#235980, CR_CHKSUM_DIC_437407#235981, CR_CODACC_437377#235982, CR_CODCLI_437387#235983, CR_CODDCR_437354#235984, CR_CODDIC_437342#235985, CR_CODDMP_437412#235986, CR_CODFRA_437391#235987, CR_CODMAIL_437410#235988, CR_CODMCR_437374#235989, CR_CODSEC_437348#235990, CR_CODSIT_437361#235991, CR_CODSUP_437364#235992, CR_CODUTI_437359#235993, CR_CODVCR_437351#235994, CR_CONTEXT_437343#235995, CR_CR_437338#235996, CR_DATCRE_437426#235997, CR_DATDCR_437355#235998, CR_DATDIC_437344#235999, CR_DATDMP_437413#236000, CR_DATMAIL_437408#236001, CR_DATMAJ_437360#236002, CR_DATMCR_437375#236003, ... 84 more fields], false
(4) View
Arguments: `H_CR_43732496`, true
(5) SubqueryAlias
Arguments: H_CR_43732496
(6) Project
Arguments: [CR_ANNONCE_437424#235980 AS H_CR_437324_CR_ANNONCE_437424#236304, CR_CHKSUM_DIC_437407#235981 AS H_CR_437324_CR_CHKSUM_DIC_437407#236305, CR_CODACC_437377#235982 AS H_CR_437324_CR_CODACC_437377#236306, CR_CODCLI_437387#235983 AS H_CR_437324_CR_CODCLI_437387#236307, CR_CODDCR_437354#235984 AS H_CR_437324_CR_CODDCR_437354#236308, CR_CODDIC_437342#235985 AS H_CR_437324_CR_CODDIC_437342#236309, CR_CODDMP_437412#235986 AS H_CR_437324_CR_CODDMP_437412#236310, CR_CODFRA_437391#235987 AS H_CR_437324_CR_CODFRA_437391#236311, CR_CODMAIL_437410#235988 AS H_CR_437324_CR_CODMAIL_437410#236312, CR_CODMCR_437374#235989 AS H_CR_437324_CR_CODMCR_437374#236313, CR_CODSEC_437348#235990 AS H_CR_437324_CR_CODSEC_437348#236314, CR_CODSIT_437361#235991 AS H_CR_437324_CR_CODSIT_437361#236315, CR_CODSUP_437364#235992 AS H_CR_437324_CR_CODSUP_437364#236316, CR_CODUTI_437359#235993 AS H_CR_437324_CR_CODUTI_437359#236317, CR_CODVCR_437351#235994 AS H_CR_437324_CR_CODVCR_437351#236318, CR_CONTEXT_437343#235995 AS H_CR_437324_CR_CONTEXT_437343#236319, CR_CR_437338#235996 AS H_CR_437324_CR_CR_437338#236320, CR_DATCRE_437426#235997 AS H_CR_437324_CR_DATCRE_437426#236321, CR_DATDCR_437355#235998 AS H_CR_437324_CR_DATDCR_437355#236322, CR_DATDIC_437344#235999 AS H_CR_437324_CR_DATDIC_437344#236323, CR_DATDMP_437413#236000 AS H_CR_437324_CR_DATDMP_437413#236324, CR_DATMAIL_437408#236001 AS H_CR_437324_CR_DATMAIL_437408#236325, CR_DATMAJ_437360#236002 AS H_CR_437324_CR_DATMAJ_437360#236326, CR_DATMCR_437375#236003 AS H_CR_437324_CR_DATMCR_437375#236327, ... 84 more fields]
(7) Project
Arguments: [cast(H_CR_437324_CR_NUMCR_437325#236370 as string) AS COL_29272194_C362_4B1A_871B_827530BCD34B#236628, cast(H_CR_437324_CR_NUMDOS_437326#236373 as string) AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#236629, cast(H_CR_437324_CR_NOMDIC_437327#236367 as string) AS COL_426404CB_5141_4F89_A6D8_45BDAAD29767#236630, cast(H_CR_437324_CR_NUMDEM_437328#236372 as string) AS COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#236631, cast(H_CR_437324_CR_NUMEXA_437329#236375 as string) AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#236632, cast(H_CR_437324_CR_TYPDOC_437330#236410 as string) AS COL_B9580440_50FB_4495_B82E_8046068EB218#236633, cast(H_CR_437324_CR_PRIOR_437331#236384 as string) AS COL_4906EFC1_6283_4227_936D_FFA86F51D118#236634, cast(H_CR_437324_CR_NOMDCR_437332#236366 as string) AS COL_087DC335_6719_4B78_B354_10A3D546B347#236635, cast(H_CR_437324_CR_TAIDCR_437333#236406 as string) AS COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#236636, cast(H_CR_437324_CR_DURDCR_437334#236337 as string) AS COL_9948D838_C98E_45C6_B06D_4A5089BDB788#236637, cast(H_CR_437324_CR_POSDCR_437335#236383 as string) AS COL_68E5CA5B_6601_4383_B215_E0B451D6EF1B#236638, cast(H_CR_437324_CR_NOMDOS_437336#236368 as string) AS COL_FA993954_05FA_428A_9A75_26EE63771B33#236639, cast(H_CR_437324_CR_FOR_CR_437337#236344 as string) AS COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#236640, cast(H_CR_437324_CR_CR_437338#236320 as string) AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#236641, cast(H_CR_437324_CR_STATDIC_437339#236394 as string) AS COL_75FEDF69_BA17_4AA6_976E_A0F3985CA619#236642, cast(H_CR_437324_CR_STATSM_437340#236395 as string) AS COL_25396BDB_9D90_4A89_944C_16346A2ED7D9#236643, cast(H_CR_437324_CR_STATCR_437341#236393 as string) AS COL_92EB8AE2_90FF_40E1_BC8E_173BA36EC527#236644, cast(H_CR_437324_CR_CODDIC_437342#236309 as string) AS COL_A171C73F_B8B7_45A2_BC8C_4F4B7EEFFA36#236645, cast(H_CR_437324_CR_CONTEXT_437343#236319 as string) AS COL_D25E2FE8_97F0_4187_B2B7_411271E5D1B6#236646, cast(H_CR_437324_CR_DATDIC_437344#236323 as string) AS COL_463770C2_2C33_4B95_B15F_D7B37A8131B5#236647, cast(H_CR_437324_CR_HEUDIC_437345#236347 as string) AS COL_2E150A55_3FB1_4504_B276_2AEBD757E8EF#236648, cast(H_CR_437324_CR_HEUI_D_437346#236349 as string) AS COL_0CF4A180_3079_498D_8767_92B0BE1B3FB9#236649, cast(H_CR_437324_CR_HEUI_F_437347#236350 as string) AS COL_806B65DB_DDCA_48E9_97A4_7B564D74437E#236650, cast(H_CR_437324_CR_CODSEC_437348#236314 as string) AS COL_3A8ABE6D_5A31_4E24_86D1_24198E29F274#236651, ... 84 more fields]
(8) Project
Arguments: [COL_29272194_C362_4B1A_871B_827530BCD34B#236628 AS COL_29272194_C362_4B1A_871B_827530BCD34B#236844, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#236629 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#236845, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#236630 AS COL_426404CB_5141_4F89_A6D8_45BDAAD29767#236846, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#236631 AS COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#236847, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#236632 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#236848, COL_B9580440_50FB_4495_B82E_8046068EB218#236633 AS COL_B9580440_50FB_4495_B82E_8046068EB218#236849, COL_4906EFC1_6283_4227_936D_FFA86F51D118#236634 AS COL_4906EFC1_6283_4227_936D_FFA86F51D118#236850, COL_087DC335_6719_4B78_B354_10A3D546B347#236635 AS COL_087DC335_6719_4B78_B354_10A3D546B347#236851, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#236636 AS COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#236852, COL_9948D838_C98E_45C6_B06D_4A5089BDB788#236637 AS COL_9948D838_C98E_45C6_B06D_4A5089BDB788#236853, COL_68E5CA5B_6601_4383_B215_E0B451D6EF1B#236638 AS COL_68E5CA5B_6601_4383_B215_E0B451D6EF1B#236854, COL_FA993954_05FA_428A_9A75_26EE63771B33#236639 AS COL_FA993954_05FA_428A_9A75_26EE63771B33#236855, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#236640 AS COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#236856, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#236641 AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#236857, COL_75FEDF69_BA17_4AA6_976E_A0F3985CA619#236642 AS COL_75FEDF69_BA17_4AA6_976E_A0F3985CA619#236858, COL_25396BDB_9D90_4A89_944C_16346A2ED7D9#236643 AS COL_25396BDB_9D90_4A89_944C_16346A2ED7D9#236859, COL_92EB8AE2_90FF_40E1_BC8E_173BA36EC527#236644 AS COL_92EB8AE2_90FF_40E1_BC8E_173BA36EC527#236860, COL_A171C73F_B8B7_45A2_BC8C_4F4B7EEFFA36#236645 AS COL_A171C73F_B8B7_45A2_BC8C_4F4B7EEFFA36#236861, COL_D25E2FE8_97F0_4187_B2B7_411271E5D1B6#236646 AS COL_D25E2FE8_97F0_4187_B2B7_411271E5D1B6#236862, COL_463770C2_2C33_4B95_B15F_D7B37A8131B5#236647 AS COL_463770C2_2C33_4B95_B15F_D7B37A8131B5#236863, COL_2E150A55_3FB1_4504_B276_2AEBD757E8EF#236648 AS COL_2E150A55_3FB1_4504_B276_2AEBD757E8EF#236864, COL_0CF4A180_3079_498D_8767_92B0BE1B3FB9#236649 AS COL_0CF4A180_3079_498D_8767_92B0BE1B3FB9#236865, COL_806B65DB_DDCA_48E9_97A4_7B564D74437E#236650 AS COL_806B65DB_DDCA_48E9_97A4_7B564D74437E#236866, COL_3A8ABE6D_5A31_4E24_86D1_24198E29F274#236651 AS COL_3A8ABE6D_5A31_4E24_86D1_24198E29F274#236867, ... 84 more fields]
(9) Filter
Arguments: NOT (COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#236857 <=> cast([NULL] as string))
(10) Project
Arguments: [COL_29272194_C362_4B1A_871B_827530BCD34B#236844 AS COL_29272194_C362_4B1A_871B_827530BCD34B#237060, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#236845 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#237061, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#236846 AS COL_426404CB_5141_4F89_A6D8_45BDAAD29767#237062, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#236847 AS COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#237063, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#236848 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#237064, COL_B9580440_50FB_4495_B82E_8046068EB218#236849 AS COL_B9580440_50FB_4495_B82E_8046068EB218#237065, COL_4906EFC1_6283_4227_936D_FFA86F51D118#236850 AS COL_4906EFC1_6283_4227_936D_FFA86F51D118#237066, COL_087DC335_6719_4B78_B354_10A3D546B347#236851 AS COL_087DC335_6719_4B78_B354_10A3D546B347#237067, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#236852 AS COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#237068, COL_FA993954_05FA_428A_9A75_26EE63771B33#236855 AS COL_FA993954_05FA_428A_9A75_26EE63771B33#237069, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#236856 AS COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#237070, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#236857 AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#237071]
(11) View
Arguments: `H_CR_43849996`, true
(12) SubqueryAlias
Arguments: H_CR_43849996
(13) Project
Arguments: [COL_426404CB_5141_4F89_A6D8_45BDAAD29767#237062, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#237070, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#237068, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#237061, COL_FA993954_05FA_428A_9A75_26EE63771B33#237069, COL_4906EFC1_6283_4227_936D_FFA86F51D118#237066, COL_087DC335_6719_4B78_B354_10A3D546B347#237067, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#237063, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#237071, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#237064, COL_B9580440_50FB_4495_B82E_8046068EB218#237065, COL_29272194_C362_4B1A_871B_827530BCD34B#237060]