Re: Volcano Planner Issue

Hi Suchit, Sorry that I couldn't find your example. Am I missing something? Suchit Kumar 于2023年2月7日周二 00:01写道： > Hi, > > Thank you for your reply, This is the example that I am creating and > inside iterativeRuleQueue it keeps running. > In this example, I need to query on top of the java

Re: Future of the Spatial Type Extension

PS Regarding which specification we choose to implement. The four principles you outline sound good to me. It’s always better to follow the standard. If leading implementations (e.g. PostGIS and H2GIS) diverge from the standard, we can make a note, and possibly support them as secondary

Re: Future of the Spatial Type Extension

Similar issues have come up with non-GIS functions. For example, the DATEDIFF function [1]. Snowflake and MSSQL have ‘DATEDIFF(timeUnit, datetime, datetime2)’, whereas MySQL has ‘DATEDIFF(date, date2)’. We document which specification we implement, and potentially we could implement both

Re: Why does timestamp diff return a value inconsistent with the time unit?

I ran the queries through SQLLine and got the expected results, as follows. 0: jdbc:calcite:model=core/src/test/resources> values ((TIMESTAMP '1971-01-01 00:00:00' - TIMESTAMP '1970-01-01 00:00:00') second); +--+ | EXPR$0 | +--+ |

Re: [DISCUSS] Apache Calcite Meetup March 2023

Here’s a time link: https://www.timeanddate.com/worldclock/fixedtime.html?msg=Apache+Calcite+meetup=20230315T18 1800 UTC = 1100 Pacific daylight time > On Feb 6, 2023, at 6:24 AM, Gavin Ray wrote: > > Heya all, > > Proposed date and time works for me as well Stamatis, thanks for the >

Re: [DISCUSS] Towards Calcite 1.33.0

It looks as if the directory was successfully moved from dev to release. (Does anyone know the URL for the dist.apache.org svn commit log?) > On Feb 6, 2023, at 1:48 PM, Jess Balint wrote: > > I just tried to publish the release. The files are present here: > >

Why does timestamp diff return a value inconsistent with the time unit?

I’ve noticed that Calcite evaluates to different time unit types than the given time unit type in a timestamp difference (I haven’t tested datetimes). For example: `(TIMESTAMP'1971-01-01 00:00:00' - TIMESTAMP'1970-01-01 00:00:00') $TIMEUNIT` gives 3153600 (milliseconds) when $TIMEUNIT =

Re: [DISCUSS] Towards Calcite 1.33.0

I just tried to publish the release. The files are present here: https://dist.apache.org/repos/dist/release/calcite/apache-calcite-1.33.0/ However the Gradle task failed with the following error. Is this failure a problem or is the release fully published? Thanks. Jess > Task :publishSvnDist

[jira] [Created] (CALCITE-5516) RelOptRulesTest optimized plan not semantically equivalent to the original one after conversion

Pinhan Zhao created CALCITE-5516: Summary: RelOptRulesTest optimized plan not semantically equivalent to the original one after conversion Key: CALCITE-5516 URL: https://issues.apache.org/jira/browse/CALCITE-5516

Re: Volcano Planner Issue

Hi, Thank you for your reply, This is the example that I am creating and inside iterativeRuleQueue it keeps running. In this example, I need to query on top of the java hashmap. Please let me know what I am missing and if there is anyway. So that I can bypass the optimiser and run the query

Re: [DISCUSS] Apache Calcite Meetup March 2023

Heya all, Proposed date and time works for me as well Stamatis, thanks for the suggestion =) On Mon, Feb 6, 2023 at 3:01 AM Alessandro Solimando < alessandro.solima...@gmail.com> wrote: > Hello everyone, > the proposed date and time is fine with me and I'd be happy to hear > Julian's talk. > >

Future of the Spatial Type Extension

Hello Everyone, I continue to make progress on the implementation of the Spatial Type (ST_) extension for calcite [1] and wanted to exchange about the current design. When implementing spatial functions, we usually refer to the OpenGIS Simple Features Implementation Specification for SQL [2]

Re: Volcano Planner Issue

Hi Suchit, It would be helpful if you could provide more information such as: - What the version are you using - How you used Calcite, e.g., what's the rules you are using, is there any custom rule? - If there is a pure Calcite reproducible test case, it would be easier for others to understand

Re: [DISCUSS] Apache Calcite Meetup March 2023

Hello everyone, the proposed date and time is fine with me and I'd be happy to hear Julian's talk. In addition, together with Stamatis, we could present how the extended logging capabilities introduced via CALCITE-4704 and CALCITE-4991