Main Force Push

Hi Calcite Devs, Just merged a PR without squashing the extra review commit, I will be fixing this to keep the main branch clean. There are no commits on top so no hashes should be disrupted or anything like that, just wanted to offer up an explanation. Thanks and sorry for the disruption!

Re: Make the github PR commits and File changed clean

Hi all, The sudden rise in commits for each PR is due to the mistake I made yesterday when trying to merge a PR. I think I got the main branch as it should be, but the one nasty side effect was that all pre-existing pull requests had many additional commits that had already been merged. In terms

Re: PR CI Failures Question

age doesn’t look specific to > Windows or your change. Just one container gone bad. I’d force-push and see > whether I get a healthier container next run. > >> > >> Julian > >> > >> [1] > https://stackoverflow.com/questions/65645510/cannot-access-script-base

Re: PR CALCITE-5948 Review Request

Hi Ran Tao, Thank you for opening this PR, I tried to leave a couple of suggestions. Best, Tanner Clary On Thu, Aug 31, 2023 at 4:30 AM Ran Tao wrote: > Hi, devs. > > can anyone help to review this? thanks. > > > Best Regards, > Ran Tao > > > Ran Tao 于2023年

PR CI Failures Question

Hi Calcite Developers, I have a PR [1] that is failing the CI checks for Windows [2]. I am not familiar with these errors and am wondering if anyone has any suggestions on how I could fix them. Thanks so much. Best, Tanner Clary [1] https://github.com/apache/calcite/pull/3391 [2] https

Re: [ANNOUNCE] New committer: Ran Tao

Congrats Ran!! Have learned a lot from your pull requests! Best, Tanner On Fri, Oct 27, 2023 at 8:32 AM Stamatis Zampetakis wrote: > Apache Calcite's Project Management Committee (PMC) has invited Ran Tao to > become a committer, and we are pleased to announce that he has accepted. > > Ran has

Re: [ANNOUNCE] New committer: Lei Shen

Congratulations, Lei! Best, Tanner On Tue, Oct 31, 2023 at 1:52 PM Francis Chuang wrote: > Congrats, Lei! > > On 1/11/2023 4:34 am, Stamatis Zampetakis wrote: > > Apache Calcite's Project Management Committee (PMC) has invited Lei Shen > to > > become a committer, and we are pleased to

Re: Would appreciate help with first PR

Hi Paul, Thanks for opening your first PR! I took a look and I think it might have been a flaky failure, I believe that has happened to me in the past. I approved the workflow run so we will see what happens with CI, I will try to give the PR a review in the meantime :) Thanks again! Best,

Re: [ANNOUNCE] New committer: Runkang He

Congratulations, Runkang! Best, Tanner On Thu, Nov 2, 2023 at 9:11 AM Ran Tao wrote: > Congrats, Runkang! > > Best Regards, > Ran Tao > > > Benchao Li 于2023年11月2日周四 22:27写道： > > > Apache Calcite's Project Management Committee (PMC) has invited > > Runkang He to become a committer, and we are

Re: [DISCUSS] Towards Calcite 1.36.0

I can revert it if that's alright, hope this helps! Best, Tanner On Tue, Nov 7, 2023 at 6:01 PM Francis Chuang wrote: > I believe the main branch should still be frozen as we're still voting > for 1.36.0. > > I think 14ed78f22eb854fe4643c6e1faad5b0824733515 needs to be reverted > and then

Re: [DISCUSS] Towards Calcite 1.36.0

The commit reverting 3154708 is here: https://github.com/apache/calcite/commit/213c13776651f83f95dceb9645a15e940ec6dce1 Let me know if I can do anything else to help and thank y'all for handling the release! Best, Tanner On Tue, Nov 7, 2023 at 6:34 PM Tanner Clary wrote: > I can rev

Re: [DISCUSS] Towards Calcite 1.36.0

fter the voting, I'll push it to main with additional commits > preparing for next version, then all the commits after > > https://github.com/apache/calcite/commit/4c9011c388f826c36463ae7da875ddb525104376 > will be invalid. > > Tanner Clary 于2023年11月8日周三 10:43写道： > > > > T

Re: [DISCUSS] Towards Calcite 1.36.0

