This is an automated email from the ASF dual-hosted git repository.
starocean999 pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 288d109a9c5 [Enhancement] (nereids)implement showTriggersCommand in
nereids (#44278)
288d109a9c5 is described below
commit 288d109a9c5f3961c775e7ffdfd2fca3923ae8f0
Author: Vallish Pai <vallish...@gmail.com>
AuthorDate: Fri Nov 22 09:08:06 2024 +0530
[Enhancement] (nereids)implement showTriggersCommand in nereids (#44278)
Issue Number: close #42731
---
.../antlr4/org/apache/doris/nereids/DorisParser.g4 | 2 +-
.../doris/nereids/parser/LogicalPlanBuilder.java | 8 +++
.../apache/doris/nereids/trees/plans/PlanType.java | 1 +
.../trees/plans/commands/ShowTriggersCommand.java | 66 ++++++++++++++++++++++
.../trees/plans/visitor/CommandVisitor.java | 5 ++
.../show/test_show_commands_nereids.groovy | 2 +
6 files changed, 83 insertions(+), 1 deletion(-)
diff --git a/fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4
b/fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4
index 177eff9b6db..ea2958c6bc9 100644
--- a/fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4
+++ b/fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4
@@ -224,6 +224,7 @@ supportedShowStatement
| SHOW CREATE MATERIALIZED VIEW mvName=identifier
ON tableName=multipartIdentifier
#showCreateMaterializedView
| SHOW BACKENDS
#showBackends
+ | SHOW FULL? TRIGGERS ((FROM | IN) database=multipartIdentifier)?
wildWhere? #showTriggers
| SHOW FRONTENDS name=identifier?
#showFrontends
| SHOW TABLE tableId=INTEGER_VALUE
#showTableId
| SHOW WHITELIST
#showWhitelist
@@ -270,7 +271,6 @@ unsupportedShowStatement
| SHOW FULL? VIEWS ((FROM | IN) database=multipartIdentifier)? wildWhere?
#showViews
| SHOW FULL? PROCESSLIST
#showProcessList
| SHOW (GLOBAL | SESSION | LOCAL)? STATUS wildWhere?
#showStatus
- | SHOW FULL? TRIGGERS ((FROM | IN) database=multipartIdentifier)?
wildWhere? #showTriggers
| SHOW EVENTS ((FROM | IN) database=multipartIdentifier)? wildWhere?
#showEvents
| SHOW CREATE VIEW name=multipartIdentifier
#showCreateView
| SHOW CREATE MATERIALIZED VIEW name=multipartIdentifier
#showMaterializedView
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/parser/LogicalPlanBuilder.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/parser/LogicalPlanBuilder.java
index d24e4c1fa7b..d3b63541d10 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/parser/LogicalPlanBuilder.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/parser/LogicalPlanBuilder.java
@@ -225,6 +225,7 @@ import
org.apache.doris.nereids.DorisParser.ShowStorageEnginesContext;
import org.apache.doris.nereids.DorisParser.ShowTableIdContext;
import org.apache.doris.nereids.DorisParser.ShowTabletsBelongContext;
import org.apache.doris.nereids.DorisParser.ShowTrashContext;
+import org.apache.doris.nereids.DorisParser.ShowTriggersContext;
import org.apache.doris.nereids.DorisParser.ShowVariablesContext;
import org.apache.doris.nereids.DorisParser.ShowViewContext;
import org.apache.doris.nereids.DorisParser.ShowWhitelistContext;
@@ -488,6 +489,7 @@ import
org.apache.doris.nereids.trees.plans.commands.ShowStorageEnginesCommand;
import org.apache.doris.nereids.trees.plans.commands.ShowTableIdCommand;
import org.apache.doris.nereids.trees.plans.commands.ShowTabletsBelongCommand;
import org.apache.doris.nereids.trees.plans.commands.ShowTrashCommand;
+import org.apache.doris.nereids.trees.plans.commands.ShowTriggersCommand;
import org.apache.doris.nereids.trees.plans.commands.ShowVariablesCommand;
import org.apache.doris.nereids.trees.plans.commands.ShowViewCommand;
import org.apache.doris.nereids.trees.plans.commands.ShowWhiteListCommand;
@@ -4216,6 +4218,7 @@ public class LogicalPlanBuilder extends
DorisParserBaseVisitor<Object> {
return new ShowBackendsCommand();
}
+ @Override
public LogicalPlan visitShowPlugins(ShowPluginsContext ctx) {
return new ShowPluginsCommand();
}
@@ -4229,6 +4232,11 @@ public class LogicalPlanBuilder extends
DorisParserBaseVisitor<Object> {
return new ShowSqlBlockRuleCommand(ruleName);
}
+ @Override
+ public LogicalPlan visitShowTriggers(ShowTriggersContext ctx) {
+ return new ShowTriggersCommand();
+ }
+
@Override
public LogicalPlan visitShowRepositories(ShowRepositoriesContext ctx) {
return new ShowRepositoriesCommand();
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/PlanType.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/PlanType.java
index c3d7fc70801..3a4484f81d0 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/PlanType.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/PlanType.java
@@ -202,6 +202,7 @@ public enum PlanType {
SHOW_STORAGE_ENGINES_COMMAND,
SHOW_TABLE_ID_COMMAND,
SHOW_TRASH_COMMAND,
+ SHOW_TRIGGERS_COMMAND,
SHOW_VARIABLES_COMMAND,
SHOW_AUTHORS_COMMAND,
SHOW_VIEW_COMMAND,
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/ShowTriggersCommand.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/ShowTriggersCommand.java
new file mode 100644
index 00000000000..dd9d2c18c57
--- /dev/null
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/ShowTriggersCommand.java
@@ -0,0 +1,66 @@
+// 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.doris.nereids.trees.plans.commands;
+
+import org.apache.doris.catalog.Column;
+import org.apache.doris.catalog.ScalarType;
+import org.apache.doris.nereids.trees.plans.PlanType;
+import org.apache.doris.nereids.trees.plans.visitor.PlanVisitor;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.qe.ShowResultSet;
+import org.apache.doris.qe.ShowResultSetMetaData;
+import org.apache.doris.qe.StmtExecutor;
+
+import com.google.common.collect.Lists;
+
+import java.util.List;
+
+/**
+ * show triggers command
+ */
+public class ShowTriggersCommand extends ShowCommand {
+ private static final ShowResultSetMetaData META_DATA =
+ ShowResultSetMetaData.builder()
+ .addColumn(new Column("Trigger",
ScalarType.createVarchar(64)))
+ .addColumn(new Column("Event",
ScalarType.createVarchar(10)))
+ .addColumn(new Column("Table",
ScalarType.createVarchar(80)))
+ .addColumn(new Column("Statement",
ScalarType.createVarchar(64)))
+ .addColumn(new Column("Timing",
ScalarType.createVarchar(80)))
+ .addColumn(new Column("Created",
ScalarType.createVarchar(80)))
+ .addColumn(new Column("sql_mode",
ScalarType.createVarchar(80)))
+ .addColumn(new Column("Definer",
ScalarType.createVarchar(80)))
+ .addColumn(new Column("character_set_client",
ScalarType.createVarchar(80)))
+ .addColumn(new Column("collation_connection",
ScalarType.createVarchar(80)))
+ .addColumn(new Column("Database Collation",
ScalarType.createVarchar(80)))
+ .build();
+
+ public ShowTriggersCommand() {
+ super(PlanType.SHOW_TRIGGERS_COMMAND);
+ }
+
+ @Override
+ public <R, C> R accept(PlanVisitor<R, C> visitor, C context) {
+ return visitor.visitShowTriggersCommand(this, context);
+ }
+
+ @Override
+ public ShowResultSet doRun(ConnectContext ctx, StmtExecutor executor)
throws Exception {
+ List<List<String>> rowSet = Lists.newArrayList();
+ return new ShowResultSet(META_DATA, rowSet);
+ }
+}
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/visitor/CommandVisitor.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/visitor/CommandVisitor.java
index 7aa935df8bf..fa5b9486ed5 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/visitor/CommandVisitor.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/visitor/CommandVisitor.java
@@ -84,6 +84,7 @@ import
org.apache.doris.nereids.trees.plans.commands.ShowStorageEnginesCommand;
import org.apache.doris.nereids.trees.plans.commands.ShowTableIdCommand;
import org.apache.doris.nereids.trees.plans.commands.ShowTabletsBelongCommand;
import org.apache.doris.nereids.trees.plans.commands.ShowTrashCommand;
+import org.apache.doris.nereids.trees.plans.commands.ShowTriggersCommand;
import org.apache.doris.nereids.trees.plans.commands.ShowVariablesCommand;
import org.apache.doris.nereids.trees.plans.commands.ShowViewCommand;
import org.apache.doris.nereids.trees.plans.commands.ShowWhiteListCommand;
@@ -333,6 +334,10 @@ public interface CommandVisitor<R, C> {
return visitCommand(showPluginsCommand, context);
}
+ default R visitShowTriggersCommand(ShowTriggersCommand
showTriggersCommand, C context) {
+ return visitCommand(showTriggersCommand, context);
+ }
+
default R visitShowRepositoriesCommand(ShowRepositoriesCommand
showRepositoriesCommand, C context) {
return visitCommand(showRepositoriesCommand, context);
}
diff --git
a/regression-test/suites/nereids_p0/show/test_show_commands_nereids.groovy
b/regression-test/suites/nereids_p0/show/test_show_commands_nereids.groovy
index 7721130d558..e994e22ec99 100644
--- a/regression-test/suites/nereids_p0/show/test_show_commands_nereids.groovy
+++ b/regression-test/suites/nereids_p0/show/test_show_commands_nereids.groovy
@@ -25,4 +25,6 @@ suite("test_show_commands_nereids") {
checkNereidsExecute("""show frontends;""")
checkNereidsExecute("""show backends;""")
checkNereidsExecute("""show whitelist;""")
+ checkNereidsExecute("""show triggers;""")
+
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
