You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by GitBox <gi...@apache.org> on 2019/06/20 18:19:58 UTC
[GitHub] [incubator-druid] vogievetsky opened a new issue #7935: DruidSQL
should support everything that it claims to support in error messages
vogievetsky opened a new issue #7935: DruidSQL should support everything that it claims to support in error messages
URL: https://github.com/apache/incubator-druid/issues/7935
### Affected Version
Druid version 0.15.0 (and probably all the ones that came before)
### Description
I run the query:
```sql
SELECT EXTRACT(DATE FROM __time) AS T FROM wikipedia LIMIT 1
```
I get the error message of:
`Encountered "DATE" at line 1, column 31. Was expecting one of: "MICROSECOND" ... "MILLISECOND" ... "SECOND" ... "MINUTE" ... "HOUR" ... "DAY" ... "DOW" ... "DOY" ... "ISODOW" ... "ISOYEAR" ... "WEEK" ... "MONTH" ... "QUARTER" ... "YEAR" ... "EPOCH" ... "DECADE" ... "CENTURY" ... "MILLENNIUM" ...`
That is fair enough `DATE` is not supported, not sure what I was thinking.
The error message seems to imply what is supported but the issue is only a subset of those work.
For example:
```sql
SELECT EXTRACT(ISOYEAR FROM __time) AS T FROM wikipedia LIMIT 1
```
returns
`Unknown exception / ISOYEAR / org.apache.calcite.sql.parser.SqlParseException`
and
```sql
SELECT EXTRACT(MILLISECOND FROM __time) AS T FROM wikipedia LIMIT 1
```
returns
`Unknown exception / Cannot build plan for query: SELECT EXTRACT(MILLISECOND FROM __time) AS T FROM wikipedia LIMIT 1 / org.apache.druid.java.util.common.ISE`
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org