This is an automated email from the ASF dual-hosted git repository.
morrysnow pushed a commit to branch branch-3.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.0 by this push:
new 8e2c58175ea [feature](nereids)support show view command in nereids
(#44699)
8e2c58175ea is described below
commit 8e2c58175ea13a1fd5d5fffe26907b94f87b4ab7
Author: starocean999 <[email protected]>
AuthorDate: Mon Dec 2 10:43:43 2024 +0800
[feature](nereids)support show view command in nereids (#44699)
pick part code of #43271 from master
---
.../antlr4/org/apache/doris/nereids/DorisParser.g4 | 12 +-
.../java/org/apache/doris/catalog/Database.java | 13 ++
.../doris/nereids/parser/LogicalPlanBuilder.java | 12 ++
.../apache/doris/nereids/trees/plans/PlanType.java | 1 +
.../trees/plans/commands/ShowViewCommand.java | 157 +++++++++++++++++++++
.../trees/plans/commands/info/TableNameInfo.java | 31 ++++
.../trees/plans/visitor/CommandVisitor.java | 5 +
.../java/org/apache/doris/qe/StmtExecutor.java | 4 +
.../data/nereids_p0/show/show_view_command.out | 17 +++
.../create_view_nereids/create_view_use_mv.groovy | 2 +
.../nereids_p0/show/show_view_command.groovy | 80 +++++++++++
11 files changed, 330 insertions(+), 4 deletions(-)
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 cdae7d27b7a..dd4ff92bb7a 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
@@ -50,9 +50,10 @@ statementBase
| supportedCreateStatement #supportedCreateStatementAlias
| supportedAlterStatement #supportedAlterStatementAlias
| materializedViewStatement #materializedViewStatementAlias
- | supportedJobStatement #supportedJobStatementAlias
+ | supportedJobStatement #supportedJobStatementAlias
| constraintStatement #constraintStatementAlias
| supportedDropStatement #supportedDropStatementAlias
+ | supportedShowStatement #supportedShowStatementAlias
| unsupportedStatement #unsupported
;
@@ -189,6 +190,12 @@ supportedDropStatement
: DROP CATALOG RECYCLE BIN WHERE idType=STRING_LITERAL EQ id=INTEGER_VALUE
#dropCatalogRecycleBin
;
+supportedShowStatement
+ : SHOW VIEW
+ (FROM |IN) tableName=multipartIdentifier
+ ((FROM | IN) database=identifier)?
#showView
+ ;
+
unsupportedOtherStatement
: HELP mark=identifierOrText
#help
| INSTALL PLUGIN FROM source=identifierOrText properties=propertyClause?
#installPlugin
@@ -302,9 +309,6 @@ unsupportedShowStatement
| SHOW (KEY | KEYS | INDEX | INDEXES)
(FROM |IN) tableName=multipartIdentifier
((FROM | IN) database=multipartIdentifier)?
#showIndex
- | SHOW VIEW
- (FROM |IN) tableName=multipartIdentifier
- ((FROM | IN) database=multipartIdentifier)?
#showView
| SHOW TRANSACTION ((FROM | IN) database=multipartIdentifier)? wildWhere?
#showTransaction
| SHOW QUERY PROFILE queryIdPath=STRING_LITERAL
#showQueryProfile
| SHOW LOAD PROFILE loadIdPath=STRING_LITERAL
#showLoadProfile
diff --git a/fe/fe-core/src/main/java/org/apache/doris/catalog/Database.java
b/fe/fe-core/src/main/java/org/apache/doris/catalog/Database.java
index 5e1782d109a..4f205be0381 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/catalog/Database.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/catalog/Database.java
@@ -497,6 +497,19 @@ public class Database extends MetaObject implements
Writable, DatabaseIf<Table>,
return views;
}
+ public List<Table> getViewsOnIdOrder() {
+ List<Table> tables = idToTable.values().stream()
+ .sorted(Comparator.comparing(Table::getId))
+ .collect(Collectors.toList());
+ List<Table> views = new ArrayList<>();
+ for (Table table : tables) {
+ if (table.getType() == TableType.VIEW) {
+ views.add(table);
+ }
+ }
+ return views;
+ }
+
/**
* this method is used for get existed table list by table id list, if
table not exist, just ignore it.
*/
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 8e3334b79ce..f29662a821e 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
@@ -176,6 +176,7 @@ import
org.apache.doris.nereids.DorisParser.ShowConstraintContext;
import org.apache.doris.nereids.DorisParser.ShowCreateMTMVContext;
import org.apache.doris.nereids.DorisParser.ShowCreateProcedureContext;
import org.apache.doris.nereids.DorisParser.ShowProcedureStatusContext;
+import org.apache.doris.nereids.DorisParser.ShowViewContext;
import org.apache.doris.nereids.DorisParser.SimpleColumnDefContext;
import org.apache.doris.nereids.DorisParser.SimpleColumnDefsContext;
import org.apache.doris.nereids.DorisParser.SingleStatementContext;
@@ -399,6 +400,7 @@ import
org.apache.doris.nereids.trees.plans.commands.ShowConstraintsCommand;
import org.apache.doris.nereids.trees.plans.commands.ShowCreateMTMVCommand;
import
org.apache.doris.nereids.trees.plans.commands.ShowCreateProcedureCommand;
import
org.apache.doris.nereids.trees.plans.commands.ShowProcedureStatusCommand;
+import org.apache.doris.nereids.trees.plans.commands.ShowViewCommand;
import org.apache.doris.nereids.trees.plans.commands.UnsupportedCommand;
import org.apache.doris.nereids.trees.plans.commands.UpdateCommand;
import org.apache.doris.nereids.trees.plans.commands.info.AlterMTMVInfo;
@@ -3786,4 +3788,14 @@ public class LogicalPlanBuilder extends
DorisParserBaseVisitor<Object> {
}
return command;
}
+
+ @Override
+ public ShowViewCommand visitShowView(ShowViewContext ctx) {
+ List<String> tableNameParts = visitMultipartIdentifier(ctx.tableName);
+ String databaseName = null;
+ if (ctx.database != null) {
+ databaseName = stripQuotes(ctx.database.getText());
+ }
+ return new ShowViewCommand(databaseName, new
TableNameInfo(tableNameParts));
+ }
}
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 73ea61fcfac..ea7eb9c26b8 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
@@ -159,6 +159,7 @@ public enum PlanType {
DROP_PROCEDURE_COMMAND,
SHOW_PROCEDURE_COMMAND,
SHOW_CREATE_PROCEDURE_COMMAND,
+ SHOW_VIEW_COMMAND,
CREATE_VIEW_COMMAND,
ALTER_VIEW_COMMAND,
ALTER_STORAGE_VAULT,
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/ShowViewCommand.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/ShowViewCommand.java
new file mode 100644
index 00000000000..775502fbccd
--- /dev/null
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/ShowViewCommand.java
@@ -0,0 +1,157 @@
+// 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.analysis.StmtType;
+import org.apache.doris.catalog.Column;
+import org.apache.doris.catalog.Database;
+import org.apache.doris.catalog.Env;
+import org.apache.doris.catalog.ScalarType;
+import org.apache.doris.catalog.Table;
+import org.apache.doris.catalog.View;
+import org.apache.doris.common.ErrorCode;
+import org.apache.doris.common.ErrorReport;
+import org.apache.doris.common.util.Util;
+import org.apache.doris.mysql.privilege.PrivPredicate;
+import org.apache.doris.nereids.NereidsPlanner;
+import org.apache.doris.nereids.StatementContext;
+import org.apache.doris.nereids.parser.NereidsParser;
+import org.apache.doris.nereids.properties.PhysicalProperties;
+import org.apache.doris.nereids.trees.plans.PlanType;
+import org.apache.doris.nereids.trees.plans.commands.info.TableNameInfo;
+import org.apache.doris.nereids.trees.plans.logical.LogicalPlan;
+import org.apache.doris.nereids.trees.plans.visitor.PlanVisitor;
+import org.apache.doris.nereids.util.PlanUtils;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.qe.OriginStatement;
+import org.apache.doris.qe.ShowResultSet;
+import org.apache.doris.qe.ShowResultSetMetaData;
+import org.apache.doris.qe.StmtExecutor;
+
+import com.google.common.base.Strings;
+import com.google.common.collect.Lists;
+
+import java.util.List;
+import java.util.stream.Collectors;
+
+/**
+ * ShowViewCommand
+ */
+public class ShowViewCommand extends Command implements NoForward {
+ private static final ShowResultSetMetaData META_DATA =
ShowResultSetMetaData.builder()
+ .addColumn(new Column("View", ScalarType.createVarchar(30)))
+ .addColumn(new Column("Create View",
ScalarType.createVarchar(65535)))
+ .build();
+
+ private final String db;
+ private final TableNameInfo tbl;
+ private List<View> matchViews = Lists.newArrayList();
+
+ public ShowViewCommand(String db, TableNameInfo tbl) {
+ super(PlanType.SHOW_VIEW_COMMAND);
+ this.db = db;
+ this.tbl = tbl;
+ }
+
+ @Override
+ public StmtType stmtType() {
+ return StmtType.SHOW;
+ }
+
+ @Override
+ public <R, C> R accept(PlanVisitor<R, C> visitor, C context) {
+ return visitor.visitShowViewCommand(this, context);
+ }
+
+ private void validate(ConnectContext ctx) throws Exception {
+ if (!Strings.isNullOrEmpty(db)) {
+ // if user specify the `from db`, overwrite the db in `tbl` with
this db.
+ // for example:
+ // show view from db1.tbl1 from db2;
+ // will be rewrote to:
+ // show view from db2.tbl1;
+ // this act same as in MySQL
+ tbl.setDb(db);
+ }
+ tbl.analyze(ctx);
+ // disallow external catalog
+ Util.prohibitExternalCatalog(tbl.getCtl(),
this.getClass().getSimpleName());
+
+ String dbName = tbl.getDb();
+ if (!Env.getCurrentEnv().getAccessManager().checkTblPriv(
+ ConnectContext.get(), tbl.getCtl(), dbName, tbl.getTbl(),
PrivPredicate.SHOW)) {
+
ErrorReport.reportAnalysisException(ErrorCode.ERR_TABLEACCESS_DENIED_ERROR,
"SHOW VIEW",
+ ConnectContext.get().getQualifiedUser(),
+ ConnectContext.get().getRemoteIP(),
+ dbName + ": " + tbl.getTbl());
+ }
+
+ Database database =
Env.getCurrentInternalCatalog().getDbOrAnalysisException(dbName);
+ database.getOlapTableOrAnalysisException(tbl.getTbl());
+ for (Table table : database.getViewsOnIdOrder()) {
+ View view = (View) table;
+ // get table refs instead of get tables because it don't need to
check table's validity
+ List<TableNameInfo> tableNameInfos = getTableNames(ctx,
view.getInlineViewDef());
+ for (TableNameInfo tableNameInfo : tableNameInfos) {
+ tableNameInfo.analyze(ctx);
+ if (tableNameInfo.equals(tbl)) {
+ matchViews.add(view);
+ }
+ }
+ }
+ }
+
+ private List<TableNameInfo> getTableNames(ConnectContext ctx, String sql) {
+ LogicalPlan unboundMvPlan = new NereidsParser().parseSingle(sql);
+ StatementContext statementContext = new StatementContext(ctx,
+ new OriginStatement(sql, 0));
+ NereidsPlanner planner = new NereidsPlanner(statementContext);
+ if (ctx.getStatementContext() == null) {
+ ctx.setStatementContext(statementContext);
+ }
+ planner.planWithLock(unboundMvPlan, PhysicalProperties.ANY,
ExplainCommand.ExplainLevel.ANALYZED_PLAN);
+ LogicalPlan logicalPlan = (LogicalPlan)
planner.getCascadesContext().getRewritePlan();
+
+ return PlanUtils.getLogicalScanFromRootPlan(logicalPlan).stream()
+ .map(plan -> new
TableNameInfo(plan.getTable().getFullQualifiers())).collect(Collectors.toList());
+ }
+
+ @Override
+ public void run(ConnectContext ctx, StmtExecutor executor) throws
Exception {
+ validate(ctx);
+ List<List<String>> rows = Lists.newArrayList();
+ for (View view : matchViews) {
+ view.readLock();
+ try {
+ List<String> createViewStmt = Lists.newArrayList();
+ Env.getDdlStmt(view, createViewStmt, null, null, false, true
/* hide password */, -1L);
+ if (!createViewStmt.isEmpty()) {
+ rows.add(Lists.newArrayList(view.getName(),
createViewStmt.get(0)));
+ }
+ } finally {
+ view.readUnlock();
+ }
+ }
+ ShowResultSet resultSet = new ShowResultSet(META_DATA, rows);
+ if (executor.isProxy()) {
+ executor.setProxyShowResultSet(resultSet);
+ } else {
+ executor.sendResultSet(resultSet);
+ }
+ }
+}
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/info/TableNameInfo.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/info/TableNameInfo.java
index 79afb2d1fba..08f30e08d31 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/info/TableNameInfo.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/info/TableNameInfo.java
@@ -121,6 +121,14 @@ public class TableNameInfo implements Writable {
return ctl;
}
+ /**
+ * set a new database name
+ * @param db new database name
+ */
+ public void setDb(String db) {
+ this.db = db;
+ }
+
/**
* get db name
* @return dbName
@@ -162,4 +170,27 @@ public class TableNameInfo implements Writable {
db = fromJson.db;
tbl = fromJson.tbl;
}
+
+ /**
+ * equals
+ */
+ @Override
+ public boolean equals(Object o) {
+ if (this == o) {
+ return true;
+ }
+ if (o == null || getClass() != o.getClass()) {
+ return false;
+ }
+ TableNameInfo that = (TableNameInfo) o;
+ return tbl.equals(that.tbl) && db.equals(that.db) &&
ctl.equals(that.ctl);
+ }
+
+ /**
+ * hashCode
+ */
+ @Override
+ public int hashCode() {
+ return Objects.hash(tbl, db, ctl);
+ }
}
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 f35e6f8a640..ab0ae46169c 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
@@ -48,6 +48,7 @@ import
org.apache.doris.nereids.trees.plans.commands.ShowConstraintsCommand;
import org.apache.doris.nereids.trees.plans.commands.ShowCreateMTMVCommand;
import
org.apache.doris.nereids.trees.plans.commands.ShowCreateProcedureCommand;
import
org.apache.doris.nereids.trees.plans.commands.ShowProcedureStatusCommand;
+import org.apache.doris.nereids.trees.plans.commands.ShowViewCommand;
import org.apache.doris.nereids.trees.plans.commands.UnsupportedCommand;
import org.apache.doris.nereids.trees.plans.commands.UpdateCommand;
import
org.apache.doris.nereids.trees.plans.commands.insert.BatchInsertIntoTableCommand;
@@ -201,4 +202,8 @@ public interface CommandVisitor<R, C> {
default R visitShowConfigCommand(ShowConfigCommand showConfigCommand, C
context) {
return visitCommand(showConfigCommand, context);
}
+
+ default R visitShowViewCommand(ShowViewCommand showViewCommand, C context)
{
+ return visitCommand(showViewCommand, context);
+ }
}
diff --git a/fe/fe-core/src/main/java/org/apache/doris/qe/StmtExecutor.java
b/fe/fe-core/src/main/java/org/apache/doris/qe/StmtExecutor.java
index 9f4cc26cbbc..e42f617aa09 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/qe/StmtExecutor.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/qe/StmtExecutor.java
@@ -340,6 +340,10 @@ public class StmtExecutor {
context.getSessionVariable().getAutoProfileThresholdMs());
}
+ public boolean isProxy() {
+ return isProxy;
+ }
+
public static InternalService.PDataRow getRowStringValue(List<Expr> cols,
FormatOptions options) throws UserException {
if (cols.isEmpty()) {
diff --git a/regression-test/data/nereids_p0/show/show_view_command.out
b/regression-test/data/nereids_p0/show/show_view_command.out
new file mode 100644
index 00000000000..33e1f8315bf
--- /dev/null
+++ b/regression-test/data/nereids_p0/show/show_view_command.out
@@ -0,0 +1,17 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !cmd --
+ttv1 CREATE VIEW `ttv1` AS select `internal`.`test_show_view_db2`.`t1`.`c1`,
`internal`.`test_show_view_db2`.`t2`.`c2` from
`internal`.`test_show_view_db2`.`t1` join `internal`.`test_show_view_db2`.`t2`
on `internal`.`test_show_view_db2`.`t1`.`c2` =
`internal`.`test_show_view_db2`.`t2`.`c2`;
+ttv2 CREATE VIEW `ttv2` AS select `internal`.`test_show_view_db2`.`t1`.`c1`
from `internal`.`test_show_view_db2`.`t1` where
`internal`.`test_show_view_db2`.`t1`.`c2` = 1;
+
+-- !cmd --
+tv1 CREATE VIEW `tv1` AS select `internal`.`test_show_view_db1`.`t1`.`c1`,
`internal`.`test_show_view_db1`.`t2`.`c2` from
`internal`.`test_show_view_db1`.`t1` join `internal`.`test_show_view_db1`.`t2`
on `internal`.`test_show_view_db1`.`t1`.`c2` =
`internal`.`test_show_view_db1`.`t2`.`c2`;
+tv2 CREATE VIEW `tv2` AS select `internal`.`test_show_view_db1`.`t1`.`c1`
from `internal`.`test_show_view_db1`.`t1` where
`internal`.`test_show_view_db1`.`t1`.`c2` = 1;
+
+-- !cmd --
+ttv1 CREATE VIEW `ttv1` AS select `internal`.`test_show_view_db2`.`t1`.`c1`,
`internal`.`test_show_view_db2`.`t2`.`c2` from
`internal`.`test_show_view_db2`.`t1` join `internal`.`test_show_view_db2`.`t2`
on `internal`.`test_show_view_db2`.`t1`.`c2` =
`internal`.`test_show_view_db2`.`t2`.`c2`;
+ttv2 CREATE VIEW `ttv2` AS select `internal`.`test_show_view_db2`.`t1`.`c1`
from `internal`.`test_show_view_db2`.`t1` where
`internal`.`test_show_view_db2`.`t1`.`c2` = 1;
+
+-- !cmd --
+ttv1 CREATE VIEW `ttv1` AS select `internal`.`test_show_view_db2`.`t1`.`c1`,
`internal`.`test_show_view_db2`.`t2`.`c2` from
`internal`.`test_show_view_db2`.`t1` join `internal`.`test_show_view_db2`.`t2`
on `internal`.`test_show_view_db2`.`t1`.`c2` =
`internal`.`test_show_view_db2`.`t2`.`c2`;
+ttv2 CREATE VIEW `ttv2` AS select `internal`.`test_show_view_db2`.`t1`.`c1`
from `internal`.`test_show_view_db2`.`t1` where
`internal`.`test_show_view_db2`.`t1`.`c2` = 1;
+
diff --git
a/regression-test/suites/ddl_p0/create_view_nereids/create_view_use_mv.groovy
b/regression-test/suites/ddl_p0/create_view_nereids/create_view_use_mv.groovy
index 295b195aa58..348dddb4f88 100644
---
a/regression-test/suites/ddl_p0/create_view_nereids/create_view_use_mv.groovy
+++
b/regression-test/suites/ddl_p0/create_view_nereids/create_view_use_mv.groovy
@@ -92,4 +92,6 @@ suite("create_view_use_mv") {
group by
k1, k2, k3, k4, k5, l_orderkey, mv_o_orderkey"""
qt_alter_view_from_mv "select * from v_for_alter order by 1"
+
+ sql """show view from orders""";
}
\ No newline at end of file
diff --git a/regression-test/suites/nereids_p0/show/show_view_command.groovy
b/regression-test/suites/nereids_p0/show/show_view_command.groovy
new file mode 100644
index 00000000000..fb5e1da8d71
--- /dev/null
+++ b/regression-test/suites/nereids_p0/show/show_view_command.groovy
@@ -0,0 +1,80 @@
+// 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.
+
+suite("show_view_command") {
+ multi_sql """
+ drop database if exists test_show_view_db1;
+ create database test_show_view_db1;
+ use test_show_view_db1;
+ drop table if exists t1;
+ drop table if exists t2;
+ create table t1
+ (c1 bigint, c2 bigint)
+ ENGINE=OLAP
+ DUPLICATE KEY(c1, c2)
+ COMMENT 'OLAP'
+ DISTRIBUTED BY HASH(c1) BUCKETS 1
+ PROPERTIES (
+ "replication_num" = "1"
+ );
+ create table t2
+ (c1 bigint, c2 bigint)
+ ENGINE=OLAP
+ DUPLICATE KEY(c1, c2)
+ COMMENT 'OLAP'
+ DISTRIBUTED BY HASH(c1) BUCKETS 1
+ PROPERTIES (
+ "replication_num" = "1"
+ );
+ drop view if exists tv1;
+ drop view if exists tv2;
+ create view tv1 as select t1.c1, t2.c2 from t1 join t2 on t1.c2 =
t2.c2;
+ create view tv2 as select t1.c1 from t1 where t1.c2 = 1;
+ drop database if exists test_show_view_db2;
+ create database test_show_view_db2;
+ use test_show_view_db2;
+ drop table if exists t1;
+ drop table if exists t2;
+ create table t1
+ (c1 bigint, c2 bigint)
+ ENGINE=OLAP
+ DUPLICATE KEY(c1, c2)
+ COMMENT 'OLAP'
+ DISTRIBUTED BY HASH(c1) BUCKETS 1
+ PROPERTIES (
+ "replication_num" = "1"
+ );
+ create table t2
+ (c1 bigint, c2 bigint)
+ ENGINE=OLAP
+ DUPLICATE KEY(c1, c2)
+ COMMENT 'OLAP'
+ DISTRIBUTED BY HASH(c1) BUCKETS 1
+ PROPERTIES (
+ "replication_num" = "1"
+ );
+ drop view if exists ttv1;
+ drop view if exists ttv2;
+ create view ttv1 as select t1.c1, t2.c2 from t1 join t2 on t1.c2 =
t2.c2;
+ create view ttv2 as select t1.c1 from t1 where t1.c2 = 1;
+ """
+
+ qt_cmd("""show view from t1;""")
+ qt_cmd("""show view from test_show_view_db1.t1;""")
+ qt_cmd("""show view from test_show_view_db2.t1;""")
+ qt_cmd("""show view from test_show_view_db1.t1 from test_show_view_db2;""")
+}
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
