WindyGao opened a new issue #7598: URL: https://github.com/apache/incubator-doris/issues/7598
### 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 0.15.1 and above ### What's Wrong? In 0.14.13.1 and previous versions, user can use struct as an identifier. For example: `CREATE ROUTINE LOAD dwd_osms_organization_load ON dwd_osms_organization COLUMNS(oid, type, struct,name, `leaderName`, `leaderId`, leaderUserId, mobile, parent, organizationCreateTime,organizationUpdateTime, updateStamp=UNIX_TIMESTAMP()) PROPERTIES ( "desired_concurrent_number"="3", "max_batch_interval" = "10", "max_batch_rows" = "300000", "max_batch_size" = "209715200", "strict_mode" = "false", "format" = "json" ) FROM KAFKA ( "kafka_broker_list" = "th199:9092,th200:9092,th201:9092", "kafka_topic" = "course_dwd_osms_organization", "property.group.id" = "doris.dwd_osms_organization_load", "property.client.id" = "doris.dwd_osms_organization_load", "property.kafka_default_offsets" = "OFFSET_BEGINNING" );` But when upgrade Doris to 0.15.1, the sql is parsing error after restarted FE. `java.io.IOException: error happens when parsing create routine load stmt: ` When execute a sql contain stream as identifier in 0.15.1, it occurs error too. `ERROR 1105 (HY000): errCode = 2, detailMessage = Syntax error in line 3: ... Encountered: STRUCT Expected: STRUCT is keyword, maybe `STRUCT`` ### What You Expected? Execute normally. ### How to Reproduce? # upgrade Set up a Doris cluster in 0.14.13.1 Create table `CREATE TABLE `dwd_osms_organization` ( `oid` int(11) NOT NULL COMMENT "", `name` varchar(255) NULL COMMENT "", `type` int(11) NULL COMMENT "", `struct` int(11) NULL COMMENT "", `leaderName` varchar(255) NULL COMMENT "", `leaderId` int(11) NULL COMMENT "", `leaderUserId` varchar(255) NULL COMMENT "", `mobile` varchar(255) NULL COMMENT "", `parent` int(11) NULL COMMENT "", `organizationCreateTime` bigint(20) NULL COMMENT "", `organizationUpdateTime` bigint(20) NULL COMMENT "", `updateStamp` int(11) NULL COMMENT "doris更新时间" ) ENGINE=OLAP UNIQUE KEY(`oid`) COMMENT "dwd_osms_organization" DISTRIBUTED BY HASH(`oid`) BUCKETS 150 PROPERTIES ( "replication_num" = "1", "in_memory" = "false", "storage_format" = "V2" );` Create routine load `CREATE ROUTINE LOAD dwd_osms_organization_load ON dwd_osms_organization COLUMNS(oid, type, struct,name, `leaderName`, `leaderId`, leaderUserId, mobile, parent, organizationCreateTime,organizationUpdateTime, updateStamp=UNIX_TIMESTAMP()) PROPERTIES ( "desired_concurrent_number"="3", "max_batch_interval" = "10", "max_batch_rows" = "300000", "max_batch_size" = "209715200", "strict_mode" = "false", "format" = "json" ) FROM KAFKA ( "kafka_broker_list" = "th199:9092,th200:9092,th201:9092", "kafka_topic" = "course_dwd_osms_organization", "property.group.id" = "doris.dwd_osms_organization_load", "property.client.id" = "doris.dwd_osms_organization_load", "property.kafka_default_offsets" = "OFFSET_BEGINNING" );` Upgrade Doris to 0.15.1 The FE won't start up. # Current Set up a current version of Doris Create table as above. Create routine load as above. Occurs error. ### Anything Else? patch #7323 it also occurs ![Uploading image.png…]() ### 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
