digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
1 [labelType="html" label="<b>CartesianProduct</b><br><br>number of output rows: 7"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 11 ms";
3 [labelType="html" label="<br><b>LocalLimit</b><br><br>"];
4 [labelType="html" label="<br><b>Project</b><br><br>"];
5 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 7"];
6 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 7<br>number of input batches: 1"];
}
7 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 3 ms<br>metadata time: 0 ms<br>size of files read: 20.3 KiB<br>number of output rows: 7"];
subgraph cluster8 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: 5 ms";
9 [labelType="html" label="<br><b>LocalLimit</b><br><br>"];
10 [labelType="html" label="<br><b>Project</b><br><br>"];
11 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 1"];
}
12 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 1<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 174.0 B"];
1->0;
3->1;
4->3;
5->4;
6->5;
7->6;
9->1;
10->9;
11->10;
12->11;
}
13
CollectLimit 1500
CartesianProduct
LocalLimit 1500
Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#790762 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#791145, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#790763 AS COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#791146, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#790804 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#791147, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#790796 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#791148, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#790810 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#791149, COL_7D270645_B926_42AF_A110_EB3A1A53031B#790784 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#791150, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#790815 AS COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#791151]
Filter (COL_64ED17E5_A991_405B_AEED_8A2977283F76#790762 <=> 011040518)
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_64ED17E5_A991_405B_AEED_8A2977283F76#790762,COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#790763,COL_7D270645_B926_42AF_A110_EB3A1A53031B#790784,COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#790796,COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#790804,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#790810,COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#790815] Batched: true, DataFilters: [(COL_64ED17E5_A991_405B_AEED_8A2977283F76#790762 <=> 011040518)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_210234], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_64ED17E5_A991_405B_AEED_8A2977283F76,011040518)], ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62:s...
LocalLimit 1500
Project
Filter ((isnotnull(REGLES#790943) AND (RC-SSN-SSF = REGLES#790943)) AND (APPLICABLE#790944 <=> O))
WholeStageCodegen (2)
FileScan csv [REGLES#790943,APPLICABLE#790944] Batched: false, DataFilters: [isnotnull(REGLES#790943), (RC-SSN-SSF = REGLES#790943), (APPLICABLE#790944 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_209983/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SSN-SSF), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>
== Physical Plan ==
CollectLimit (11)
+- CartesianProduct Inner (10)
:- * LocalLimit (5)
: +- * Project (4)
: +- * Filter (3)
: +- * ColumnarToRow (2)
: +- Scan parquet (1)
+- * LocalLimit (9)
+- * Project (8)
+- * Filter (7)
+- Scan csv (6)
(1) Scan parquet
Output [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#790762, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#790763, COL_7D270645_B926_42AF_A110_EB3A1A53031B#790784, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#790796, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#790804, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#790810, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#790815]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_210234]
PushedFilters: [EqualNullSafe(COL_64ED17E5_A991_405B_AEED_8A2977283F76,011040518)]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62:string,COL_7D270645_B926_42AF_A110_EB3A1A53031B:string,COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157:string,COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28:string,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A:string,COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF:timestamp>
(2) ColumnarToRow [codegen id : 1]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#790762, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#790763, COL_7D270645_B926_42AF_A110_EB3A1A53031B#790784, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#790796, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#790804, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#790810, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#790815]
(3) Filter [codegen id : 1]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#790762, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#790763, COL_7D270645_B926_42AF_A110_EB3A1A53031B#790784, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#790796, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#790804, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#790810, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#790815]
Condition : (COL_64ED17E5_A991_405B_AEED_8A2977283F76#790762 <=> 011040518)
(4) Project [codegen id : 1]
Output [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#790762 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#791145, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#790763 AS COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#791146, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#790804 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#791147, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#790796 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#791148, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#790810 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#791149, COL_7D270645_B926_42AF_A110_EB3A1A53031B#790784 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#791150, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#790815 AS COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#791151]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#790762, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#790763, COL_7D270645_B926_42AF_A110_EB3A1A53031B#790784, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#790796, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#790804, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#790810, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#790815]
(5) LocalLimit [codegen id : 1]
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#791145, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#791146, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#791147, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#791148, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#791149, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#791150, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#791151]
Arguments: 1500
(6) Scan csv
Output [2]: [REGLES#790943, APPLICABLE#790944]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_209983/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SSN-SSF), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>
(7) Filter [codegen id : 2]
Input [2]: [REGLES#790943, APPLICABLE#790944]
Condition : ((isnotnull(REGLES#790943) AND (RC-SSN-SSF = REGLES#790943)) AND (APPLICABLE#790944 <=> O))
(8) Project [codegen id : 2]
Output: []
Input [2]: [REGLES#790943, APPLICABLE#790944]
(9) LocalLimit [codegen id : 2]
Input: []
Arguments: 1500
(10) CartesianProduct
Join type: Inner
Join condition: None
(11) CollectLimit
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#791145, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#791146, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#791147, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#791148, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#791149, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#791150, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#791151]
Arguments: 1500