On Tue, Nov 7, 2023 at 6:54 PM Tanner Clary wrote: > Oops I took revert too literally. I can reset it two commits (the revert > commit and the commit I reverted). Sorry for the misunderstanding. > > Tanner > > On Tue, Nov 7, 2023 at 6:49 PM Benchao Li wrote: > >> Tann

Re: [DISCUSS] Towards Calcite 1.36.0

ed. > > On 8/11/2023 1:58 pm, Tanner Clary wrote: > > Ok I believe I reset main to > > > https://github.com/apache/calcite/commit/4c9011c388f826c36463ae7da875ddb525104376 > > . > > Feel free to take a look at > https://github.com/apache/calcite/commits/main >

Re: [ANNOUNCE] New committer: Mihai Budiu

Congrats, Mihai! You've definitely helped me along the way. Best, Tanner On Thu, Oct 26, 2023 at 7:40 AM Runkang He wrote: > Congratulations Mihai! > > Best, > Runkang He > > Zhe Hu 于2023年10月26日周四 21:40写道： > > > Congrats, Mihai ! > > > > > > Best > > ZheHu > > > > > > Replied Message

Re: PR CALCITE-6008 Review Request

Hi Jiabao, Thanks for opening this PR, I left a couple of comments. Best, Tanner On Thu, Sep 21, 2023 at 3:55 AM Jiabao Sun wrote: > Hi community, > > I have submitted a PR with CALCITE-6008 > to correct ARRAY_AGG function's return type. > > If someone has time, please help me to review the

Re: PR CALCITE-6040/CALCITE-5918 Review Request

I added some comments and questions to pull #3459, thanks for the contributions! Tanner On Thu, Oct 12, 2023 at 8:27 AM Ran Tao wrote: > Hi community, > > I have 2 issues with MAP constructor/function. > > In CALCITE-6040, I have fixed a bug of the calcite map constructor when the > map meets

Re: PR CALCITE-5889 Review Request

I left a couple of minor comments, thanks for the pull request! -Tanner On Sun, Aug 27, 2023 at 6:23 PM Runkang He wrote: > I would like to review it. Thanks for your contribution. > > LakeShen 于2023年8月27日周日 21:01写道： > > > Hi community, > > > > In CALCITE-5889,I have added a rule to rewrite

BigQuery Timestamp_Add Implementation Question

with either of these approaches or if there is another better alternative. Apologies again if this is the wrong forum. Thank you! Best, Tanner Clary

Re: [DISCUSS] Towards Calcite 1.33.0

Yes I will be putting up a PR with a fix in the next hour or so. Sorry about the hold up! Tanner On Thu, Jan 26, 2023 at 8:09 AM Julian Hyde wrote: > I agree that this is a blocker. > > Sergey’s PR illustrates the problem but isn’t a great fix. The fix should > look for “flag” literals in

Re: [DISCUSS] Towards Calcite 1.33.0

MP ‘…’, quarter). > > > On Jan 26, 2023, at 9:13 AM, Tanner Clary > wrote: > > > > Yes I will be putting up a PR with a fix in the next hour or so. Sorry > > about the hold up! > > > > Tanner > > > > On Thu, Jan 26, 2023 at 8:09 AM Julian Hyde &g

Re: [QUESTION]: Bug Fix Release

Hello, With regards to the unrelated issue with DATE_DIFF, I authored CALCITE-5469 so perhaps if you want to open a new thread or post a comment on the case itself, I would be happy to take a look. Best, Tanner On Wed, Mar 8, 2023 at 8:42 AM James Turton wrote: > Hi > > All of Drill's

Requesting PR Reviews

5585 <https://issues.apache.org/jira/browse/CALCITE-5585>] - [PR #3114 <https://github.com/apache/calcite/pull/3114>]* Thank you in advance to anyone who is able to assist! Best, Tanner Clary

Re: [ANNOUNCE] New committer: Oliver Lee

Congrats Oliver!! Very well deserved On Tue, Jun 13, 2023 at 12:29 PM Julian Hyde wrote: > Thanks for your contributions, Oliver! And welcome! > > On Tue, Jun 13, 2023 at 4:31 AM Zhe Hu wrote: > > > > Congrats Oliver! > > Replied Message > > | From | xiong duan | > > | Date |

Re: Force push to calcite main

