Hi Everyone, I think it would be useful to add a LIMIT syntax with SHOW queries. Or have some sort of ability to show a subset of tables.
It would be incredibly useful when working with catalogs that have hundreds of databases and thousands of tables. In most cases folks want a responsive UI and would prefer to click "load more" than wait a really long time. I would propose that the default behaviour remains but the additional syntax is passed as a new set of overloaded methods in the Catalog. I'd like to push this limit to the Catalog so the Catalog can decide if it should filter before or after "loading" all of the objects. What do folks think? I think this will likely require a FLIP since it is quite a large change to the SQL Gateway and Catalog. (Similarly, I think it would be useful to offer the ability to push the LIKE predicate down to the Catalog. Therefore the developer can optimize the code if there is a predicate. Currently we do this after the rows are returned.) Ryan van Huuksloot Staff Engineer, Infrastructure | Streaming Platform [image: Shopify] <https://www.shopify.com/?utm_medium=salessignatures&utm_source=hs_email>
