Re: RelFieldTrimmer misses optimization opportunity for always false condition

Thanks for reporting this, Vladimir. You can file a JIRA for it. Best, Chuwnei On Wed, Aug 12, 2020 at 12:06 AM Julian Hyde wrote: > I’m not entirely sure why RelFieldTrimmer doesn’t touch the “*” case. > Perhaps because its main job is to trim fields, and so if there’s no field > trimming

Re: [ANNOUNCE] Ruben Quesada Lopez joins Calcite PMC

Congrats, Ruben! Best Forward XING JIN 于2020年8月12日周三 上午8:58写道： > Congrats, Ruben! > > 953396112 <953396...@qq.com> 于2020年8月12日周三 上午7:47写道： > > > Congratulations,Ruben! > > > > > > xzh > > --原始邮件-- > > 发件人: > >

Re: [ANNOUNCE] Ruben Quesada Lopez joins Calcite PMC

Congratulations ~ Best, Danny Chan 在 2020年8月12日 +0800 AM9:57，chunwei ，写道： > Congrats, Ruben! > > On Wed, Aug 12, 2020 at 8:58 AM XING JIN wrote: > > > Congrats, Ruben! > > > > 953396112 <953396...@qq.com> 于2020年8月12日周三 上午7:47写道： > > > > > Congratulations,Ruben! > > > > > > > > > xzh > > >

Re: [ANNOUNCE] Ruben Quesada Lopez joins Calcite PMC

Congratulations, Ruben! chunwei 于2020年8月12日周三 上午9:57写道： > Congrats, Ruben! > > On Wed, Aug 12, 2020 at 8:58 AM XING JIN wrote: > > > Congrats, Ruben! > > > > 953396112 <953396...@qq.com> 于2020年8月12日周三 上午7:47写道： > > > > > Congratulations,Ruben! > > > > > > > > > xzh > > >

Re: [ANNOUNCE] Ruben Quesada Lopez joins Calcite PMC

Congrats, Ruben! On Wed, Aug 12, 2020 at 8:58 AM XING JIN wrote: > Congrats, Ruben! > > 953396112 <953396...@qq.com> 于2020年8月12日周三 上午7:47写道： > > > Congratulations,Ruben! > > > > > > xzh > > --原始邮件-- > > 发件人: > >

Re: [ANNOUNCE] Ruben Quesada Lopez joins Calcite PMC

Congrats, Ruben! 953396112 <953396...@qq.com> 于2020年8月12日周三 上午7:47写道： > Congratulations,Ruben! > > > xzh > --原始邮件-- > 发件人: > "dev" > < >

??????[ANNOUNCE] Ruben Quesada Lopez joins Calcite PMC

Congratulations,Ruben! xzh ---- ??: "dev"

Re: [ANNOUNCE] Ruben Quesada Lopez joins Calcite PMC

Congrats, Ruben! On 2020/08/11 21:53:47, Stamatis Zampetakis wrote: > I'm pleased to announce that Ruben has accepted an invitation to > join the Calcite PMC. Ruben has been a consistent and helpful > figure in the Calcite community for which we are very grateful. We > look forward to the

Re: [DISCUSS] Sarg (search argument) to generalize and replace IN in RexCall

> I am proposing to use sargs only where we would today use RexCall(IN). The > data structures have about the same size. Sargs are sorted. I cannot see any > cases that would become more expensive. IIRC, RexCall(IN) is not supported yet. With sargs, you have to sort it, no matter explicitly or

[ANNOUNCE] Ruben Quesada Lopez joins Calcite PMC

I'm pleased to announce that Ruben has accepted an invitation to join the Calcite PMC. Ruben has been a consistent and helpful figure in the Calcite community for which we are very grateful. We look forward to the continued contributions and support. Please join me in congratulating Ruben! -

Re: RelToSqlConverter NullPointerException

Thanks for reporting this. Please file a JIRA case with the necessary information. Also it would be helpful if you could refactor your test case as part of RelToSqlConverterTest [1]. Best, Stamatis [1]

Re: Gather real world statistics about row count, CPU, and IO cost

Any help for improving the cost model is much appreciated. I am not sure what you have in mind when you mention real-world statistics but I think you could also start with the stats provided by synthetic datasets such as Foodmart, TPC-H and TPC-DS. Foodmart, TPC-H and TPC-DS come along with a

Re: Contribute to Calcite

Hi Malte, I've added you as a contributor on JIRA. Welcome to the project! Best, Stamatis On Tue, Aug 11, 2020 at 7:42 PM Malte Bellmann wrote: > Hello, > > I’d like to contribute to Calcite, could you please give me contribution > permission on JIRA. > > JIRA Username: MalteBellmann > >

Apache Calicte learning curve