Hello, This was my mistake, my apologies. I will update the hashes. Sorry for any inconvenience. Tanner On Thu, Jul 6, 2023 at 3:34 AM stanilovsky evgeny < estanilovs...@gridgain.com> wrote: > I already told that community need to vote for prohibit force push. > > > Hello, > > > > It appears

Re: [ANNOUNCE] New committer: Dan Zou

Congrats, Dan! It has been great working with you on some of the functions, welcome! Best, Tanner On Wed, Jul 5, 2023 at 12:12 PM Julian Hyde wrote: > Welcome, Dan! And thank you for your contributions so far. > > > On Jul 4, 2023, at 7:12 PM, Jiajun Xie > wrote: > > > > Congratulations, Dan!

Re: [ANNOUNCE] New committer: TJ Banghart

Congrats and welcome, TJ!! On Tue, Jul 4, 2023 at 8:26 AM Runkang He wrote: > Congratulations, TJ! > > Best, Runkang He > > xiong duan 于2023年7月4日周二 19:39写道： > > > Congratulations, TJ! Welcome! > > > > Jacky Lau 于2023年7月4日周二 18:56写道： > > > > > Congratulations, TJ! > > > > > > Best Jacky! > > >

Re: [ANNOUNCE] New committer: Tanner Clary

and hopefully collaborate with many of you along the way. Thanks again, Tanner Clary On Fri, May 26, 2023 at 5:12 AM Michael Mior wrote: > Congratulations and welcome Tanner! > -- > Michael Mior > mm...@apache.org > > > On Fri, May 26, 2023 at 5:05 AM Stamatis Zampetakis

Re: [ANNOUNCE] New committer: Jacky Lau

Congratulations Jacky, I've learned a lot from your PRs. Welcome! Best, Tanner On Wed, Jun 28, 2023 at 7:50 AM Benchao Li wrote: > Congratulations, Jacky! > > Bertil Chapuis 于2023年6月28日周三 20:52写道： > > > Welcome Jacky! > > > > Best, > > > > Bertil > > > > > On 28 Jun 2023, at 14:26, Dan Zou

Re: [DISCUSS] Towards Calcite 1.35.0

issue is IN PROGRESS). (Assigine Julian Hyde) > >> 2. https://issues.apache.org/jira/browse/CALCITE-5706(The PR has > >> merge.But issue is IN PROGRESS). (Assigine Julian Hyde) > >> 3. https://issues.apache.org/jira/browse/CALCITE-5765(The PR has > >>

Re: [ANNOUNCE] New committer: Zhe Hu

Congrats, Zhe Hu!! Best, Tanner On Wed, Jun 28, 2023 at 5:52 AM Bertil Chapuis wrote: > Congratulations, Zhe Hu! > > Best regards, > > Bertil > > > On 28 Jun 2023, at 14:26, Dan Zou wrote: > > > > Congratulations, Zhe Hu! > > > > Best, > > Dan Zou > > > > > > > > > > > >> 2023年6月28日

Unparsing based on operand type

Hey Calcite Devs, I'm working on CALCITE-6220 and the summary is that we should unparse MIN/MAX differently for Postgres/Redshift depending on its operand type (if the type is BOOLEAN, it should be rewritten as BOOL_AND/OR). This problem seems

Re: Unparsing based on operand type

parsing won't > make this problem much simpler, although there you can at least count on > the representation being properly typed. > > Mihai > > From: Tanner Clary > Sent: Tuesday, January 23, 2024 12:32 PM > To: dev@calcite.apache.org > Subje

Re: Unparsing based on operand type

Budiu wrote: > I think that unparse is supposed to work even if you haven't validated. > > Also, validation does not really know about dialects. > > Mihai > ________ > From: Tanner Clary > Sent: Tuesday, January 23, 2024 1:00 PM > To: dev@calcit

Re: Failing CI

Thanks for fixing this, Stamatis! -Tanner On Wed, Dec 6, 2023 at 8:04 AM Benchao Li wrote: > An update on this, it has been solved in CALCITE-6123 by Stamatis, the > Druid test is supposed to be stable now, thanks Stamatis for fixing > this and also thanks everyone who helped on this. > >

Re: [MINOR]

