问题描述:背景:在仪表盘传递时间查询时报错
ERROR datart.server.config.WebExceptionHandler : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2021-07-28 00:00:00'' at line 1
传递时间后sql语句变为>=TIMESTAMP ‘2021-07-28 00:00:00’ and <TIMESTAMP ‘2022-07-28 00:00:00’
starrocks中不支持这种sql。
解决方案:修改datart源代码
在SqlScriptRender类中找到replacementPair.getReplacement()代码:
打包上传