This is an automated email from the ASF dual-hosted git repository.
zhangliang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new a241fb1fc27 Support parsing Doris ALTER/PAUSE/RESUME ROUTINE LOAD
syntax (#38144)
a241fb1fc27 is described below
commit a241fb1fc27457c39ca029189ce3eb38ed331e30
Author: cxy <[email protected]>
AuthorDate: Sun Feb 22 22:12:38 2026 +0800
Support parsing Doris ALTER/PAUSE/RESUME ROUTINE LOAD syntax (#38144)
---
.../core/database/visitor/SQLVisitorRule.java | 6 ++
.../src/main/antlr4/imports/doris/DMLStatement.g4 | 12 +++
.../sql/parser/autogen/DorisStatement.g4 | 3 +
.../statement/type/DorisDMLStatementVisitor.java | 78 ++++++++++++++++++
.../doris/dml/DorisAlterRoutineLoadStatement.java | 63 ++++++++++++++
.../doris/dml/DorisPauseRoutineLoadStatement.java | 51 ++++++++++++
.../doris/dml/DorisResumeRoutineLoadStatement.java | 51 ++++++++++++
.../DorisAlterRoutineLoadStatementAssert.java | 95 ++++++++++++++++++++++
.../dml/dialect/doris/DorisDMLStatementAssert.java | 12 +++
...a => DorisPauseRoutineLoadStatementAssert.java} | 29 ++++---
... => DorisResumeRoutineLoadStatementAssert.java} | 29 ++++---
.../cases/parser/jaxb/RootSQLParserTestCases.java | 12 +++
.../DorisAlterRoutineLoadStatementTestCase.java | 55 +++++++++++++
.../DorisPauseRoutineLoadStatementTestCase.java | 46 +++++++++++
.../DorisResumeRoutineLoadStatementTestCase.java | 46 +++++++++++
.../main/resources/case/dml/alter-routine-load.xml | 37 +++++++++
.../main/resources/case/dml/pause-routine-load.xml | 27 ++++++
.../resources/case/dml/resume-routine-load.xml | 27 ++++++
.../sql/supported/dml/alter-routine-load.xml | 23 ++++++
.../sql/supported/dml/pause-routine-load.xml | 23 ++++++
.../sql/supported/dml/resume-routine-load.xml | 23 ++++++
21 files changed, 724 insertions(+), 24 deletions(-)
diff --git
a/parser/sql/engine/core/src/main/java/org/apache/shardingsphere/sql/parser/engine/core/database/visitor/SQLVisitorRule.java
b/parser/sql/engine/core/src/main/java/org/apache/shardingsphere/sql/parser/engine/core/database/visitor/SQLVisitorRule.java
index 67f75be8ac2..04685c67bb1 100644
---
a/parser/sql/engine/core/src/main/java/org/apache/shardingsphere/sql/parser/engine/core/database/visitor/SQLVisitorRule.java
+++
b/parser/sql/engine/core/src/main/java/org/apache/shardingsphere/sql/parser/engine/core/database/visitor/SQLVisitorRule.java
@@ -425,6 +425,12 @@ public enum SQLVisitorRule {
CREATE_ROUTINE_LOAD("CreateRoutineLoad", SQLStatementType.DML),
+ ALTER_ROUTINE_LOAD("AlterRoutineLoad", SQLStatementType.DML),
+
+ PAUSE_ROUTINE_LOAD("PauseRoutineLoad", SQLStatementType.DML),
+
+ RESUME_ROUTINE_LOAD("ResumeRoutineLoad", SQLStatementType.DML),
+
SHOW_CREATE_TABLE("ShowCreateTable", SQLStatementType.DAL),
SHOW_OTHER("ShowOther", SQLStatementType.DAL),
diff --git
a/parser/sql/engine/dialect/doris/src/main/antlr4/imports/doris/DMLStatement.g4
b/parser/sql/engine/dialect/doris/src/main/antlr4/imports/doris/DMLStatement.g4
index 8520176e295..a85ea71f89e 100644
---
a/parser/sql/engine/dialect/doris/src/main/antlr4/imports/doris/DMLStatement.g4
+++
b/parser/sql/engine/dialect/doris/src/main/antlr4/imports/doris/DMLStatement.g4
@@ -263,6 +263,18 @@ dataSourceProperty
: (identifier | SINGLE_QUOTED_TEXT | DOUBLE_QUOTED_TEXT) EQ_? literals
;
+alterRoutineLoad
+ : ALTER ROUTINE LOAD FOR (owner DOT_)? jobName jobProperties? (FROM
dataSource dataSourceProperties?)?
+ ;
+
+pauseRoutineLoad
+ : PAUSE (ALL ROUTINE LOAD | (ROUTINE LOAD FOR (owner DOT_)? jobName))
+ ;
+
+resumeRoutineLoad
+ : RESUME (ALL ROUTINE LOAD | (ROUTINE LOAD FOR (owner DOT_)? jobName))
+ ;
+
loadDataStatement
: LOAD DATA
(LOW_PRIORITY | CONCURRENT)? LOCAL?
diff --git
a/parser/sql/engine/dialect/doris/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/DorisStatement.g4
b/parser/sql/engine/dialect/doris/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/DorisStatement.g4
index f1c9eba4214..c17be2b7bee 100644
---
a/parser/sql/engine/dialect/doris/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/DorisStatement.g4
+++
b/parser/sql/engine/dialect/doris/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/DorisStatement.g4
@@ -87,6 +87,9 @@ execute
| kill
| loadStatement
| createRoutineLoad
+ | alterRoutineLoad
+ | pauseRoutineLoad
+ | resumeRoutineLoad
| cacheIndex
| loadIndexInfo
| optimizeTable
diff --git
a/parser/sql/engine/dialect/doris/src/main/java/org/apache/shardingsphere/sql/parser/engine/doris/visitor/statement/type/DorisDMLStatementVisitor.java
b/parser/sql/engine/dialect/doris/src/main/java/org/apache/shardingsphere/sql/parser/engine/doris/visitor/statement/type/DorisDMLStatementVisitor.java
index 53ba2071911..62dd4479826 100644
---
a/parser/sql/engine/dialect/doris/src/main/java/org/apache/shardingsphere/sql/parser/engine/doris/visitor/statement/type/DorisDMLStatementVisitor.java
+++
b/parser/sql/engine/dialect/doris/src/main/java/org/apache/shardingsphere/sql/parser/engine/doris/visitor/statement/type/DorisDMLStatementVisitor.java
@@ -21,11 +21,14 @@ import org.antlr.v4.runtime.tree.TerminalNode;
import org.apache.shardingsphere.database.connector.core.type.DatabaseType;
import org.apache.shardingsphere.sql.parser.api.ASTNode;
import
org.apache.shardingsphere.sql.parser.api.visitor.statement.type.DMLStatementVisitor;
+import
org.apache.shardingsphere.sql.parser.autogen.DorisStatementParser.AlterRoutineLoadContext;
import
org.apache.shardingsphere.sql.parser.autogen.DorisStatementParser.CallContext;
import
org.apache.shardingsphere.sql.parser.autogen.DorisStatementParser.ColumnsClauseContext;
import
org.apache.shardingsphere.sql.parser.autogen.DorisStatementParser.ColumnMappingContext;
import
org.apache.shardingsphere.sql.parser.autogen.DorisStatementParser.CreateRoutineLoadContext;
import
org.apache.shardingsphere.sql.parser.autogen.DorisStatementParser.DataSourcePropertyContext;
+import
org.apache.shardingsphere.sql.parser.autogen.DorisStatementParser.PauseRoutineLoadContext;
+import
org.apache.shardingsphere.sql.parser.autogen.DorisStatementParser.ResumeRoutineLoadContext;
import
org.apache.shardingsphere.sql.parser.autogen.DorisStatementParser.DoStatementContext;
import
org.apache.shardingsphere.sql.parser.autogen.DorisStatementParser.HandlerStatementContext;
import
org.apache.shardingsphere.sql.parser.autogen.DorisStatementParser.ImportStatementContext;
@@ -63,7 +66,10 @@ import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dml.Ca
import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dml.DoStatement;
import org.apache.shardingsphere.sql.parser.statement.core.util.SQLUtils;
import
org.apache.shardingsphere.sql.parser.statement.core.value.identifier.IdentifierValue;
+import
org.apache.shardingsphere.sql.parser.statement.doris.dml.DorisAlterRoutineLoadStatement;
import
org.apache.shardingsphere.sql.parser.statement.doris.dml.DorisCreateRoutineLoadStatement;
+import
org.apache.shardingsphere.sql.parser.statement.doris.dml.DorisPauseRoutineLoadStatement;
+import
org.apache.shardingsphere.sql.parser.statement.doris.dml.DorisResumeRoutineLoadStatement;
import
org.apache.shardingsphere.sql.parser.statement.mysql.dml.MySQLHandlerStatement;
import
org.apache.shardingsphere.sql.parser.statement.mysql.dml.MySQLImportStatement;
import
org.apache.shardingsphere.sql.parser.statement.mysql.dml.MySQLLoadDataStatement;
@@ -199,6 +205,78 @@ public final class DorisDMLStatementVisitor extends
DorisStatementVisitor implem
return result;
}
+ @Override
+ public ASTNode visitAlterRoutineLoad(final AlterRoutineLoadContext ctx) {
+ DorisAlterRoutineLoadStatement result = new
DorisAlterRoutineLoadStatement(getDatabaseType());
+ if (null != ctx.jobName()) {
+ JobNameSegment jobName = new
JobNameSegment(ctx.jobName().start.getStartIndex(),
ctx.jobName().stop.getStopIndex(), new
IdentifierValue(ctx.jobName().getText()));
+ if (null != ctx.owner()) {
+ OwnerSegment owner = (OwnerSegment) visit(ctx.owner());
+ jobName.setOwner(owner);
+ }
+ result.setJobName(jobName);
+ }
+ if (null != ctx.jobProperties()) {
+ PropertiesSegment propertiesSegment = new
PropertiesSegment(ctx.jobProperties().start.getStartIndex(),
ctx.jobProperties().stop.getStopIndex());
+ for (int i = 0; i < ctx.jobProperties().jobProperty().size(); i++)
{
+ JobPropertyContext propertyCtx =
ctx.jobProperties().jobProperty(i);
+ String key = getPropertyKey(propertyCtx.identifier(),
propertyCtx.SINGLE_QUOTED_TEXT(), propertyCtx.DOUBLE_QUOTED_TEXT());
+ String value =
SQLUtils.getExactlyValue(propertyCtx.literals().getText());
+ PropertySegment propertySegment = new
PropertySegment(propertyCtx.start.getStartIndex(),
propertyCtx.stop.getStopIndex(), key, value);
+ propertiesSegment.getProperties().add(propertySegment);
+ }
+ result.setJobProperties(propertiesSegment);
+ }
+ if (null != ctx.dataSource()) {
+ result.setDataSource(ctx.dataSource().getText());
+ }
+ if (null != ctx.dataSourceProperties() && null !=
ctx.dataSourceProperties().dataSourceProperty()) {
+ PropertiesSegment propertiesSegment = new
PropertiesSegment(ctx.dataSourceProperties().start.getStartIndex(),
ctx.dataSourceProperties().stop.getStopIndex());
+ for (int i = 0; i <
ctx.dataSourceProperties().dataSourceProperty().size(); i++) {
+ DataSourcePropertyContext propertyCtx =
ctx.dataSourceProperties().dataSourceProperty(i);
+ String key = getPropertyKey(propertyCtx.identifier(),
propertyCtx.SINGLE_QUOTED_TEXT(), propertyCtx.DOUBLE_QUOTED_TEXT());
+ String value =
SQLUtils.getExactlyValue(propertyCtx.literals().getText());
+ PropertySegment propertySegment = new
PropertySegment(propertyCtx.start.getStartIndex(),
propertyCtx.stop.getStopIndex(), key, value);
+ propertiesSegment.getProperties().add(propertySegment);
+ }
+ result.setDataSourceProperties(propertiesSegment);
+ }
+ result.addParameterMarkers(getParameterMarkerSegments());
+ return result;
+ }
+
+ @Override
+ public ASTNode visitPauseRoutineLoad(final PauseRoutineLoadContext ctx) {
+ DorisPauseRoutineLoadStatement result = new
DorisPauseRoutineLoadStatement(getDatabaseType());
+ result.setAll(null != ctx.ALL());
+ if (null != ctx.jobName()) {
+ JobNameSegment jobName = new
JobNameSegment(ctx.jobName().start.getStartIndex(),
ctx.jobName().stop.getStopIndex(), new
IdentifierValue(ctx.jobName().getText()));
+ if (null != ctx.owner()) {
+ OwnerSegment owner = (OwnerSegment) visit(ctx.owner());
+ jobName.setOwner(owner);
+ }
+ result.setJobName(jobName);
+ }
+ result.addParameterMarkers(getParameterMarkerSegments());
+ return result;
+ }
+
+ @Override
+ public ASTNode visitResumeRoutineLoad(final ResumeRoutineLoadContext ctx) {
+ DorisResumeRoutineLoadStatement result = new
DorisResumeRoutineLoadStatement(getDatabaseType());
+ result.setAll(null != ctx.ALL());
+ if (null != ctx.jobName()) {
+ JobNameSegment jobName = new
JobNameSegment(ctx.jobName().start.getStartIndex(),
ctx.jobName().stop.getStopIndex(), new
IdentifierValue(ctx.jobName().getText()));
+ if (null != ctx.owner()) {
+ OwnerSegment owner = (OwnerSegment) visit(ctx.owner());
+ jobName.setOwner(owner);
+ }
+ result.setJobName(jobName);
+ }
+ result.addParameterMarkers(getParameterMarkerSegments());
+ return result;
+ }
+
private void processColumnMappings(final ColumnsClauseContext
columnsClauseCtx, final DorisCreateRoutineLoadStatement statement) {
for (int i = 0; i < columnsClauseCtx.columnMapping().size(); i++) {
ColumnMappingContext mappingCtx =
columnsClauseCtx.columnMapping(i);
diff --git
a/parser/sql/statement/dialect/doris/src/main/java/org/apache/shardingsphere/sql/parser/statement/doris/dml/DorisAlterRoutineLoadStatement.java
b/parser/sql/statement/dialect/doris/src/main/java/org/apache/shardingsphere/sql/parser/statement/doris/dml/DorisAlterRoutineLoadStatement.java
new file mode 100644
index 00000000000..e2a1877393d
--- /dev/null
+++
b/parser/sql/statement/dialect/doris/src/main/java/org/apache/shardingsphere/sql/parser/statement/doris/dml/DorisAlterRoutineLoadStatement.java
@@ -0,0 +1,63 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.shardingsphere.sql.parser.statement.doris.dml;
+
+import lombok.Getter;
+import lombok.Setter;
+import org.apache.shardingsphere.database.connector.core.type.DatabaseType;
+import
org.apache.shardingsphere.sql.parser.statement.core.segment.ddl.job.JobNameSegment;
+import
org.apache.shardingsphere.sql.parser.statement.core.segment.ddl.property.PropertiesSegment;
+import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dml.DMLStatement;
+
+import java.util.Optional;
+
+/**
+ * Doris alter routine load statement.
+ */
+@Getter
+@Setter
+public final class DorisAlterRoutineLoadStatement extends DMLStatement {
+
+ private JobNameSegment jobName;
+
+ private PropertiesSegment jobProperties;
+
+ private String dataSource;
+
+ private PropertiesSegment dataSourceProperties;
+
+ public DorisAlterRoutineLoadStatement(final DatabaseType databaseType) {
+ super(databaseType);
+ }
+
+ public Optional<JobNameSegment> getJobName() {
+ return Optional.ofNullable(jobName);
+ }
+
+ public Optional<PropertiesSegment> getJobProperties() {
+ return Optional.ofNullable(jobProperties);
+ }
+
+ public Optional<String> getDataSource() {
+ return Optional.ofNullable(dataSource);
+ }
+
+ public Optional<PropertiesSegment> getDataSourceProperties() {
+ return Optional.ofNullable(dataSourceProperties);
+ }
+}
diff --git
a/parser/sql/statement/dialect/doris/src/main/java/org/apache/shardingsphere/sql/parser/statement/doris/dml/DorisPauseRoutineLoadStatement.java
b/parser/sql/statement/dialect/doris/src/main/java/org/apache/shardingsphere/sql/parser/statement/doris/dml/DorisPauseRoutineLoadStatement.java
new file mode 100644
index 00000000000..d4b48860fe8
--- /dev/null
+++
b/parser/sql/statement/dialect/doris/src/main/java/org/apache/shardingsphere/sql/parser/statement/doris/dml/DorisPauseRoutineLoadStatement.java
@@ -0,0 +1,51 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.shardingsphere.sql.parser.statement.doris.dml;
+
+import lombok.Getter;
+import lombok.Setter;
+import org.apache.shardingsphere.database.connector.core.type.DatabaseType;
+import
org.apache.shardingsphere.sql.parser.statement.core.segment.ddl.job.JobNameSegment;
+import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dml.DMLStatement;
+
+import java.util.Optional;
+
+/**
+ * Doris pause routine load statement.
+ */
+@Getter
+@Setter
+public final class DorisPauseRoutineLoadStatement extends DMLStatement {
+
+ private boolean all;
+
+ private JobNameSegment jobName;
+
+ public DorisPauseRoutineLoadStatement(final DatabaseType databaseType) {
+ super(databaseType);
+ }
+
+ /**
+ * Get job name segment.
+ *
+ * @return job name segment
+ */
+ public Optional<JobNameSegment> getJobName() {
+ return Optional.ofNullable(jobName);
+ }
+}
diff --git
a/parser/sql/statement/dialect/doris/src/main/java/org/apache/shardingsphere/sql/parser/statement/doris/dml/DorisResumeRoutineLoadStatement.java
b/parser/sql/statement/dialect/doris/src/main/java/org/apache/shardingsphere/sql/parser/statement/doris/dml/DorisResumeRoutineLoadStatement.java
new file mode 100644
index 00000000000..54462ef72a0
--- /dev/null
+++
b/parser/sql/statement/dialect/doris/src/main/java/org/apache/shardingsphere/sql/parser/statement/doris/dml/DorisResumeRoutineLoadStatement.java
@@ -0,0 +1,51 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.shardingsphere.sql.parser.statement.doris.dml;
+
+import lombok.Getter;
+import lombok.Setter;
+import org.apache.shardingsphere.database.connector.core.type.DatabaseType;
+import
org.apache.shardingsphere.sql.parser.statement.core.segment.ddl.job.JobNameSegment;
+import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dml.DMLStatement;
+
+import java.util.Optional;
+
+/**
+ * Doris resume routine load statement.
+ */
+@Getter
+@Setter
+public final class DorisResumeRoutineLoadStatement extends DMLStatement {
+
+ private boolean all;
+
+ private JobNameSegment jobName;
+
+ public DorisResumeRoutineLoadStatement(final DatabaseType databaseType) {
+ super(databaseType);
+ }
+
+ /**
+ * Get job name segment.
+ *
+ * @return job name segment
+ */
+ public Optional<JobNameSegment> getJobName() {
+ return Optional.ofNullable(jobName);
+ }
+}
diff --git
a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisAlterRoutineLoadStatementAssert.java
b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisAlterRoutineLoadStatementAssert.java
new file mode 100644
index 00000000000..fc9946ebf04
--- /dev/null
+++
b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisAlterRoutineLoadStatementAssert.java
@@ -0,0 +1,95 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package
org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.dml.dialect.doris;
+
+import lombok.AccessLevel;
+import lombok.NoArgsConstructor;
+import
org.apache.shardingsphere.sql.parser.statement.core.segment.ddl.property.PropertySegment;
+import
org.apache.shardingsphere.sql.parser.statement.doris.dml.DorisAlterRoutineLoadStatement;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.asserts.segment.SQLSegmentAssert;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.asserts.segment.owner.OwnerAssert;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dal.dialect.doris.PropertyTestCase;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dml.dialect.doris.DorisAlterRoutineLoadStatementTestCase;
+import org.hamcrest.CoreMatchers;
+import org.hamcrest.MatcherAssert;
+import org.junit.jupiter.api.Assertions;
+
+/**
+ * Alter routine load statement assert for Doris.
+ */
+@NoArgsConstructor(access = AccessLevel.PRIVATE)
+public final class DorisAlterRoutineLoadStatementAssert {
+
+ /**
+ * Assert alter routine load statement is correct with expected parser
result.
+ *
+ * @param assertContext assert context
+ * @param actual actual alter routine load statement
+ * @param expected expected alter routine load statement test case
+ */
+ public static void assertIs(final SQLCaseAssertContext assertContext,
final DorisAlterRoutineLoadStatement actual, final
DorisAlterRoutineLoadStatementTestCase expected) {
+ assertJobName(assertContext, actual, expected);
+ assertJobProperties(assertContext, actual, expected);
+ assertDataSource(assertContext, actual, expected);
+ assertDataSourceProperties(assertContext, actual, expected);
+ }
+
+ private static void assertJobName(final SQLCaseAssertContext
assertContext, final DorisAlterRoutineLoadStatement actual, final
DorisAlterRoutineLoadStatementTestCase expected) {
+ if (actual.getJobName().isPresent()) {
+ MatcherAssert.assertThat(assertContext.getText("Job name does not
match: "), actual.getJobName().get().getIdentifier().getValue(),
CoreMatchers.is(expected.getJobName()));
+ if (null != expected.getOwner()) {
+ OwnerAssert.assertIs(assertContext,
actual.getJobName().get().getOwner().orElse(null), expected.getOwner());
+ }
+ }
+ }
+
+ private static void assertJobProperties(final SQLCaseAssertContext
assertContext, final DorisAlterRoutineLoadStatement actual, final
DorisAlterRoutineLoadStatementTestCase expected) {
+ if (actual.getJobProperties().isPresent() && null !=
expected.getJobProperties() && !expected.getJobProperties().isEmpty()) {
+ Assertions.assertNotNull(actual.getJobProperties().get(),
assertContext.getText("Job properties should not be null"));
+ MatcherAssert.assertThat(assertContext.getText("Job properties
size does not match: "), actual.getJobProperties().get().getProperties().size(),
+ CoreMatchers.is(expected.getJobProperties().size()));
+ for (int i = 0; i < expected.getJobProperties().size(); i++) {
+ assertProperty(assertContext,
actual.getJobProperties().get().getProperties().get(i),
expected.getJobProperties().get(i));
+ }
+ }
+ }
+
+ private static void assertDataSource(final SQLCaseAssertContext
assertContext, final DorisAlterRoutineLoadStatement actual, final
DorisAlterRoutineLoadStatementTestCase expected) {
+ if (null != expected.getDataSource()) {
+ MatcherAssert.assertThat(assertContext.getText("Data source does
not match: "), actual.getDataSource().orElse(null),
CoreMatchers.is(expected.getDataSource()));
+ }
+ }
+
+ private static void assertDataSourceProperties(final SQLCaseAssertContext
assertContext, final DorisAlterRoutineLoadStatement actual, final
DorisAlterRoutineLoadStatementTestCase expected) {
+ if (actual.getDataSourceProperties().isPresent() && null !=
expected.getDataSourceProperties() &&
!expected.getDataSourceProperties().isEmpty()) {
+ Assertions.assertNotNull(actual.getDataSourceProperties().get(),
assertContext.getText("Data source properties should not be null"));
+ MatcherAssert.assertThat(assertContext.getText("Data source
properties size does not match: "),
actual.getDataSourceProperties().get().getProperties().size(),
+
CoreMatchers.is(expected.getDataSourceProperties().size()));
+ for (int i = 0; i < expected.getDataSourceProperties().size();
i++) {
+ assertProperty(assertContext,
actual.getDataSourceProperties().get().getProperties().get(i),
expected.getDataSourceProperties().get(i));
+ }
+ }
+ }
+
+ private static void assertProperty(final SQLCaseAssertContext
assertContext, final PropertySegment actual, final PropertyTestCase expected) {
+ MatcherAssert.assertThat(assertContext.getText(String.format("Property
key '%s' assertion error: ", expected.getKey())), actual.getKey(),
CoreMatchers.is(expected.getKey()));
+ MatcherAssert.assertThat(assertContext.getText(String.format("Property
value for key '%s' assertion error: ", expected.getKey())), actual.getValue(),
CoreMatchers.is(expected.getValue()));
+ SQLSegmentAssert.assertIs(assertContext, actual, expected);
+ }
+}
diff --git
a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisDMLStatementAssert.java
b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisDMLStatementAssert.java
index 088a0d2693a..ad8f31f900a 100644
---
a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisDMLStatementAssert.java
+++
b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisDMLStatementAssert.java
@@ -20,10 +20,16 @@ package
org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.
import lombok.AccessLevel;
import lombok.NoArgsConstructor;
import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dml.DMLStatement;
+import
org.apache.shardingsphere.sql.parser.statement.doris.dml.DorisAlterRoutineLoadStatement;
import
org.apache.shardingsphere.sql.parser.statement.doris.dml.DorisCreateRoutineLoadStatement;
+import
org.apache.shardingsphere.sql.parser.statement.doris.dml.DorisPauseRoutineLoadStatement;
+import
org.apache.shardingsphere.sql.parser.statement.doris.dml.DorisResumeRoutineLoadStatement;
import
org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.SQLParserTestCase;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dml.dialect.doris.DorisAlterRoutineLoadStatementTestCase;
import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dml.dialect.doris.DorisCreateRoutineLoadStatementTestCase;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dml.dialect.doris.DorisPauseRoutineLoadStatementTestCase;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dml.dialect.doris.DorisResumeRoutineLoadStatementTestCase;
/**
* Doris DML statement assert.
@@ -41,6 +47,12 @@ public final class DorisDMLStatementAssert {
public static void assertIs(final SQLCaseAssertContext assertContext,
final DMLStatement actual, final SQLParserTestCase expected) {
if (actual instanceof DorisCreateRoutineLoadStatement) {
DorisCreateRoutineLoadStatementAssert.assertIs(assertContext,
(DorisCreateRoutineLoadStatement) actual,
(DorisCreateRoutineLoadStatementTestCase) expected);
+ } else if (actual instanceof DorisAlterRoutineLoadStatement) {
+ DorisAlterRoutineLoadStatementAssert.assertIs(assertContext,
(DorisAlterRoutineLoadStatement) actual,
(DorisAlterRoutineLoadStatementTestCase) expected);
+ } else if (actual instanceof DorisPauseRoutineLoadStatement) {
+ DorisPauseRoutineLoadStatementAssert.assertIs(assertContext,
(DorisPauseRoutineLoadStatement) actual,
(DorisPauseRoutineLoadStatementTestCase) expected);
+ } else if (actual instanceof DorisResumeRoutineLoadStatement) {
+ DorisResumeRoutineLoadStatementAssert.assertIs(assertContext,
(DorisResumeRoutineLoadStatement) actual,
(DorisResumeRoutineLoadStatementTestCase) expected);
}
}
}
diff --git
a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisDMLStatementAssert.java
b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisPauseRoutineLoadStatementAssert.java
similarity index 51%
copy from
test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisDMLStatementAssert.java
copy to
test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisPauseRoutineLoadStatementAssert.java
index 088a0d2693a..af1108890f4 100644
---
a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisDMLStatementAssert.java
+++
b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisPauseRoutineLoadStatementAssert.java
@@ -19,28 +19,33 @@ package
org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.
import lombok.AccessLevel;
import lombok.NoArgsConstructor;
-import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dml.DMLStatement;
-import
org.apache.shardingsphere.sql.parser.statement.doris.dml.DorisCreateRoutineLoadStatement;
+import
org.apache.shardingsphere.sql.parser.statement.doris.dml.DorisPauseRoutineLoadStatement;
import
org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
-import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.SQLParserTestCase;
-import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dml.dialect.doris.DorisCreateRoutineLoadStatementTestCase;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.asserts.segment.owner.OwnerAssert;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dml.dialect.doris.DorisPauseRoutineLoadStatementTestCase;
+import org.hamcrest.CoreMatchers;
+import org.hamcrest.MatcherAssert;
/**
- * Doris DML statement assert.
+ * Pause routine load statement assert for Doris.
*/
@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class DorisDMLStatementAssert {
+public final class DorisPauseRoutineLoadStatementAssert {
/**
- * Assert Doris DML statement is correct with expected parser result.
+ * Assert pause routine load statement is correct with expected parser
result.
*
* @param assertContext assert context
- * @param actual actual DML statement
- * @param expected expected parser result
+ * @param actual actual pause routine load statement
+ * @param expected expected pause routine load statement test case
*/
- public static void assertIs(final SQLCaseAssertContext assertContext,
final DMLStatement actual, final SQLParserTestCase expected) {
- if (actual instanceof DorisCreateRoutineLoadStatement) {
- DorisCreateRoutineLoadStatementAssert.assertIs(assertContext,
(DorisCreateRoutineLoadStatement) actual,
(DorisCreateRoutineLoadStatementTestCase) expected);
+ public static void assertIs(final SQLCaseAssertContext assertContext,
final DorisPauseRoutineLoadStatement actual, final
DorisPauseRoutineLoadStatementTestCase expected) {
+ MatcherAssert.assertThat(assertContext.getText("All flag does not
match: "), actual.isAll(), CoreMatchers.is(expected.isAll()));
+ if (!expected.isAll() && actual.getJobName().isPresent()) {
+ MatcherAssert.assertThat(assertContext.getText("Job name does not
match: "), actual.getJobName().get().getIdentifier().getValue(),
CoreMatchers.is(expected.getJobName()));
+ if (null != expected.getOwner()) {
+ OwnerAssert.assertIs(assertContext,
actual.getJobName().get().getOwner().orElse(null), expected.getOwner());
+ }
}
}
}
diff --git
a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisDMLStatementAssert.java
b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisResumeRoutineLoadStatementAssert.java
similarity index 52%
copy from
test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisDMLStatementAssert.java
copy to
test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisResumeRoutineLoadStatementAssert.java
index 088a0d2693a..5833c03cdaf 100644
---
a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisDMLStatementAssert.java
+++
b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/dml/dialect/doris/DorisResumeRoutineLoadStatementAssert.java
@@ -19,28 +19,33 @@ package
org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.
import lombok.AccessLevel;
import lombok.NoArgsConstructor;
-import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dml.DMLStatement;
-import
org.apache.shardingsphere.sql.parser.statement.doris.dml.DorisCreateRoutineLoadStatement;
+import
org.apache.shardingsphere.sql.parser.statement.doris.dml.DorisResumeRoutineLoadStatement;
import
org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
-import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.SQLParserTestCase;
-import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dml.dialect.doris.DorisCreateRoutineLoadStatementTestCase;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.asserts.segment.owner.OwnerAssert;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dml.dialect.doris.DorisResumeRoutineLoadStatementTestCase;
+import org.hamcrest.CoreMatchers;
+import org.hamcrest.MatcherAssert;
/**
- * Doris DML statement assert.
+ * Resume routine load statement assert for Doris.
*/
@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class DorisDMLStatementAssert {
+public final class DorisResumeRoutineLoadStatementAssert {
/**
- * Assert Doris DML statement is correct with expected parser result.
+ * Assert resume routine load statement is correct with expected parser
result.
*
* @param assertContext assert context
- * @param actual actual DML statement
- * @param expected expected parser result
+ * @param actual actual resume routine load statement
+ * @param expected expected resume routine load statement test case
*/
- public static void assertIs(final SQLCaseAssertContext assertContext,
final DMLStatement actual, final SQLParserTestCase expected) {
- if (actual instanceof DorisCreateRoutineLoadStatement) {
- DorisCreateRoutineLoadStatementAssert.assertIs(assertContext,
(DorisCreateRoutineLoadStatement) actual,
(DorisCreateRoutineLoadStatementTestCase) expected);
+ public static void assertIs(final SQLCaseAssertContext assertContext,
final DorisResumeRoutineLoadStatement actual, final
DorisResumeRoutineLoadStatementTestCase expected) {
+ MatcherAssert.assertThat(assertContext.getText("All flag does not
match: "), actual.isAll(), CoreMatchers.is(expected.isAll()));
+ if (!expected.isAll() && actual.getJobName().isPresent()) {
+ MatcherAssert.assertThat(assertContext.getText("Job name does not
match: "), actual.getJobName().get().getIdentifier().getValue(),
CoreMatchers.is(expected.getJobName()));
+ if (null != expected.getOwner()) {
+ OwnerAssert.assertIs(assertContext,
actual.getJobName().get().getOwner().orElse(null), expected.getOwner());
+ }
}
}
}
diff --git
a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/RootSQLParserTestCases.java
b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/RootSQLParserTestCases.java
index 3f3db1a1b42..3470feef953 100644
---
a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/RootSQLParserTestCases.java
+++
b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/RootSQLParserTestCases.java
@@ -41,7 +41,10 @@ import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.s
import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dal.dialect.doris.DorisShowRoutineLoadStatementTestCase;
import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dal.dialect.doris.DorisUnsetVariableStatementTestCase;
import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ddl.standard.catalog.AlterCatalogStatementTestCase;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dml.dialect.doris.DorisAlterRoutineLoadStatementTestCase;
import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dml.dialect.doris.DorisCreateRoutineLoadStatementTestCase;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dml.dialect.doris.DorisPauseRoutineLoadStatementTestCase;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dml.dialect.doris.DorisResumeRoutineLoadStatementTestCase;
import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.tcl.HiveAbortStatementTestCase;
import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dal.dialect.mysql.MySQLCloneStatementTestCase;
import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dal.dialect.mysql.MySQLCreateLoadableFunctionTestCase;
@@ -623,6 +626,15 @@ public final class RootSQLParserTestCases {
@XmlElement(name = "create-routine-load")
private final List<DorisCreateRoutineLoadStatementTestCase>
createRoutineLoadTestCases = new LinkedList<>();
+ @XmlElement(name = "alter-routine-load")
+ private final List<DorisAlterRoutineLoadStatementTestCase>
alterRoutineLoadTestCases = new LinkedList<>();
+
+ @XmlElement(name = "pause-routine-load")
+ private final List<DorisPauseRoutineLoadStatementTestCase>
pauseRoutineLoadTestCases = new LinkedList<>();
+
+ @XmlElement(name = "resume-routine-load")
+ private final List<DorisResumeRoutineLoadStatementTestCase>
resumeRoutineLoadTestCases = new LinkedList<>();
+
@XmlElement(name = "set-constraints")
private final List<SetConstraintsStatementTestCase>
setConstraintsTestCases = new LinkedList<>();
diff --git
a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/dml/dialect/doris/DorisAlterRoutineLoadStatementTestCase.java
b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/dml/dialect/doris/DorisAlterRoutineLoadStatementTestCase.java
new file mode 100644
index 00000000000..7e5fbf20241
--- /dev/null
+++
b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/dml/dialect/doris/DorisAlterRoutineLoadStatementTestCase.java
@@ -0,0 +1,55 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dml.dialect.doris;
+
+import lombok.Getter;
+import lombok.Setter;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.SQLParserTestCase;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.segment.impl.table.ExpectedOwner;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dal.dialect.doris.PropertyTestCase;
+
+import javax.xml.bind.annotation.XmlAccessType;
+import javax.xml.bind.annotation.XmlAccessorType;
+import javax.xml.bind.annotation.XmlAttribute;
+import javax.xml.bind.annotation.XmlElement;
+import java.util.LinkedList;
+import java.util.List;
+
+/**
+ * Doris alter routine load statement test case.
+ */
+@XmlAccessorType(XmlAccessType.FIELD)
+@Getter
+@Setter
+public final class DorisAlterRoutineLoadStatementTestCase extends
SQLParserTestCase {
+
+ @XmlAttribute(name = "job-name")
+ private String jobName;
+
+ @XmlElement
+ private ExpectedOwner owner;
+
+ @XmlElement(name = "job-property")
+ private final List<PropertyTestCase> jobProperties = new LinkedList<>();
+
+ @XmlAttribute(name = "data-source")
+ private String dataSource;
+
+ @XmlElement(name = "data-source-property")
+ private final List<PropertyTestCase> dataSourceProperties = new
LinkedList<>();
+}
diff --git
a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/dml/dialect/doris/DorisPauseRoutineLoadStatementTestCase.java
b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/dml/dialect/doris/DorisPauseRoutineLoadStatementTestCase.java
new file mode 100644
index 00000000000..fde646a567d
--- /dev/null
+++
b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/dml/dialect/doris/DorisPauseRoutineLoadStatementTestCase.java
@@ -0,0 +1,46 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dml.dialect.doris;
+
+import lombok.Getter;
+import lombok.Setter;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.SQLParserTestCase;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.segment.impl.table.ExpectedOwner;
+
+import javax.xml.bind.annotation.XmlAccessType;
+import javax.xml.bind.annotation.XmlAccessorType;
+import javax.xml.bind.annotation.XmlAttribute;
+import javax.xml.bind.annotation.XmlElement;
+
+/**
+ * Doris pause routine load statement test case.
+ */
+@XmlAccessorType(XmlAccessType.FIELD)
+@Getter
+@Setter
+public final class DorisPauseRoutineLoadStatementTestCase extends
SQLParserTestCase {
+
+ @XmlAttribute
+ private boolean all;
+
+ @XmlAttribute(name = "job-name")
+ private String jobName;
+
+ @XmlElement
+ private ExpectedOwner owner;
+}
diff --git
a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/dml/dialect/doris/DorisResumeRoutineLoadStatementTestCase.java
b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/dml/dialect/doris/DorisResumeRoutineLoadStatementTestCase.java
new file mode 100644
index 00000000000..945f292e2f8
--- /dev/null
+++
b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/dml/dialect/doris/DorisResumeRoutineLoadStatementTestCase.java
@@ -0,0 +1,46 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.dml.dialect.doris;
+
+import lombok.Getter;
+import lombok.Setter;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.SQLParserTestCase;
+import
org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.segment.impl.table.ExpectedOwner;
+
+import javax.xml.bind.annotation.XmlAccessType;
+import javax.xml.bind.annotation.XmlAccessorType;
+import javax.xml.bind.annotation.XmlAttribute;
+import javax.xml.bind.annotation.XmlElement;
+
+/**
+ * Doris resume routine load statement test case.
+ */
+@XmlAccessorType(XmlAccessType.FIELD)
+@Getter
+@Setter
+public final class DorisResumeRoutineLoadStatementTestCase extends
SQLParserTestCase {
+
+ @XmlAttribute
+ private boolean all;
+
+ @XmlAttribute(name = "job-name")
+ private String jobName;
+
+ @XmlElement
+ private ExpectedOwner owner;
+}
diff --git a/test/it/parser/src/main/resources/case/dml/alter-routine-load.xml
b/test/it/parser/src/main/resources/case/dml/alter-routine-load.xml
new file mode 100644
index 00000000000..45ca4f38257
--- /dev/null
+++ b/test/it/parser/src/main/resources/case/dml/alter-routine-load.xml
@@ -0,0 +1,37 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<sql-parser-test-cases>
+ <alter-routine-load sql-case-id="alter_routine_load_simple"
job-name="label1" data-source="kafka">
+ <owner name="db1" start-index="23" stop-index="25" />
+ <job-property key="desired_concurrent_number" value="10"
start-index="46" stop-index="79" />
+ <data-source-property key="kafka_partitions" value="0, 1, 2"
start-index="94" stop-index="123" />
+ <data-source-property key="kafka_offsets" value="100, 200, 100"
start-index="126" stop-index="158" />
+ <data-source-property key="property.group.id" value="new_group"
start-index="161" stop-index="193" />
+ </alter-routine-load>
+
+ <alter-routine-load sql-case-id="alter_routine_load_no_properties"
job-name="label1" data-source="kafka">
+ <owner name="db1" start-index="23" stop-index="25" />
+ <data-source-property key="kafka_topic" value="new_topic"
start-index="46" stop-index="72" />
+ </alter-routine-load>
+
+ <alter-routine-load sql-case-id="alter_routine_load_only_properties"
job-name="label1">
+ <job-property key="max_batch_interval" value="30" start-index="42"
stop-index="68" />
+ <job-property key="max_batch_rows" value="500000" start-index="71"
stop-index="97" />
+ </alter-routine-load>
+</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/dml/pause-routine-load.xml
b/test/it/parser/src/main/resources/case/dml/pause-routine-load.xml
new file mode 100644
index 00000000000..b113cb7e571
--- /dev/null
+++ b/test/it/parser/src/main/resources/case/dml/pause-routine-load.xml
@@ -0,0 +1,27 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<sql-parser-test-cases>
+ <pause-routine-load sql-case-id="pause_routine_load_simple"
job-name="test1" all="false" />
+
+ <pause-routine-load sql-case-id="pause_routine_load_with_owner"
job-name="job1" all="false">
+ <owner name="db1" start-index="23" stop-index="25" />
+ </pause-routine-load>
+
+ <pause-routine-load sql-case-id="pause_routine_load_all" all="true" />
+</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/dml/resume-routine-load.xml
b/test/it/parser/src/main/resources/case/dml/resume-routine-load.xml
new file mode 100644
index 00000000000..22d84a73c0b
--- /dev/null
+++ b/test/it/parser/src/main/resources/case/dml/resume-routine-load.xml
@@ -0,0 +1,27 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<sql-parser-test-cases>
+ <resume-routine-load sql-case-id="resume_routine_load_simple"
job-name="test1" all="false" />
+
+ <resume-routine-load sql-case-id="resume_routine_load_with_owner"
job-name="job1" all="false">
+ <owner name="db1" start-index="24" stop-index="26" />
+ </resume-routine-load>
+
+ <resume-routine-load sql-case-id="resume_routine_load_all" all="true" />
+</sql-parser-test-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/dml/alter-routine-load.xml
b/test/it/parser/src/main/resources/sql/supported/dml/alter-routine-load.xml
new file mode 100644
index 00000000000..d7cd9a50b4d
--- /dev/null
+++ b/test/it/parser/src/main/resources/sql/supported/dml/alter-routine-load.xml
@@ -0,0 +1,23 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<sql-cases>
+ <sql-case id="alter_routine_load_simple" value="ALTER ROUTINE LOAD FOR
db1.label1 PROPERTIES ('desired_concurrent_number' = '10') FROM kafka
('kafka_partitions' = '0, 1, 2', 'kafka_offsets' = '100, 200, 100',
'property.group.id' = 'new_group')" db-types="Doris" />
+ <sql-case id="alter_routine_load_no_properties" value="ALTER ROUTINE LOAD
FOR db1.label1 FROM kafka ('kafka_topic' = 'new_topic')" db-types="Doris" />
+ <sql-case id="alter_routine_load_only_properties" value="ALTER ROUTINE
LOAD FOR label1 PROPERTIES ('max_batch_interval' = '30', 'max_batch_rows' =
'500000')" db-types="Doris" />
+</sql-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/dml/pause-routine-load.xml
b/test/it/parser/src/main/resources/sql/supported/dml/pause-routine-load.xml
new file mode 100644
index 00000000000..e72c846e2da
--- /dev/null
+++ b/test/it/parser/src/main/resources/sql/supported/dml/pause-routine-load.xml
@@ -0,0 +1,23 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<sql-cases>
+ <sql-case id="pause_routine_load_simple" value="PAUSE ROUTINE LOAD FOR
test1" db-types="Doris" />
+ <sql-case id="pause_routine_load_with_owner" value="PAUSE ROUTINE LOAD FOR
db1.job1" db-types="Doris" />
+ <sql-case id="pause_routine_load_all" value="PAUSE ALL ROUTINE LOAD"
db-types="Doris" />
+</sql-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/dml/resume-routine-load.xml
b/test/it/parser/src/main/resources/sql/supported/dml/resume-routine-load.xml
new file mode 100644
index 00000000000..67f6e7d7104
--- /dev/null
+++
b/test/it/parser/src/main/resources/sql/supported/dml/resume-routine-load.xml
@@ -0,0 +1,23 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<sql-cases>
+ <sql-case id="resume_routine_load_simple" value="RESUME ROUTINE LOAD FOR
test1" db-types="Doris" />
+ <sql-case id="resume_routine_load_with_owner" value="RESUME ROUTINE LOAD
FOR db1.job1" db-types="Doris" />
+ <sql-case id="resume_routine_load_all" value="RESUME ALL ROUTINE LOAD"
db-types="Doris" />
+</sql-cases>
