lgbo-ustc commented on issue #8142:
URL:
https://github.com/apache/incubator-gluten/issues/8142#issuecomment-2518977374
problems
## 1
```sql
0: jdbc:hive2://localhost:10000> explain select days, rtime, uid, owner,
day1 from(select day1 as days, rtime, uid, owner, day1 from (select distinct
coalesce(day, "today") as day1, rtime, uid, owner from test_7096 where day =
'2024-09-01')) group by days, rtime, uid, owner, day1;
+----------------------------------------------------+
| plan |
+----------------------------------------------------+
| == Physical Plan ==
CHNativeColumnarToRow
+- ^(2) HashAggregateTransformer(keys=[day1#0, rtime#8, uid#9, owner#10],
functions=[], isStreamingAgg=false)
+- ^(2) InputIteratorTransformer[day1#0, rtime#8, uid#9, owner#10]
+- ColumnarExchange hashpartitioning(day1#0, rtime#8, uid#9, owner#10,
day1#0, 5), ENSURE_REQUIREMENTS, [plan_id=155], [shuffle_writer_type=hash],
[OUTPUT] ArrayBuffer(day1:StringType, rtime:IntegerType, uid:StringType,
owner:StringType)
+- ^(1) HashAggregateTransformer(keys=[day1#0, rtime#8, uid#9,
owner#10], functions=[], isStreamingAgg=false)
+- ^(1) ProjectExecTransformer [coalesce(day#7, today) AS
day1#0, rtime#8, uid#9, owner#10]
+- ^(1) FilterExecTransformer (isnotnull(day#7) AND (day#7 =
2024-09-01))
+- ^(1) NativeScan hive default.test_7096 [day#7,
owner#10, rtime#8, uid#9], HiveTableRelation [`default`.`test_7096`,
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [day#7, rtime#8,
uid#9, owner#10], Partition Cols: []]
|
+----------------------------------------------------+
```
If we make columns are unique in grouping keys and aggregate results. There
is mismatch between aggregate result and output.
--
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]
