SHOW TABLES and DESCRIBE <table> Equivalents in Apache Pinot

Question

What are the equivalents for the SHOW TABLES and DESCRIBE <table> in Apache Pinot?

Basically, I just want to get a list of tables in the cluster and I want to be able to get the column names and their data types for a chosen table.

Answer 1

I think you can you use this to see all available commands:

calcite dialect reference

describe: DESCRIBE DATABASE databaseName | DESCRIBE CATALOG [ databaseName . ] catalogName | DESCRIBE SCHEMA [ [ databaseName . ] catalogName ] . schemaName | DESCRIBE [ TABLE ] [ [ [ databaseName . ] catalogName . ] schemaName . ] tableName [ columnName ] | DESCRIBE [ STATEMENT ] { query | insert | update | merge | delete }

Answer 2

As of Apache Pinot 0.11.x, it supports fetching schema only from its Controller APIs. See docs here https://docs.pinot.apache.org/basics/components/exploring-pinot#rest-api