Should time or timestamp be required as the first column in the insert SQL statement when using Apache IoTDB?

user_17147335 0
Viewed 27

In v0.12.2, it is supported:

insert into root.test2.wf01.wt01(time, json ,`status`) values (111, "abcddf", true)

but not supported:

insert into root.test2.wf01.wt01(json, `status`, time) values ("abcddf", true, 111)

get error msg:

Msg: 401: line 1:34 mismatched input 'json' expecting {'.', '('}

I am developing an ORM tool. If the time must be in the first column, many popular ORM tools (hibernate, JPA, Spring Data)will not be able to integrate IoTDB.

iotdb apache-iotdb time-series database
1 Answers

yes, we require the first column as time in an insert SQL... I think we can modify our Antlr parser to support that. By the way, are you familiar with antlr4? I believe it is not a big modification.

user_171032630
Related