I like the [MINOR] prefix because it makes it easy to identify simple commits (via grep or ctrl+f), the same way [CALCITE-1234] makes it easy to find commits related to [CALCITE-1234]. I also like that it maintains the "[...]" styling at the beginning of the commit message. Neither of these

Re: [ANNOUNCE] New Calcite PMC chair: Benchao Li

Congrats, Benchao :) -Tanner On Thu, Dec 21, 2023 at 2:33 AM Alessandro Solimando < alessandro.solima...@gmail.com> wrote: > Congratulations Benchao, and thanks again to Stamatis for his great job! > > On Thu, 21 Dec 2023 at 11:18, Ruben Q L wrote: > > > Congratulations Benchao!! > > > > > >

Many PRs failing CI

Hi Calcite devs, When trying to review PRs this morning, I noticed many of them are currently failing the Druid CI [1]. The failures seem to be unrelated to the PR contents from what I can tell. I was wondering if anyone had suggestions as to how we could fix this. I looked for an open email

Re: Many PRs failing CI

Nevermind, I found https://issues.apache.org/jira/browse/CALCITE-6123. On Wed, Nov 29, 2023 at 10:31 AM Tanner Clary wrote: > Hi Calcite devs, > > When trying to review PRs this morning, I noticed many of them are > currently failing the Druid CI [1]. The failures seem to

Re: About SqlFunctions.java slimming in calcite

I don't think it's a bad idea but I'm also not sure whether it's worth the time and effort of deciding what functions should be grouped together, etc. Seeing as how methods in that class are mostly (always?) called via reflection, I think having them in one place is helpful in ensuring consistent

Re: Some questions about calcite

t; may > > > > have had its own set of standards before, but I may not be clear > about > > > > this. I hope that calcite’s return value of the math function in > > certain > > > > calculation situations will meet the requirements of m

Re: Some questions about calcite

I feel like I'm missing something about this whole issue. We have implemented so many functions that there's probably an existing pattern for just about any issue with dialect parity we encounter. What's the core problem? What behavior is so difficult to emulate and why? Caican let me know if you

Re: Some questions about calcite

> is unusual for a function. > > Mihai > ________ > From: Tanner Clary > Sent: Thursday, February 22, 2024 4:45 PM > To: dev@calcite.apache.org > Subject: Re: Some questions about calcite > > I feel like I'm missing something about this whole issu

Re: Simulataneous changes to Avatica and Calcite

How do the tests fail? You could use deprecated methods? You could also block the quidem tests with a TODO for the JIRA (is that hacky?) On Mon, Feb 26, 2024 at 5:58 PM Mihai Budiu wrote: > Hello, > > I have submitted a fix to Avatica improving the output of times and > timestamps with

Re: [ANNOUNCE] Sergey Nuyanzin joins Calcite PMC

Congrats Sergey! Tanner On Tue, Mar 5, 2024 at 4:14 AM Benchao Li wrote: > I am pleased to announce that Sergey has accepted an invitation to > join the Calcite PMC. Sergey has been a consistent and helpful figure > in the Calcite community for which we are very grateful. We look > forward to

Re: Calcite Setup Issues

I’ve had this issue before when I was using the wrong Java version. Setting to 1.8 normally fixes for me. Could be worth trying. Tanner On Sat, Apr 6, 2024 at 2:53 AM Anurag Naik wrote: > Thank you, Mr. Francis. I have now subscribed to the mailing list. > > So the issue I have been

[jira] [Created] (CALCITE-6001) Add default charset per dialect

Tanner Clary created CALCITE-6001: - Summary: Add default charset per dialect Key: CALCITE-6001 URL: https://issues.apache.org/jira/browse/CALCITE-6001 Project: Calcite Issue Type: New

[jira] [Created] (CALCITE-5983) Add DIV and IEEE_DIVIDE functions (enabled in BigQuery library)

Tanner Clary created CALCITE-5983: - Summary: Add DIV and IEEE_DIVIDE functions (enabled in BigQuery library) Key: CALCITE-5983 URL: https://issues.apache.org/jira/browse/CALCITE-5983 Project: Calcite

[jira] [Created] (CALCITE-6021) Add CURRENT_DATETIME function (enabled in BigQuery library)

Tanner Clary created CALCITE-6021: - Summary: Add CURRENT_DATETIME function (enabled in BigQuery library) Key: CALCITE-6021 URL: https://issues.apache.org/jira/browse/CALCITE-6021 Project: Calcite

