Re: Projection for SELECT COUNT(*)

As Stamatis said, we don’t have a consistent policy on zero-length records. But in that thread I logged https://issues.apache.org/jira/browse/CALCITE-4597 to clarify the situation. It would be great if someone worked on it. I see Viliam’s

Re: [DISCUSS] Refactoring tests

I haven’t heard from anyone. I plan to merge https://issues.apache.org/jira/browse/CALCITE-4986 "Make HepProgram thread-safe” in the next hour or two, then I will squash/rebase/merge https://issues.apache.org/jira/browse/CALCITE-4885

Re: Apache Calcite - How to create proper nested json object using JSON_OBJECT (it produces json with escapes)

Hi Stamatis: Here is the JIRA ticket - https://issues.apache.org/jira/browse/CALCITE-4989 Thanks again for your advice. On Tuesday, January 18, 2022, 12:25:28 PM EST, M Singh wrote: Hi Stamatis: Thanks for your quick response. I do have a question regarding the tests you have posted -

[jira] [Created] (CALCITE-4989) Nested JSON_OBJECT creation does not produce proper json

Mans Singh created CALCITE-4989: --- Summary: Nested JSON_OBJECT creation does not produce proper json Key: CALCITE-4989 URL: https://issues.apache.org/jira/browse/CALCITE-4989 Project: Calcite

[Question] What does the prefixes mean in calcite RexLocalRef

Recently, I'm reading the source code of calcite, and find it hard to understand what the prefix '$t' means in RexLocalRef. private static final List NAMES = new SelfPopulatingList("$t", 30); This is a bit puzzling. Could anyone provide some explanation?

Re: [DISCUSS] RepeatUnion improvements

Hi Ruben, We use RepeateUnion in our downstream project to process tree structures. And for us, it works like charm. I looked through the proposed changes and I find them reasonable. RelBuilder API is the same, so, most client code should still work. Thanks for your contribution! Regards, Igor

Re: Apache Calcite - How to create proper nested json object using JSON_OBJECT (it produces json with escapes)

Hi Stamatis: Thanks for your quick response. I do have a question regarding the tests you have posted - especially the last one (Add tests for JSON_OBJECT in functions.iq · zabetak/calcite@988c13c) - it shows the response as  {dept={address={number=128, street=Avenue New York, po=92000},

Re: Apache Calcite - Usage of Querable table/Querable/RawQueryable/etc interfaces

Thanks Gavin for your pointers.  I am in the waiting list for the search tool you mentioned.  I will continue to search on google in the meanwhile.  Mans On Tuesday, January 18, 2022, 08:44:31 AM EST, Gavin Ray wrote: Not to be dismissive, but one thing I've done that has been

Jenkins build is back to normal : Calcite » Calcite-snapshots #51

See

Re: Basic query execution question: RelRunner fails due to SchemaPlusImpl#snapshot throwing "UnsupportedOperation"

The same code works in Java/Scala so there must be a quirk or small deviation in my Kotlin code. I'll chalk this one up to user error. Here's the working Java implementation: public class CalciteSchemaManager { public

Re: Apache Calcite - Usage of Querable table/Querable/RawQueryable/etc interfaces

Not to be dismissive, but one thing I've done that has been helpful for me, is to search all public repos for usage/examples of the thing I am trying to understand. For example, this "RawQueryable" does not appear to be utilized in any user-facing code on Github, so it may not be useful for you:

[REVIEW REQUEST]: Review Request for CALCITE-4987

Hi community, I'd like to request a review on CALCITE-4987( https://github.com/apache/calcite/pull/2693), which also fixes CALCITE-2552. After this fix, the RelToSqlConverter will generate ORDER BY clause by dialect's conformance, and prefer ORDER BY ordinal rather alias when both is supported.

Re: Apache Calcite - Usage of Querable table/Querable/RawQueryable/etc interfaces

Hey Folks: Just wanted to see if you have any pointers to help me understand the queryable concepts. Thanks On Friday, January 14, 2022, 09:09:06 AM EST, M Singh wrote: Hi Folks: A few newbie questions -  1. I wanted to find out what are the benefits of a queryable table

Re: Apache Calcite - How to create proper nested json object using JSON_OBJECT (it produces json with escapes)

Hello, JSON_OBJECT is indeed the appropriate function for this use-case. I did a few tests [1] and it seems that escaped quotes are introduced when nesting the calls so most likely it is a bug. Please log a JIRA for this. Best, Stamatis [1]

Build failed in Jenkins: Calcite » Calcite-snapshots #50

See Changes: [yuzhao.cyz] [CALCITE-4967] Support SQL hints for temporal table join -- [...truncated 459.83 KB...] > Task :redis:test Gradle Test Executor

Re: [DISCUSS] RepeatUnion improvements

Thanks for the feedback Julian. I will take a look at the Morel issue. On Mon, Jan 17, 2022 at 11:12 PM Julian Hyde wrote: > Thanks for the heads up. There was a good reason that we marked > RepeatUnion experimental: so that we can make these improvements without > anyone complaining. I welcome