Re: Parsing FILTER Operator

> Stamatis > > On Mon, Sep 27, 2021 at 10:59 AM Atri Sharma wrote: > > > Thanks for the reply. > > > > I dont think that was the case (I am not running from SQLLine, but > > from a custom Calcite integration). > > > > I think it was something to do wit

Re: Parsing FILTER Operator

hongkang jiang wrote: > > "SELECT COUNT(*) FILTER (WHERE timestampColumn > '2021-01-01), > timestampColumn FROM testTable WHERE timestampColumn > '2021-01-01" > + "00:00:00.123' GROUP BY timestampColumn" > > There's a semicolon missing. > >

Parsing FILTER Operator

Using the Babel parser, I get an error while parsing the following query: "SELECT COUNT(*) FILTER (WHERE timestampColumn > '2021-01-01), timestampColumn FROM testTable WHERE timestampColumn > '2021-01-01" + "00:00:00.123' GROUP BY timestampColumn" The exception raised is: Caused by:

Re: Using Calcite as a Distributed Optimizer

Is there an example I can refer to? On Fri, 14 May 2021, 04:59 Haisheng Yuan, wrote: > Yes, definitely. Many distributed big data systems use Apache Calcite to > optimize queries and generate distributed plans. > > On 2021/05/13 23:16:10, Atri Sharma wrote: > > Thank you.

Re: Using Calcite as a Distributed Optimizer

, but I wanted to understand if achieving the above is possible with Calcite today. Atri On Fri, 14 May 2021, 01:20 Julian Hyde, wrote: > Calcite has no user@ list. So, ask away here! > > > On May 13, 2021, at 10:52 AM, Atri Sharma wrote: > > > > Sorry, didn't realize I had

Re: Using Calcite as a Distributed Optimizer

Sorry, didn't realize I had sent to the dev list. I will send to the user list On Thu, 13 May 2021, 15:57 Atri Sharma, wrote: > Hi All, > > Are there examples of using Calcite to compile and optimize queries to > be run on a set of nodes, and then merge partial results ba

Using Calcite as a Distributed Optimizer

Hi All, Are there examples of using Calcite to compile and optimize queries to be run on a set of nodes, and then merge partial results back? Atri -- Regards, Atri l'apprenant

Re: Calcite contributions

On Tue, Aug 28, 2018 at 6:09 PM Vladimir Sitnikov wrote: > Initial analysis by Alexey was not right, so he implemented a wrong > solution. That happens when people try to fix unfamiliar codebases. I am completely out of line here, but this statement sounds pretty detrimental to any potential

Re: Ordering of columns during a join

ve > fixed it myself. > > Julian > > >> On May 23, 2018, at 10:11 AM, Atri Sharma <atri.j...@gmail.com> wrote: >> >> Thanks. >> >> That seems to be the issue. Can you point me to where I need to fix >> the mappings in order to ensure the right o

Re: Ordering of columns during a join

nge. > If you’re seeing errors due to columns not being the type you expect then you > probably have the mappings mixed up. > > Julian > > > > >> On May 22, 2018, at 7:59 PM, Atri Sharma <atri.j...@gmail.com> wrote: >> >> Please let me know. I am bloc

[Needs Review] CALCIE - 873

https://github.com/apache/calcite/pull/485 -- Regards, Atri l'apprenant

Re: Ordering of columns during a join

Please let me know. I am blocked on CALCITE - 500 on this, so it will be great if I could get some advise here. Thanks On Tue, May 22, 2018 at 7:23 PM, Atri Sharma <atri.j...@gmail.com> wrote: > I agree, however, the cast failures are something I am not sure about. If > you look a

Re: Ordering of columns during a join

bug, but I can certainly see > how this would be considered unexpected behaviour. > > -- > Michael Mior > mm...@uwaterloo.ca > > > Le mar. 22 mai 2018 à 09:26, Atri Sharma <atri.j...@gmail.com> a écrit : > > > Hi All, > > > > As an experiment, I sw

Re: Ordering of columns during a join

hese are failing due to incorrect ordering of columns, I am just not sure how/where. On Tue, May 22, 2018 at 6:56 PM, Atri Sharma <atri.j...@gmail.com> wrote: > Hi All, > > As an experiment, I switched the order of inputs to > EnumerableDefaults::join_ during the implementation stage of >

Ordering of columns during a join

Hi All, As an experiment, I switched the order of inputs to EnumerableDefaults::join_ during the implementation stage of EnumerableJoin if the Join type is Inner. Since there will be no need to generate nulls on either side, I would assume that the choice of the side being built and the side

Needs Review -- CALCITE - 500

Hi All, Can somebody take a look at https://github.com/apache/calcite/pull/691? Regards, Atri

CALCITE - 99

Hi All, Is CALCITE - 99 still applicable? Is it worth a shot? https://issues.apache.org/jira/browse/CALCITE-99 Regards, Atri

CALCITE - 873

Hi All, I am reviving CALCITE-873 and wanted to follow up on the same. I have re run the tests and added it in the Test suite as well. Julian/others, please review the CR: https://github.com/apache/calcite/pull/485 Regards, Atri

