You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by as...@apache.org on 2023/06/19 01:05:52 UTC
[doris] branch master updated: [Enhancement](table) adding information_schema.parameters table (#20259)
This is an automated email from the ASF dual-hosted git repository.
ashingau 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 1efd345963 [Enhancement](table) adding information_schema.parameters table (#20259)
1efd345963 is described below
commit 1efd345963a06788b98897555789ed5cf09b3171
Author: Zhiyu Hu <45...@users.noreply.github.com>
AuthorDate: Mon Jun 19 09:05:46 2023 +0800
[Enhancement](table) adding information_schema.parameters table (#20259)
this is a virtual table for compatibility information_schema parameters table
---
.../org/apache/doris/analysis/SchemaTableType.java | 3 ++-
.../java/org/apache/doris/catalog/SchemaTable.java | 18 ++++++++++++++++++
gensrc/thrift/Descriptors.thrift | 3 ++-
.../data/query_p0/system/test_query_sys_tables.out | 2 ++
.../query_p0/system/test_query_sys_tables.groovy | 1 +
5 files changed, 25 insertions(+), 2 deletions(-)
diff --git a/fe/fe-core/src/main/java/org/apache/doris/analysis/SchemaTableType.java b/fe/fe-core/src/main/java/org/apache/doris/analysis/SchemaTableType.java
index ca282015fa..f1e6031d23 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/analysis/SchemaTableType.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/analysis/SchemaTableType.java
@@ -67,7 +67,8 @@ public enum SchemaTableType {
SCH_VIEWS("VIEWS", "VIEWS", TSchemaTableType.SCH_VIEWS),
SCH_CREATE_TABLE("CREATE_TABLE", "CREATE_TABLE", TSchemaTableType.SCH_CREATE_TABLE),
SCH_INVALID("NULL", "NULL", TSchemaTableType.SCH_INVALID),
- SCH_ROWSETS("ROWSETS", "ROWSETS", TSchemaTableType.SCH_ROWSETS);
+ SCH_ROWSETS("ROWSETS", "ROWSETS", TSchemaTableType.SCH_ROWSETS),
+ SCH_PARAMETERS("PARAMETERS", "PARAMETERS", TSchemaTableType.SCH_PARAMETERS);
private static final String dbName = "INFORMATION_SCHEMA";
private static SelectList fullSelectLists;
diff --git a/fe/fe-core/src/main/java/org/apache/doris/catalog/SchemaTable.java b/fe/fe-core/src/main/java/org/apache/doris/catalog/SchemaTable.java
index 160c6169bc..5237955c88 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/catalog/SchemaTable.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/catalog/SchemaTable.java
@@ -392,6 +392,24 @@ public class SchemaTable extends Table {
.column("CREATION_TIME", ScalarType.createType(PrimitiveType.BIGINT))
.column("NEWEST_WRITE_TIMESTAMP", ScalarType.createType(PrimitiveType.BIGINT))
.build()))
+ .put("parameters", new SchemaTable(SystemIdGenerator.getNextId(), "parameters", TableType.SCHEMA,
+ builder().column("SPECIFIC_CATALOG", ScalarType.createVarchar(64))
+ .column("SPECIFIC_SCHEMA", ScalarType.createVarchar(64))
+ .column("SPECIFIC_NAME", ScalarType.createVarchar(64))
+ .column("ORDINAL_POSITION", ScalarType.createVarchar(77))
+ .column("PARAMETER_MODE", ScalarType.createVarchar(77))
+ .column("PARAMETER_NAME", ScalarType.createVarchar(77))
+ .column("DATA_TYPE", ScalarType.createVarchar(64))
+ .column("CHARACTER_OCTET_LENGTH", ScalarType.createVarchar(64))
+ .column("NUMERIC_PRECISION", ScalarType.createVarchar(512))
+ .column("NUMERIC_SCALE", ScalarType.createVarchar(64))
+ .column("DATETIME_PRECISION", ScalarType.createVarchar(64))
+ .column("CHARACTER_SET_NAME", ScalarType.createVarchar(256))
+ .column("COLLATION_NAME", ScalarType.createVarchar(64))
+ .column("DTD_IDENTIFIER", ScalarType.createVarchar(64))
+ .column("ROUTINE_TYPE", ScalarType.createVarchar(64))
+ .column("DATA_TYPEDTD_IDENDS", ScalarType.createVarchar(64))
+ .build()))
.build();
protected SchemaTable(long id, String name, TableType type, List<Column> baseSchema) {
diff --git a/gensrc/thrift/Descriptors.thrift b/gensrc/thrift/Descriptors.thrift
index b848b847a4..d8fd59c101 100644
--- a/gensrc/thrift/Descriptors.thrift
+++ b/gensrc/thrift/Descriptors.thrift
@@ -114,7 +114,8 @@ enum TSchemaTableType {
SCH_INVALID,
SCH_ROWSETS,
SCH_BACKENDS,
- SCH_COLUMN_STATISTICS
+ SCH_COLUMN_STATISTICS,
+ SCH_PARAMETERS;
}
enum THdfsCompression {
diff --git a/regression-test/data/query_p0/system/test_query_sys_tables.out b/regression-test/data/query_p0/system/test_query_sys_tables.out
index 5ccb57f74e..73300030c8 100644
--- a/regression-test/data/query_p0/system/test_query_sys_tables.out
+++ b/regression-test/data/query_p0/system/test_query_sys_tables.out
@@ -55,3 +55,5 @@ test_view
-- !sql --
+-- !sql --
+
diff --git a/regression-test/suites/query_p0/system/test_query_sys_tables.groovy b/regression-test/suites/query_p0/system/test_query_sys_tables.groovy
index 7c35837398..f74edcd524 100644
--- a/regression-test/suites/query_p0/system/test_query_sys_tables.groovy
+++ b/regression-test/suites/query_p0/system/test_query_sys_tables.groovy
@@ -205,4 +205,5 @@ suite("test_query_sys_tables", "query,p0") {
qt_sql "select * from referential_constraints"
qt_sql "select * from key_column_usage"
qt_sql "select * from triggers"
+ qt_sql "select * from parameters"
}
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org