[jira] [Created] (CALCITE-6013) Unnecessary measures added as projects during rel construction

Tanner Clary created CALCITE-6013: - Summary: Unnecessary measures added as projects during rel construction Key: CALCITE-6013 URL: https://issues.apache.org/jira/browse/CALCITE-6013 Project: Calcite

[jira] [Created] (CALCITE-6045) CURRENT_TIMESTAMP has incorrect return type

Tanner Clary created CALCITE-6045: - Summary: CURRENT_TIMESTAMP has incorrect return type Key: CALCITE-6045 URL: https://issues.apache.org/jira/browse/CALCITE-6045 Project: Calcite Issue Type

[jira] [Created] (CALCITE-5932) Add SAFE_SUBTRACT function (enabled in BigQuery library)

Tanner Clary created CALCITE-5932: - Summary: Add SAFE_SUBTRACT function (enabled in BigQuery library) Key: CALCITE-5932 URL: https://issues.apache.org/jira/browse/CALCITE-5932 Project: Calcite

[jira] [Created] (CALCITE-5933) Add SAFE_DIVIDE function (enabled in BigQuery library)

Tanner Clary created CALCITE-5933: - Summary: Add SAFE_DIVIDE function (enabled in BigQuery library) Key: CALCITE-5933 URL: https://issues.apache.org/jira/browse/CALCITE-5933 Project: Calcite

[jira] [Created] (CALCITE-5955) Non-aggregate window functions incorrectly contain window frame clause for BigQuery

Tanner Clary created CALCITE-5955: - Summary: Non-aggregate window functions incorrectly contain window frame clause for BigQuery Key: CALCITE-5955 URL: https://issues.apache.org/jira/browse/CALCITE-5955

[jira] [Created] (CALCITE-5454) Update BigQuery Conformance for != and % operators

Tanner Clary created CALCITE-5454: - Summary: Update BigQuery Conformance for != and % operators Key: CALCITE-5454 URL: https://issues.apache.org/jira/browse/CALCITE-5454 Project: Calcite

[jira] [Created] (CALCITE-5459) Implement BigQuery TIME() Function

Tanner Clary created CALCITE-5459: - Summary: Implement BigQuery TIME() Function Key: CALCITE-5459 URL: https://issues.apache.org/jira/browse/CALCITE-5459 Project: Calcite Issue Type

[jira] [Created] (CALCITE-5464) Implement BigQuery DATE_ADD/DATE_DIFF

Tanner Clary created CALCITE-5464: - Summary: Implement BigQuery DATE_ADD/DATE_DIFF Key: CALCITE-5464 URL: https://issues.apache.org/jira/browse/CALCITE-5464 Project: Calcite Issue Type: Sub

[jira] [Created] (CALCITE-5469) Implement BigQuery DATETIME_ADD/DATETIME_DIFF

Tanner Clary created CALCITE-5469: - Summary: Implement BigQuery DATETIME_ADD/DATETIME_DIFF Key: CALCITE-5469 URL: https://issues.apache.org/jira/browse/CALCITE-5469 Project: Calcite Issue

[jira] [Created] (CALCITE-5422) Time units to be supported by TIMESTAMP_ADD function

Tanner Clary created CALCITE-5422: - Summary: Time units to be supported by TIMESTAMP_ADD function Key: CALCITE-5422 URL: https://issues.apache.org/jira/browse/CALCITE-5422 Project: Calcite

[jira] [Created] (CALCITE-5432) Implement BigQuery TIME_ADD/TIME_DIFF

Tanner Clary created CALCITE-5432: - Summary: Implement BigQuery TIME_ADD/TIME_DIFF Key: CALCITE-5432 URL: https://issues.apache.org/jira/browse/CALCITE-5432 Project: Calcite Issue Type: Sub

[jira] [Created] (CALCITE-5436) Implement DATE, TIME, TIMESTAMP Subtraction Functions (compatible w/ BigQuery)

Tanner Clary created CALCITE-5436: - Summary: Implement DATE, TIME, TIMESTAMP Subtraction Functions (compatible w/ BigQuery) Key: CALCITE-5436 URL: https://issues.apache.org/jira/browse/CALCITE-5436

