search

dbeaver / cloudbeaver

Cloud Database Manager
https://dbeaver.com/
Apache License 2.0
3.39k stars 370 forks source link

Can support the Apache IoTDB driver better ？ #2601

Closed sunquan819 closed 2 months ago

sunquan819 commented 4 months ago

After installing the Apache IoTDB driver using Dbeaver, most SQL can be executed, BUT after installing the Apache IoTDB driver using CloudBeaver, most SQL cannot be executed Some errors like the following: SQL Error [700] [Error occurred while parsing SQL to physical plan: line 1:61 token recognition error at: '']: 700: Error occurred while parsing SQL to physical plan: line 1:61 token recognition error at: '' SQL Error [700] [Error occurred while parsing SQL to physical plan: line 1:61 token recognition error at: '']: 700: Error occurred while parsing SQL to physical plan: line 1:61 token recognition error at: ''

Error details： Org. jkiss. dbeaver. model. SQL DBSQLException: SQL Error [700] [Error occurred while parsing SQL to physical plan: line 1:61 token recognition error at: '']: 700: Error occurred while parsing SQL to physical plan: line 1:61 token recognition error at: '' At org.jkiss.beaver.model. impl.jdbc. exec JDBCStatementImpl. executeStatement (JDBCStatementImpl. java: 133) At org.jkiss.beaver.model. impl.jdbc. structure JDBCTable. readData (JDBCTable. Java: 192) At io. cloudbeaver. service. SQL WebSQLProcessor. lambda $2 (WebSQLProcessor. java: 293) At org.jkiss.beaver.modeL.exec DBExecUtils. tryExecuteRecover (DBExecUtils. java: 194) At io. cloudbeaver. service. SQL WebSQLProcessor. readDataFromContainer (WebSQLProcessor. java: 290) At io. cloudbeaver. service. SQL. impl WebServiceSQL $2. run (WebServiceSQL. Java: 439) At io. cloudbeaver. model. session WebSession $1. run (WebSession. java: 742) At org. jkiss. beaver. model. runtime AbstractJob. run (AbstractJob. java: 115) At org. eclipse. core. internal. Jacobs Worker. run (Worker. java: 63) Caused by: org. apache. iotdb. jdbc IoTDBSQLException: 700: Error occurred while parsing SQL to physical plan: line 1:61 token recognition error at: '' At org. apache. iotdb. jdbc IoTDBStatement. executeSQL (IoTDBStatement. java: 265) At org. apache. iotdb. jdbc IoTDBStatement. execute (IoTDBStatement. java: 219) At org.jkiss.beaver.model. impl.jdbc. exec JDBCStatementImpl. execute (JDBCStatementImpl. java: 330) At org.jkiss.beaver.model. impl.jdbc. exec JDBCStatementImpl. executeStatement (JDBCStatementImpl. java: 131) ... 8 more

LonwoLonwo commented 4 months ago

Hello @sunquan819

Could you please provide footage of your SQL execution? Which tabs do you use? Do you highlight the query text or not? Are you using the same driver in both products? These details will be beneficial.

LonwoLonwo commented 2 months ago

It's been a while since no update here. If the issue is still actual please let me know and provide additional information.