Understanding Join Internals

Hi All, I needed some help in understanding join internals please. I understood EnumerableJoin and its internals, but not sure as to how the translation to EnumerableDefaults went through. Specifically, I did not understand why EnumerableJoin does not have a physical equivalent that implements

[jira] [Created] (CALCITE-1888) VolcanoPlanner should identify if transformed node and original node are identical

Atri Sharma created CALCITE-1888: Summary: VolcanoPlanner should identify if transformed node and original node are identical Key: CALCITE-1888 URL: https://issues.apache.org/jira/browse/CALCITE-1888

Re: Wrapping an input JdbcRel forces the planner into an infinite loop

Did you try attaching debugger and see where the code is hanging? My guess is that the code flow is hanging in applyRules in HepPlanner. The iterator is not moving over the plan hence is stuck in an infinite loop. This is a known bug in HepPlanner. I will create a JIRA case for this. Please add

Re: PR for Calcite 873

lear > to whoever is reading the JIRA. Anyone who is interested in that case will > already have subscribed to it as a “watcher”. > >> On Jun 29, 2017, at 10:11 AM, Atri Sharma <atri.j...@gmail.com> wrote: >> >> Hi Julian, >> >> I have fixed your comments

Re: Spatial indexes

this list. > > James (Phoenix), Jacques (Dremio), Fabian (Flink), Jinfeng/Aman (Drill) can > be proxies for their their communities. And others who are building > interesting stuff I don’t know about. > > Julian > >> On Jun 28, 2017, at 10:29 AM, Atri Sharma <atri.j...@

Re: Spatial indexes

ize features. > > Julian > > >> On Jun 28, 2017, at 9:10 AM, Atri Sharma <atri.j...@gmail.com> wrote: >> >> And I have created the JIRA: >> >> https://issues.apache.org/jira/browse/CALCITE-1861 >> >> >> >> On Wed, Jun 28, 201

[jira] [Created] (CALCITE-1861) Spatial Indexes

Atri Sharma created CALCITE-1861: Summary: Spatial Indexes Key: CALCITE-1861 URL: https://issues.apache.org/jira/browse/CALCITE-1861 Project: Calcite Issue Type: Improvement

Re: Spatial indexes

And I have created the JIRA: https://issues.apache.org/jira/browse/CALCITE-1861 On Wed, Jun 28, 2017 at 7:02 AM, Julian Hyde wrote: > Is anyone looking for a neat project in Calcite that would have a big > impact? I'm thinking that we could add support for spatial indexes to

Re: Spatial indexes

I will log a JIRA case for this, and we can continue discussions there. On Jun 28, 2017 10:43 AM, "Jacques Nadeau" <jacq...@apache.org> wrote: > I don't know how much I can contribute but it sounds like a great way to > expand Calcite. Good idea Julian! > > On Jun 27

Re: Spatial indexes

I am all for it. This sounds really interesting. On Jun 28, 2017 7:02 AM, "Julian Hyde" wrote: > Is anyone looking for a neat project in Calcite that would have a big > impact? I'm thinking that we could add support for spatial indexes to > Calcite in such a way that

Re: PR for Calcite 873

Just noticed that my editor decided to fold the imports automatically. Will fix that tomorrow On Jun 27, 2017 11:33 PM, "Atri Sharma" <atri.j...@gmail.com> wrote: > Hi All, > > Please find PR for Calcite 873 at: > > https://github.com/apache/calcite/

Re: Rule to eliminate a redundant LogicalSort

Hi Michael, I am currently working on 873 which address this exact use case. I have the patch ready but have hit a bug in HepPlanner which Julian is looking into. Post that, I should be able to push the JIRA and get this rule in. Will be glad for your review on it On Jun 27, 2017 8:22 PM,

Not getting responses on Dev list

Hi Sir, Just wanted to check, is there anything wrong in the way I have been asking questions on the dev list please? I asked a few on the dev list but did not get any response, so was wondering if there is anything wrong in the way I have been asking questions please. Please let me know.

Re: call.transformTo not returning infinitely

