taiyang-li opened a new issue, #9193:
URL: https://github.com/apache/incubator-gluten/issues/9193
### Backend
CH (ClickHouse)
### Bug description
``` sql
CREATE TEMPORARY VIEW lineitem
USING org.apache.spark.sql.parquet
OPTIONS (
path "/data1/liyang/tpch/tpch-data-sf1/lineitem"
) ;
```
vanilla
``` sql
0: jdbc:hive2://localhost:10000/> select sum(if(l_tax > 0.5, 1, 0)) from
lineitem;
+---------------------------------+
| sum((IF((l_tax > 0.5), 1, 0))) |
+---------------------------------+
| 0 |
+---------------------------------+
1 row selected (0.323 seconds)
```
gluten
```
0: jdbc:hive2://localhost:10000/> select sum(if(l_tax > 0.5, 1, 0)) from
lineitem;
+---------------------------------+
| sum((IF((l_tax > 0.5), 1, 0))) |
+---------------------------------+
| NULL |
+---------------------------------+
1 row selected (0.294 seconds)
```
### 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]
