hdh-spark-job - Details for Query 1392

Submitted Time: 2026/10/23 13:28:34
Duration: 0.9 s
Succeeded Jobs: 1388 1392

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" CollectLimit "]; 1 [labelType="html" label=" Union "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 14 ms"; 3 [labelType="html" label=" LocalLimit "]; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label="Filter number of output rows: 3"]; 6 [labelType="html" label="Scan JDBCRelation((SELECT \"xa_codexa\", \"xa_lib30\", \"xa_libuti\", \"xa_typexa\", \"xa_contra\", \"xa_durava\", \"xa_durpen\", \"xa_durapr\", \"xa_durtot\", \"xa_durmed\", \"xa_protoc\", \"xa_datmaj\", \"xa_coduti\", \"xa_codpro\", \"xa_coulstd\", \"xa_couleur\", \"xa_flmedobl\", \"xa_flatsobl\", \"xa_flvalplanif\", \"xa_flvalaccueil\", \"xa_nivvcr\", \"xa_flrtcclq\", \"xa_fllabochaud\", \"xa_datede\", \"xa_datefi\", \"xa_flgrpjour\", \"xa_primai\", \"xa_codpros\", \"xa_codconv\", \"xa_later\", \"xa_incidence\", \"xa_position\", \"xa_flgrve\", \"xa_flexainj\", \"xa_contrapat\", \"xa_flprore\", \"xa_flcacheinet\", \"xa_flnocot\", \"xa_codadm\", \"xa_flgrvi\", \"xa_reganas\", \"xa_flrecist\", \"xa_flnocr\", \"xa_icd\", \"xa_type_icd\", \"xa_flrecist_ec\", \"xa_codloinc\" FROM \"xplore\".\"h_examen\") as x) [numPartitions=1] number of output rows: 253"]; } subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 12 ms"; 8 [labelType="html" label=" LocalLimit "]; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="Filter number of output rows: 3"]; 11 [labelType="html" label="Scan JDBCRelation((SELECT \"xa_codexa\", \"xa_lib30\", \"xa_libuti\", \"xa_typexa\", \"xa_contra\", \"xa_durava\", \"xa_durpen\", \"xa_durapr\", \"xa_durtot\", \"xa_durmed\", \"xa_protoc\", \"xa_datmaj\", \"xa_coduti\", \"xa_codpro\", \"xa_coulstd\", \"xa_couleur\", \"xa_flmedobl\", \"xa_flatsobl\", \"xa_flvalplanif\", \"xa_flvalaccueil\", \"xa_nivvcr\", \"xa_flrtcclq\", \"xa_fllabochaud\", \"xa_datede\", \"xa_datefi\", \"xa_flgrpjour\", \"xa_primai\", \"xa_codpros\", \"xa_codconv\", \"xa_later\", \"xa_incidence\", \"xa_position\", \"xa_flgrve\", \"xa_flexainj\", \"xa_contrapat\", \"xa_flprore\", \"xa_flcacheinet\", \"xa_flnocot\", \"xa_codadm\", \"xa_flgrvi\", \"xa_reganas\", \"xa_flrecist\", \"xa_flnocr\", \"xa_icd\", \"xa_type_icd\", \"xa_flrecist_ec\", \"xa_codloinc\" FROM \"xplore2\".\"h_examen\") as x) [numPartitions=1] number of output rows: 253"]; } 1->0; 3->1; 4->3; 5->4; 6->5; 8->1; 9->8; 10->9; 11->10; }

CollectLimit 1500

Union

LocalLimit 1500

