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

+1 Tanner Clary (Committer) On Fri, Oct 4, 2024 at 9:26 PM Xiong Duan wrote: > +1 Xiong Duan(Committer) > > The Tag's web link is invalid. > > Julian Hyde 于2024年10月5日周六 11:36写道： > > > > Hi all, > > > > I have created a build for Apache Calcite 1.38.0

Re: [ANNOUNCE] New committer: Norman Jordan

Congratulations, Norman! Tanner On Wed, Aug 14, 2024 at 6:12 PM Cancai Cai wrote: > Congratulations Norman! > > > 2024年8月14日 20:23，Alessandro Solimando > 写道： > > > > Congratulations, Norman, very well deserved! > > > > On Wed, Aug 14, 2024, 13:43 Benchao Li wrote: > > > >> Congratulations Nor

Re: [ANNOUNCE] Mihai Budiu joins Calcite PMC

Congrats Mihai, well deserved! Tanner On Thu, Jul 25, 2024 at 7:49 PM Cancai Cai wrote: > Congratulations, Mihai! > Thank you Mihai for your help all the time > > > 2024年7月26日 10:43，Francis Chuang 写道： > > > > Congratulations, Mihai! > > > > On 26/07/2024 12:37 pm, Benchao Li wrote: > >> I am

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 encounterin

[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

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 t

[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

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 precision

Re: Some questions about calcite

lay said, > calcite > > 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

Re: Some questions about calcite

gt; 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

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 w

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 c

[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

Re: Unparsing based on operand type

Mihai 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:

Re: Unparsing based on operand type

to unparsing 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

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

[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-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-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-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-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-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-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

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 reason

[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

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!! > > > > > > On

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. > > Julia

[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

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 be unrela

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 threa

Re: [DISCUSS] Towards Calcite 1.36.0

een released. > > 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

Re: [DISCUSS] Towards Calcite 1.36.0

anner 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: > >>

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写道： > > > &

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 reve

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 rebas

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 p

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, Tanner

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 announce

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: 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-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 n

[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-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

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 PR

[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-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

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 o

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! Tanner

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

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: 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年

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 th

[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-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-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-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-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

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: 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 th

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: [DISCUSS] Towards Calcite 1.35.0

.But 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: 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 wr

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日 20:24，Jiaj

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 | 06/13/20

[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-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-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-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

Re: [ANNOUNCE] New committer: Tanner Clary

roject 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 Za

[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-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-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-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-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-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

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

[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-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

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 DATE_TRU

[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-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-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

Re: [DISCUSS] Towards Calcite 1.33.0

MESTAMP ‘…’, 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 Hyd

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 order

[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-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-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-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-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-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-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-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-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-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-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: Ca

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

  1   2   >