Re: Optimize object lookup in REST catalog

2024-12-17 Thread Vladimir Ozerov
Hi Piotr, Yufei, Thanks for the feedback. In addition to a single object lookup and namespace listing, is there anything else that can potentially help query engines reduce latency during semantic analysis? As an example, maybe a bulk object lookup? Like, you have 10 objects in a query. Usually,

Re: Optimize object lookup in REST catalog

2024-12-17 Thread Yufei Gu
Seems a nice optimization. I also echo Piotr's point about the list endpoints. Either a `relation` or a `table-like` are good to have. Looking forward to a formal proposal! Yufei On Thu, Dec 5, 2024 at 5:37 AM Piotr Findeisen wrote: > Hi > > I like the idea to just "get relation" to get the re

Re: Optimize object lookup in REST catalog

2024-12-05 Thread Piotr Findeisen
Hi I like the idea to just "get relation" to get the relation in one shot. Similar thing applies to listing relations. This is obviously less common operation, but not uncommon and also more expensive. BI tools query information_schema.tables (and other information_schema information). To complete