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: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