Project [xa_codexa#701858 AS COL_BA700E71_6183_4187_9746_E6A8BE8A7260#704007, xa_lib30#701859 AS COL_EE8557FB_1121_4390_B12D_B50C4CC1159D#704008, xa_libuti#701860 AS COL_07330D6D_FE7A_4A0A_BD48_05EFB77E3B27#704009, xa_typexa#701861 AS COL_E80B0007_06E9_466F_BC9D_091661288E44#704010, xa_contra#701862 AS COL_E280AE76_6FEE_49E1_B03C_7701314E077C#704011, xa_durava#701863 AS COL_1E4A86D9_E54A_43B8_976E_DC11FCB68FFA#704012, xa_durpen#701864 AS COL_CEAD91B9_04C8_4B15_8FD0_72E8CE977D80#704013, xa_durapr#701865 AS COL_895DD35A_8996_4280_9C3B_7530D6232E96#704014, xa_durtot#701866 AS COL_5828A643_05B1_4FCD_A4B4_DA5B6DA3E2C0#704015, xa_durmed#701867 AS COL_DA9C8942_A4E1_46CF_9F26_2F6CE49A1320#704016, xa_protoc#701868 AS COL_97B4380D_7B3D_4DC3_A02E_5E56125EBBB1#704017, xa_datmaj#701869 AS COL_B5481877_BD3F_48AB_9DEF_93A78A27393C#704018, xa_coduti#701870 AS COL_B158002F_104C_4016_880C_FE27BBC05539#704019, xa_codpro#701871 AS COL_C08E2596_A8A5_4BC4_BC1D_C0BD120F7110#704020, xa_coulstd#701872 AS COL_2FD80DAD_5192_402C_AD9A_073DEB7F7D84#704021, xa_couleur#701873 AS COL_3B4AAD4A_1631_4FC8_BCAB_8BE0FA7004AB#704022, xa_flmedobl#701874 AS COL_D2EA269F_AE55_4AE8_8E19_04BC8DFC944B#704023, xa_flatsobl#701875 AS COL_7E5CBC27_2DA5_4BA4_80A6_BC09226C994A#704024, xa_flvalplanif#701876 AS COL_57A3329B_E0A8_48E5_8730_ABE51BCDE12D#704025, xa_flvalaccueil#701877 AS COL_103CCD8E_76DE_4844_B5BC_3B4CD178D2A8#704026, xa_nivvcr#701878 AS COL_3BA92538_CCFB_452A_A9EC_27B8144B3005#704027, xa_flrtcclq#701879 AS COL_9BAAC44D_D351_4A8F_84CA_540A36209F8F#704028, xa_fllabochaud#701880 AS COL_488D4701_EFE7_46B9_A196_F7891A438661#704029, xa_datede#701881 AS COL_F3C34D17_6E02_4029_8C4C_973C47DEC6EE#704030, ... 24 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#701858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#701858)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#701859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#701859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#701860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#701860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#701861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#701861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#701862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#701862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#701863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#701863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#701864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#701864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#701865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#701865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#701866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#701866)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#701867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#701867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#701868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#701868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#701869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#701869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#701870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#701870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#701871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#701871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#701872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#701872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#701873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#701873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#701874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#701874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#701875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#701875)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#701876)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#701876)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#701877)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#701877)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#701878)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#701878)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#701879)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#701879)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#701880)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#701880)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#701881)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#701881)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#701882)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#701882)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#701883)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#701883)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#701884)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#701884)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#701885)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#701885)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#701886)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#701886)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#701887)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#701887)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#701888)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#701888)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#701889)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#701889)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#701890)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#701890)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#701891)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#701891)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#701892)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#701892)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#701893)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#701893)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#701894)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#701894)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#701895)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#701895)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#701896)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#701896)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#701897)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#701897)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#701898)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#701898)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#701899)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#701899)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#701900)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#701900)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#701901)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#701901)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#701902)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#701902)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#701903)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#701903)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#701904)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#701904)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN) END)

Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore"."h_examen") as x) [numPartitions=1] [xa_codexa#701858,xa_lib30#701859,xa_libuti#701860,xa_typexa#701861,xa_contra#701862,xa_durava#701863,xa_durpen#701864,xa_durapr#701865,xa_durtot#701866,xa_durmed#701867,xa_protoc#701868,xa_datmaj#701869,xa_coduti#701870,xa_codpro#701871,xa_coulstd#701872,xa_couleur#701873,xa_flmedobl#701874,xa_flatsobl#701875,xa_flvalplanif#701876,xa_flvalaccueil#701877,xa_nivvcr#701878,xa_flrtcclq#701879,xa_fllabochaud#701880,xa_datede#701881,... 23 more fields] PushedFilters: [], ReadSchema: struct<xa_codexa:string,xa_lib30:string,xa_libuti:string,xa_typexa:string,xa_contra:string,xa_dur...

WholeStageCodegen (1)

LocalLimit 1500

Project [xa_codexa#702759 AS COL_BA700E71_6183_4187_9746_E6A8BE8A7260#704202, xa_lib30#702760 AS COL_EE8557FB_1121_4390_B12D_B50C4CC1159D#704203, xa_libuti#702761 AS COL_07330D6D_FE7A_4A0A_BD48_05EFB77E3B27#704204, xa_typexa#702762 AS COL_E80B0007_06E9_466F_BC9D_091661288E44#704205, xa_contra#702763 AS COL_E280AE76_6FEE_49E1_B03C_7701314E077C#704206, xa_durava#702764 AS COL_1E4A86D9_E54A_43B8_976E_DC11FCB68FFA#704207, xa_durpen#702765 AS COL_CEAD91B9_04C8_4B15_8FD0_72E8CE977D80#704208, xa_durapr#702766 AS COL_895DD35A_8996_4280_9C3B_7530D6232E96#704209, xa_durtot#702767 AS COL_5828A643_05B1_4FCD_A4B4_DA5B6DA3E2C0#704210, xa_durmed#702768 AS COL_DA9C8942_A4E1_46CF_9F26_2F6CE49A1320#704211, xa_protoc#702769 AS COL_97B4380D_7B3D_4DC3_A02E_5E56125EBBB1#704212, xa_datmaj#702770 AS COL_B5481877_BD3F_48AB_9DEF_93A78A27393C#704213, xa_coduti#702771 AS COL_B158002F_104C_4016_880C_FE27BBC05539#704214, xa_codpro#702772 AS COL_C08E2596_A8A5_4BC4_BC1D_C0BD120F7110#704215, xa_coulstd#702773 AS COL_2FD80DAD_5192_402C_AD9A_073DEB7F7D84#704216, xa_couleur#702774 AS COL_3B4AAD4A_1631_4FC8_BCAB_8BE0FA7004AB#704217, xa_flmedobl#702775 AS COL_D2EA269F_AE55_4AE8_8E19_04BC8DFC944B#704218, xa_flatsobl#702776 AS COL_7E5CBC27_2DA5_4BA4_80A6_BC09226C994A#704219, xa_flvalplanif#702777 AS COL_57A3329B_E0A8_48E5_8730_ABE51BCDE12D#704220, xa_flvalaccueil#702778 AS COL_103CCD8E_76DE_4844_B5BC_3B4CD178D2A8#704221, xa_nivvcr#702779 AS COL_3BA92538_CCFB_452A_A9EC_27B8144B3005#704222, xa_flrtcclq#702780 AS COL_9BAAC44D_D351_4A8F_84CA_540A36209F8F#704223, xa_fllabochaud#702781 AS COL_488D4701_EFE7_46B9_A196_F7891A438661#704224, xa_datede#702782 AS COL_F3C34D17_6E02_4029_8C4C_973C47DEC6EE#704225, ... 24 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#702759)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#702759)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#702760)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#702760)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#702761)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#702761)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#702762)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#702762)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#702763)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#702763)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#702764)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#702764)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#702765)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#702765)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#702766)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#702766)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#702767)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#702767)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#702768)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#702768)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#702769)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#702769)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#702770)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#702770)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#702771)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#702771)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#702772)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#702772)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#702773)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#702773)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#702774)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#702774)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#702775)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#702775)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#702776)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#702776)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#702777)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#702777)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#702778)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#702778)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#702779)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#702779)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#702780)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#702780)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#702781)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#702781)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#702782)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#702782)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#702783)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#702783)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#702784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#702784)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#702785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#702785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#702786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#702786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#702787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#702787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#702788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#702788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#702789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#702789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#702790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#702790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#702791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#702791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#702792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#702792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#702793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#702793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#702794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#702794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#702795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#702795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#702796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#702796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#702797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#702797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#702798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#702798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#702799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#702799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#702800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#702800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#702801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#702801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#702802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#702802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#702803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#702803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#702804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#702804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#702805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#702805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN) END)

Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore2"."h_examen") as x) [numPartitions=1] [xa_codexa#702759,xa_lib30#702760,xa_libuti#702761,xa_typexa#702762,xa_contra#702763,xa_durava#702764,xa_durpen#702765,xa_durapr#702766,xa_durtot#702767,xa_durmed#702768,xa_protoc#702769,xa_datmaj#702770,xa_coduti#702771,xa_codpro#702772,xa_coulstd#702773,xa_couleur#702774,xa_flmedobl#702775,xa_flatsobl#702776,xa_flvalplanif#702777,xa_flvalaccueil#702778,xa_nivvcr#702779,xa_flrtcclq#702780,xa_fllabochaud#702781,xa_datede#702782,... 23 more fields] PushedFilters: [], ReadSchema: struct<xa_codexa:string,xa_lib30:string,xa_libuti:string,xa_typexa:string,xa_contra:string,xa_dur...

WholeStageCodegen (2)

Details

== Physical Plan ==
CollectLimit (10)
+- Union (9)
   :- * LocalLimit (4)
   :  +- * Project (3)
   :     +- * Filter (2)
   :        +- * Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore"."h_examen") as x) [numPartitions=1]  (1)
   +- * LocalLimit (8)
      +- * Project (7)
         +- * Filter (6)
            +- * Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore2"."h_examen") as x) [numPartitions=1]  (5)


(1) Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore"."h_examen") as x) [numPartitions=1]  [codegen id : 1]
Output [47]: [xa_codexa#701858, xa_lib30#701859, xa_libuti#701860, xa_typexa#701861, xa_contra#701862, xa_durava#701863, xa_durpen#701864, xa_durapr#701865, xa_durtot#701866, xa_durmed#701867, xa_protoc#701868, xa_datmaj#701869, xa_coduti#701870, xa_codpro#701871, xa_coulstd#701872, xa_couleur#701873, xa_flmedobl#701874, xa_flatsobl#701875, xa_flvalplanif#701876, xa_flvalaccueil#701877, xa_nivvcr#701878, xa_flrtcclq#701879, xa_fllabochaud#701880, xa_datede#701881, xa_datefi#701882, xa_flgrpjour#701883, xa_primai#701884, xa_codpros#701885, xa_codconv#701886, xa_later#701887, xa_incidence#701888, xa_position#701889, xa_flgrve#701890, xa_flexainj#701891, xa_contrapat#701892, xa_flprore#701893, xa_flcacheinet#701894, xa_flnocot#701895, xa_codadm#701896, xa_flgrvi#701897, xa_reganas#701898, xa_flrecist#701899, xa_flnocr#701900, xa_icd#701901, xa_type_icd#701902, xa_flrecist_ec#701903, xa_codloinc#701904]
ReadSchema: struct<xa_codexa:string,xa_lib30:string,xa_libuti:string,xa_typexa:string,xa_contra:string,xa_durava:string,xa_durpen:string,xa_durapr:string,xa_durtot:string,xa_durmed:string,xa_protoc:string,xa_datmaj:string,xa_coduti:string,xa_codpro:string,xa_coulstd:string,xa_couleur:string,xa_flmedobl:string,xa_flatsobl:string,xa_flvalplanif:string,xa_flvalaccueil:string,xa_nivvcr:string,xa_flrtcclq:string,xa_fllabochaud:string,xa_datede:string,xa_datefi:string,xa_flgrpjour:string,xa_primai:string,xa_codpros:string,xa_codconv:string,xa_later:string,xa_incidence:string,xa_position:string,xa_flgrve:string,xa_flexainj:string,xa_contrapat:string,xa_flprore:string,xa_flcacheinet:string,xa_flnocot:string,xa_codadm:string,xa_flgrvi:string,xa_reganas:string,xa_flrecist:string,xa_flnocr:string,xa_icd:string,xa_type_icd:string,xa_flrecist_ec:string,xa_codloinc:string>

(2) Filter [codegen id : 1]
Input [47]: [xa_codexa#701858, xa_lib30#701859, xa_libuti#701860, xa_typexa#701861, xa_contra#701862, xa_durava#701863, xa_durpen#701864, xa_durapr#701865, xa_durtot#701866, xa_durmed#701867, xa_protoc#701868, xa_datmaj#701869, xa_coduti#701870, xa_codpro#701871, xa_coulstd#701872, xa_couleur#701873, xa_flmedobl#701874, xa_flatsobl#701875, xa_flvalplanif#701876, xa_flvalaccueil#701877, xa_nivvcr#701878, xa_flrtcclq#701879, xa_fllabochaud#701880, xa_datede#701881, xa_datefi#701882, xa_flgrpjour#701883, xa_primai#701884, xa_codpros#701885, xa_codconv#701886, xa_later#701887, xa_incidence#701888, xa_position#701889, xa_flgrve#701890, xa_flexainj#701891, xa_contrapat#701892, xa_flprore#701893, xa_flcacheinet#701894, xa_flnocot#701895, xa_codadm#701896, xa_flgrvi#701897, xa_reganas#701898, xa_flrecist#701899, xa_flnocr#701900, xa_icd#701901, xa_type_icd#701902, xa_flrecist_ec#701903, xa_codloinc#701904]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#701858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#701858)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#701859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#701859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#701860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#701860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#701861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#701861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#701862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#701862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#701863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#701863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#701864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#701864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#701865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#701865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#701866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#701866)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#701867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#701867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#701868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#701868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#701869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#701869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#701870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#701870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#701871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#701871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#701872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#701872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#701873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#701873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#701874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#701874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#701875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#701875)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#701876)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#701876)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#701877)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#701877)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#701878)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#701878)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#701879)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#701879)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#701880)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#701880)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#701881)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#701881)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#701882)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#701882)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#701883)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#701883)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#701884)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#701884)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#701885)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#701885)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#701886)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#701886)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#701887)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#701887)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#701888)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#701888)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#701889)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#701889)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#701890)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#701890)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#701891)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#701891)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#701892)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#701892)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#701893)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#701893)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#701894)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#701894)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#701895)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#701895)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#701896)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#701896)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#701897)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#701897)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#701898)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#701898)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#701899)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#701899)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#701900)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#701900)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#701901)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#701901)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#701902)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#701902)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#701903)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#701903)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#701904)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#701904)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN) END)

(3) Project [codegen id : 1]
Output [48]: [xa_codexa#701858 AS COL_BA700E71_6183_4187_9746_E6A8BE8A7260#704007, xa_lib30#701859 AS COL_EE8557FB_1121_4390_B12D_B50C4CC1159D#704008, xa_libuti#701860 AS COL_07330D6D_FE7A_4A0A_BD48_05EFB77E3B27#704009, xa_typexa#701861 AS COL_E80B0007_06E9_466F_BC9D_091661288E44#704010, xa_contra#701862 AS COL_E280AE76_6FEE_49E1_B03C_7701314E077C#704011, xa_durava#701863 AS COL_1E4A86D9_E54A_43B8_976E_DC11FCB68FFA#704012, xa_durpen#701864 AS COL_CEAD91B9_04C8_4B15_8FD0_72E8CE977D80#704013, xa_durapr#701865 AS COL_895DD35A_8996_4280_9C3B_7530D6232E96#704014, xa_durtot#701866 AS COL_5828A643_05B1_4FCD_A4B4_DA5B6DA3E2C0#704015, xa_durmed#701867 AS COL_DA9C8942_A4E1_46CF_9F26_2F6CE49A1320#704016, xa_protoc#701868 AS COL_97B4380D_7B3D_4DC3_A02E_5E56125EBBB1#704017, xa_datmaj#701869 AS COL_B5481877_BD3F_48AB_9DEF_93A78A27393C#704018, xa_coduti#701870 AS COL_B158002F_104C_4016_880C_FE27BBC05539#704019, xa_codpro#701871 AS COL_C08E2596_A8A5_4BC4_BC1D_C0BD120F7110#704020, xa_coulstd#701872 AS COL_2FD80DAD_5192_402C_AD9A_073DEB7F7D84#704021, xa_couleur#701873 AS COL_3B4AAD4A_1631_4FC8_BCAB_8BE0FA7004AB#704022, xa_flmedobl#701874 AS COL_D2EA269F_AE55_4AE8_8E19_04BC8DFC944B#704023, xa_flatsobl#701875 AS COL_7E5CBC27_2DA5_4BA4_80A6_BC09226C994A#704024, xa_flvalplanif#701876 AS COL_57A3329B_E0A8_48E5_8730_ABE51BCDE12D#704025, xa_flvalaccueil#701877 AS COL_103CCD8E_76DE_4844_B5BC_3B4CD178D2A8#704026, xa_nivvcr#701878 AS COL_3BA92538_CCFB_452A_A9EC_27B8144B3005#704027, xa_flrtcclq#701879 AS COL_9BAAC44D_D351_4A8F_84CA_540A36209F8F#704028, xa_fllabochaud#701880 AS COL_488D4701_EFE7_46B9_A196_F7891A438661#704029, xa_datede#701881 AS COL_F3C34D17_6E02_4029_8C4C_973C47DEC6EE#704030, xa_datefi#701882 AS COL_72AE437C_65F0_4F14_840F_20F6CBD13FFE#704031, xa_flgrpjour#701883 AS COL_1CF619C3_B1AE_44A5_A736_1FF2F4620F5C#704032, xa_primai#701884 AS COL_3096E362_B1DB_46F3_90DC_775035D8D5F6#704033, xa_codpros#701885 AS COL_FED94951_3C79_48E5_81CF_E82E957ED527#704034, xa_codconv#701886 AS COL_6F2ADD22_2D1B_4C6F_B498_0D3E82CD8962#704035, xa_later#701887 AS COL_B3CB34EE_BD89_439C_BD0E_C12EF5F825B9#704036, xa_incidence#701888 AS COL_C53F2CE1_7181_4272_9DCB_D3807860FC20#704037, xa_position#701889 AS COL_EE0092CB_3D9B_45F6_81D8_7F3CB780EA71#704038, xa_flgrve#701890 AS COL_3E5C5522_12FE_46B9_AC85_739272783536#704039, xa_flexainj#701891 AS COL_0615A03D_B8B3_40E4_9F05_601D8282C898#704040, xa_contrapat#701892 AS COL_9080731E_A0D2_4401_93B0_F596A3032A8C#704041, xa_flprore#701893 AS COL_F63D6109_73AD_4FD9_A8E0_F2BCCD1A6778#704042, xa_flcacheinet#701894 AS COL_0F3925CF_7B2B_49FE_8475_A71B78929015#704043, xa_flnocot#701895 AS COL_C4098ACC_06AA_4C6F_BB63_A019E510FC1B#704044, xa_codadm#701896 AS COL_62B18B34_0190_443A_9B6C_66C0C12A76A4#704045, xa_flgrvi#701897 AS COL_B68505A9_53AE_4770_AC79_43A3CC546FB8#704046, xa_reganas#701898 AS COL_B7B1B1D0_2740_4A96_A971_36BD13FBE095#704047, xa_flrecist#701899 AS COL_1C4A9859_0A94_4C59_96FE_F0D17AB2FEC0#704048, xa_flnocr#701900 AS COL_70429539_8921_4BF7_B9AB_9B9502AF2207#704049, xa_icd#701901 AS COL_A196186C_2065_4866_BBD9_8A7D2C3960BD#704050, xa_type_icd#701902 AS COL_82187AA8_9D5D_45A7_ABF8_5D8C667DB843#704051, xa_flrecist_ec#701903 AS COL_1E1AE4B8_334E_47DB_8A89_4CB9F17F913A#704052, xa_codloinc#701904 AS COL_AD2B6C61_F112_47BF_A854_FC7C5330BEC2#704053, str_create(Cab_A) AS COL_8D7E9B23_758F_470D_A454_59D0B15FB43C#704054]
Input [47]: [xa_codexa#701858, xa_lib30#701859, xa_libuti#701860, xa_typexa#701861, xa_contra#701862, xa_durava#701863, xa_durpen#701864, xa_durapr#701865, xa_durtot#701866, xa_durmed#701867, xa_protoc#701868, xa_datmaj#701869, xa_coduti#701870, xa_codpro#701871, xa_coulstd#701872, xa_couleur#701873, xa_flmedobl#701874, xa_flatsobl#701875, xa_flvalplanif#701876, xa_flvalaccueil#701877, xa_nivvcr#701878, xa_flrtcclq#701879, xa_fllabochaud#701880, xa_datede#701881, xa_datefi#701882, xa_flgrpjour#701883, xa_primai#701884, xa_codpros#701885, xa_codconv#701886, xa_later#701887, xa_incidence#701888, xa_position#701889, xa_flgrve#701890, xa_flexainj#701891, xa_contrapat#701892, xa_flprore#701893, xa_flcacheinet#701894, xa_flnocot#701895, xa_codadm#701896, xa_flgrvi#701897, xa_reganas#701898, xa_flrecist#701899, xa_flnocr#701900, xa_icd#701901, xa_type_icd#701902, xa_flrecist_ec#701903, xa_codloinc#701904]

(4) LocalLimit [codegen id : 1]
Input [48]: [COL_BA700E71_6183_4187_9746_E6A8BE8A7260#704007, COL_EE8557FB_1121_4390_B12D_B50C4CC1159D#704008, COL_07330D6D_FE7A_4A0A_BD48_05EFB77E3B27#704009, COL_E80B0007_06E9_466F_BC9D_091661288E44#704010, COL_E280AE76_6FEE_49E1_B03C_7701314E077C#704011, COL_1E4A86D9_E54A_43B8_976E_DC11FCB68FFA#704012, COL_CEAD91B9_04C8_4B15_8FD0_72E8CE977D80#704013, COL_895DD35A_8996_4280_9C3B_7530D6232E96#704014, COL_5828A643_05B1_4FCD_A4B4_DA5B6DA3E2C0#704015, COL_DA9C8942_A4E1_46CF_9F26_2F6CE49A1320#704016, COL_97B4380D_7B3D_4DC3_A02E_5E56125EBBB1#704017, COL_B5481877_BD3F_48AB_9DEF_93A78A27393C#704018, COL_B158002F_104C_4016_880C_FE27BBC05539#704019, COL_C08E2596_A8A5_4BC4_BC1D_C0BD120F7110#704020, COL_2FD80DAD_5192_402C_AD9A_073DEB7F7D84#704021, COL_3B4AAD4A_1631_4FC8_BCAB_8BE0FA7004AB#704022, COL_D2EA269F_AE55_4AE8_8E19_04BC8DFC944B#704023, COL_7E5CBC27_2DA5_4BA4_80A6_BC09226C994A#704024, COL_57A3329B_E0A8_48E5_8730_ABE51BCDE12D#704025, COL_103CCD8E_76DE_4844_B5BC_3B4CD178D2A8#704026, COL_3BA92538_CCFB_452A_A9EC_27B8144B3005#704027, COL_9BAAC44D_D351_4A8F_84CA_540A36209F8F#704028, COL_488D4701_EFE7_46B9_A196_F7891A438661#704029, COL_F3C34D17_6E02_4029_8C4C_973C47DEC6EE#704030, COL_72AE437C_65F0_4F14_840F_20F6CBD13FFE#704031, COL_1CF619C3_B1AE_44A5_A736_1FF2F4620F5C#704032, COL_3096E362_B1DB_46F3_90DC_775035D8D5F6#704033, COL_FED94951_3C79_48E5_81CF_E82E957ED527#704034, COL_6F2ADD22_2D1B_4C6F_B498_0D3E82CD8962#704035, COL_B3CB34EE_BD89_439C_BD0E_C12EF5F825B9#704036, COL_C53F2CE1_7181_4272_9DCB_D3807860FC20#704037, COL_EE0092CB_3D9B_45F6_81D8_7F3CB780EA71#704038, COL_3E5C5522_12FE_46B9_AC85_739272783536#704039, COL_0615A03D_B8B3_40E4_9F05_601D8282C898#704040, COL_9080731E_A0D2_4401_93B0_F596A3032A8C#704041, COL_F63D6109_73AD_4FD9_A8E0_F2BCCD1A6778#704042, COL_0F3925CF_7B2B_49FE_8475_A71B78929015#704043, COL_C4098ACC_06AA_4C6F_BB63_A019E510FC1B#704044, COL_62B18B34_0190_443A_9B6C_66C0C12A76A4#704045, COL_B68505A9_53AE_4770_AC79_43A3CC546FB8#704046, COL_B7B1B1D0_2740_4A96_A971_36BD13FBE095#704047, COL_1C4A9859_0A94_4C59_96FE_F0D17AB2FEC0#704048, COL_70429539_8921_4BF7_B9AB_9B9502AF2207#704049, COL_A196186C_2065_4866_BBD9_8A7D2C3960BD#704050, COL_82187AA8_9D5D_45A7_ABF8_5D8C667DB843#704051, COL_1E1AE4B8_334E_47DB_8A89_4CB9F17F913A#704052, COL_AD2B6C61_F112_47BF_A854_FC7C5330BEC2#704053, COL_8D7E9B23_758F_470D_A454_59D0B15FB43C#704054]
Arguments: 1500

(5) Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore2"."h_examen") as x) [numPartitions=1]  [codegen id : 2]
Output [47]: [xa_codexa#702759, xa_lib30#702760, xa_libuti#702761, xa_typexa#702762, xa_contra#702763, xa_durava#702764, xa_durpen#702765, xa_durapr#702766, xa_durtot#702767, xa_durmed#702768, xa_protoc#702769, xa_datmaj#702770, xa_coduti#702771, xa_codpro#702772, xa_coulstd#702773, xa_couleur#702774, xa_flmedobl#702775, xa_flatsobl#702776, xa_flvalplanif#702777, xa_flvalaccueil#702778, xa_nivvcr#702779, xa_flrtcclq#702780, xa_fllabochaud#702781, xa_datede#702782, xa_datefi#702783, xa_flgrpjour#702784, xa_primai#702785, xa_codpros#702786, xa_codconv#702787, xa_later#702788, xa_incidence#702789, xa_position#702790, xa_flgrve#702791, xa_flexainj#702792, xa_contrapat#702793, xa_flprore#702794, xa_flcacheinet#702795, xa_flnocot#702796, xa_codadm#702797, xa_flgrvi#702798, xa_reganas#702799, xa_flrecist#702800, xa_flnocr#702801, xa_icd#702802, xa_type_icd#702803, xa_flrecist_ec#702804, xa_codloinc#702805]
ReadSchema: struct<xa_codexa:string,xa_lib30:string,xa_libuti:string,xa_typexa:string,xa_contra:string,xa_durava:string,xa_durpen:string,xa_durapr:string,xa_durtot:string,xa_durmed:string,xa_protoc:string,xa_datmaj:string,xa_coduti:string,xa_codpro:string,xa_coulstd:string,xa_couleur:string,xa_flmedobl:string,xa_flatsobl:string,xa_flvalplanif:string,xa_flvalaccueil:string,xa_nivvcr:string,xa_flrtcclq:string,xa_fllabochaud:string,xa_datede:string,xa_datefi:string,xa_flgrpjour:string,xa_primai:string,xa_codpros:string,xa_codconv:string,xa_later:string,xa_incidence:string,xa_position:string,xa_flgrve:string,xa_flexainj:string,xa_contrapat:string,xa_flprore:string,xa_flcacheinet:string,xa_flnocot:string,xa_codadm:string,xa_flgrvi:string,xa_reganas:string,xa_flrecist:string,xa_flnocr:string,xa_icd:string,xa_type_icd:string,xa_flrecist_ec:string,xa_codloinc:string>

(6) Filter [codegen id : 2]
Input [47]: [xa_codexa#702759, xa_lib30#702760, xa_libuti#702761, xa_typexa#702762, xa_contra#702763, xa_durava#702764, xa_durpen#702765, xa_durapr#702766, xa_durtot#702767, xa_durmed#702768, xa_protoc#702769, xa_datmaj#702770, xa_coduti#702771, xa_codpro#702772, xa_coulstd#702773, xa_couleur#702774, xa_flmedobl#702775, xa_flatsobl#702776, xa_flvalplanif#702777, xa_flvalaccueil#702778, xa_nivvcr#702779, xa_flrtcclq#702780, xa_fllabochaud#702781, xa_datede#702782, xa_datefi#702783, xa_flgrpjour#702784, xa_primai#702785, xa_codpros#702786, xa_codconv#702787, xa_later#702788, xa_incidence#702789, xa_position#702790, xa_flgrve#702791, xa_flexainj#702792, xa_contrapat#702793, xa_flprore#702794, xa_flcacheinet#702795, xa_flnocot#702796, xa_codadm#702797, xa_flgrvi#702798, xa_reganas#702799, xa_flrecist#702800, xa_flnocr#702801, xa_icd#702802, xa_type_icd#702803, xa_flrecist_ec#702804, xa_codloinc#702805]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#702759)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#702759)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#702760)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#702760)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#702761)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#702761)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#702762)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#702762)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#702763)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#702763)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#702764)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#702764)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#702765)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#702765)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#702766)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#702766)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#702767)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#702767)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#702768)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#702768)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#702769)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#702769)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#702770)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#702770)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#702771)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#702771)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#702772)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#702772)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#702773)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#702773)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#702774)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#702774)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#702775)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#702775)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#702776)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#702776)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#702777)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#702777)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#702778)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#702778)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#702779)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#702779)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#702780)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#702780)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#702781)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#702781)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#702782)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#702782)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#702783)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#702783)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#702784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#702784)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#702785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#702785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#702786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#702786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#702787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#702787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#702788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#702788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#702789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#702789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#702790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#702790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#702791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#702791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#702792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#702792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#702793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#702793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#702794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#702794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#702795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#702795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#702796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#702796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#702797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#702797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#702798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#702798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#702799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#702799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#702800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#702800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#702801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#702801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#702802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#702802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#702803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#702803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#702804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#702804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#702805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#702805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN) END)

(7) Project [codegen id : 2]
Output [48]: [xa_codexa#702759 AS COL_BA700E71_6183_4187_9746_E6A8BE8A7260#704202, xa_lib30#702760 AS COL_EE8557FB_1121_4390_B12D_B50C4CC1159D#704203, xa_libuti#702761 AS COL_07330D6D_FE7A_4A0A_BD48_05EFB77E3B27#704204, xa_typexa#702762 AS COL_E80B0007_06E9_466F_BC9D_091661288E44#704205, xa_contra#702763 AS COL_E280AE76_6FEE_49E1_B03C_7701314E077C#704206, xa_durava#702764 AS COL_1E4A86D9_E54A_43B8_976E_DC11FCB68FFA#704207, xa_durpen#702765 AS COL_CEAD91B9_04C8_4B15_8FD0_72E8CE977D80#704208, xa_durapr#702766 AS COL_895DD35A_8996_4280_9C3B_7530D6232E96#704209, xa_durtot#702767 AS COL_5828A643_05B1_4FCD_A4B4_DA5B6DA3E2C0#704210, xa_durmed#702768 AS COL_DA9C8942_A4E1_46CF_9F26_2F6CE49A1320#704211, xa_protoc#702769 AS COL_97B4380D_7B3D_4DC3_A02E_5E56125EBBB1#704212, xa_datmaj#702770 AS COL_B5481877_BD3F_48AB_9DEF_93A78A27393C#704213, xa_coduti#702771 AS COL_B158002F_104C_4016_880C_FE27BBC05539#704214, xa_codpro#702772 AS COL_C08E2596_A8A5_4BC4_BC1D_C0BD120F7110#704215, xa_coulstd#702773 AS COL_2FD80DAD_5192_402C_AD9A_073DEB7F7D84#704216, xa_couleur#702774 AS COL_3B4AAD4A_1631_4FC8_BCAB_8BE0FA7004AB#704217, xa_flmedobl#702775 AS COL_D2EA269F_AE55_4AE8_8E19_04BC8DFC944B#704218, xa_flatsobl#702776 AS COL_7E5CBC27_2DA5_4BA4_80A6_BC09226C994A#704219, xa_flvalplanif#702777 AS COL_57A3329B_E0A8_48E5_8730_ABE51BCDE12D#704220, xa_flvalaccueil#702778 AS COL_103CCD8E_76DE_4844_B5BC_3B4CD178D2A8#704221, xa_nivvcr#702779 AS COL_3BA92538_CCFB_452A_A9EC_27B8144B3005#704222, xa_flrtcclq#702780 AS COL_9BAAC44D_D351_4A8F_84CA_540A36209F8F#704223, xa_fllabochaud#702781 AS COL_488D4701_EFE7_46B9_A196_F7891A438661#704224, xa_datede#702782 AS COL_F3C34D17_6E02_4029_8C4C_973C47DEC6EE#704225, xa_datefi#702783 AS COL_72AE437C_65F0_4F14_840F_20F6CBD13FFE#704226, xa_flgrpjour#702784 AS COL_1CF619C3_B1AE_44A5_A736_1FF2F4620F5C#704227, xa_primai#702785 AS COL_3096E362_B1DB_46F3_90DC_775035D8D5F6#704228, xa_codpros#702786 AS COL_FED94951_3C79_48E5_81CF_E82E957ED527#704229, xa_codconv#702787 AS COL_6F2ADD22_2D1B_4C6F_B498_0D3E82CD8962#704230, xa_later#702788 AS COL_B3CB34EE_BD89_439C_BD0E_C12EF5F825B9#704231, xa_incidence#702789 AS COL_C53F2CE1_7181_4272_9DCB_D3807860FC20#704232, xa_position#702790 AS COL_EE0092CB_3D9B_45F6_81D8_7F3CB780EA71#704233, xa_flgrve#702791 AS COL_3E5C5522_12FE_46B9_AC85_739272783536#704234, xa_flexainj#702792 AS COL_0615A03D_B8B3_40E4_9F05_601D8282C898#704235, xa_contrapat#702793 AS COL_9080731E_A0D2_4401_93B0_F596A3032A8C#704236, xa_flprore#702794 AS COL_F63D6109_73AD_4FD9_A8E0_F2BCCD1A6778#704237, xa_flcacheinet#702795 AS COL_0F3925CF_7B2B_49FE_8475_A71B78929015#704238, xa_flnocot#702796 AS COL_C4098ACC_06AA_4C6F_BB63_A019E510FC1B#704239, xa_codadm#702797 AS COL_62B18B34_0190_443A_9B6C_66C0C12A76A4#704240, xa_flgrvi#702798 AS COL_B68505A9_53AE_4770_AC79_43A3CC546FB8#704241, xa_reganas#702799 AS COL_B7B1B1D0_2740_4A96_A971_36BD13FBE095#704242, xa_flrecist#702800 AS COL_1C4A9859_0A94_4C59_96FE_F0D17AB2FEC0#704243, xa_flnocr#702801 AS COL_70429539_8921_4BF7_B9AB_9B9502AF2207#704244, xa_icd#702802 AS COL_A196186C_2065_4866_BBD9_8A7D2C3960BD#704245, xa_type_icd#702803 AS COL_82187AA8_9D5D_45A7_ABF8_5D8C667DB843#704246, xa_flrecist_ec#702804 AS COL_1E1AE4B8_334E_47DB_8A89_4CB9F17F913A#704247, xa_codloinc#702805 AS COL_AD2B6C61_F112_47BF_A854_FC7C5330BEC2#704248, str_create(Cab_B) AS COL_8D7E9B23_758F_470D_A454_59D0B15FB43C#704249]
Input [47]: [xa_codexa#702759, xa_lib30#702760, xa_libuti#702761, xa_typexa#702762, xa_contra#702763, xa_durava#702764, xa_durpen#702765, xa_durapr#702766, xa_durtot#702767, xa_durmed#702768, xa_protoc#702769, xa_datmaj#702770, xa_coduti#702771, xa_codpro#702772, xa_coulstd#702773, xa_couleur#702774, xa_flmedobl#702775, xa_flatsobl#702776, xa_flvalplanif#702777, xa_flvalaccueil#702778, xa_nivvcr#702779, xa_flrtcclq#702780, xa_fllabochaud#702781, xa_datede#702782, xa_datefi#702783, xa_flgrpjour#702784, xa_primai#702785, xa_codpros#702786, xa_codconv#702787, xa_later#702788, xa_incidence#702789, xa_position#702790, xa_flgrve#702791, xa_flexainj#702792, xa_contrapat#702793, xa_flprore#702794, xa_flcacheinet#702795, xa_flnocot#702796, xa_codadm#702797, xa_flgrvi#702798, xa_reganas#702799, xa_flrecist#702800, xa_flnocr#702801, xa_icd#702802, xa_type_icd#702803, xa_flrecist_ec#702804, xa_codloinc#702805]

(8) LocalLimit [codegen id : 2]
Input [48]: [COL_BA700E71_6183_4187_9746_E6A8BE8A7260#704202, COL_EE8557FB_1121_4390_B12D_B50C4CC1159D#704203, COL_07330D6D_FE7A_4A0A_BD48_05EFB77E3B27#704204, COL_E80B0007_06E9_466F_BC9D_091661288E44#704205, COL_E280AE76_6FEE_49E1_B03C_7701314E077C#704206, COL_1E4A86D9_E54A_43B8_976E_DC11FCB68FFA#704207, COL_CEAD91B9_04C8_4B15_8FD0_72E8CE977D80#704208, COL_895DD35A_8996_4280_9C3B_7530D6232E96#704209, COL_5828A643_05B1_4FCD_A4B4_DA5B6DA3E2C0#704210, COL_DA9C8942_A4E1_46CF_9F26_2F6CE49A1320#704211, COL_97B4380D_7B3D_4DC3_A02E_5E56125EBBB1#704212, COL_B5481877_BD3F_48AB_9DEF_93A78A27393C#704213, COL_B158002F_104C_4016_880C_FE27BBC05539#704214, COL_C08E2596_A8A5_4BC4_BC1D_C0BD120F7110#704215, COL_2FD80DAD_5192_402C_AD9A_073DEB7F7D84#704216, COL_3B4AAD4A_1631_4FC8_BCAB_8BE0FA7004AB#704217, COL_D2EA269F_AE55_4AE8_8E19_04BC8DFC944B#704218, COL_7E5CBC27_2DA5_4BA4_80A6_BC09226C994A#704219, COL_57A3329B_E0A8_48E5_8730_ABE51BCDE12D#704220, COL_103CCD8E_76DE_4844_B5BC_3B4CD178D2A8#704221, COL_3BA92538_CCFB_452A_A9EC_27B8144B3005#704222, COL_9BAAC44D_D351_4A8F_84CA_540A36209F8F#704223, COL_488D4701_EFE7_46B9_A196_F7891A438661#704224, COL_F3C34D17_6E02_4029_8C4C_973C47DEC6EE#704225, COL_72AE437C_65F0_4F14_840F_20F6CBD13FFE#704226, COL_1CF619C3_B1AE_44A5_A736_1FF2F4620F5C#704227, COL_3096E362_B1DB_46F3_90DC_775035D8D5F6#704228, COL_FED94951_3C79_48E5_81CF_E82E957ED527#704229, COL_6F2ADD22_2D1B_4C6F_B498_0D3E82CD8962#704230, COL_B3CB34EE_BD89_439C_BD0E_C12EF5F825B9#704231, COL_C53F2CE1_7181_4272_9DCB_D3807860FC20#704232, COL_EE0092CB_3D9B_45F6_81D8_7F3CB780EA71#704233, COL_3E5C5522_12FE_46B9_AC85_739272783536#704234, COL_0615A03D_B8B3_40E4_9F05_601D8282C898#704235, COL_9080731E_A0D2_4401_93B0_F596A3032A8C#704236, COL_F63D6109_73AD_4FD9_A8E0_F2BCCD1A6778#704237, COL_0F3925CF_7B2B_49FE_8475_A71B78929015#704238, COL_C4098ACC_06AA_4C6F_BB63_A019E510FC1B#704239, COL_62B18B34_0190_443A_9B6C_66C0C12A76A4#704240, COL_B68505A9_53AE_4770_AC79_43A3CC546FB8#704241, COL_B7B1B1D0_2740_4A96_A971_36BD13FBE095#704242, COL_1C4A9859_0A94_4C59_96FE_F0D17AB2FEC0#704243, COL_70429539_8921_4BF7_B9AB_9B9502AF2207#704244, COL_A196186C_2065_4866_BBD9_8A7D2C3960BD#704245, COL_82187AA8_9D5D_45A7_ABF8_5D8C667DB843#704246, COL_1E1AE4B8_334E_47DB_8A89_4CB9F17F913A#704247, COL_AD2B6C61_F112_47BF_A854_FC7C5330BEC2#704248, COL_8D7E9B23_758F_470D_A454_59D0B15FB43C#704249]
Arguments: 1500

(9) Union

(10) CollectLimit
Input [48]: [COL_BA700E71_6183_4187_9746_E6A8BE8A7260#704007, COL_EE8557FB_1121_4390_B12D_B50C4CC1159D#704008, COL_07330D6D_FE7A_4A0A_BD48_05EFB77E3B27#704009, COL_E80B0007_06E9_466F_BC9D_091661288E44#704010, COL_E280AE76_6FEE_49E1_B03C_7701314E077C#704011, COL_1E4A86D9_E54A_43B8_976E_DC11FCB68FFA#704012, COL_CEAD91B9_04C8_4B15_8FD0_72E8CE977D80#704013, COL_895DD35A_8996_4280_9C3B_7530D6232E96#704014, COL_5828A643_05B1_4FCD_A4B4_DA5B6DA3E2C0#704015, COL_DA9C8942_A4E1_46CF_9F26_2F6CE49A1320#704016, COL_97B4380D_7B3D_4DC3_A02E_5E56125EBBB1#704017, COL_B5481877_BD3F_48AB_9DEF_93A78A27393C#704018, COL_B158002F_104C_4016_880C_FE27BBC05539#704019, COL_C08E2596_A8A5_4BC4_BC1D_C0BD120F7110#704020, COL_2FD80DAD_5192_402C_AD9A_073DEB7F7D84#704021, COL_3B4AAD4A_1631_4FC8_BCAB_8BE0FA7004AB#704022, COL_D2EA269F_AE55_4AE8_8E19_04BC8DFC944B#704023, COL_7E5CBC27_2DA5_4BA4_80A6_BC09226C994A#704024, COL_57A3329B_E0A8_48E5_8730_ABE51BCDE12D#704025, COL_103CCD8E_76DE_4844_B5BC_3B4CD178D2A8#704026, COL_3BA92538_CCFB_452A_A9EC_27B8144B3005#704027, COL_9BAAC44D_D351_4A8F_84CA_540A36209F8F#704028, COL_488D4701_EFE7_46B9_A196_F7891A438661#704029, COL_F3C34D17_6E02_4029_8C4C_973C47DEC6EE#704030, COL_72AE437C_65F0_4F14_840F_20F6CBD13FFE#704031, COL_1CF619C3_B1AE_44A5_A736_1FF2F4620F5C#704032, COL_3096E362_B1DB_46F3_90DC_775035D8D5F6#704033, COL_FED94951_3C79_48E5_81CF_E82E957ED527#704034, COL_6F2ADD22_2D1B_4C6F_B498_0D3E82CD8962#704035, COL_B3CB34EE_BD89_439C_BD0E_C12EF5F825B9#704036, COL_C53F2CE1_7181_4272_9DCB_D3807860FC20#704037, COL_EE0092CB_3D9B_45F6_81D8_7F3CB780EA71#704038, COL_3E5C5522_12FE_46B9_AC85_739272783536#704039, COL_0615A03D_B8B3_40E4_9F05_601D8282C898#704040, COL_9080731E_A0D2_4401_93B0_F596A3032A8C#704041, COL_F63D6109_73AD_4FD9_A8E0_F2BCCD1A6778#704042, COL_0F3925CF_7B2B_49FE_8475_A71B78929015#704043, COL_C4098ACC_06AA_4C6F_BB63_A019E510FC1B#704044, COL_62B18B34_0190_443A_9B6C_66C0C12A76A4#704045, COL_B68505A9_53AE_4770_AC79_43A3CC546FB8#704046, COL_B7B1B1D0_2740_4A96_A971_36BD13FBE095#704047, COL_1C4A9859_0A94_4C59_96FE_F0D17AB2FEC0#704048, COL_70429539_8921_4BF7_B9AB_9B9502AF2207#704049, COL_A196186C_2065_4866_BBD9_8A7D2C3960BD#704050, COL_82187AA8_9D5D_45A7_ABF8_5D8C667DB843#704051, COL_1E1AE4B8_334E_47DB_8A89_4CB9F17F913A#704052, COL_AD2B6C61_F112_47BF_A854_FC7C5330BEC2#704053, COL_8D7E9B23_758F_470D_A454_59D0B15FB43C#704054]
Arguments: 1500

SQL / DataFrame Properties

Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet