Re: Calcite tables which support multiple data retrieval patterns

2023-12-11 Thread Julian Hyde
PS Austin, You and the people on the cc: list should subscribe to dev@calcite. It will allow you to post without moderation (which often adds a delay of several hours) and will allow you to receive replies. > On Dec 11, 2023, at 12:05 PM, Julian Hyde wrote: > > Thanks for starting this

Re: Calcite tables which support multiple data retrieval patterns

2023-12-11 Thread Julian Hyde
Thanks for starting this conversation. I believe we should be looking for common patterns and devising ways to solve them using relational algebra. (Because that’s the hammer that we have in Calcite… and it’s a very powerful hammer. For example, we can represent all kinds of materialized

Calcite tables which support multiple data retrieval patterns

2023-12-11 Thread Austin Richardson
Hello, My team is working on a feature to add a general “base table” for a collection of Calcite tables in our service. Something we’ve come across is that different tables will have different supported data retrieval patterns, which we’ve been referring to as “indices”. For example, assume we