Support for SHOW TABLES and DESCRIBE <tbl_name> Commands

[MinuraPunchihewa]

As a user, I would like to be able to issue an equivalent of MySQL's SHOW TABLES and DESCRIBE <tbl_name> commands, to get a list of tables in my cluster and to get metadata about a particular table (such as its columns and their types) respectively.

[liyujiel]

Hey folks, I'm new here, may I take this task? :) @npawar

[xiangfu0]

Hey folks, I'm new here, may I take this task? :) @npawar

Thanks! Assigned to you!

[xiangfu0]

I think we may need to support the SQL syntax, cc: @walterddr to confirm we already have all the prerequisites.

[walterddr]

see: https://calcite.apache.org/docs/reference.html#ddl-extensions

• DESCRIBE TABLE <table_name> should be parsable by calcite
• SHOW TALBES might not be,
  • although we can make it as an alias of DESCRIBE DATABASE "default" since pinot doesn't have a catalog/database concept and it should show the table list

[jonas-grgt]

I'm interested in diving into this one, feels like a good first issue. Might need some time getting acquainted with the code base and calcite.

[aadilkhalifa]

Can I take this up? @xiangfu0 @walterddr

[Jackie-Jiang]

@aadilkhalifa Sure, welcome to the community!

[marregui]

hi!, I saw this tasty feature and I must have it. Could I please know the status?, if nobody is currently working on it due to too busy schedules, may I please take it? thank you

[aadilkhalifa]

@marregui Hi. I'm working on it here https://github.com/apache/pinot/pull/12537