*Sriram G* *Tech*
On Wed, 24 Sept 2025, 09:55 Ryan van Huuksloot, <[email protected]> wrote: > 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> >
