afterincomparableyum opened a new issue, #11319:
URL: https://github.com/apache/incubator-gluten/issues/11319

   ### Backend
   
   VL (Velox)
   
   ### Bug description
   
   On Gluten 1.5.0 Velox Iceberg: 
   
   select
     count(*) as failures,
     count(*) != 0 as should_warn,
     count(*) != 0 as should_error
   from (
     with validation_errors as (
       select
         ingestion_id, 
         count(*) as cnt
       from (
         select * 
         from schema.table.`branch_0.1.12-pd` 
         where ingestion_ts > date_sub(current_timestamp(), 3)
       ) dbt_subquery
       group by ingestion_id
       having count(*) > 1
         or ingestion_id is null
     )
     select * from validation_errors
   )
   
   outputs: 
   
   failures | should_warn | should_error
   -------------------------------------
   8950    | true                | true
   
   
   where on vanilla spark 3.5.6: 
   
   failures | should_warn | should_error
   -------------------------------------
   0           | false               | false
   
   
   
   Info on columns: 
   
   ingestion_id: binary
   ingestion_ts: timestamp_ntz
   
   purpose of query is a DQ check to see if there are any duplicate ingestion 
IDs. 
   
   ### Gluten version
   
   _No response_
   
   ### Spark version
   
   None
   
   ### Spark configurations
   
   _No response_
   
   ### System information
   
   _No response_
   
   ### Relevant logs
   
   ```bash
   
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to