[ SDK PERFORMANCE] The execution of the show tables command takes a long time.

[wxp0329]

As shown in the above figure, CarbonShowTablesCommand obtains metadata from metastore for each table. Currently, when there are 180,000 tables, it takes a long time (about 1 hours) to run the show tables command in spark-sql shell, which needs to be optimized.
When the filter function is not invoked, it takes about 12 seconds to obtain 180,000 tables by running the show tables command.As shown in the following figure.

[kevinjmh]

Maybe we can try to get tables' info in one batch instead of one by one

  def getTable(db: String, table: String): CatalogTable

  def getTablesByName(db: String, tables: Seq[String]): Seq[CatalogTable]

[wxp0329]

Maybe we can try to get tables' info in one batch instead of one by one

  def getTable(db: String, table: String): CatalogTable

  def getTablesByName(db: String, tables: Seq[String]): Seq[CatalogTable]

hi, when and which version can solve the problem?