[GH-ISSUE #2601] Can support the Apache IoTDB driver better ？ #872

New issue

Closed

opened 2026-03-07 20:56:02 +03:00 by kerem · 0 comments

kerem commented

2026-03-07 20:56:02 +03:00

Owner

Originally created by @sunquan819 on GitHub (May 10, 2024).
Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/2601

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

Originally created by @sunquan819 on GitHub (May 10, 2024). Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/2601 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

Rows
Columns