Hi All, Please advise. Regards, Atri On Jun 25, 2017 11:25 PM, "Atri Sharma" <atri.j...@gmail.com> wrote: > Debugging a bit further, I realised that the code flow is stuck in > applyRules. In the following code: > > while (iter.hasNext()) { >

Re: Understanding checkPlanning method

/resources/org/apache/calcite/test/RelOptRulesTest.xml > > > -Jesús > > > > > > On 6/18/17, 7:05 PM, "Atri Sharma" <atri.j...@gmail.com> wrote: > > >Hi All, > > > >I am trying to understand the way checkPlanning executes. I picked > >

Re: call.transformTo not returning infinitely

is constantly the top level LogicalSort node, and not moving down the plan. Is there something that I am missing? Regards, Atri On Sun, Jun 25, 2017 at 2:30 PM, Atri Sharma <atri.j...@gmail.com> wrote: > Hi All, > > I am working on removing redundant sorts and am stuck when > tra

call.transformTo not returning infinitely

Hi All, I am working on removing redundant sorts and am stuck when transforming the call to replace older Sort node with the reduced one. The code works like following: final RelCollation newCollation = RelCollations.of(collationsList); Sort result = sort.copy(sort.getTraitSet(),

Re: Running and debugging tests in Calcite

on the method name or class name and type > alt-shift-f9 (debug on the Run menu). You don’t need to “attach”. > > > On Jan 7, 2017, at 1:27 AM, Atri Sharma <atri.j...@gmail.com> wrote: > > > > Hi All, > > > > I wanted to check on how to run Calcite tests and at

Running and debugging tests in Calcite

Hi All, I wanted to check on how to run Calcite tests and attach debugger in tests in Intellij. Please advise. Regards, Atri

Re: Checkstyle Stuff

efore > ‘org.apache.calcite’, which is wrong, but once I fix that checkstyle is > usually happy. > > I run ‘mvn validate' in emacs to quickly find and navigate to the errors: > > $ emacs -nw --eval "(compile \"mvn -o -DskipTests validate | grep '^/'\")" >

Re: Running a specific test

ire/maven-surefire- > plugin/examples/single-test.html <http://maven.apache.org/ > surefire/maven-surefire-plugin/examples/single-test.html> > > E.g. mvn -Dtest=SqlParserTest -DfailIfNoTests=false test > > > On Sep 11, 2016, at 5:11 PM, Atri Sharma <atri.j...@gmail.

Running a specific test

Could anyone advise as to what is the cleanest way of invoking a specific test through the command line?

Understanding RelTrait and family

Can anyone please elaborate on the concept of Traits, what do they represent, and what defines their equivalence please? Regards, Atri

Re: How to override the costs

Apologies,that is computeSelfCost, not computeSelf. On Sun, Sep 11, 2016 at 6:21 PM, Atri Sharma <atri.j...@gmail.com> wrote: > If you are looking to change the costing model for a specific planner > node, you need to change the costing function for it (for an example, look >

Re: How to override the costs

If you are looking to change the costing model for a specific planner node, you need to change the costing function for it (for an example, look into a node's computeSelf method). Regards, Atri On 11 Sep 2016 5:57 p.m., "Hiroyuki Yamada" wrote: > Hello, > > I'm currently

Re: Making Calcite release 1.9

ld run more smoothly. > > Julian > > [1] https://calcite.apache.org/docs/howto.html#making-a- > release-for-calcite-committers <https://calcite.apache.org/ > docs/howto.html#making-a-release-for-calcite-committers> > > > On Aug 23, 2016, at 10:44 AM, Atri Sharma <a..

Re: Making Calcite release 1.9

If there are no objections, > >> I can be the release manager for 1.9. > >> > >> I will log the issues that I would like to go in before the release in > >> CALCITE-1356. I suggest everybody does the same! > >> > >> > >> Thanks, > >

Re: [DISCUSSION] Relational algebra on FPGA?

+1 On 24 Aug 2016 11:34 p.m., "Julian Hyde" wrote: > The short answer is yes: Netezza did it way back. > > The long answer is maybe: hardware acceleration techniques always seem to > lose to general purpose hardware in the long run. The one exception, in my > opinion, is

Re: Making Calcite release 1.9

> docs/howto.html#making-a-release-for-calcite-committers> > > > On Aug 23, 2016, at 10:44 AM, Atri Sharma <a...@apache.org> wrote: > > > > I can be the release manager (my first time,so would need support and > > bootstrapping, but would love to help). >

Re: On vacation

I can take a look at the optimizer PRs On 8 Aug 2016 8:52 a.m., "Julian Hyde" wrote: > I shall be on vacation for the next 2 weeks. I’ll be less active on email. > Can you all make sure that pull requests get handled in a timely fashion? > > Julian > >

Re: CIDR submission

+1. I will be submitting as well On 25 Jul 2016 6:21 p.m., "Jesus Camacho Rodriguez" < jcamachorodrig...@hortonworks.com> wrote: > Hi team, > > I am writing this email to know if there is interest in the community > about submitting a Calcite paper to CIDR 2017. > >

Re: Cancel flag in AvaticaResultSet

On 27 Jun 2016 11:18 pm, "Julian Hyde" wrote: > > I am developing a fix for https://issues.apache.org/jira/browse/CALCITE-1227 < https://issues.apache.org/jira/browse/CALCITE-1227> in https://github.com/julianhyde/calcite/tree/1227-streaming-csv-table <

Re: Non-reserved words on the first place of a sql statement

On 27 Jun 2016 7:13 pm, "Vitalii Diravka" wrote: > > Hi all! > > Recently I tried to use "ADD" on the first place of a new custom sql > statement and found that non-reserved words can't be placed on the first > place of the statement. > But it is ok if a non-reserved

Calcite Planner and Hacking

Hi Folks, I wanted to check if I could hack on algebra/optimizer part of Calcite. I have been looking around for things to do and JIRAs that need attention but have been mostly lost on the direction. Could someone help me with some documentation and some long term projects I could pick up?