[jira] [Created] (CALCITE-6352) The map_contains_key function may return true when the key and mapkeytype types are different.

Caican Cai created CALCITE-6352: --- Summary: The map_contains_key function may return true when the key and mapkeytype types are different. Key: CALCITE-6352 URL: https://issues.apache.org/jira/browse/CALCITE-6352

Re: [VOTE] Release Apache Calcite Avatica 1.25.0 (release candidate 0)

+1 (non-binding) after verifying as follows: - verified gpg signature: OK $ curl "https://downloads.apache.org/calcite/KEYS; | gpg --import $ gpg --verify apache-calcite-avatica-1.25.0-src.tar.gz.asc apache-calcite-avatica-1.25.0-src.tar.gz - verified package checksum: OK $ diff <(cat

[jira] [Created] (CALCITE-6351) Update LICENSE and NOTICE for Jekyll website template

Francis Chuang created CALCITE-6351: --- Summary: Update LICENSE and NOTICE for Jekyll website template Key: CALCITE-6351 URL: https://issues.apache.org/jira/browse/CALCITE-6351 Project: Calcite

[jira] [Created] (CALCITE-6350) Unexpected result from UNION with literals expression

Evgeny Stanilovsky created CALCITE-6350: --- Summary: Unexpected result from UNION with literals expression Key: CALCITE-6350 URL: https://issues.apache.org/jira/browse/CALCITE-6350 Project:

Re: Draft: board report for 2024 Q1

+1, thanks Benchao! On Thu, 4 Apr 2024 at 09:26, Stamatis Zampetakis wrote: > +1, nothing to add! > > On Wed, Apr 3, 2024 at 11:11 PM Francis Chuang > wrote: > > > > +1, Great work, Benchao! > > > > On 4/04/2024 5:39 am, Ruben Q L wrote: > > > +1 > > > > > > Thanks Benchao for preparing the

Re: Draft: board report for 2024 Q1

+1, nothing to add! On Wed, Apr 3, 2024 at 11:11 PM Francis Chuang wrote: > > +1, Great work, Benchao! > > On 4/04/2024 5:39 am, Ruben Q L wrote: > > +1 > > > > Thanks Benchao for preparing the report! > > > > > > On Wed, Apr 3, 2024 at 7:34 PM Michael Mior wrote: > > > >> +1 Thanks Benchao! >

Re: [VOTE] Release Apache Calcite Avatica 1.25.0 (release candidate 0)

