Time or Timestamp should not be required as the first column in insert SQL statement

[jiazhili-dawnlight]

support

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

but not support

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 {'.', '('}

[jixuan1989]

hi, yes, we require the first column as time in an insert SQL... Any strong requirements for changing the position?

[jiazhili-dawnlight]

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

[jixuan1989]

yes, 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.

[jiazhili-dawnlight]

i familiar with antlr4 ....

[rhmangmang]

hi, yes, we require the first column as time in an insert SQL... Any strong requirements for changing the position?

this situation occurs again in release 0.11.0, should we write this description in the UserGuide?

[gofow]

Hi, I'd like to do this by modifying the 'insertColumnsSpec' in 'IoTDBSqlParser'. Would you mind assign the issue to me? @qiaojialin @HTHou @jixuan1989

[HTHou]

Fixed by https://github.com/apache/iotdb/pull/12074