Hi all,
in the last weeks I worked on Integrating the Apache IoTDB Project with Calcite.
This covers two possible scenarios. One, to use Apache IoTDB as an Adapter in
Apache Calcite (like MongoDB, Cassandra, et al) and on the other hand we are
looking at using Calcites Query Optimizer to
the planner?
Regards,
Vladimir.
вт, 11 янв. 2022 г. в 12:44, Julian Feinauer :
> Hey Stamatis,
>
> yes, thats why I looked it up at first… the results are wrong : )
> So both tables for themselves are sorted but the Full Join is finally two
> blocks. The Left Join (sorted li
.
I hope I am not saying something stupid but I think there are cases where a
full join algorithm can retain the order of some of its inputs.
Best,
Stamatis
On Tue, Jan 11, 2022 at 8:30 AM Julian Feinauer <
j.feina...@pragmaticminds.de> wrote:
> Hi Julian, Xiong,
>
> thanks for yo
Hi Julian, Xiong,
thanks for your fast replies!
So first, the default Rules were registered:
planner = new VolcanoPlanner();
RelOptUtil.registerDefaultRules(planner, false, true);
And as traits I used:
planner.addRelTraitDef(ConventionTraitDef.INSTANCE);
Hi all,
I just observed a Plan transformation that I don’t quite understand.
The Logical Plan is:
LogicalSort(sort0=[$0], dir0=[DESC])
LogicalProject(time=[COALESCE($0, $2)], s1=[$1], s0=[$3])
LogicalJoin(condition=[=($0, $2)], joinType=[full])
LogicalTableScan(table=[[root,
Congratulations Danny! Very well deserved!
Julian
Am 01.11.19, 20:49 schrieb "Muhammad Gelbana" :
Congratulations!
Thanks,
Gelbana
On Fri, Nov 1, 2019 at 9:07 AM Stamatis Zampetakis
wrote:
> Congratulations Danny!
>
> You are doing an
nes wrote:
>> >
>> > Hi!
>> >
>> > I'll be giving a talk on "Fast federated SQL with Apache Calcite".
>> > Would be great to meet up with any other Calciters attending!
>> >
>> > See you there
>> >
>> > Chris
Hi,
I agree with Julians view. And I also agree with initially starting with
Avatica as separate TLP but not as a separate PMC (there are multiple Examples
of PMCs that govern multiple Projects, like pointed out from Julian).
JulianF
Am 21.10.19, 03:19 schrieb "Julian Hyde" :
In Apache,
Hi,
I would love to attend a Caclite meetup but as we are from Germany I'm unsure
about the community here.
But what about a "virtual meetup" via Hangout or something as "addition".
But of course, if people from Germany are interested we would be honored to
host a Meetup near Stuttgart.
requiring board attention.
>>>
>>> ## Membership Data:
>>> Apache Calcite was founded 2015-10-22 (4 years ago)
>>> There are currently 45 committers and 20 PMC members in this project.
>>> The Committer-to-PMC ratio is 9:4.
>>>
Hi all,
are there any Calcite related talks in Berlin or any Calciters attending?
I will be there.
JulianF
Am 04.10.19, 19:09 schrieb "my...@apache.org" :
Dear Apache Calcite committers,
In a little over 2 weeks time, ApacheCon Europe is taking place in
Berlin. Join us from
ourse we’ll face many issues while development and I'll appreciate if
some of you assist us.
Regards,
Igor
> 1 окт. 2019 г., в 12:32, Julian Feinauer
написал(а):
>
> Hi Denis,
>
> Nice to hear from you and the ignite team... that sounds l
Hi Denis,
Nice to hear from you and the ignite team... that sounds like an excellent
idea. I liked the idea of Ignite since I heard about it (I think when it became
TLP back then). So I would be happy to help you if you have specific
questions... I‘m currently working on a related topic,
Yes, I totally agree that's a major change by any means. As Julian pointed out
above its only about non-code changes.
Julian
From: Andrei Sereda
Sent: Friday, September 27, 2019 7:25:56 PM
To: dev@calcite.apache.org
Subject: Re: [DISCUSS] Small contributions
I
Hi,
I agree with that and would love such a section (with timestamps). This could
also make it easier for newcomers to learn about calcite.
Julian
From: Julian Hyde
Sent: Tuesday, September 24, 2019 8:50:21 PM
To: dev
Subject: Re: Integrating Calcite, Omid,
Congrats Muhammad!
Julian
Am 19.09.19, 09:47 schrieb "Kevin Risden" :
Congrats and welcome Muhammad!
Kevin Risden
On Wed, Sep 18, 2019 at 12:15 PM Muhammad Gelbana
wrote:
> Thank you all for the very warm welcome.
>
> Calcite really changed a
> Congrats, Julian!
> > > > >
> > > > > - Haisheng
> > > > >
> > > > > --
> > > > > 发件人:Chunwei Lei
>
2019 at 9:24 AM Danny Chan wrote:
> >
> > > Congratulations, Muhammad ! Welcome to join us ! Thanks for your huge
> > > contribution for the Match Recognize.
> > >
> > > Best,
> > > Danny Chan
> > > 在 2019
Hi,
this is a good point Julian. So an implementation should consider a re-planning
(possibly triggered by a quick recheck of cost function with the given Literal
values). But this should not be a general issue with the approach, or?
JulianF
Am 16.09.19, 23:36 schrieb "Julian Hyde" :
I
Julian Feinauer created CALCITE-3345:
Summary: Implement time_bucket function
Key: CALCITE-3345
URL: https://issues.apache.org/jira/browse/CALCITE-3345
Project: Calcite
Issue Type: New
Julian Feinauer created CALCITE-3341:
Summary: Implement FINAL modifier functionality
Key: CALCITE-3341
URL: https://issues.apache.org/jira/browse/CALCITE-3341
Project: Calcite
Issue
Thank you Francis, good job!
JulianF
Am 10.09.19, 14:34 schrieb "Francis Chuang" :
Thanks for getting this massive release out, Stamatis!
Francis
On 11/09/2019 7:27 am, Stamatis Zampetakis wrote:
> Thanks to everyone who has tested the release candidate and given
translates it of a TableScan of your taste?
Julian
Am 10.09.19, 08:13 schrieb "Julian Feinauer" :
Hi Gabriel,
thats an interesting question for me too.
Do you need parameters for those "dynamic tables"?
If not you could do it similar to what Dri
Hi Gabriel,
thats an interesting question for me too.
Do you need parameters for those "dynamic tables"?
If not you could do it similar to what Drill is doing and just implement a
Schema which always returns "true" if someone asks for a Table and then returns
a Table Implementation that you
in SFO so I’ll miss most of the speakers’ dinner.
Did you get the invite to the ApacheCon slack? Let’s communicate there.
Julian
> On Sep 9, 2019, at 16:40, Julian Feinauer
wrote:
>
> Hi all,
> I have my talk till 18:20. What about meeting
, look forward to your
spark of the thoughts.
Best,
Danny Chan
在 2019年9月7日 +0800 PM1:58,Julian Feinauer ,写道:
> Hi all,
>
> as I’m currently traveling to Las Vegas I asked myself if there already are
> any considerations to meet with the Calcite Community, e.g. in the Hackathon
> Spa
Hi Stamatis,
thank you for your effort!
+1 (non-binding)
I found some minor issues I described below and the failing Test from the last
RC but as its addressed for the next release, so I think it's reasonable
addressed.
I checked:
- Checksum and Signature correct
- Checked LICENSE and NOTICE
ning - Thu lunchtime. Would love to hang out and write
code.
IMHO, conferences are for "conferring" - chatting in corridors, and
occasionally in bars - more than they are about attending talks.
Who else is going?
Julian
On Fri, Sep 6, 2019 at 10:5
Hi all,
as I’m currently traveling to Las Vegas I asked myself if there already are any
considerations to meet with the Calcite Community, e.g. in the Hackathon Space
or something.
I saw some talsk about Caclite so I guess that some PMCs / Contributors are in
Las Vegas and I would be really
atis Zampetakis" :
Sorry about that, I will cancel the vote and start a new one for rc1 ASAP.
In the meantime, do we want to fix CALCITE-2816 (or skip the relevant tests
for problematic locales)?
On Thu, Sep 5, 2019 at 8:28 AM Julian Feinauer
wrote:
>
55 AM Julian Hyde wrote:
> >
> > > Regarding the 'ps' failures. I've added a suggestion to
> > >
> > >
https://issues.apache.org/jira/browse/CALCITE-2816?focusedCommentId=16921772=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#co
Thanks Vladimir,
This would also be my first assumption that its due to German locale which also
causes problems with parsing frequently.
I think we should either fix that or note it somewhere in the how to to ensure
that people can reproduce the build, so I think I should keep my -1 (but it's
if this is a regression from 1.20.0?
Best,
Stamatis
On Mon, Sep 2, 2019, 9:32 PM Julian Feinauer
wrote:
> Hi Stamatis,
>
> thank you for your effort!
>
> Unfortunately, I think I have to vote
>
> -1 (non-binding)
>
> as I encountered an issue building the artefacts w
Hi Stamatis,
thank you for your effort!
Unfortunately, I think I have to vote
-1 (non-binding)
as I encountered an issue building the artefacts with the given instruction
(see below).
But as my vote is non-binding it's up to the more experienced devs to decide
how to handle this case
Hi all,
as I try to make progress towards the *full* functionality of MATCH_RECOGNIZE
in Calcite I added support for the CLASSIFIER function.
The issue can be found in [1] and the PR in [2].
I would kindly ask for a review and some comments as the current implementation
works BUT is not
Julian Feinauer created CALCITE-3302:
Summary: Add support for CLASSIFIER() command in MATCH_RECOGNIZE
Key: CALCITE-3302
URL: https://issues.apache.org/jira/browse/CALCITE-3302
Project: Calcite
Julian Feinauer created CALCITE-3294:
Summary: Implement FINAL Clause for MATCH_RECOGNIZE
Key: CALCITE-3294
URL: https://issues.apache.org/jira/browse/CALCITE-3294
Project: Calcite
Issue
ve you what you need.
> On Aug 23, 2019, at 7:11 AM, Julian Feinauer
wrote:
>
> Hi,
>
> a short update on this matter.
> We had a meetup yesterday with the PLC4X community and I prepared a very
first "demo" implementation of the Optimizer
zers AFAIR use approaches like simulated annealing).
Best
Julian
Am 20.08.19, 15:38 schrieb "Julian Feinauer" :
Hi Stamatis,
thanks for your response.
I think my brain just needs a bit more time to get really deep into those
advanced planning topics (its sometimes slow on a
Hi,
there are some SQL dialect grammars online here (for ANTLR4)
https://github.com/antlr/grammars-v4/tree/master/mysql
https://github.com/antlr/grammars-v4/tree/master/plsql
https://github.com/antlr/grammars-v4/tree/master/sqlite
https://github.com/antlr/grammars-v4/tree/master/tsql
They could
you are in the territory for which we created the Spool operator (see
> discussion in https://issues.apache.org/jira/browse/CALCITE-481 <
> https://issues.apache.org/jira/browse/CALCITE-481>).
>
> Julian
>
>
> > On Aug 19, 2019, at 6:34
n in https://issues.apache.org/jira/browse/CALCITE-481
<https://issues.apache.org/jira/browse/CALCITE-481>).
Julian
> On Aug 19, 2019, at 6:34 AM, Julian Feinauer
wrote:
>
> Hi Danny,
>
> thanks for the quick reply.
> Cost calcu
t,
Danny Chan
在 2019年8月19日 +0800 PM5:20,Julian Feinauer ,写道:
> Hi folks,
>
> I’m here again with another PLC4X related question
(https://plc4x.apache.org).
> As we have more and more usecases we encounter situations where we send
LOTS of replies to PLCs which o
Hi folks,
I’m here again with another PLC4X related question (https://plc4x.apache.org).
As we have more and more usecases we encounter situations where we send LOTS of
replies to PLCs which one could sometimes optimize.
This has multiple reasons upstream (like multiple different Services
I will be there and would love some : )
Julian
Am 07.08.19, 13:07 schrieb "Michael Mior" :
I won't be at ApacheCon, but should we request some stickers with our new
logo?
--
Michael Mior
mm...@apache.org
-- Forwarded message -
De : Sally
Hi Stamatis,
Thank you for the overview.
Currently Julian is working on a Pr of mine which does not exactly fix
CALCITE-1935 but at least bring in the first support for MATCH_RECOGNIZE which
I would consider at list a partial success.
But as the PR is rather big and the branch lived for two
Hi all,
I finally finished to bring the joint work on MATCH_RECOGNIZE to a state where
at least two non-trivial Tests work, see [3].
The Work is based on a lot of preliminary work of Hongze and Julian (Hyde)
which was done over a period of over a year, therefore the code is rather large.
I also
Hi, Yuzhou,
Thank you very much!
Please, tell me if you need any informations or snippets.
Julian
Von meinem Mobiltelefon gesendet
Ursprüngliche Nachricht
Betreff: Re: Problem with Code Generation
Von: Yuzhao Chen
An: dev@calcite.apache.org
Cc:
Julian Feinauer, i have
Hi all,
I have some problems with the code generation from Linq4j which I'm unable to
resolve myself.
Basically, I want to translate a condition from Rex to a Linq4j expression to
use it in generated code.
In my example the Condition is from Match Recognize and in SQL is:
`up."commission" >
Hi Vladimir,
without beeing a super expert I guess the term "binary" in this context refers
to a compiled package.
The Release Policy [1] states that for a (compiled) artifact the source code
has to be released alongside.
So the images are basically the source for the homepage or documentation
+1 I totally agree.
Julian
Ursprüngliche Nachricht
Betreff: Re: [DISCUSS] Move gitbox notification emails to another list?
Von: Vladimir Sitnikov
An: Apache Calcite dev list
Cc:
+1 to do something about it.
Diverting the messages to another list sounds good.
Vladimir
Congratulations... Would also like to see a preprint.
Von meinem Mobiltelefon gesendet
Ursprüngliche Nachricht
Betreff: Re: Another Calcite-related paper accepted for SIGMOD -- "One SQL to
Rule Them All"
Von: Andrei Sereda
An: dev@calcite.apache.org
Cc:
Congratulations.
When
We also use it for PLC4X and it works flawlessly.
+1
Julian
Am 11.02.19, 11:23 schrieb "Vova Vysotskyi" :
Great idea! Drill website already uses gitbox [1]
+1
[1] https://gitbox.apache.org/repos/asf?p=drill-site.git
Kind regards,
Volodymyr Vysotskyi
19 at 3:23 AM Julian Feinauer
wrote:
> Hey all,
>
> I don't know if this is unusual or undoable due to permission issues as
> I'm no commiter.
> But I'd like to offer my duties as RM.
> I am not that familiar with Calcite releases but just fini
Hey all,
I don't know if this is unusual or undoable due to permission issues as I'm no
commiter.
But I'd like to offer my duties as RM.
I am not that familiar with Calcite releases but just finished my first
official release for an Apache Projekt with PLC4X.
Best
Julian
Am 06.02.19, 21:00
ian
> On Jan 9, 2019, at 9:13 AM, Julian Feinauer
wrote:
>
> Hi all,
>
> as discussed in earlier exchanges (see [1]), I started to work on
implementing MATCH_RECOGNIZE based on Julian (Hydes) work [2].
> I think I made some progress and resol
Hi all,
as discussed in earlier exchanges (see [1]), I started to work on implementing
MATCH_RECOGNIZE based on Julian (Hydes) work [2].
I think I made some progress and resolved some of the problems but I’m at a
stage now where I’d need some advice from more seasoned Calcite dev’s on how to
Hi Lekshmi,
your activity sounds very interesting.
One important thing to note is that Performance testing in Java is always
tricky due to JIT and "warmup" phase of the JVM. Thus it is generally
recommended to do these tests with JMH
(https://openjdk.java.net/projects/code-tools/jmh/).
I
Best,
Hongze
[1] https://issues.apache.org/jira/browse/CALCITE-2266
[2] http://calcite.apache.org/docs/reference.html#json-functions
At 2018-12-29 18:18:59, "Julian Feinauer"
wrote:
>Hi all,
>
>we use Post
Hi all,
we use Postgres a lot and make heavy use of the JSONB datatype [1].
Is there support for something similar in Calcite?
If so, can someone point me to the docs as I’ve not found anything in the list
of builtin functions.
There are several reasons why it would be cool for us to have
because I
was looking forward to working on this code over the Xmas break.
Julian
> On Dec 28, 2018, at 3:02 PM, Julian Feinauer
wrote:
>
> Hi Julian,
>
> as it got really confusing for me with the eps-NFA (and all the
concurrent partial
ec 27, 2018, at 1:19 PM, Julian Feinauer
wrote:
>
> Hi Julian,
>
> regarding "^" and "$" it seems like Zhiqiang already introduced the
fields strictStart and strictEnd in org.apache.calcite.rel.core.Match. But I
agree with you and already
We can sync up when my branch is working.
Julian
> On Dec 26, 2018, at 6:44 AM, Julian Feinauer
wrote:
>
> Hi Julian,
>
> I used [1] as reference. Anchors are explicitly stated as part of the
syntax and explained as:
>
>> Anchors w
Julian Feinauer created CALCITE-2756:
Summary: ForEachStatement generates invalid Java Code
Key: CALCITE-2756
URL: https://issues.apache.org/jira/browse/CALCITE-2756
Project: Calcite
it will be difficult to change that.
Julian
> On Dec 25, 2018, at 2:56 PM, Julian Feinauer
wrote:
>
> Hey,
>
> it's once again me, JulianF.
> I started work on the Automaton / Matcher and implemented OR and OPTIONAL
("?"
%3e>>
>
> [4]
> https://github.com/Zhiqiang-He/calcite/tree/calcite-1935-MR-Implementation3
> <https://github.com/Zhiqiang-He/calcite/tree/calcite-1935-MR-Implementation3><https://github.com/Zhiqiang-He/calcite/tree/calcite-1935-MR-Implementation3%3e>>
>
>
> &g
Hi all,
I am kind of cross posting this but I think it could be interesting for both
communities, see my original post on the plc4x dev ML [1].
I just finished a first implementation of a PLC4X-Calcite Adapter.
What one can do with that is to create a Table (Scannable or Streamable) with
values
on't end, you need
> to
> > decide how this is handled which usually amounts to a choice of
windowing
> > algorithm. There are a few other things to think about. The presentation
> > linked below from Julian Hyde has a nice overview
> >
> > https
t/julianhyde/streaming-sql-62376119
>
> --
> Michael Mior
> mm...@apache.org
>
>
> Le mar. 18 déc. 2018 à 02:28, Julian Feinauer
> a écrit :
>
>> Hi Michael,
>>
>> yes, our workloads are usually in the cont
org/docs/stream.html
--
Michael Mior
mm...@apache.org
Le dim. 16 déc. 2018 à 18:39, Julian Feinauer
a écrit :
> Hi Calcite-devs,
>
> I just had a very interesting mail exchange with Julian (Hyde) on the
> incubator list [1]. It was about our proje
Hi Calcite-devs,
I just had a very interesting mail exchange with Julian (Hyde) on the incubator
list [1]. It was about our project CRUNCH (which is mostly about time series
analyses and signal processing) and its relation to relational algebra and I
wanted to bring the discussion to this list
Sorry, this is an old mail which got sent accidentally again by my mail program.
Please ignore this and excuse this.
Julian
Am 21.11.18, 16:34 schrieb "Julian Feinauer" :
Hi Julian,
I decided to reply to this (old) email, because here some facts are noted.
Funni
Hi Julian,
I decided to reply to this (old) email, because here some facts are noted.
Funnily, Apache Flink released their MATCH_RECOGNIZE Implementation yesterday.
So I recall that you and Zhigiang He did something on this.
I would like to have such a feature in Calcite (as stated in the other
Hi,
if I understand your question correctly, you want to "transform" a SQL
Statement into calls to pandas, is this right?
If so, you could implement a specific Call Convention, see [1].
By implementing your own Implementor you could then build together your pandas
call.
Julian
[1]
ect) seems to be appropriate solution
but what should I pass as dialect?
On Wed, Oct 31, 2018 at 4:05 PM Julian Feinauer <
j.feina...@pragmaticminds.de> wrote:
> Hi Shashwat,
>
> the implementation to use should be SqlBasicCall.
> And to achieve wha
On Wed, Oct 31, 2018 at 3:42 PM Julian Feinauer <
j.feina...@pragmaticminds.de> wrote:
> Hi Shashwat,
>
> Calcite does this by a Call to the "AS" Operator (basically value as v is
> just syntactic sugar for AS(value, v)).
Hi Shashwat,
Calcite does this by a Call to the "AS" Operator (basically value as v is just
syntactic sugar for AS(value, v)).
So you need to create a call node (SqlCall) with the AS Operator
(SqlStdOperatorTable.AS) and as operands you node and an SqlIdentifier for the
Alias.
But your
ey also bring
streams, constant tables and time-varying tables under the same roof.
Do you think this approach is worthwhile? Are there other data models in
signal processing/event processing that we could bring into the relational
model by applying transforms?
Julian
/3acd92b45c21e081f781affc8cb5700d972f9b0b
Am 25.10.18, 22:46 schrieb "Julian Feinauer" :
Hi Julian,
I filed a Jira form y general suggestion about "Timeseries SQL"
(CALCITE-2640).
For the discussion in the other thread, I had a look into the present state
of the code (from you and Zhiq
I'm familiar enough with the codebase to make the whole thing work.
Thus, if anybody of the seasoned Calcite devs could offer some help I would be
happy to discuss details of the implementation and support the implementation
as good as possible.
Best
Julian
Am 23.10.18, 07:57 schrieb "Julian F
Julian Feinauer created CALCITE-2640:
Summary: Support for SQL on Timeseries / Traces
Key: CALCITE-2640
URL: https://issues.apache.org/jira/browse/CALCITE-2640
Project: Calcite
Issue
Hi Julian,
I decided to reply to this (old) email, because here some facts are noted.
Funnily, Apache Flink released their MATCH_RECOGNIZE Implementation yesterday.
So I recall that you and Zhigiang He did something on this.
I would like to have such a feature in Calcite (as stated in the other
id foundation.
Julian
> On Oct 21, 2018, at 10:04 PM, Julian Feinauer
wrote:
>
> Hi Mark,
>
> thanks for your reply.
> In fact, I'm sorry that I missed to mention MATCH_RECOGNIZE in my
original mail.
> I was real
transform it to a Query with MATCH_RECOGNIZE.
So if there is still help needed please let me know (a quick search through the
JIRA showed CALCITE-1935) which seems like there is still some implementation
missing.
Best
Julian
Am 22.10.18, 02:41 schrieb "Mark Hammond" :
Hi Julian
Dear calcite devs,
I follow the project for a long time and love how calcite made it possible to
use SQL everywhere (have done several sql interfaces on top of specific file
formats myself). I also like the strong support for streaming SQL.
The reason I'm writing this email is not only to give
vOYTS_tMGh=xASVqgC47DpBQQtYgc8r7BjNuvR+w=hh...@mail.gmail.com%3E
On Mon, Aug 13, 2018 at 5:37 AM Julian Feinauer
wrote:
>
> Hi devs,
>
> First, a short disclaimer, I am cross-posting this question on the
calcite and on the SQuirrelSQL mailing list as I’m
Hey Guys,
first of all, great work!
I’m following the Calcite project since I worked a lot with Drill about 8
months ago and I’m very pleased about how everything has developed.
We are currently trying to replace our self-made SQL Parser and Engine with
Calcite.
But I have one question as
87 matches
Mail list logo