I’m having trouble inserting data into Apache IoTDB. My data includes text values that contain semicolons, and I’m encountering a 700 syntax parsing error. Here is a simplified version of the data and the SQL statement I’m using:

INSERT INTO root.ln.wf01.wt01(timestamp, temperature, status)
VALUES (1625589000000, 35.5, 'normal; no issues detected');

When I run this, IoTDB returns:

Error 700: Syntax parsing error

From what I understand, in IoTDB, semicolons are used to terminate SQL statements, and having a semicolon within a text value seems to cause an issue. I’ve tried various ways to escape the semicolon but haven’t found a solution.

• Environment:
  • Apache IoTDB version: 0.12.4
  • Client: IoTDB CLI

My question is twofold:

1. How can I properly insert text values that include semicolons without causing a syntax error?
2. Are there any escaping mechanisms or special syntax that IoTDB supports to handle such cases?

Any guidance or examples on how to handle this would be greatly appreciated!