Skip to content
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
rupal-bq opened this issue Dec 17, 2019 · 0 comments
Labels
enhancement New feature or request JDBC/ODBC formatting This issue is related to JDBC or ODBC driver client SQL

Comments

@rupal-bq
Copy link
Contributor

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.

@rupal-bq rupal-bq changed the title Extend support for SHOW query to apply filter on TABLE_CAT, TABLE_SCHEM and TABLE_TYPE Extend support for SHOW query to apply filter on TABLE_CAT, TABLE_SCHEM and TABLE_TYPE Dec 17, 2019
@anirudha anirudha added enhancement New feature or request JDBC/ODBC formatting This issue is related to JDBC or ODBC driver client labels Apr 13, 2020
@dai-chen dai-chen added the SQL label Sep 11, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
enhancement New feature or request JDBC/ODBC formatting This issue is related to JDBC or ODBC driver client SQL
Projects
None yet
Development

No branches or pull requests

3 participants