Filter ((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(PC_NUMPCO_438161#130930)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_NUMPCO_438161#130930)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_NUMDOS_438162#130928)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_NUMDOS_438162#130928)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_NUMDEM_438163#130927)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_NUMDEM_438163#130927)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_PRIMAI_438164#130933)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_PRIMAI_438164#130933)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_ANNVAL_438165#130913)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_ANNVAL_438165#130913)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_MODPCT_438166#130926)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_MODPCT_438166#130926)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODCHA_438167#130914)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODCHA_438167#130914)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODPER_438168#130916)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODPER_438168#130916)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODSER_438169#130917)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODSER_438169#130917)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_COMPAR_438170#130922)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_COMPAR_438170#130922)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_PLATRE_438171#130932)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_PLATRE_438171#130932)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_NUMSAL_438172#130931)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_NUMSAL_438172#130931)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODUTI_438173#130920)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODUTI_438173#130920)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_DATMAJ_438174#130923)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_DATMAJ_438174#130923)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODSIT_438175#130918)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODSIT_438175#130918)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_FLRMO_438176#130925)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_FLRMO_438176#130925)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_FLALD_438177#130924)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_FLALD_438177#130924)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODUAM_438178#130919)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODUAM_438178#130919)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODPER2_438179#130915)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODPER2_438179#130915)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_NUMEXA_438180#130929)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_NUMEXA_438180#130929)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_COMMENT_438181#130921)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_COMMENT_438181#130921)), ) END)
== Physical Plan ==
AdaptiveSparkPlan (14)
+- == Final Plan ==
* HashAggregate (8)
+- ShuffleQueryStage (7), Statistics(sizeInBytes=16.0 B, rowCount=1)
+- Exchange (6)
+- * HashAggregate (5)
+- * Project (4)
+- * Filter (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
+- == Initial Plan ==
HashAggregate (13)
+- Exchange (12)
+- HashAggregate (11)
+- Project (10)
+- Filter (9)
+- Scan parquet (1)
(1) Scan parquet
Output [21]: [PC_ANNVAL_438165#130913, PC_CODCHA_438167#130914, PC_CODPER2_438179#130915, PC_CODPER_438168#130916, PC_CODSER_438169#130917, PC_CODSIT_438175#130918, PC_CODUAM_438178#130919, PC_CODUTI_438173#130920, PC_COMMENT_438181#130921, PC_COMPAR_438170#130922, PC_DATMAJ_438174#130923, PC_FLALD_438177#130924, PC_FLRMO_438176#130925, PC_MODPCT_438166#130926, PC_NUMDEM_438163#130927, PC_NUMDOS_438162#130928, PC_NUMEXA_438180#130929, PC_NUMPCO_438161#130930, PC_NUMSAL_438172#130931, PC_PLATRE_438171#130932, PC_PRIMAI_438164#130933]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_PRECOT_438160]
ReadSchema: struct<PC_ANNVAL_438165:string,PC_CODCHA_438167:string,PC_CODPER2_438179:string,PC_CODPER_438168:string,PC_CODSER_438169:string,PC_CODSIT_438175:string,PC_CODUAM_438178:string,PC_CODUTI_438173:string,PC_COMMENT_438181:string,PC_COMPAR_438170:string,PC_DATMAJ_438174:string,PC_FLALD_438177:string,PC_FLRMO_438176:string,PC_MODPCT_438166:string,PC_NUMDEM_438163:string,PC_NUMDOS_438162:string,PC_NUMEXA_438180:string,PC_NUMPCO_438161:string,PC_NUMSAL_438172:string,PC_PLATRE_438171:string,PC_PRIMAI_438164:string>
(2) ColumnarToRow [codegen id : 1]
Input [21]: [PC_ANNVAL_438165#130913, PC_CODCHA_438167#130914, PC_CODPER2_438179#130915, PC_CODPER_438168#130916, PC_CODSER_438169#130917, PC_CODSIT_438175#130918, PC_CODUAM_438178#130919, PC_CODUTI_438173#130920, PC_COMMENT_438181#130921, PC_COMPAR_438170#130922, PC_DATMAJ_438174#130923, PC_FLALD_438177#130924, PC_FLRMO_438176#130925, PC_MODPCT_438166#130926, PC_NUMDEM_438163#130927, PC_NUMDOS_438162#130928, PC_NUMEXA_438180#130929, PC_NUMPCO_438161#130930, PC_NUMSAL_438172#130931, PC_PLATRE_438171#130932, PC_PRIMAI_438164#130933]
(3) Filter [codegen id : 1]
Input [21]: [PC_ANNVAL_438165#130913, PC_CODCHA_438167#130914, PC_CODPER2_438179#130915, PC_CODPER_438168#130916, PC_CODSER_438169#130917, PC_CODSIT_438175#130918, PC_CODUAM_438178#130919, PC_CODUTI_438173#130920, PC_COMMENT_438181#130921, PC_COMPAR_438170#130922, PC_DATMAJ_438174#130923, PC_FLALD_438177#130924, PC_FLRMO_438176#130925, PC_MODPCT_438166#130926, PC_NUMDEM_438163#130927, PC_NUMDOS_438162#130928, PC_NUMEXA_438180#130929, PC_NUMPCO_438161#130930, PC_NUMSAL_438172#130931, PC_PLATRE_438171#130932, PC_PRIMAI_438164#130933]
Condition : ((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(PC_NUMPCO_438161#130930)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_NUMPCO_438161#130930)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_NUMDOS_438162#130928)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_NUMDOS_438162#130928)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_NUMDEM_438163#130927)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_NUMDEM_438163#130927)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_PRIMAI_438164#130933)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_PRIMAI_438164#130933)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_ANNVAL_438165#130913)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_ANNVAL_438165#130913)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_MODPCT_438166#130926)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_MODPCT_438166#130926)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODCHA_438167#130914)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODCHA_438167#130914)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODPER_438168#130916)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODPER_438168#130916)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODSER_438169#130917)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODSER_438169#130917)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_COMPAR_438170#130922)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_COMPAR_438170#130922)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_PLATRE_438171#130932)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_PLATRE_438171#130932)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_NUMSAL_438172#130931)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_NUMSAL_438172#130931)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODUTI_438173#130920)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODUTI_438173#130920)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_DATMAJ_438174#130923)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_DATMAJ_438174#130923)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODSIT_438175#130918)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODSIT_438175#130918)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_FLRMO_438176#130925)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_FLRMO_438176#130925)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_FLALD_438177#130924)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_FLALD_438177#130924)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODUAM_438178#130919)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODUAM_438178#130919)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODPER2_438179#130915)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODPER2_438179#130915)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_NUMEXA_438180#130929)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_NUMEXA_438180#130929)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_COMMENT_438181#130921)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_COMMENT_438181#130921)), ) END)
(4) Project [codegen id : 1]
Output: []
Input [21]: [PC_ANNVAL_438165#130913, PC_CODCHA_438167#130914, PC_CODPER2_438179#130915, PC_CODPER_438168#130916, PC_CODSER_438169#130917, PC_CODSIT_438175#130918, PC_CODUAM_438178#130919, PC_CODUTI_438173#130920, PC_COMMENT_438181#130921, PC_COMPAR_438170#130922, PC_DATMAJ_438174#130923, PC_FLALD_438177#130924, PC_FLRMO_438176#130925, PC_MODPCT_438166#130926, PC_NUMDEM_438163#130927, PC_NUMDOS_438162#130928, PC_NUMEXA_438180#130929, PC_NUMPCO_438161#130930, PC_NUMSAL_438172#130931, PC_PLATRE_438171#130932, PC_PRIMAI_438164#130933]
(5) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#132326L]
Results [1]: [count#132327L]
(6) Exchange
Input [1]: [count#132327L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=12379]
(7) ShuffleQueryStage
Output [1]: [count#132327L]
Arguments: 0
(8) HashAggregate [codegen id : 2]
Input [1]: [count#132327L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#132072L]
Results [1]: [count(1)#132072L AS COL_83385714-3802-4012-b4f5-6dd2e169b988#132077L]
(9) Filter
Input [21]: [PC_ANNVAL_438165#130913, PC_CODCHA_438167#130914, PC_CODPER2_438179#130915, PC_CODPER_438168#130916, PC_CODSER_438169#130917, PC_CODSIT_438175#130918, PC_CODUAM_438178#130919, PC_CODUTI_438173#130920, PC_COMMENT_438181#130921, PC_COMPAR_438170#130922, PC_DATMAJ_438174#130923, PC_FLALD_438177#130924, PC_FLRMO_438176#130925, PC_MODPCT_438166#130926, PC_NUMDEM_438163#130927, PC_NUMDOS_438162#130928, PC_NUMEXA_438180#130929, PC_NUMPCO_438161#130930, PC_NUMSAL_438172#130931, PC_PLATRE_438171#130932, PC_PRIMAI_438164#130933]
Condition : ((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(PC_NUMPCO_438161#130930)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_NUMPCO_438161#130930)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_NUMDOS_438162#130928)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_NUMDOS_438162#130928)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_NUMDEM_438163#130927)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_NUMDEM_438163#130927)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_PRIMAI_438164#130933)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_PRIMAI_438164#130933)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_ANNVAL_438165#130913)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_ANNVAL_438165#130913)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_MODPCT_438166#130926)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_MODPCT_438166#130926)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODCHA_438167#130914)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODCHA_438167#130914)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODPER_438168#130916)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODPER_438168#130916)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODSER_438169#130917)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODSER_438169#130917)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_COMPAR_438170#130922)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_COMPAR_438170#130922)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_PLATRE_438171#130932)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_PLATRE_438171#130932)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_NUMSAL_438172#130931)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_NUMSAL_438172#130931)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODUTI_438173#130920)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODUTI_438173#130920)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_DATMAJ_438174#130923)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_DATMAJ_438174#130923)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODSIT_438175#130918)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODSIT_438175#130918)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_FLRMO_438176#130925)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_FLRMO_438176#130925)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_FLALD_438177#130924)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_FLALD_438177#130924)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODUAM_438178#130919)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODUAM_438178#130919)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_CODPER2_438179#130915)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_CODPER2_438179#130915)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_NUMEXA_438180#130929)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_NUMEXA_438180#130929)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PC_COMMENT_438181#130921)), )) THEN false ELSE Contains(str_remove_accent(upper(PC_COMMENT_438181#130921)), ) END)
(10) Project
Output: []
Input [21]: [PC_ANNVAL_438165#130913, PC_CODCHA_438167#130914, PC_CODPER2_438179#130915, PC_CODPER_438168#130916, PC_CODSER_438169#130917, PC_CODSIT_438175#130918, PC_CODUAM_438178#130919, PC_CODUTI_438173#130920, PC_COMMENT_438181#130921, PC_COMPAR_438170#130922, PC_DATMAJ_438174#130923, PC_FLALD_438177#130924, PC_FLRMO_438176#130925, PC_MODPCT_438166#130926, PC_NUMDEM_438163#130927, PC_NUMDOS_438162#130928, PC_NUMEXA_438180#130929, PC_NUMPCO_438161#130930, PC_NUMSAL_438172#130931, PC_PLATRE_438171#130932, PC_PRIMAI_438164#130933]
(11) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#132326L]
Results [1]: [count#132327L]
(12) Exchange
Input [1]: [count#132327L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=12359]
(13) HashAggregate
Input [1]: [count#132327L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#132072L]
Results [1]: [count(1)#132072L AS COL_83385714-3802-4012-b4f5-6dd2e169b988#132077L]
(14) AdaptiveSparkPlan
Output [1]: [COL_83385714-3802-4012-b4f5-6dd2e169b988#132077L]
Arguments: isFinalPlan=true