Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature] Implement the metadata related api of flightsql #1174

Closed
yukkit opened this issue May 11, 2023 · 0 comments · Fixed by #1173
Closed

[Feature] Implement the metadata related api of flightsql #1174

yukkit opened this issue May 11, 2023 · 0 comments · Fixed by #1173

Comments

@yukkit
Copy link
Contributor

yukkit commented May 11, 2023

Is your feature request related to a problem? Please describe.

Get the metadata of catalog/schema/table through the flight sql client

Describe the solution you'd like

implement

FlightSqlService::get_flight_info_catalogs

Retrieves the catalog names available in this database. The results are ordered by catalog name.
The catalog column is:

  • TABLE_CAT String => catalog name

FlightSqlService::get_flight_info_schemas

Retrieves the schema names available in this database. The results are ordered by TABLE_CATALOG and TABLE_SCHEM.
The schema columns are:

  • TABLE_SCHEM String => schema name (database in CnosDB)
  • TABLE_CATALOG String => catalog name (tenant in CnosDB)

FlightSqlService::get_flight_info_tables

Retrieves a description of the tables available in the given catalog. Only table descriptions matching the catalog, schema, table name and type criteria are returned. They are ordered by TABLE_TYPE, TABLE_CAT, TABLE_SCHEM and TABLE_NAME.
Each table description has the following columns:

  • TABLE_CAT String => table catalog (tenant in CnosDB)
  • TABLE_SCHEM String => table schema (database in CnosDB)
  • TABLE_NAME String => table name
  • TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW", "LOCAL TEMPORARY".

FlightSqlService::get_flight_info_table_types

Retrieves the table types available in this database. The results are ordered by table type.
The table type is:

  • TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW", "LOCAL TEMPORARY".

Describe alternatives you've considered

Additional context

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant