按层级 sum 功能结果集,不支持使用“别名”
Open
- Dominant language
- Java
- Stars
- 6.4k
- Forks
- 1.2k
- Avg merge
- 1d 23h
- Merged PRs (30d)
- 115
Description
对字段 sum 查询后,希望使用“别名” 展示结果集列;例如:
select sum(errorQps) as errorQps ,sum(QPS) as QPS from root.yuerj."30001"."client-521".*.*.* GROUP BY ([1970-01-01T08:00:00.100+08:00, 1970-01-01T08:00:00.900+08:00), 100ms) ,level=3
Contributor guide
Research direction
Start by reproducing the shown SELECT SUM ... AS ... GROUP BY query against Apache IoTDB, focusing on the level=3 hierarchical result set. Compare the returned column names with the aliases in the query; done means the aggregated columns are displayed using errorQps and QPS without breaking the query.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100