zemin-piao opened a new issue #11909:
URL: https://github.com/apache/druid/issues/11909
Please provide a detailed title (e.g. "Broker crashes when using TopN query
with Bound filter" instead of just "Broker crashes").
### 0.21.0
The Druid version where the problem was encountered.
### Description
As mentioned in the title, when running sql query which does aggregation on
column with name "count", it returns SQL parse failed issue. For example:
```
select sum(count) from capturesummary where id = 707849 and ps = 459 group
by jt, ps, __time
```
error message:
```
SQL parse failed (org.apache.calcite.sql.parser.SqlParseException):
Encountered "count )" at line 1, column 12.
Was expecting one of:
"ALL" ...
"ARRAY" ...
"CASE" ...
"CURRENT" ...
"CURRENT_CATALOG" ...
"CURRENT_DATE" ...
"CURRENT_DEFAULT_TRANSFORM_GROUP" ...
"CURRENT_PATH" ...
"CURRENT_ROLE" ...
"CURRENT_SCHEMA" ...
"CURRENT_TIME" ...
```
--
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]