[jira] [Created] (CALCITE-5449) Implement EXTRACT() Function for BigQuery

Tanner Clary created CALCITE-5449: - Summary: Implement EXTRACT() Function for BigQuery Key: CALCITE-5449 URL: https://issues.apache.org/jira/browse/CALCITE-5449 Project: Calcite Issue Type

[jira] [Created] (CALCITE-5452) Add BigQuery LENGTH() as synonym for CHAR_LENGTH()

Tanner Clary created CALCITE-5452: - Summary: Add BigQuery LENGTH() as synonym for CHAR_LENGTH() Key: CALCITE-5452 URL: https://issues.apache.org/jira/browse/CALCITE-5452 Project: Calcite

[jira] [Created] (CALCITE-5385) Add BigQuery as supported library for implemented functions

Tanner Clary created CALCITE-5385: - Summary: Add BigQuery as supported library for implemented functions Key: CALCITE-5385 URL: https://issues.apache.org/jira/browse/CALCITE-5385 Project: Calcite

[jira] [Created] (CALCITE-5404) Implement BigQuery's POW() and TRUNC() math functions

Tanner Clary created CALCITE-5404: - Summary: Implement BigQuery's POW() and TRUNC() math functions Key: CALCITE-5404 URL: https://issues.apache.org/jira/browse/CALCITE-5404 Project: Calcite

[jira] [Created] (CALCITE-5384) Implement LEFT/RIGHT String functions for BigQuery

Tanner Clary created CALCITE-5384: - Summary: Implement LEFT/RIGHT String functions for BigQuery Key: CALCITE-5384 URL: https://issues.apache.org/jira/browse/CALCITE-5384 Project: Calcite

[jira] [Created] (CALCITE-5484) Implement BigQuery DATETIME_SUB

Tanner Clary created CALCITE-5484: - Summary: Implement BigQuery DATETIME_SUB Key: CALCITE-5484 URL: https://issues.apache.org/jira/browse/CALCITE-5484 Project: Calcite Issue Type: Sub-task

[jira] [Created] (CALCITE-5580) Add SPLIT() Function (Enabled for BigQuery)

Tanner Clary created CALCITE-5580: - Summary: Add SPLIT() Function (Enabled for BigQuery) Key: CALCITE-5580 URL: https://issues.apache.org/jira/browse/CALCITE-5580 Project: Calcite Issue Type

[jira] [Created] (CALCITE-5579) Allow Time Frames as Valid Expressions

Tanner Clary created CALCITE-5579: - Summary: Allow Time Frames as Valid Expressions Key: CALCITE-5579 URL: https://issues.apache.org/jira/browse/CALCITE-5579 Project: Calcite Issue Type

[jira] [Created] (CALCITE-5585) Add STRPOS() Function (Enabled for BigQuery)

Tanner Clary created CALCITE-5585: - Summary: Add STRPOS() Function (Enabled for BigQuery) Key: CALCITE-5585 URL: https://issues.apache.org/jira/browse/CALCITE-5585 Project: Calcite Issue

[jira] [Created] (CALCITE-5564) Add 2-argument support for PERCENTILE_CONT/DISC

Tanner Clary created CALCITE-5564: - Summary: Add 2-argument support for PERCENTILE_CONT/DISC Key: CALCITE-5564 URL: https://issues.apache.org/jira/browse/CALCITE-5564 Project: Calcite Issue

[jira] [Created] (CALCITE-5610) Implement COTH, CSCH, SECH Functions

Tanner Clary created CALCITE-5610: - Summary: Implement COTH, CSCH, SECH Functions Key: CALCITE-5610 URL: https://issues.apache.org/jira/browse/CALCITE-5610 Project: Calcite Issue Type: Sub

[jira] [Created] (CALCITE-5605) Add BigQuery as supported library for CHR

Tanner Clary created CALCITE-5605: - Summary: Add BigQuery as supported library for CHR Key: CALCITE-5605 URL: https://issues.apache.org/jira/browse/CALCITE-5605 Project: Calcite Issue Type

[jira] [Created] (CALCITE-5565) Implement BigQuery LOG function

Tanner Clary created CALCITE-5565: - Summary: Implement BigQuery LOG function Key: CALCITE-5565 URL: https://issues.apache.org/jira/browse/CALCITE-5565 Project: Calcite Issue Type: Task

