This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang 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 b7ac60f189a Support Hive SHOW DATABASES & SHOW CONNECTORS & SHOW
TABLES statement parse (#36221)
b7ac60f189a is described below
commit b7ac60f189ad254dfb8fb4d4ad8b849f1cc617c7
Author: Claire <[email protected]>
AuthorDate: Mon Aug 11 13:49:58 2025 +0800
Support Hive SHOW DATABASES & SHOW CONNECTORS & SHOW TABLES statement parse
(#36221)
* support show databases statement
* support show connectors statement
* support show tables statement
* update
* checkstyle
* update code
* update RELEASE-NOTES
* update RELEASE-NOTES
* Update HiveDALStatementVisitor.java
* support hive drop function statement
* update showdatabases
* update show connectors
* update show tables
* checkstyle
---
RELEASE-NOTES.md | 1 +
parser/sql/dialect/hive/pom.xml | 6 +++
.../hive/src/main/antlr4/imports/hive/BaseRule.g4 | 4 ++
.../hive/DALStatement.g4} | 56 +++++++++-------------
.../src/main/antlr4/imports/hive/HiveKeyword.g4 | 4 ++
.../sql/parser/autogen/HiveStatement.g4 | 3 +-
.../visitor/statement/HiveStatementVisitor.java | 7 +++
.../statement/type/HiveDALStatementVisitor.java | 54 +++++++++++++++++++++
parser/sql/statement/type/{ => hive}/pom.xml | 18 +++----
.../hive/dal/show/HiveShowConnectorsStatement.java | 38 +++++++++++++++
parser/sql/statement/type/pom.xml | 1 +
.../it/parser/src/main/resources/case/dal/show.xml | 47 ++++++++++++++++++
.../src/main/resources/sql/supported/dal/show.xml | 10 ++++
13 files changed, 205 insertions(+), 44 deletions(-)
diff --git a/RELEASE-NOTES.md b/RELEASE-NOTES.md
index d26aa0c2ec1..2a9c94d49a0 100644
--- a/RELEASE-NOTES.md
+++ b/RELEASE-NOTES.md
@@ -74,6 +74,7 @@
1. SQL Parser: Support Hive CREATE FUNCTION statement parse -
[#36193](https://github.com/apache/shardingsphere/pull/36193)
1. SQL Parser: Support Hive DROP FUNCTION statement parse -
[#36196](https://github.com/apache/shardingsphere/pull/36196)
1. SQL Parser: Support Hive RELOAD FUNCTION statement parse -
[#36200](https://github.com/apache/shardingsphere/pull/36200)
+1. SQL Parser: Support Hive SHOW DATABASES & SHOW CONNECTORS & SHOW TABLES
statement parse - [#36221](https://github.com/apache/shardingsphere/pull/36221)
1. SQL Parser: Support SQL Server xml methods parse -
[#35911](https://github.com/apache/shardingsphere/pull/35911)
1. SQL Parser: Support SQL Server CHANGETABLE function parse -
[#35920](https://github.com/apache/shardingsphere/pull/35920)
1. SQL Parser: Support SQL Server AI_GENERATE_EMBEDDINGS function parse -
[#35922](https://github.com/apache/shardingsphere/pull/35922)
diff --git a/parser/sql/dialect/hive/pom.xml b/parser/sql/dialect/hive/pom.xml
index 37cf958d6f7..0653ebe3c9c 100644
--- a/parser/sql/dialect/hive/pom.xml
+++ b/parser/sql/dialect/hive/pom.xml
@@ -48,5 +48,11 @@
<version>${project.version}</version>
<scope>test</scope>
</dependency>
+ <dependency>
+ <groupId>org.apache.shardingsphere</groupId>
+ <artifactId>shardingsphere-parser-sql-statement-hive</artifactId>
+ <version>5.5.3-SNAPSHOT</version>
+ <scope>compile</scope>
+ </dependency>
</dependencies>
</project>
diff --git a/parser/sql/dialect/hive/src/main/antlr4/imports/hive/BaseRule.g4
b/parser/sql/dialect/hive/src/main/antlr4/imports/hive/BaseRule.g4
index 8717c51a1e7..788eadac598 100644
--- a/parser/sql/dialect/hive/src/main/antlr4/imports/hive/BaseRule.g4
+++ b/parser/sql/dialect/hive/src/main/antlr4/imports/hive/BaseRule.g4
@@ -636,6 +636,10 @@ charsetName
: textOrIdentifier | BINARY | DEFAULT
;
+databaseName
+ : identifier
+ ;
+
tableName
: (owner DOT_)? name
;
diff --git
a/parser/sql/dialect/hive/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/HiveStatement.g4
b/parser/sql/dialect/hive/src/main/antlr4/imports/hive/DALStatement.g4
similarity index 53%
copy from
parser/sql/dialect/hive/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/HiveStatement.g4
copy to parser/sql/dialect/hive/src/main/antlr4/imports/hive/DALStatement.g4
index 6175cadc325..14e3e9d1c36 100644
---
a/parser/sql/dialect/hive/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/HiveStatement.g4
+++ b/parser/sql/dialect/hive/src/main/antlr4/imports/hive/DALStatement.g4
@@ -15,40 +15,28 @@
* limitations under the License.
*/
-grammar HiveStatement;
+grammar DALStatement;
-import Comments, DMLStatement, DDLStatement;
+import BaseRule;
-// TODO correct hive SQL parsing according to official documentation
-execute
- : (select
- | insert
- | update
- | delete
- | loadStatement
- | createDatabase
- | dropDatabase
- | alterDatabase
- | use
- | createTable
- | dropTable
- | truncateTable
- | msckStatement
- | alterTable
- | createView
- | dropView
- | alterView
- | createMaterializedView
- | dropMaterializedView
- | alterMaterializedView
- | createIndex
- | dropIndex
- | alterIndex
- | createMacro
- | dropMacro
- | createFunction
- | dropFunction
- | reloadFunction
- ) (SEMI_ EOF? | EOF)
- | EOF
+show
+ : showDatabases
+ | showConnectors
+ | showTables
+ ;
+
+showDatabases
+ : SHOW (DATABASES|SCHEMAS) showLike?
+ ;
+
+showConnectors
+ : SHOW CONNECTORS
+ ;
+
+showTables
+ : SHOW TABLES (IN databaseName)? stringLiterals?
+ ;
+
+showLike
+ : LIKE stringLiterals
;
diff --git
a/parser/sql/dialect/hive/src/main/antlr4/imports/hive/HiveKeyword.g4
b/parser/sql/dialect/hive/src/main/antlr4/imports/hive/HiveKeyword.g4
index 3b13d2cd825..f373cbe0750 100644
--- a/parser/sql/dialect/hive/src/main/antlr4/imports/hive/HiveKeyword.g4
+++ b/parser/sql/dialect/hive/src/main/antlr4/imports/hive/HiveKeyword.g4
@@ -3365,3 +3365,7 @@ MACRO
JAR
: J A R
;
+
+CONNECTORS
+ : C O N N E C T O R S
+ ;
diff --git
a/parser/sql/dialect/hive/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/HiveStatement.g4
b/parser/sql/dialect/hive/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/HiveStatement.g4
index 6175cadc325..cdf233feb67 100644
---
a/parser/sql/dialect/hive/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/HiveStatement.g4
+++
b/parser/sql/dialect/hive/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/HiveStatement.g4
@@ -17,7 +17,7 @@
grammar HiveStatement;
-import Comments, DMLStatement, DDLStatement;
+import Comments, DMLStatement, DDLStatement, DALStatement;
// TODO correct hive SQL parsing according to official documentation
execute
@@ -49,6 +49,7 @@ execute
| createFunction
| dropFunction
| reloadFunction
+ | show
) (SEMI_ EOF? | EOF)
| EOF
;
diff --git
a/parser/sql/dialect/hive/src/main/java/org/apache/shardingsphere/sql/parser/hive/visitor/statement/HiveStatementVisitor.java
b/parser/sql/dialect/hive/src/main/java/org/apache/shardingsphere/sql/parser/hive/visitor/statement/HiveStatementVisitor.java
index 2611ef6ff6b..08d2ffce3b3 100644
---
a/parser/sql/dialect/hive/src/main/java/org/apache/shardingsphere/sql/parser/hive/visitor/statement/HiveStatementVisitor.java
+++
b/parser/sql/dialect/hive/src/main/java/org/apache/shardingsphere/sql/parser/hive/visitor/statement/HiveStatementVisitor.java
@@ -52,6 +52,7 @@ import
org.apache.shardingsphere.sql.parser.autogen.HiveStatementParser.TableNam
import
org.apache.shardingsphere.sql.parser.autogen.HiveStatementParser.TemporalLiteralsContext;
import
org.apache.shardingsphere.sql.parser.autogen.HiveStatementParser.ViewNameContext;
import
org.apache.shardingsphere.sql.parser.autogen.HiveStatementParser.ViewNamesContext;
+import
org.apache.shardingsphere.sql.parser.autogen.HiveStatementParser.DatabaseNameContext;
import
org.apache.shardingsphere.sql.parser.statement.core.enums.ParameterMarkerType;
import
org.apache.shardingsphere.sql.parser.statement.core.segment.ddl.index.IndexNameSegment;
import
org.apache.shardingsphere.sql.parser.statement.core.segment.ddl.index.IndexSegment;
@@ -72,6 +73,7 @@ import
org.apache.shardingsphere.sql.parser.statement.core.segment.dml.expr.simp
import
org.apache.shardingsphere.sql.parser.statement.core.segment.dml.expr.subquery.SubqueryExpressionSegment;
import
org.apache.shardingsphere.sql.parser.statement.core.segment.dml.expr.subquery.SubquerySegment;
import
org.apache.shardingsphere.sql.parser.statement.core.segment.dml.item.ExpressionProjectionSegment;
+import
org.apache.shardingsphere.sql.parser.statement.core.segment.generic.DatabaseSegment;
import
org.apache.shardingsphere.sql.parser.statement.core.segment.generic.OwnerSegment;
import
org.apache.shardingsphere.sql.parser.statement.core.segment.generic.ParameterMarkerSegment;
import
org.apache.shardingsphere.sql.parser.statement.core.segment.generic.table.SimpleTableSegment;
@@ -180,6 +182,11 @@ public abstract class HiveStatementVisitor extends
HiveStatementBaseVisitor<ASTN
return new IdentifierValue(ctx.getText());
}
+ @Override
+ public final ASTNode visitDatabaseName(final DatabaseNameContext ctx) {
+ return new DatabaseSegment(ctx.getStart().getStartIndex(),
ctx.getStop().getStopIndex(), (IdentifierValue) visit(ctx.identifier()));
+ }
+
@Override
public final ASTNode visitTableName(final TableNameContext ctx) {
SimpleTableSegment result = new SimpleTableSegment(new
TableNameSegment(ctx.name().getStart().getStartIndex(),
diff --git
a/parser/sql/dialect/hive/src/main/java/org/apache/shardingsphere/sql/parser/hive/visitor/statement/type/HiveDALStatementVisitor.java
b/parser/sql/dialect/hive/src/main/java/org/apache/shardingsphere/sql/parser/hive/visitor/statement/type/HiveDALStatementVisitor.java
index 78f8f09af67..e442ac2f145 100644
---
a/parser/sql/dialect/hive/src/main/java/org/apache/shardingsphere/sql/parser/hive/visitor/statement/type/HiveDALStatementVisitor.java
+++
b/parser/sql/dialect/hive/src/main/java/org/apache/shardingsphere/sql/parser/hive/visitor/statement/type/HiveDALStatementVisitor.java
@@ -21,9 +21,21 @@ import
org.apache.shardingsphere.infra.database.core.type.DatabaseType;
import org.apache.shardingsphere.sql.parser.api.ASTNode;
import
org.apache.shardingsphere.sql.parser.api.visitor.statement.type.DALStatementVisitor;
import
org.apache.shardingsphere.sql.parser.autogen.HiveStatementParser.UseContext;
+import
org.apache.shardingsphere.sql.parser.autogen.HiveStatementParser.ShowDatabasesContext;
+import
org.apache.shardingsphere.sql.parser.autogen.HiveStatementParser.ShowLikeContext;
+import
org.apache.shardingsphere.sql.parser.autogen.HiveStatementParser.ShowConnectorsContext;
+import
org.apache.shardingsphere.sql.parser.autogen.HiveStatementParser.ShowTablesContext;
import
org.apache.shardingsphere.sql.parser.hive.visitor.statement.HiveStatementVisitor;
+import
org.apache.shardingsphere.sql.parser.statement.core.segment.dal.FromDatabaseSegment;
+import
org.apache.shardingsphere.sql.parser.statement.core.segment.dal.ShowFilterSegment;
+import
org.apache.shardingsphere.sql.parser.statement.core.segment.dal.ShowLikeSegment;
+import
org.apache.shardingsphere.sql.parser.statement.core.segment.generic.DatabaseSegment;
import
org.apache.shardingsphere.sql.parser.statement.core.value.identifier.IdentifierValue;
+import
org.apache.shardingsphere.sql.parser.statement.core.value.literal.impl.StringLiteralValue;
+import
org.apache.shardingsphere.sql.parser.statement.hive.dal.show.HiveShowConnectorsStatement;
import
org.apache.shardingsphere.sql.parser.statement.mysql.dal.MySQLUseStatement;
+import
org.apache.shardingsphere.sql.parser.statement.mysql.dal.show.database.MySQLShowDatabasesStatement;
+import
org.apache.shardingsphere.sql.parser.statement.mysql.dal.show.table.MySQLShowTablesStatement;
/**
* DAL statement visitor for Hive.
@@ -39,4 +51,46 @@ public final class HiveDALStatementVisitor extends
HiveStatementVisitor implemen
String database = null == ctx.DEFAULT() ? new
IdentifierValue(ctx.identifier().getText()).getValue() : "default";
return new MySQLUseStatement(getDatabaseType(), database);
}
+
+ @Override
+ public ASTNode visitShowDatabases(final ShowDatabasesContext ctx) {
+ ShowFilterSegment filter = null;
+ if (null != ctx.showLike()) {
+ filter = new
ShowFilterSegment(ctx.showLike().getStart().getStartIndex(),
ctx.showLike().getStop().getStopIndex());
+ filter.setLike((ShowLikeSegment) visit(ctx.showLike()));
+ }
+ MySQLShowDatabasesStatement result = new
MySQLShowDatabasesStatement(getDatabaseType(), filter);
+ result.addParameterMarkers(getParameterMarkerSegments());
+ return result;
+ }
+
+ @Override
+ public ASTNode visitShowLike(final ShowLikeContext ctx) {
+ StringLiteralValue literalValue = (StringLiteralValue)
visit(ctx.stringLiterals());
+ return new ShowLikeSegment(ctx.getStart().getStartIndex(),
ctx.getStop().getStopIndex(), literalValue.getValue());
+ }
+
+ @Override
+ public ASTNode visitShowConnectors(final ShowConnectorsContext ctx) {
+ return new HiveShowConnectorsStatement(getDatabaseType());
+ }
+
+ @Override
+ public ASTNode visitShowTables(final ShowTablesContext ctx) {
+ FromDatabaseSegment fromDatabase = null;
+ if (null != ctx.databaseName()) {
+ DatabaseSegment databaseSegment = (DatabaseSegment)
visit(ctx.databaseName());
+ fromDatabase = new
FromDatabaseSegment(ctx.databaseName().getStart().getStartIndex(),
databaseSegment);
+ }
+ ShowFilterSegment filter = null;
+ if (null != ctx.stringLiterals()) {
+ StringLiteralValue literalValue = (StringLiteralValue)
visit(ctx.stringLiterals());
+ ShowLikeSegment likeSegment = new
ShowLikeSegment(ctx.stringLiterals().getStart().getStartIndex(),
ctx.stringLiterals().getStop().getStopIndex(), literalValue.getValue());
+ filter = new
ShowFilterSegment(ctx.stringLiterals().getStart().getStartIndex(),
ctx.stringLiterals().getStop().getStopIndex());
+ filter.setLike(likeSegment);
+ }
+ MySQLShowTablesStatement result = new
MySQLShowTablesStatement(getDatabaseType(), fromDatabase, filter, false);
+ result.addParameterMarkers(getParameterMarkerSegments());
+ return result;
+ }
}
diff --git a/parser/sql/statement/type/pom.xml
b/parser/sql/statement/type/hive/pom.xml
similarity index 76%
copy from parser/sql/statement/type/pom.xml
copy to parser/sql/statement/type/hive/pom.xml
index 2d12dd59ea9..814eb3b9783 100644
--- a/parser/sql/statement/type/pom.xml
+++ b/parser/sql/statement/type/hive/pom.xml
@@ -20,17 +20,17 @@
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.apache.shardingsphere</groupId>
- <artifactId>shardingsphere-parser-sql-statement</artifactId>
+ <artifactId>shardingsphere-parser-sql-statement-type</artifactId>
<version>5.5.3-SNAPSHOT</version>
</parent>
- <artifactId>shardingsphere-parser-sql-statement-type</artifactId>
- <packaging>pom</packaging>
+ <artifactId>shardingsphere-parser-sql-statement-hive</artifactId>
<name>${project.artifactId}</name>
- <modules>
- <module>postgresql</module>
- <module>mysql</module>
- <module>sqlserver</module>
- <module>oracle</module>
- </modules>
+ <dependencies>
+ <dependency>
+ <groupId>org.apache.shardingsphere</groupId>
+ <artifactId>shardingsphere-parser-sql-statement-core</artifactId>
+ <version>${project.version}</version>
+ </dependency>
+ </dependencies>
</project>
diff --git
a/parser/sql/statement/type/hive/src/main/java/org/apache/shardingsphere/sql/parser/statement/hive/dal/show/HiveShowConnectorsStatement.java
b/parser/sql/statement/type/hive/src/main/java/org/apache/shardingsphere/sql/parser/statement/hive/dal/show/HiveShowConnectorsStatement.java
new file mode 100644
index 00000000000..72b6170a41f
--- /dev/null
+++
b/parser/sql/statement/type/hive/src/main/java/org/apache/shardingsphere/sql/parser/statement/hive/dal/show/HiveShowConnectorsStatement.java
@@ -0,0 +1,38 @@
+/*
+ * 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.hive.dal.show;
+
+import org.apache.shardingsphere.infra.database.core.type.DatabaseType;
+import
org.apache.shardingsphere.sql.parser.statement.core.statement.attribute.SQLStatementAttributes;
+import
org.apache.shardingsphere.sql.parser.statement.core.statement.attribute.type.TablelessDataSourceBroadcastRouteSQLStatementAttribute;
+import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dal.DALStatement;
+
+/**
+ * Show connectors statement for Hive.
+ */
+public final class HiveShowConnectorsStatement extends DALStatement {
+
+ public HiveShowConnectorsStatement(final DatabaseType databaseType) {
+ super(databaseType);
+ }
+
+ @Override
+ public SQLStatementAttributes getAttributes() {
+ return new SQLStatementAttributes(new
TablelessDataSourceBroadcastRouteSQLStatementAttribute());
+ }
+}
diff --git a/parser/sql/statement/type/pom.xml
b/parser/sql/statement/type/pom.xml
index 2d12dd59ea9..ee18e426080 100644
--- a/parser/sql/statement/type/pom.xml
+++ b/parser/sql/statement/type/pom.xml
@@ -32,5 +32,6 @@
<module>mysql</module>
<module>sqlserver</module>
<module>oracle</module>
+ <module>hive</module>
</modules>
</project>
diff --git a/test/it/parser/src/main/resources/case/dal/show.xml
b/test/it/parser/src/main/resources/case/dal/show.xml
index 6d056443995..6df44dad3e8 100644
--- a/test/it/parser/src/main/resources/case/dal/show.xml
+++ b/test/it/parser/src/main/resources/case/dal/show.xml
@@ -869,4 +869,51 @@
<show sql-case-id="show_search_path" name="search_path" />
<show sql-case-id="show_errors" />
<show sql-case-id="show_parameter_smtp_out_server" />
+
+ <show-databases sql-case-id="show_databases_basic" />
+
+ <show-databases sql-case-id="show_schemas_basic" />
+
+ <show-databases sql-case-id="show_databases_with_like_wildcard">
+ <filter start-index="15" stop-index="25">
+ <like pattern="emp*" start-delimiter="'" end-delimiter="'"
start-index="15" stop-index="25" />
+ </filter>
+ </show-databases>
+
+ <show-databases sql-case-id="show_schemas_with_like_sql_wildcard">
+ <filter start-index="13" stop-index="28">
+ <like pattern="emplo_ees" start-delimiter="'" end-delimiter="'"
start-index="13" stop-index="28" />
+ </filter>
+ </show-databases>
+
+ <show-databases sql-case-id="show_databases_with_like_exact_match">
+ <filter start-index="15" stop-index="30">
+ <like pattern="employees" start-delimiter="'" end-delimiter="'"
start-index="15" stop-index="30" />
+ </filter>
+ </show-databases>
+
+ <show sql-case-id="show_connectors" />
+
+ <show-tables sql-case-id="show_tables_basic" />
+
+ <show-tables sql-case-id="show_tables_in_database">
+ <from start-index="15" stop-index="22">
+ <database name="sales_db" start-index="15" stop-index="22" />
+ </from>
+ </show-tables>
+
+ <show-tables sql-case-id="show_tables_with_wildcard">
+ <filter start-index="12" stop-index="20">
+ <like pattern="order_*" start-delimiter="'" end-delimiter="'"
start-index="12" stop-index="20" />
+ </filter>
+ </show-tables>
+
+ <show-tables sql-case-id="show_tables_in_db_with_wildcard">
+ <from start-index="15" stop-index="22">
+ <database name="sales_db" start-index="15" stop-index="22" />
+ </from>
+ <filter start-index="24" stop-index="32">
+ <like pattern="order_*" start-delimiter="'" end-delimiter="'"
start-index="24" stop-index="32" />
+ </filter>
+ </show-tables>
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dal/show.xml
b/test/it/parser/src/main/resources/sql/supported/dal/show.xml
index b995ffa0c6c..67767018b34 100644
--- a/test/it/parser/src/main/resources/sql/supported/dal/show.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dal/show.xml
@@ -146,4 +146,14 @@
<sql-case id="show_search_path" value="SHOW search_path;"
db-types="PostgreSQL,openGauss" />
<sql-case id="show_errors" value="SHOW ERRORS;" db-types="Oracle"/>
<sql-case id="show_parameter_smtp_out_server" value="SHOW PARAMETER
SMTP_OUT_SERVER" db-types="Oracle"/>
+ <sql-case id="show_databases_basic" value="SHOW DATABASES;"
db-types="Hive" />
+ <sql-case id="show_schemas_basic" value="SHOW SCHEMAS;" db-types="Hive" />
+ <sql-case id="show_databases_with_like_wildcard" value="SHOW DATABASES
LIKE 'emp*';" db-types="Hive" />
+ <sql-case id="show_schemas_with_like_sql_wildcard" value="SHOW SCHEMAS
LIKE 'emplo_ees';" db-types="Hive" />
+ <sql-case id="show_databases_with_like_exact_match" value="SHOW DATABASES
LIKE 'employees';" db-types="Hive" />
+ <sql-case id="show_connectors" value="SHOW CONNECTORS;" db-types="Hive" />
+ <sql-case id="show_tables_basic" value="SHOW TABLES;" db-types="Hive" />
+ <sql-case id="show_tables_in_database" value="SHOW TABLES IN sales_db;"
db-types="Hive" />
+ <sql-case id="show_tables_with_wildcard" value="SHOW TABLES 'order_*';"
db-types="Hive" />
+ <sql-case id="show_tables_in_db_with_wildcard" value="SHOW TABLES IN
sales_db 'order_*';" db-types="Hive" />
</sql-cases>
