zhixingheyi-tian opened a new issue, #8764:
URL: https://github.com/apache/incubator-gluten/issues/8764

   ### Backend
   
   VL (Velox)
   
   ### Bug description
   
   ```
   CREATE TABLE default.testtable (
     a                    bigint,
     b               bigint,
     c        int
   )
   USING parquet
   LOCATION 'file:///data/dataset/testtable';
   ```
   
   dataset:
   
   [dataset.txt](https://github.com/user-attachments/files/18844458/dataset.txt)
   
   query:
   
   ```
     select
       max(a) as id
     from
       testtable
     where
       c = 2  
     group by
       b;
   ```
   
   [Expected behavior]
   
   ```
   spark-sql (default)>   select
                      >     max(a) as id
                      >   from
                      >     testtable
                      >   where
                      >     c = 2  
                      >   group by
                      >     b;
   299
   275
   233
   237
   323
   321
   253
   102
   226
   219
   297
   319
   327
   249
   96
   Time taken: 4.221 seconds, Fetched 15 row(s)
   ```
   
   
   [Actual behavior]
   
   
   ```
   spark-sql (default)>   select
                      >     max(a) as id
                      >   from
                      >     testtable
                      >   where
                      >     c = 2  
                      >   group by
                      >     b;
   139938755249256
   139938755249256
   139936948064087
   139945378802512
   139945378802512
   139938755303160
   139938755303160
   139945378802512
   139945378802512
   139938755249256
   139945378802512
   139945378802512
   139945378802512
   139938755249256
   139938755303160
   Time taken: 4.244 seconds, Fetched 15 row(s)
   ```
   
   
   
   ### 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