[jira] [Created] (CALCITE-5554) Add DAYOFWEEK and DAYOFYEAR as valid synonyms of DOW, DOY

Tanner Clary created CALCITE-5554: - Summary: Add DAYOFWEEK and DAYOFYEAR as valid synonyms of DOW, DOY Key: CALCITE-5554 URL: https://issues.apache.org/jira/browse/CALCITE-5554 Project: Calcite

[jira] [Created] (CALCITE-5644) Implement BigQuery CONTAINS_SUBSTR

Tanner Clary created CALCITE-5644: - Summary: Implement BigQuery CONTAINS_SUBSTR Key: CALCITE-5644 URL: https://issues.apache.org/jira/browse/CALCITE-5644 Project: Calcite Issue Type: Task

[jira] [Created] (CALCITE-5660) Implement BigQuery Array Subscript Operators

Tanner Clary created CALCITE-5660: - Summary: Implement BigQuery Array Subscript Operators Key: CALCITE-5660 URL: https://issues.apache.org/jira/browse/CALCITE-5660 Project: Calcite Issue

[jira] [Created] (CALCITE-5666) Add ISOWEEK and WEEK(WEEKDAY) to TimeUnit in Avatica

Tanner Clary created CALCITE-5666: - Summary: Add ISOWEEK and WEEK(WEEKDAY) to TimeUnit in Avatica Key: CALCITE-5666 URL: https://issues.apache.org/jira/browse/CALCITE-5666 Project: Calcite

[jira] [Created] (CALCITE-5677) Fix unparsing for BigQuery SUBSTR

Tanner Clary created CALCITE-5677: - Summary: Fix unparsing for BigQuery SUBSTR Key: CALCITE-5677 URL: https://issues.apache.org/jira/browse/CALCITE-5677 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-5600) Allow EXTRACT() to accept custom time frames

Tanner Clary created CALCITE-5600: - Summary: Allow EXTRACT() to accept custom time frames Key: CALCITE-5600 URL: https://issues.apache.org/jira/browse/CALCITE-5600 Project: Calcite Issue

[jira] [Created] (CALCITE-5766) Implement SAFE_NEGATE function (enabled for BigQuery)

Tanner Clary created CALCITE-5766: - Summary: Implement SAFE_NEGATE function (enabled for BigQuery) Key: CALCITE-5766 URL: https://issues.apache.org/jira/browse/CALCITE-5766 Project: Calcite

[jira] [Created] (CALCITE-5827) Add TO_HEX and FROM_HEX functions (enabled in BigQuery library)

Tanner Clary created CALCITE-5827: - Summary: Add TO_HEX and FROM_HEX functions (enabled in BigQuery library) Key: CALCITE-5827 URL: https://issues.apache.org/jira/browse/CALCITE-5827 Project: Calcite

[jira] [Created] (CALCITE-5747) FLOOR() return type differs from BigQuery

Tanner Clary created CALCITE-5747: - Summary: FLOOR() return type differs from BigQuery Key: CALCITE-5747 URL: https://issues.apache.org/jira/browse/CALCITE-5747 Project: Calcite Issue Type

[jira] [Created] (CALCITE-5757) Incorrect return type for BigQuery TIMESTAMP functions

Tanner Clary created CALCITE-5757: - Summary: Incorrect return type for BigQuery TIMESTAMP functions Key: CALCITE-5757 URL: https://issues.apache.org/jira/browse/CALCITE-5757 Project: Calcite

[jira] [Created] (CALCITE-5735) Implement BigQuery SAFE_MULTIPLY function

Tanner Clary created CALCITE-5735: - Summary: Implement BigQuery SAFE_MULTIPLY function Key: CALCITE-5735 URL: https://issues.apache.org/jira/browse/CALCITE-5735 Project: Calcite Issue Type

[jira] [Created] (CALCITE-5869) LEAST_RESTRICTIVE does not use inner type of MEASURE for comparisons

Tanner Clary created CALCITE-5869: - Summary: LEAST_RESTRICTIVE does not use inner type of MEASURE for comparisons Key: CALCITE-5869 URL: https://issues.apache.org/jira/browse/CALCITE-5869 Project

