yhp353134 opened a new issue #7352:
URL: https://github.com/apache/incubator-doris/issues/7352


   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### Version
   
   apache 0.15 release版本
   
   ### What's Wrong?
   
   创建了一张表,通过canal同步数据
   CREATE TABLE `test_doris2`
   (
     `id`        int(10),
     `name`      varchar(255),
     `create_at` datetime,
     `update_at` datetime
   ) ENGINE =OLAP UNIQUE KEY(id) DISTRIBUTED BY HASH(id) BUCKETS 8;
   
   创建同步任务报错:
   CREATE SYNC ods.test_doris_job6
   (
     FROM test.test_doris2 INTO test_doris2
     COLUMNS(id, `name`, create_at, update_at)
   )
   FROM BINLOG
   (
     "type" = "canal",
     "canal.server.ip" = "x.x.x.x",
     "canal.server.port" = "11111",
     "canal.destination" = "doris",
     "canal.username" = "",
     "canal.password" = ""
   );
   错误信息:
   [2021-12-08 17:22:23] [42000][1064] errCode = 2, detailMessage = Syntax 
error in line 4:
   [2021-12-08 17:22:23] COLUMNS(id, `name`, create_at, update_at)
   [2021-12-08 17:22:23] ^
   [2021-12-08 17:22:23] Encountered: COLUMNS
   [2021-12-08 17:22:23] Expected: COMMA
   
   
   
   
   
   ### What You Expected?
   
   我想调换字段顺序映射
   
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


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

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to