Re: New rule for Converting UNION ALL with same inputs but different filters to single input with OR FILTER

On a more general fusion case, you could probably refer to osdi paper "resin general sub query fusion" which has chapters talking about general union fusion that deals with the case Julian pointed out. Btw, per my understanding cases of union fusion is not that many in practice. Curious to know

Re: [DISCUSS] Trolls and community

I echo Jacques’ nice and decent comments on this. *"""* *- I think Julian and Vladimir are far and above the most prolificcontributors on the project (by any measure I can use: code, commits, emailresponses, longevity, consistency, releases, etc). [3]- I think Julian and Vladimir

Re: [ANNOUNCE] New committer: Vladimir Ozerov

Congrats. just found the blog: https://www.querifylabs.com/author/vladimir-ozerov On Thu, Jun 24, 2021 at 2:27 PM Alessandro Solimando < alessandro.solima...@gmail.com> wrote: > Congratulations Vladimir, well deserved, I had the chance to read some > of the blog posts and I have appreciated them

Re: Proposal to extend Calcite into a incremental query optimizer

gt;>>> for a > >>>>> Zoom > >>>>>>>>>>>>> meeting and discuss how to integrate Tempura into > >> Calcite. > >>>>>>>>>>>>> > >>>>>>>>>>>>> Since some of our team members are i

Re: Proposal to extend Calcite into a incremental query optimizer

it would be very nice to see a POC of your work. On Thu, Jan 28, 2021 at 10:21 AM Botong Huang wrote: > Hi Julian, > > Just wondering if there are any updates? We are wondering if it would help > to post our code for a quick preview. > > Thanks, > Botong > > On Fri, Jan 1, 2021 at 11:04 AM

Re: [DISCUSS] Does anybody think this is debuging unfriendly: "call.transformTo(relBuilder.build())"

+1, `step into` causes bad debug experience. On Mon, Nov 23, 2020 at 6:13 PM JiaTao Tao wrote: > I can create a JIRA and update the code, it's minor but I think it is good > for us. > > > Regards! > > Aron Tao > > > Haisheng Yuan 于2020年11月23日周一 下午5:53写道： > > > Agree with Jiatao, I had the same

Re: [DISCUSSION] Rename master branch to main

I am against this change -1. (probably vain anyways) @Michael Mior yes there are people against it. nobody expressed any gain from this. nobody required this change. This change expressed a thinking in `incorrect` direction. (personal opinion) On Wed, Jul 29, 2020 at 10:31 PM Michael Mior

Re: Question of Calcite Dynamic Code Generation Feature

like Haisheng mentioned, it is certainly debuggable, although not as convenient as plain java code. my understanding is that, the java code generation is merely a demonstration of the physical plan implementation. there are all kinds of ways to implement the logical plan, java code is merely a

Re: stored procedure

pig latin is the closest as I am aware of, refer to the pig adapter in project folder. On Mon, May 11, 2020 at 4:35 AM Lekshmi wrote: > Hi, > As part of my research project, we would like to use the stored > procedure. do you have any pointers for the implementation of stored > procedures or

Re: [DISCUSS] Remove Kotlin

I've used the new version calcite with new version of IntelliJ, everything works. I like that. I can see valadmir put some efforts in this, I respect that. and all effort put in to the codebase should be respected. from my side, I don't contribute as much now, but occasionally I would look at the

Re: Re: [ANNOUNCE] Haisheng Yuan joins Calcite PMC

congrats, well deserved. On Mon, Nov 11, 2019 at 2:26 PM Wang Yanlin <1989yanlinw...@163.com> wrote: > Congrats Haisheng! Well deserved!-- > > Best, > Wang Yanlin > > > > 在 2019-11-11 14:09:58，"Leonard Xu" 写道： > >Congratulations! HaiSheng > > > >Best, > >Leonard Xu > >> On 2019年11月11日, at

Re: [QUESTION] One query executed on two or more different data storages through Calcite

my intuition is leave the plans alone. when actually execute the TABLESCAN PLAN, send it to two targets. refer to the csv example. On Tue, Oct 22, 2019 at 9:26 PM Juan Pan wrote: > Hi Danny and Julian > > > Thanks, i did some researches after listened to your suggestions. It seems > not an easy

Re: [DISCUSS] Small contributions

I really liked the compact commit log messages in calcite repo. on the one hand contributions should be encouraged, on the other hand I don't want to see commit log jammed with 'fix typo' stuff. let's hope that won't be the case. On Sat, Sep 28, 2019 at 4:27 AM Julian Feinauer <

Re: Calcite swag

Nice 在 2019年8月13日星期二，Danny Chan 写道： > Nice t-shirt, I like the black one ~ > > Best, > Danny Chan > 在 2019年8月12日 +0800 PM8:49，Michael Mior ，写道： > > For anyone who may be interested, Calcite swag now available at the > > link below. You'll see a link there to view the logo on other products > >

Re: Filterable table

talking about this class reminds me of my own usage of ProjectableFilterable. it works. but this feels like a very bad design, what if I want to push down Aggregation ? AggregatableProjectableFilterable? I don't know the intention of the initial design, but this just doesn't feel right. On Mon,

Re: Is there a document that can help understand Calcite's code generation?

the way worked for me is to run through some rather simple SQL queries. nothing unusual though, it is really just a big block of `if else` stuff to concatenate java code represented by strings, which probably could be better represented using freeMarker. On Thu, Aug 1, 2019 at 9:00 PM Muhammad

Re: Giving the Calcite logo some love

I will vote "logo-alt1-v5.svg " , looks nice. On Wed, Jun 5, 2019 at 6:11 AM Stamatis Zampetakis wrote: > I created a branch to gather all alternative logos [1]. > > Among the two aforementioned proposals, I added a

sql to rule machine learning

found some efforts in bringing sql to machine learning world. https://github.com/sql-machine-learning/sqlflow/blob/develop/doc/syntax.md any comments ? -- ~~~ no mistakes ~~

Re: using calcite to read csv files from hdfs.

I would say calcite csv example is a good start point. On Fri, Mar 8, 2019 at 10:10 AM 勾王敏浩 wrote: > Hello, everyone. > This is Wangminhao Gou. I have an urgent need now. I want to read CSV > files from remote HDFS and parse them using calcite. Now that I can use a > file stream to get this CSV

Re: Will the number of traits in the traitSet affect the time of Volcano optimization?

I guess trait really feels different from your config. I guess `Context` is where you are looking for, see below. /** * Does nothing. * * @deprecated Previously, this method installed the cancellation-checking * flag for this planner, but is now deprecated. Now, you should add a * {@link

Re: [DISCUSS] Where do we draw the line?

haven't contributed a while. I mostly agree with Julian's comment. I'm not a native English speaker and I think that line of comment could be interpreted as `humorous` or may be at least intended to. if I was contributing that feature, I would care more if there are comments to help push my

[jira] [Created] (CALCITE-2467) Please update OWASP Dependency Check version to current 3.3.1

Albert Baker created CALCITE-2467: - Summary: Please update OWASP Dependency Check version to current 3.3.1 Key: CALCITE-2467 URL: https://issues.apache.org/jira/browse/CALCITE-2467 Project: Calcite

Re: [DISCUSS] Committer duties

I saw FLINK has a weekly update, this might be a useful way to let people know more about what's happening. On Wed, Mar 28, 2018 at 10:10 AM, Michael Mior wrote: > I wasn't suggesting that people submitting issues or PRs do the assigning. > Aside from time, my biggest

Re: [ANNOUNCE] New committer: Zhen Wang

Thanks for the intro and for inviting me, Julian. really honored to be part of the community, generally I'm interested in the idea of writing higher level specifications and let the `machine/core` to handle the performance and other details. standard SQL is one such example, and calcite is one

Re: Ask Advices on Calcite Streaming SQL

Hi, the question seems too broad and not well framed. but in general if you want to understand more about streaming within `calcite`. - Firstly: The document - Secondly: Julian also led several discussions in the dev thread, you might be able to

Re: sqlline not available after compile/install/package

thanks, this solves my issue. On Sun, May 15, 2016 at 12:09 AM, Julian Hyde <jh...@apache.org> wrote: > Try this: > > $ rm target/fullclasspath.txt > $ ./sqlline > > Does it work now? > > What java version? > > Julian > > > On May 14, 2016, a

Re: Calcite on StackOverflow

last time I was looking, think there were totally less than 5 questions or so. Trend is changing. ^^ On Thu, Mar 31, 2016 at 5:36 PM, Julian Hyde wrote: > Looking for ways to contribute to Calcite? There are a few questions > tagged “calcite” that do not yet have answers. It

hashCode functions using multiply method

Hi , I've noticed a lot of the places, calcite codes is using something like this: result = 31 * result + (body != null ? body.hashCode() : 0); using multiply in hash code calculation probably isn't best practice. something like shift operator should be more efficient. since the project is

physical plan concepts in calcite

Hi I haven't read anything related to that. I wonder if there are any concepts related to that. I noticed when phoenix adopting calcite it is wrapping around the logical plans. thought it should only override corresponding physical plans etc... thanks. -- ~~~ no mistakes