[jira] [Created] (CALCITE-6220) Map MAX/MIN to BOOL_OR/BOOL_AND for Postgres and Redshift

Tanner Clary created CALCITE-6220: - Summary: Map MAX/MIN to BOOL_OR/BOOL_AND for Postgres and Redshift Key: CALCITE-6220 URL: https://issues.apache.org/jira/browse/CALCITE-6220 Project: Calcite

[jira] [Created] (CALCITE-6182) Add LENGTH/LEN function (enabled in Snowflake library)

Tanner Clary created CALCITE-6182: - Summary: Add LENGTH/LEN function (enabled in Snowflake library) Key: CALCITE-6182 URL: https://issues.apache.org/jira/browse/CALCITE-6182 Project: Calcite

[jira] [Created] (CALCITE-6172) Allow aliased operators to re-use existing tests

Tanner Clary created CALCITE-6172: - Summary: Allow aliased operators to re-use existing tests Key: CALCITE-6172 URL: https://issues.apache.org/jira/browse/CALCITE-6172 Project: Calcite Issue

[jira] [Created] (CALCITE-6186) Enable DATEDIFF for Snowflake, map to BigQuery equivalents

Tanner Clary created CALCITE-6186: - Summary: Enable DATEDIFF for Snowflake, map to BigQuery equivalents Key: CALCITE-6186 URL: https://issues.apache.org/jira/browse/CALCITE-6186 Project: Calcite

[jira] [Created] (CALCITE-6196) Remove OVER requirement for BigQuery PERCENTILE_CONT/DISC

Tanner Clary created CALCITE-6196: - Summary: Remove OVER requirement for BigQuery PERCENTILE_CONT/DISC Key: CALCITE-6196 URL: https://issues.apache.org/jira/browse/CALCITE-6196 Project: Calcite

[jira] [Created] (CALCITE-6205) Add BITAND_AGG, BITOR_AGG functions (enabled in Snowflake library)

Tanner Clary created CALCITE-6205: - Summary: Add BITAND_AGG, BITOR_AGG functions (enabled in Snowflake library) Key: CALCITE-6205 URL: https://issues.apache.org/jira/browse/CALCITE-6205 Project

[jira] [Created] (CALCITE-6206) Add library operator mapping for unparsing

Tanner Clary created CALCITE-6206: - Summary: Add library operator mapping for unparsing Key: CALCITE-6206 URL: https://issues.apache.org/jira/browse/CALCITE-6206 Project: Calcite Issue Type

[jira] [Created] (CALCITE-6197) TIME_SUB is unparsed incorrectly

Tanner Clary created CALCITE-6197: - Summary: TIME_SUB is unparsed incorrectly Key: CALCITE-6197 URL: https://issues.apache.org/jira/browse/CALCITE-6197 Project: Calcite Issue Type

[jira] [Created] (CALCITE-6198) Add TO_TIMESTAMP_LTZ function (enabled in Snowflake library)

Tanner Clary created CALCITE-6198: - Summary: Add TO_TIMESTAMP_LTZ function (enabled in Snowflake library) Key: CALCITE-6198 URL: https://issues.apache.org/jira/browse/CALCITE-6198 Project: Calcite

[jira] [Created] (CALCITE-6156) Add ENDSWITH, STARTSWITH functions (enabled in Snowflake library)

Tanner Clary created CALCITE-6156: - Summary: Add ENDSWITH, STARTSWITH functions (enabled in Snowflake library) Key: CALCITE-6156 URL: https://issues.apache.org/jira/browse/CALCITE-6156 Project

[jira] [Created] (CALCITE-6225) Unparse LOGICAL_AND/OR as BOOLAND_AGG/BOOLOR_AGG for Snowflake

Tanner Clary created CALCITE-6225: - Summary: Unparse LOGICAL_AND/OR as BOOLAND_AGG/BOOLOR_AGG for Snowflake Key: CALCITE-6225 URL: https://issues.apache.org/jira/browse/CALCITE-6225 Project: Calcite

[jira] [Created] (CALCITE-6290) Incorrect return type for BigQuery REPEAT

Tanner Clary created CALCITE-6290: - Summary: Incorrect return type for BigQuery REPEAT Key: CALCITE-6290 URL: https://issues.apache.org/jira/browse/CALCITE-6290 Project: Calcite Issue Type

[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