Hi Team, I am working as a Software Developer in data migration sector. We use the Apache-Calcite framework. I am trying to learn how to use it and apparently it has a steep learning curve. I went through the documentation but as a beginner it is difficult to grasp. Can you provide me some useful

Re: [VOTE] Release apache-calcite-1.25.0 (release candidate 0)

Hi All, I plan to close the vote tomorrow (Aug 12th). If you still want to validate RC0 please do so before Wednesday. Regards, Andrei. On Tue, Aug 11, 2020 at 1:13 PM Andrei Sereda wrote: > Thanks, Julian, for the hint. I'll update the KEYS file. > > On Tue, Aug 11, 2020 at 11:59 AM Julian

Re: [VOTE] Release apache-calcite-1.25.0 (release candidate 0)

Thanks, Julian, for the hint. I'll update the KEYS file. On Tue, Aug 11, 2020 at 11:59 AM Julian Hyde wrote: > Andrei, > > Your key’s signature appears in KEYS because you signed Stamatis’s key. > But your key isn’t actually defined in the file. After I imported the file, > your key was still

Re: [DISCUSS] Sarg (search argument) to generalize and replace IN in RexCall

Let’s bring this discussion back to the original question: for these kinds of predicates, is Sarg a better data structure than IN? It absolutely is. There are algorithms in RexSimplify that, for each term in an OR list, simplify using all available predicates, and when they have simplified

Contribute to Calcite

Hello, I’d like to contribute to Calcite, could you please give me contribution permission on JIRA. JIRA Username: MalteBellmann Thank you, Malte

Re: RelFieldTrimmer misses optimization opportunity for always false condition

I’m not entirely sure why RelFieldTrimmer doesn’t touch the “*” case. Perhaps because its main job is to trim fields, and so if there’s no field trimming to be done, it tries to do no harm. The main code responsible for pruning empty relational operators is PruneEmptyRules. I think you should

Re: [VOTE] Release apache-calcite-1.25.0 (release candidate 0)

Andrei, Your key’s signature appears in KEYS because you signed Stamatis’s key. But your key isn’t actually defined in the file. After I imported the file, your key was still ‘unknown’ according to gpg. Julian > On Aug 11, 2020, at 8:04 AM, Andrei Sereda wrote: > >  >> >> * Andrei, I

Re: [VOTE] Release apache-calcite-1.25.0 (release candidate 0)

> * Andrei, I don’t think your key is in KEYS. Be sure to add it before the release announcement. I see my signing key in KEYS $ curl -s https://dist.apache.org/repos/dist/release/calcite/KEYS | grep sereda sig C41CFDDFED34C028 2019-08-19 Andrei Sereda (CODE SIGNING KEY) <

RelFieldTrimmer misses optimization opportunity for always false condition

Hi colleagues, Consider the following query. If the RelFieldTrimmer is applied to this, then the expression is reduced to an empty LogicalValues: SELECT field FROM table WHERE TRUE IS FALSE However, the following query will not be simplified, leaving a table scan with "always false" filter:

Re: [DISCUSS] Publish test JARS

It will have to wait until the release is complete, but yes, I’d like to get this in. Thanks for the patch Vladimir! On Tue, Aug 11, 2020 at 04:38 Danny Chan wrote: > Michael, do you plan to push this function/patch ? We actually need this > too ~ > > Best, > Danny Chan > 在 2020年8月11日 +0800

Re: master locked during 1.25.0 release

Danny, Master branch is still locked. I have backed out your commit https://github.com/apache/calcite/commit/aadb605decd6bb6a853e23fac4b0f479b2397e06 . Julian > On Aug 7, 2020, at 7:03 PM, Andrei Sereda

Re: [VOTE] Release apache-calcite-1.25.0 (release candidate 0)

+1 (binding) Checked keys, hashes, LICENSE, NOTICE, README; compiled and ran tests on Ubuntu/JDK 14; ran RAT. * Andrei, I don’t think your key is in KEYS. Be sure to add it before the release announcement. * There are several files in the source distro that are not in git: an empty ‘arrow’

Re: [VOTE] Release apache-calcite-1.25.0 (release candidate 0)

If I remember well the site preview is not implemented so it is normal that links are broken. I don't know if this has changed recently but if not I think we should remove the site preview links from the draft email to avoid confusion. Best, Stamatis On Mon, Aug 10, 2020 at 8:08 PM Andrei Sereda

Re: [DISCUSS] Publish test JARS

Michael, do you plan to push this function/patch ? We actually need this too ~ Best, Danny Chan 在 2020年8月11日 +0800 AM3:06，Michael Mior ，写道： > Thanks for pointing back to the previous discussion. I'm fine with > publishing separate modules. No real preference on my end since I > haven't found