mmuru opened a new issue #4799:
URL: https://github.com/apache/incubator-doris/issues/4799
**Is your feature request related to a problem? Please describe.**
Currently, Doris does not support update table. It throws the exception when
we perform update on any data model tables.
Like any SQL databases, the update table should be supported in Doris.
**Describe the solution you'd like**
Like Apache Impala supports update table statement. Hence, Apache Doris
should support update table statement in all data model tables. I believe,
update is being supported implicitly within Apache Doris.
**Describe alternatives you've considered**
N/A
**Additional context**
`
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]
`
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
