Re: Does someone interested in integration calcite + PostgreSQL wire protocol ?

2022-09-28 Thread Dmitry Sysolyatin
Hello! I had a long discussion with our company management where I tried to convince them to publish those code as open source. But unfortunately the answer was negative. Sorry On Mon, Sep 12, 2022 at 8:22 AM André kouamé wrote: > +1 > > Le lun. 12 sept. 2022 à 00:36, Justin Swanhart a > écri

Re: Conversion from Bindable to Enumerable

2022-09-28 Thread Pranav Deshpande
Thank you very much Thomas & Stamatis. Thomas, I will try what you said. Stamatis, I looked at the rule and the test case. And yes, it is exactly what I wanted to try! Thank you very much. I am facing one issue though. I have a test case where I have all the enumerable rules. It is working. When

Retrieve data from JSON file instead of database

2022-09-28 Thread Kartik Kudada
Hi Calcite Dev, I have the below requirements. 1. Get the result set from the Database 2. convert to JSON, do some modifications to JSON 3. Again convert to ResultSet from JSON, and send it back to the user as a resultset I am not getting how to achieve this using calcite-core as JAR to used in

Testing function definitions for the Babel SQL parser

2022-09-28 Thread James Scicluna
Dear Apache Calcite Team, I’m planning to add several function definitions for Spark and Hive in SqlLibraryOperators for the Babel SQL parser to use. To test these, would it be enough to just add unit tests in BabelTest (as opposed to SqlOperatorTest) using checkSqlResult? Thanks, James

Re: Testing function definitions for the Babel SQL parser

2022-09-28 Thread Julian Hyde
Do the functions have non-standard syntax? If so then will probably have to be in Babel. If not they could go into Core (and SqlLibraryOperators). Please log a jira case for your work. They will need to be specified at some point, the earlier the better. The SqlOperatorTests format is a bit bette

[jira] [Created] (CALCITE-5301) Support AT TIME ZONE

2022-09-28 Thread Rong Rong (Jira)
Rong Rong created CALCITE-5301: -- Summary: Support AT TIME ZONE Key: CALCITE-5301 URL: https://issues.apache.org/jira/browse/CALCITE-5301 Project: Calcite Issue Type: New Feature Compon

Re: Retrieve data from JSON file instead of database

2022-09-28 Thread Julian Hyde
I have thought about building a similar capability. The question is, how to package it? Maybe a ‘Replay Adapter’ that looks like a Schema, sits on top of another Schema (which is almost certainly backed by a JDBC adapter). The Replay Adapter has a key-value store of some kind, where the key is