[GitHub] [incubator-pinot] amarnathkarthik edited a comment on issue #6298: Support Describe Pinot table and schema

[GitBox <gi...@apache.org>]

amarnathkarthik edited a comment on issue #6298:
URL: https://github.com/apache/incubator-pinot/issues/6298#issuecomment-752363299


   @fx19880617 Here is my initial analysis, correct me if I'm wrong.
   Calcite does not support `SHOW (databases | tables)` kind of SQL, below are the available implementations; therefore `DESCRIBE TABLE <table_name>` should work. To list all tables will have to go with `SELECT table_name FROM information_schema.TABLES;` and to list all schema then `SELECT table_name FROM information_schema.SCHEMATA;`
   
   ```
   SqlAlter
   SqlBasicCall
   SqlCase
   SqlCreate
   SqlDdl
   SqlDelete
   SqlDescribeSchema
   SqlDescribeTable
   SqlDrop
   SqlExplain
   SqlInsert
   SqlJoin
   SqlMatchRecognize
   SqlMerge
   SqlOrderBy
   SqlSelect
   SqlSetOption
   SqlSnapshot
   SqlUpdate
   SqlWindow
   SqlWith
   SqlWithItem
   ```


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org