Hi,
I am using Master branch and running the following query
update table1 set username='muru' where siteid=5;
throws exception (see below)
I checked Doris FAQ and documentation but no reference to the update table.
Please, help me to understand and how to update table values?
Thanks,
Muru
2020-10-06 17:41:09,617 WARN (doris-mysql-nio-pool-82|684)
[ConnectProcessor.analyze():243] origin_stmt: update table1 set
username='muru' where siteid=5; Analyze error message: Syntax error in line
1:
update table1 set username='muru' where siteid=5
^
Encountered: IDENTIFIER
Expected
org.apache.doris.common.AnalysisException: errCode = 2, detailMessage =
Syntax error
at
org.apache.doris.analysis.SqlParser.unrecovered_syntax_error(SqlParser.java:1749)
~[palo-fe.jar:3.4.0]
at java_cup.runtime.lr_parser.parse(lr_parser.java:616)
~[jflex-1.4.3.jar:?]
at
org.apache.doris.common.util.SqlParserUtils.getMultiStmts(SqlParserUtils.java:50)
~[palo-fe.jar:3.4.0]
at
org.apache.doris.qe.ConnectProcessor.analyze(ConnectProcessor.java:239)
~[palo-fe.jar:3.4.0]
at
org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:183)
~[palo-fe.jar:3.4.0]
at
org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:325)
~[palo-fe.jar:3.4.0]
at
org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:510)
~[palo-fe.jar:3.4.0]
at
org.apache.doris.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:50)
~[palo-fe.jar:3.4.0]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_262]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_262]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_262]
