Re: Translate join predicates into filters

2023-05-17 Thread Dan Zou
Hi Luca, If I understand you correctly, what you are looking for is temporal table join. Flink has implemented this based on Calcite, maybe is a good reference. You could find more details in [1], [2], [3]. - [1] https://issues.apache.org/jira/browse/CALCITE-1912 - [2]

Translate join predicates into filters

2023-05-17 Thread Luca Marchi
Morning everyone, in our company we are running a POC using Apache Calcite, and we would like to collect some feedbacks from you for the scenario mentioned below. There is a service API that allows retrieving some `Book`s, and we would like to build a table adapter on top of this service; this

LITERAL_AGG

2023-05-17 Thread Julian Hyde
Can someone please review https://github.com/apache/calcite/pull/3209. It has fixes for https://issues.apache.org/jira/browse/CALCITE-4334 (LITERAL_AGG) and https://issues.apache.org/jira/browse/CALCITE-5697 (RelBuilder.convert). I would especially like feedback on the strategy of avoiding a

[jira] [Created] (CALCITE-5707) Add ARRAY_CONTAINS for Spark dialect

2023-05-17 Thread jackylau (Jira)
jackylau created CALCITE-5707: - Summary: Add ARRAY_CONTAINS for Spark dialect Key: CALCITE-5707 URL: https://issues.apache.org/jira/browse/CALCITE-5707 Project: Calcite Issue Type: Improvement