This repository has been archived by the owner on Aug 2, 2022. It is now read-only.
Extend support for SHOW query to apply filter on TABLE_CAT, TABLE_SCHEM and TABLE_TYPE #324
Open
Description
Expected Result: List of filtered table, catalog, schema names, and table types.
Currently, filter is available only for TABLE_NAME
For example, SHOW TABLES LIKE kib* returns a list of filtered TABLE_NAME
{
"schema": [
{
"name": "TABLE_CAT",
"type": "keyword"
},
{
"name": "TABLE_SCHEM",
"type": "keyword"
},
{
"name": "TABLE_NAME",
"type": "keyword"
},
{
"name": "TABLE_TYPE",
"type": "keyword"
},
{
"name": "REMARKS",
"type": "keyword"
},
{
"name": "TYPE_CAT",
"type": "keyword"
},
{
"name": "TYPE_SCHEM",
"type": "keyword"
},
{
"name": "TYPE_NAME",
"type": "keyword"
},
{
"name": "SELF_REFERENCING_COL_NAME",
"type": "keyword"
},
{
"name": "REF_GENERATION",
"type": "keyword"
}
],
"total": 4,
"datarows": [
[
"odfe-cluster",
null,
"kibana_sample_data_ecommerce",
"BASE TABLE",
null,
null,
null,
null,
null,
null
],
[
"odfe-cluster",
null,
"kibana_sample_data_flights",
"BASE TABLE",
null,
null,
null,
null,
null,
null
],
[
"odfe-cluster",
null,
"kibana_sample_data_logs",
"BASE TABLE",
null,
null,
null,
null,
null,
null
],
[
"odfe-cluster",
null,
"kibana_sample_data_types",
"BASE TABLE",
null,
null,
null,
null,
null,
null
]
],
"size": 4,
"status": 200
}
Similar support is required for TABLE_CAT, TABLE_SCHEM and TABLE_TYPE.