datart icon indicating copy to clipboard operation
datart copied to clipboard

Sql parse bug

Open JashonHuang opened this issue 3 years ago • 0 comments

version: 1.0.0-beta.3 SQL:SELECT * FROM mytable t where indicator_name = $INDICATOR_NAME$ ) AS "DATART_VTABLE" OFFSET 0 LIMIT 1000 DB: PRESTO EXCEPTION:org.apache.calcite.sql.parser.SqlParseException: Encountered "LIMIT" at line 1, column 390. Was expecting one of: <EOF> "FETCH" ... "ROW" ... "ROWS" ...

Hi when i use presto sql config a variable in datart , it shows sql parse error, however when not use variable it turns right. the indicator_name is a string type and i config INDICATOR_NAME as string as well

JashonHuang avatar Jun 10 '22 12:06 JashonHuang