query::sql

Function query_from_information_schema_table

source
async fn query_from_information_schema_table(
    query_engine: &QueryEngineRef,
    catalog_manager: &CatalogManagerRef,
    query_ctx: QueryContextRef,
    table_name: &str,
    select: Vec<Expr>,
    projects: Vec<(&str, &str)>,
    filters: Vec<Expr>,
    like_field: Option<&str>,
    sort: Vec<Expr>,
    kind: ShowKind,
) -> Result<Output>
Expand description

Cast a show statement execution into a query from tables in information_schema.

  • table_name: the table name in information_schema,
  • projects: query projection, a list of (column, renamed_column),
  • filters: filter expressions for query,
  • like_field: the field to filter by the predicate ShowKind::Like,
  • sort: sort the results by the specified sorting expressions,
  • kind: the show kind