Re: update table

[Zhao Chun]

Hi

Doris don't support 'update' statement right now.
If you want to update a table, you should create table with `unique key`.
They you can insert a new row to overwrite the old one.

Thanks,
Zhao Chun


Murugan Muthusamy <mmuru...@gmail.com> 于2020年10月27日周二 上午2:33写道：

> 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]
>