Ubuntu 20.04.6 LTS, jdk1.8.0_261, Gradle wrapper, Gradle 8.1.1 * Checked signatures and checksums OK * Checked diff between repo and artifacts OK * Went over release note OK (It mentions two Gradle versions 8.4 and 8.5) * Checked README, NOTICE, LICENSE OK (minor fixes in LICENSE from Calcite

Re: [Follow up] Calcite Setup Issues

Hi Anurag, As Mihai said in your previous thread, this is the right list for discussing the issues you are encountering. Please subscribe to the list, so that your emails won't go into the moderation queue and to ensure that you're receiving the replies. I am sending a copy of this message

[Follow up] Calcite Setup Issues

I write this to follow up on a previously sent email regarding the issues I am facing while trying to build calcite. I need it for a research project that I am going to be working on. I would like it if you could guide me to the appropriate communication channels to allow me to interact with the

Re: [VOTE] Release Apache Calcite Avatica 1.25.0 (release candidate 0)

Opps, good catch! Please ignore the links to the calcite-avatica-site-preview repo. Those are generated by the asf-release plugin, but we don't use any preview repos for Calcite. On 3/04/2024 9:41 pm, Benchao Li wrote: +1 (binding) - checked signature and checksum [OK] - checked copyright

Re: Draft: board report for 2024 Q1

+1, Great work, Benchao! On 4/04/2024 5:39 am, Ruben Q L wrote: +1 Thanks Benchao for preparing the report! On Wed, Apr 3, 2024 at 7:34 PM Michael Mior wrote: +1 Thanks Benchao! -- Michael Mior mm...@apache.org On Wed, Apr 3, 2024 at 6:11 AM Benchao Li wrote: Hello, Below you can

Re: Draft: board report for 2024 Q1

+1 Thanks Benchao for preparing the report! On Wed, Apr 3, 2024 at 7:34 PM Michael Mior wrote: > +1 Thanks Benchao! > > -- > Michael Mior > mm...@apache.org > > > On Wed, Apr 3, 2024 at 6:11 AM Benchao Li wrote: > > > Hello, > > > > Below you can find a draft of this quarter's board report.

Re: Draft: board report for 2024 Q1

+1 Thanks Benchao! -- Michael Mior mm...@apache.org On Wed, Apr 3, 2024 at 6:11 AM Benchao Li wrote: > Hello, > > Below you can find a draft of this quarter's board report. I plan to > submit the final version next Tuesday (Apr 9, 2024). > > Please let me know if you have any additions or

Re: Draft: board report for 2024 Q1

+1 Thank you. Great idea to mention the new ASF members. Julian > On Apr 3, 2024, at 3:11 AM, Benchao Li wrote: > > Hello, > > Below you can find a draft of this quarter's board report. I plan to > submit the final version next Tuesday (Apr 9, 2024). > > Please let me know if you have any

Community over Code EU 2024: Start planning your trip!

[Note: You're receiving this email because you are subscribed to one or more project dev@ mailing lists at the Apache Software Foundation.] Dear community, We hope you are doing great, are you ready for Community Over Code EU? Check out the featured sessions, get your tickets with special

Participate in the ASF 25th Anniversary Campaign

Hi everyone, As part of The ASF’s 25th anniversary campaign[1], we will be celebrating projects and communities in multiple ways. We invite all projects and contributors to participate in the following ways: * Individuals - submit your first contribution:

Re: [VOTE] Release Apache Calcite Avatica 1.25.0 (release candidate 0)

+1 (binding) - checked signature and checksum [OK] - checked copyright year in notice [OK] - downloaded src, make sure no unexpected files [OK] - compiled and tested from source [OK] - reviewed release note [OK] - checked a few files in Nexus for signature and checksum [OK] - downloaded javadoc

Draft: board report for 2024 Q1

Hello, Below you can find a draft of this quarter's board report. I plan to submit the final version next Tuesday (Apr 9, 2024). Please let me know if you have any additions or corrections. -- Best, Benchao Li ## Description: Apache Calcite is a highly customizable framework for parsing and

Apache Calcite stream query is not producing any output.

Hi, I am a university student in South Korea. I am currently working on a project to improve the performance of Kafka streaming SQL using the Kafka adapter in Apache Calcite. However, even though I followed the example on the official website, no data is being displayed in sqlline. Here is the

[VOTE] Release Apache Calcite Avatica 1.25.0 (release candidate 0)

Hi all, I have created a build for Apache Calcite Avatica 1.25.0, release candidate 0. Thanks to everyone who has contributed to this release. You can read the release notes here: https://github.com/apache/calcite-avatica/blob/avatica-1.25.0-rc0/site/_docs/history.md The commit to be voted

Avatica - Main branch closed for 1.25.0 release

Hey everyone, Just wanted to drop a quick note that I am closing Avatica's main branch to prepare 1.25.0-rc0 for voting. Francis

Re: Pull Request Reviews for Avatica

Great work! Thanks, Mihai. I will have Avatica 1.25.0 rc0 available for voting soon. On 2/04/2024 4:04 am, Mihai Budiu wrote: I have merged 6282 and 6248 in Avatica. Mihai From: Francis Chuang Sent: Monday, March 18, 2024 4:09 AM To: dev@calcite.apache.org

[jira] [Created] (CALCITE-6349) CoreRules.PROJECT_REDUCE_EXPRESSIONS crashes on expression with ARRAY_REPEAT

Mihai Budiu created CALCITE-6349: Summary: CoreRules.PROJECT_REDUCE_EXPRESSIONS crashes on expression with ARRAY_REPEAT Key: CALCITE-6349 URL: https://issues.apache.org/jira/browse/CALCITE-6349

[jira] [Created] (CALCITE-6348) ARRAY_OVERLAP with a NULL argument crashes the compiler

Mihai Budiu created CALCITE-6348: Summary: ARRAY_OVERLAP with a NULL argument crashes the compiler Key: CALCITE-6348 URL: https://issues.apache.org/jira/browse/CALCITE-6348 Project: Calcite

[jira] [Created] (CALCITE-6347) ARRAY_REPEAT with a string argument causes a compiler crash

Mihai Budiu created CALCITE-6347: Summary: ARRAY_REPEAT with a string argument causes a compiler crash Key: CALCITE-6347 URL: https://issues.apache.org/jira/browse/CALCITE-6347 Project: Calcite

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

See

Re: Pull Request Reviews for Avatica

I have merged 6282 and 6248 in Avatica. Mihai From: Francis Chuang Sent: Monday, March 18, 2024 4:09 AM To: dev@calcite.apache.org Subject: Re: Pull Request Reviews for Avatica Going through the open PRs again (thanks to community members who reviewed and

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

See Changes: [mbudiu] [CALCITE-6248] Illegal dates are accepted by casts -- [...truncated 300.77 KB...]

[jira] [Created] (CALCITE-6346) JdbcAdapter: Cast for dynamic filter arguments is lost

Corvin Kuebler created CALCITE-6346: --- Summary: JdbcAdapter: Cast for dynamic filter arguments is lost Key: CALCITE-6346 URL: https://issues.apache.org/jira/browse/CALCITE-6346 Project: Calcite

Re: Calcite Setup Issues

This mailing list is the appropriate channel. Mihai From: Anurag Naik Sent: Saturday, March 30, 2024 3:44:20 AM To: dev@calcite.apache.org Subject: Calcite Setup Issues Greetings, Calcite dev team! I am Anurag Naik, a college student from India on my way to

Calcite Setup Issues

Greetings, Calcite dev team! I am Anurag Naik, a college student from India on my way to start a research internship. During the course of my research internship I will be using Apache Calcite to connect to a postgresql database. It has been almost a week that I have been trying to set up

[jira] [Created] (CALCITE-6345) Intervals with more than 100 years are not supported

Mihai Budiu created CALCITE-6345: Summary: Intervals with more than 100 years are not supported Key: CALCITE-6345 URL: https://issues.apache.org/jira/browse/CALCITE-6345 Project: Calcite

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

See Changes: [mbudiu] [CALCITE-6282] Avatica ignores time precision when returning TIME results -- [...truncated 106.49 KB...] > Task :babel:classes >

Re: Question about exposing tables and columns

Also here is the client-side code: String sql = "select * from ddw_fact_realtime_metric"; Connection connection = null; Statement statement = null; try { connection = DriverManager.getConnection("jdbc:avatica:remote:url=http://localhost:9787;serialization=PROTOBUF;); statement =

Re: Question about exposing tables and columns

Hey Dilip, I don't think your attachment made it through, due to moderation. Can you try uploading it as a gist on GitHub? Francis On 29/03/2024 7:50 am, Dilip Patel wrote: Hi We have a data warehouse, and I want to expose only selected tables from the DW and create a virtual database. I

Question about exposing tables and columns

Hi We have a data warehouse, and I want to expose only selected tables from the DW and create a virtual database. I aim to allow the consumer to query these tables via the JDBC driver. I came across the Calcite and Avatica libraries and they seem to be capable of doing this. I was able to

Re: Towards Avatica 1.25.0

I think the tests for Avatica pull from Calcite master to run, so until CALCITE-6282 and CALCITE-6322 are merged in the Calcite repo, the Avatica tests will fail. On 28/03/2024 12:27 am, Mihai Budiu wrote: I have tried to test these two calcite prs with both versions of avatica 1.23 and 1.25

[jira] [Created] (CALCITE-6344) RelToSqlConverter invalid quotation for arrays and item operator(ansi dialect)

Anton Kovalevsky created CALCITE-6344: - Summary: RelToSqlConverter invalid quotation for arrays and item operator(ansi dialect) Key: CALCITE-6344 URL: https://issues.apache.org/jira/browse/CALCITE-6344

Re: Towards Avatica 1.25.0

I have tried to test these two calcite prs with both versions of avatica 1.23 and 1.25 From: Istvan Toth Sent: Wednesday, March 27, 2024 6:21:59 AM To: dev@calcite.apache.org Subject: Re: Towards Avatica 1.25.0 Which is strange, because AFAIK one of the Avatica

Re: Towards Avatica 1.25.0

Which is strange, because AFAIK one of the Avatica tests run by CI is supposed to run the Calcite test suite with that Avatica build. On Wed, Mar 27, 2024 at 12:17 PM Istvan Toth wrote: > Based on my test run above, Calcite tests already fail with Avatica HEAD. > We should figure that out

Re: Towards Avatica 1.25.0

Based on my test run above, Calcite tests already fail with Avatica HEAD. We should figure that out before adding new changes. On Wed, Mar 27, 2024 at 2:35 AM Mihai Budiu wrote: > Ok, I have pushed two Calcite PRs that temporarily disable tests, once > these are accepted and merged I hope the

Community Over Code NA 2024 Travel Assistance Applications now open!

Hello to all users, contributors and Committers! [ You are receiving this email as a subscriber to one or more ASF project dev or user mailing lists and is not being sent to you directly. It is important that we reach all of our users and contributors/committers so that they may get a chance

Re: Towards Avatica 1.25.0

Ok, I have pushed two Calcite PRs that temporarily disable tests, once these are accepted and merged I hope the Avatica PRs will also pass all tests. https://github.com/apache/calcite/pull/3708 https://github.com/apache/calcite/pull/3740 Mihai From: Francis

[jira] [Created] (CALCITE-6343) AS alias operator strips MEASUREness from measures

Barry Kelly created CALCITE-6343: Summary: AS alias operator strips MEASUREness from measures Key: CALCITE-6343 URL: https://issues.apache.org/jira/browse/CALCITE-6343 Project: Calcite Issue

[jira] [Created] (CALCITE-6342) Use highest input precision for datetime with/without local time zone

Dawid Wysakowicz created CALCITE-6342: - Summary: Use highest input precision for datetime with/without local time zone Key: CALCITE-6342 URL: https://issues.apache.org/jira/browse/CALCITE-6342

[jira] [Created] (CALCITE-6341) DynamicRecordType join query will generate uncompailable code

Yonatan Graber created CALCITE-6341: --- Summary: DynamicRecordType join query will generate uncompailable code Key: CALCITE-6341 URL: https://issues.apache.org/jira/browse/CALCITE-6341 Project:

Re: Towards Avatica 1.25.0

+1 I think this is a good plan On 26/03/2024 3:25 pm, Mihai Budiu wrote: Regarding https://issues.apache.org/jira/projects/CALCITE/issues/CALCITE-6282 Avatica ignores time precision when returning TIME results I have PR https://github.com/apache/calcite-avatica/pull/241 in Avatica, and a

Re: Towards Avatica 1.25.0

Regarding https://issues.apache.org/jira/projects/CALCITE/issues/CALCITE-6282 Avatica ignores time precision when returning TIME results I have PR https://github.com/apache/calcite-avatica/pull/241 in Avatica, and a corresponding PR in Calcite https://github.com/apache/calcite/pull/3740 which

Re: Towards Avatica 1.25.0

On Avatica's side, we definitely want the tests to pass, otherwise it will be hard to give the release a +1 during the voting process if there are test failures. On 26/03/2024 11:31 am, Mihai Budiu wrote: Great. I will use this to test the changes on calcite's side. What needs to happen to

Re: Towards Avatica 1.25.0

Great. I will use this to test the changes on calcite's side. What needs to happen to merge two prs in avatica? Do we need the avatica CI to pass our can we temporarily ignore the failures? If we need the CI to pass it looks like first we have to merge in calcite main changes which temporarily

[jira] [Created] (CALCITE-6340) RelBuilder always creates Project with Convention.NONE during aggregate_

Adam Kennedy created CALCITE-6340: - Summary: RelBuilder always creates Project with Convention.NONE during aggregate_ Key: CALCITE-6340 URL: https://issues.apache.org/jira/browse/CALCITE-6340

Re: Towards Avatica 1.25.0

I could not repro the compilation issue: My workflow is: In Avatica: git checkout main ./gradlew publishToMavenLocal In Calcite: git checkout main ./gradlew clean build -Pcalcite.avatica.version=1.25.0-SNAPSHOT -PenableMavenLocal The Calcite test suite does fail, but everything compiles.

Re: Towards Avatica 1.25.0

I have already approved https://github.com/apache/calcite-avatica/pull/234 If Sergey is not available, any committer (including me) can merge it. Istvan On Mon, Mar 25, 2024 at 7:10 AM Mihai Budiu wrote: > I have authored the first two PRs in this list, they are certainly ready > on the

Type inference for array item

Hello, It seems that the array item operator (a[x]) always returns a nullable result, irrespective of the nullability of the elements of the array, or of the index. Is this a bug, or is this by design? It looks like the standard array item operator throws for out of bound accesses, so why not

Re: Towards Avatica 1.25.0

I have authored the first two PRs in this list, they are certainly ready on the Avatica side, and they have been approved and are ready to merge. I have made corresponding PR on the Calcite side, and I have been trying to test them with Calcite, but it's not easy. First, there is a flag in

[jira] [Created] (CALCITE-6339) Replace hashicorp/go-uuid with google/uuid

Francis Chuang created CALCITE-6339: --- Summary: Replace hashicorp/go-uuid with google/uuid Key: CALCITE-6339 URL: https://issues.apache.org/jira/browse/CALCITE-6339 Project: Calcite Issue

Towards Avatica 1.25.0

Hey everyone, I want to start the discussion for releasing Avatica 1.25.0 before we release Calcite 1.37.0. Relevant discussions are here: - Calcite 1.37.0: https://lists.apache.org/thread/k27rwmhggmsbvwmgxs9fydcw2f0hook8 - Avatica PRs:

[jira] [Created] (CALCITE-6338) RelMdCollation#project can return an incomplete list of collations

Ruben Q L created CALCITE-6338: -- Summary: RelMdCollation#project can return an incomplete list of collations Key: CALCITE-6338 URL: https://issues.apache.org/jira/browse/CALCITE-6338 Project: Calcite

[jira] [Created] (CALCITE-6337) Distinguish naked measure support between inside and outside aggregation

Barry Kelly created CALCITE-6337: Summary: Distinguish naked measure support between inside and outside aggregation Key: CALCITE-6337 URL: https://issues.apache.org/jira/browse/CALCITE-6337 Project:

Re: [DISCUSS] Towards Calcite 1.37.0

Thanks Benchao for driving the discussion. I would like to be release manager for 1.39.0 version. Besides, I could help to review some open pull requests. -- Best, Jing Zhang James Duong 于2024年3月19日周二 01:14写道： > I’ll help take a look at some of the open Avatica and Calcite PRs. > > From:

[jira] [Created] (CALCITE-6336) When inserting an insert SQL statement containing non-ANSII characters into an Oracle database, an exception occurs

gunveda created CALCITE-6336: Summary: When inserting an insert SQL statement containing non-ANSII characters into an Oracle database, an exception occurs Key: CALCITE-6336 URL:

[jira] [Created] (CALCITE-6335) Quidem tests should allow specifying optimization passes to apply to programs

Mihai Budiu created CALCITE-6335: Summary: Quidem tests should allow specifying optimization passes to apply to programs Key: CALCITE-6335 URL: https://issues.apache.org/jira/browse/CALCITE-6335

Re: Using quidem tests to validate optimization rules

You are correct. There is no mechanism, and one would be really useful. > On Mar 18, 2024, at 1:19 PM, Mihai Budiu wrote: > > Hello, > > I was looking around to see whether it's possible to use a quidem test to > exercise specific optimization rules, but I couldn't find anything. Is there >

Using quidem tests to validate optimization rules

Hello, I was looking around to see whether it's possible to use a quidem test to exercise specific optimization rules, but I couldn't find anything. Is there such a mechanism, or should I file an issue to create one? Thank you, Mihai

Re: [DISCUSS] Towards Calcite 1.37.0

I’ll help take a look at some of the open Avatica and Calcite PRs. From: Mihai Budiu Date: Monday, March 18, 2024 at 9:48 AM To: dev@calcite.apache.org Subject: Re: [DISCUSS] Towards Calcite 1.37.0 This would be great, I am fixing two very basic bugs. Was busy with some other stuff, so I didn't

Re: [DISCUSS] Towards Calcite 1.37.0

This would be great, I am fixing two very basic bugs. Was busy with some other stuff, so I didn't have time to figure out how to submit the PRs so that they pass, if anyone has more detailed instructions I would be very happy. Otherwise I will dig into it. Mihai

Re: Pull Request Reviews for Avatica

Going through the open PRs again (thanks to community members who reviewed and merged!), I think these are definitely candidates that can be merged for the 1.25.0 release: - CALCITE-6282 - Avatica ignores time precision when returning TIME results [1] - CALCITE-6248 - Illegal dates are

[jira] [Created] (CALCITE-6334) Release Avatica 1.25.0

Francis Chuang created CALCITE-6334: --- Summary: Release Avatica 1.25.0 Key: CALCITE-6334 URL: https://issues.apache.org/jira/browse/CALCITE-6334 Project: Calcite Issue Type: Task

Re: [DISCUSS] Towards Calcite 1.37.0

Hi Francis thanks for letting know I think it would makes sense to apply this changes to Avatica and then to Calcite On Mon, Mar 18, 2024 at 8:59 AM Xiong Duan wrote: > +1 It is a good time to release a new version. > > Francis Chuang 于2024年3月18日周一 05:44写道： > > > > Hey everyone, > > > > I

Re: [DISCUSS] Towards Calcite 1.37.0

+1 It is a good time to release a new version. Francis Chuang 于2024年3月18日周一 05:44写道： > > Hey everyone, > > I just wanted to jump in regarding CALCITE-6248 [1] and CALCITE-6282 (no > corresponding PRs in the Calcite repo yet). > > The corresponding PRs in the Avatica repo are: > -

Re: [DISCUSS] Towards Calcite 1.37.0

Hey everyone, I just wanted to jump in regarding CALCITE-6248 [1] and CALCITE-6282 (no corresponding PRs in the Calcite repo yet). The corresponding PRs in the Avatica repo are: - https://github.com/apache/calcite-avatica/pull/238 - https://github.com/apache/calcite-avatica/pull/241 As the

Re: Supporting a function with different capabilities depending on database

> if the validator encounters an operator, it looks (by name) for the operator > in the currently active library to see if it is available, then tries to > resolve arguments and return values Yes, that is pretty much correct. Except that there can be several active libraries, so the validator

Re: Incorrect Quidem test in agg.iq

I started investigating but didn't get a chance to follow up. I don't know whether Calcite or Postgres is correct. I suspect the difference is due to the expression 'comm is null'. Because I don't know whether GROUPING_ID's behavior is defined if its arguments are not all columns. But I think the

[jira] [Created] (CALCITE-6333) Queries with distinct aggregations with filter throw NPE when planned using joins

Abhishek Agarwal created CALCITE-6333: - Summary: Queries with distinct aggregations with filter throw NPE when planned using joins Key: CALCITE-6333 URL: https://issues.apache.org/jira/browse/CALCITE-6333

[jira] [Created] (CALCITE-6332) Optimization CoreRules.AGGREGATE_EXPAND_DISTINCT_AGGREGATES_TO_JOIN produces incorrect results for aggregates with groupSets

Mihai Budiu created CALCITE-6332: Summary: Optimization CoreRules.AGGREGATE_EXPAND_DISTINCT_AGGREGATES_TO_JOIN produces incorrect results for aggregates with groupSets Key: CALCITE-6332 URL:

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

See Changes: [Tanner Clary] [CALCITE-6314] Add RANDOM function (enabled in Postgres library) -- [...truncated 9.07 KB...] > Task

Re: @Deprecated annotation

it's helpful, thanks benchao. On Wed, Mar 13, 2024 at 7:10 PM Benchao Li wrote: > There were multiple discussions about this in the past, searching in > the mailing list, the latest one is[1]. > > [1] https://lists.apache.org/thread/x00z7z2bd44gotn3vtvf626jm66jvdl6 > > Hongyu Guo 于2024年3月13日周三

Re: How to better support the adaptation of the same functions in different dialects

Trying to unify the behavior of different engines is always a painful task. For example, if there is a function named `abc`, engine1 and engine2 implement it both, but they require different parameters and result in different output, I think we must create two instances in SqlLibraryOperators with

[jira] [Created] (CALCITE-6331) The third-party source code file doesn't have a License file.

Calvin Kirs created CALCITE-6331: Summary: The third-party source code file doesn't have a License file. Key: CALCITE-6331 URL: https://issues.apache.org/jira/browse/CALCITE-6331 Project: Calcite

Re: How to better support the adaptation of the same functions in different dialects

I've asked a lot of questions recently, and I hope I won't cause too much trouble to the community. On 2024/03/14 10:32:09 Cancai Cai wrote: > Hello, everyone in the calcite community. > > Recently, I have been adapting the behavior of functions in different > dialects to the calcite community.

Re: [ANNOUNCE] Sergey Nuyanzin joins Calcite PMC

Hi everybody, Thank you very much! On Wed, Mar 6, 2024 at 4:13 PM Jacky Lau wrote: > Congratulations, Sergey! > Jacky Lau > > Stamatis Zampetakis 于2024年3月6日 周三17:09写道： > > > Congratulations Sergey, very well deserved! > > > > On Wed, Mar 6, 2024 at 3:33 AM Hongyu Guo > wrote: > > > > > >

How to better support the adaptation of the same functions in different dialects

Hello, everyone in the calcite community. Recently, I have been adapting the behavior of functions in different dialects to the calcite community. At first, I used the method in CALCITE-5831 [1], but later I discovered that this The method is

[jira] [Created] (CALCITE-6330) Print the average row size when when explaining an operator

mengdou created CALCITE-6330: Summary: Print the average row size when when explaining an operator Key: CALCITE-6330 URL: https://issues.apache.org/jira/browse/CALCITE-6330 Project: Calcite

[jira] [Created] (CALCITE-6329) Use weighted-average calculation for the columns in Union operator

mengdou created CALCITE-6329: Summary: Use weighted-average calculation for the columns in Union operator Key: CALCITE-6329 URL: https://issues.apache.org/jira/browse/CALCITE-6329 Project: Calcite

[jira] [Created] (CALCITE-6328) The BigQuery functions SAFE_* do not match the BigQuery specification

Mihai Budiu created CALCITE-6328: Summary: The BigQuery functions SAFE_* do not match the BigQuery specification Key: CALCITE-6328 URL: https://issues.apache.org/jira/browse/CALCITE-6328 Project:

[jira] [Created] (CALCITE-6327) getValidatedNodeTypeIfKnown should never throw

Claude Brisson created CALCITE-6327: --- Summary: getValidatedNodeTypeIfKnown should never throw Key: CALCITE-6327 URL: https://issues.apache.org/jira/browse/CALCITE-6327 Project: Calcite

Re: @Deprecated annotation

There were multiple discussions about this in the past, searching in the mailing list, the latest one is[1]. [1] https://lists.apache.org/thread/x00z7z2bd44gotn3vtvf626jm66jvdl6 Hongyu Guo 于2024年3月13日周三 11:43写道： > > Hi devs, > > I found there are over 800 @Deprecated in the project, and most of

Re: [DISCUSS] Towards Calcite 1.37.0

Thank you, Hongyu, for volunteering to be a release manager. What's worth to mention is that to be a release manager does not require PMC membership nor being a committer, and it is a good chance to be involved in community activities apart from code/discussion, which would be a good additional

Re: [Question] Regarding the loading conflict between SqlStdOperatorTable and SqlLibraryOperators

Hello, I conducted debugging, and the result is as you said. I may need some time to think about how to modify this part of the code. Thank you very much for your suggestion. Best regards， Cancai Cai Benchao Li 于2024年3月11日周一 21:09写道： > I didn't go deep into CALCITE-6259, so I might not able to

@Deprecated annotation

Hi devs, I found there are over 800 @Deprecated in the project, and most of them have the comment 'to be removed before 2.0'. So do we have a schedule or plan to remove them? You can use GREP to quickly check deprecated annotations. ``` > grep -roh "@Deprecated" . | wc -l 802 > grep -roh

Re: [DISCUSS] Towards Calcite 1.37.0

I would like to take on the role of RM for one release On Thu, Mar 7, 2024 at 2:58 AM Alessandro Solimando < alessandro.solima...@gmail.com> wrote: > Hey Sergey, > thanks for being the release manager for 1.37.0. > > I have added fixVersion=1.37.0 to CALCITE-2040 >

[jira] [Created] (CALCITE-6326) Add LOG10 and LN function (enabled in Mysql, Spark library)

Caican Cai created CALCITE-6326: --- Summary: Add LOG10 and LN function (enabled in Mysql, Spark library) Key: CALCITE-6326 URL: https://issues.apache.org/jira/browse/CALCITE-6326 Project: Calcite

[jira] [Created] (CALCITE-6325) Add LOG function (enabled in Mysql, Spark library)

Caican Cai created CALCITE-6325: --- Summary: Add LOG function (enabled in Mysql, Spark library) Key: CALCITE-6325 URL: https://issues.apache.org/jira/browse/CALCITE-6325 Project: Calcite Issue

[jira] [Created] (CALCITE-6324) Type inferred for result of STDDEV, VAR_SAMP, etc. is incorrect

Mihai Budiu created CALCITE-6324: Summary: Type inferred for result of STDDEV, VAR_SAMP, etc. is incorrect Key: CALCITE-6324 URL: https://issues.apache.org/jira/browse/CALCITE-6324 Project: Calcite

Incorrect Quidem test in agg.iq

I have been staring at a particular Quidem test from agg.iq: https://github.com/apache/calcite/blame/b412fa4ac0b1340a9f4e50c1d7ae4c869dcd1d2f/core/src/test/resources/sql/agg.iq#L1304 select sum(sal) as s, grouping_id(job, deptno, comm is null) as g, group_id() as i from "scott".emp group by

Re: Supporting a function with different capabilities depending on database

I’m referring to using the “fun” connection property and setting it to ‘postgresql’, which enables PostgreSQL built-in functions and operators. I believe this is referred to as a “library” as well. I saw this SOUNDEX PR and think it covers what I’m looking for:

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

See Changes: [Sergey Nuyanzin] [CALCITE-6138] Parser does not accept TIMESTAMP WITH TIME ZONE as a data type -- [...truncated 122.11 KB...] public

[jira] [Created] (CALCITE-6323) Serialize return type during RelJson.toJson(RexNode node) for SqlKind.SAFE_CAST

Tanner Clary created CALCITE-6323: - Summary: Serialize return type during RelJson.toJson(RexNode node) for SqlKind.SAFE_CAST Key: CALCITE-6323 URL: https://issues.apache.org/jira/browse/CALCITE-6323

[jira] [Created] (CALCITE-6322) Casts to DECIMAL types are ignored

Mihai Budiu created CALCITE-6322: Summary: Casts to DECIMAL types are ignored Key: CALCITE-6322 URL: https://issues.apache.org/jira/browse/CALCITE-6322 Project: Calcite Issue Type: Bug

Re: Supporting a function with different capabilities depending on database

"...different capabilities depending on database” What exactly do you mean by “database”? If I create a Calcite model that has one schema backed by a Postgres JDBC catalog and another schema backed by a MySQL JDBC catalog, what “database” would you expect a connection to this model to have?

<    1   2   3   4   5   6   7   8   9   10   >