Re: Re: [Question] Unknown cost calculation/propagation in RelSubsets

2024-02-06 Thread Thomas Rebele
Cordialement / Best Regards, *Dr. Thomas Rebele* | R Developer | Germany | *E* *treb...@tibco.com * | *W* *www.cloud.com <http://www.cloud.com/>* *Cloud SG Germany GmbH* | ℅ Citrix Systems GmbH, Erika-Mann-Straße 67-69, 80636 München Deutschland | Registergericht: Amtsgericht München, HRB

Re: [Question] Unknown cost calculation/propagation in RelSubsets

2024-01-16 Thread Thomas Rebele
/calcite/blob/c4042a34ef054b89cec1c47fefcbc8689bad55be/core/src/main/java/org/apache/calcite/plan/volcano/VolcanoPlanner.java#L722 Cordialement / Best Regards, *Dr. Thomas Rebele* | R Developer | Germany | *E* *treb...@tibco.com * | *W* *www.cloud.com <http://www.cloud.com/>* *Cloud SG German

[jira] [Created] (CALCITE-5965) Avoid unnecessary String concatenations in the RexFieldAccess constructor to improve the performance

2023-08-29 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-5965: -- Summary: Avoid unnecessary String concatenations in the RexFieldAccess constructor to improve the performance Key: CALCITE-5965 URL: https://issues.apache.org/jira/browse

[jira] [Created] (CALCITE-5686) Generalize return types of the linq4j expression shuttle

2023-05-04 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-5686: -- Summary: Generalize return types of the linq4j expression shuttle Key: CALCITE-5686 URL: https://issues.apache.org/jira/browse/CALCITE-5686 Project: Calcite

Re: Push unparsed SQL select statement into RelBuilder

2023-01-13 Thread Thomas Rebele
to TableFunctionScan? Cordialement / Best Regards, *Dr. Thomas Rebele* | R Developer | Germany | *E* *treb...@tibco.com * | *W* *www.tibco.com <http://www.tibco.com/>* *TIBCO Software GmbH* | St.-Martin-Str. 106, 81669 München, Deutschland | Registergericht: Amtsgericht München, HRB

[jira] [Created] (CALCITE-5473) Keep more collations in RelMdCollation#project for monotonic RexCalls

2023-01-12 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-5473: -- Summary: Keep more collations in RelMdCollation#project for monotonic RexCalls Key: CALCITE-5473 URL: https://issues.apache.org/jira/browse/CALCITE-5473 Project

[jira] [Created] (CALCITE-5472) RexCallBinding#getOperandMonotonicity should return CONSTANT for RexLiterals

2023-01-12 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-5472: -- Summary: RexCallBinding#getOperandMonotonicity should return CONSTANT for RexLiterals Key: CALCITE-5472 URL: https://issues.apache.org/jira/browse/CALCITE-5472

[jira] [Created] (CALCITE-5471) RelSupplier.SqlRelSupplier#apply should use .project(), not .rel

2023-01-12 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-5471: -- Summary: RelSupplier.SqlRelSupplier#apply should use .project(), not .rel Key: CALCITE-5471 URL: https://issues.apache.org/jira/browse/CALCITE-5471 Project

[jira] [Created] (CALCITE-5470) VolcanoPlanner removes a necessary sort

2023-01-12 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-5470: -- Summary: VolcanoPlanner removes a necessary sort Key: CALCITE-5470 URL: https://issues.apache.org/jira/browse/CALCITE-5470 Project: Calcite Issue Type

Re: Conversion from Bindable to Enumerable

2022-09-27 Thread Thomas Rebele
all)); > builder.add(Expressions.return_(null, resultVar)); > return implementor.result(physType, builder.toBlock()); > } > } > > private static EnumerableRel getEnumerableRel(BindableRel bindable) { > return new EnumerableBindableRel(bindable); > } > Cordi

Re: Changes to the rule pattern interface

2022-04-12 Thread Thomas Rebele
read.html/rfdf6f9b7821988bdd92b0377e3d293443a6376f4773c4c658c891cf9%40%3Cdev.calcite.apache.org%3E> . Cordialement / Best Regards, *Thomas Rebele, PhD* | R Developer | Germany | www.tibco.com On Tue, Apr 12, 2022 at 6:10 PM Gavin Ray wrote: > I don't have any weight behind my opinion or experience, > but anything that

Re: [DISCUSS] Github PR link to JIRA issue

2022-03-30 Thread Thomas Rebele
been removed because the ticket is not available? Cordialement / Best Regards, *Thomas Rebele, PhD* | R Developer | Germany | www.tibco.com On Wed, Mar 30, 2022 at 7:57 PM Julian Hyde wrote: > It seems to happen sporadically. Maybe the commit message of the PR needs > to start with e

[jira] [Created] (CALCITE-5061) Improve recursive application of the field trimming

2022-03-23 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-5061: -- Summary: Improve recursive application of the field trimming Key: CALCITE-5061 URL: https://issues.apache.org/jira/browse/CALCITE-5061 Project: Calcite

Re: ARRAY_CONCAT does not work

2022-02-04 Thread Thomas Rebele
Hello, SqlParserTest might help you. It has some checks related to BIG_QUERY. Maybe a .parserConfig(SqlParser.Config.DEFAULT.withConformance(SqlConformanceEnum.BIG_QUERY)) could fix the problem. Cordialement / Best Regards, *Thomas Rebele, PhD* | R Developer | Germany | www.tibco.com On Fri

Re: Failed to import gradle

2022-01-27 Thread Thomas Rebele
Hello, the Calcite mailing list removes pictures. Could you please post the error message in text form? Cordialement / Best Regards, *Thomas Rebele, PhD* | R Developer | Germany | www.tibco.com On Thu, Jan 27, 2022 at 7:38 AM Aitozi wrote: > Hi community: > I'm new to calcite com

Re: Failing task :linq4j:jandexMain when executing CheckerFramework

2021-12-17 Thread Thomas Rebele
ot; JAVA_HOME=/usr/lib/jvm/java-1.11.0-openjdk-amd64 ./gradlew build -x test -PenableCheckerframework > Configure project : Building Apache Calcite 1.29.0-SNAPSHOT > Task :linq4j:jandexMain FAILED ... Cordialement / Best Regards, *Thomas Rebele, PhD* | R Developer | Germany | www.tibco.com

[jira] [Created] (CALCITE-4947) Checkstyle fails on classes generated by Intellij when using option "build and run [tests] using Intellij IDEA"

2021-12-17 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-4947: -- Summary: Checkstyle fails on classes generated by Intellij when using option "build and run [tests] using Intellij IDEA" Key: CALCITE-4947 URL: https://issues.apach

[jira] [Created] (CALCITE-4944) Add a property to activate the RuleMatchVisualizer

2021-12-16 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-4944: -- Summary: Add a property to activate the RuleMatchVisualizer Key: CALCITE-4944 URL: https://issues.apache.org/jira/browse/CALCITE-4944 Project: Calcite

Re: UNNEST in relational algebra

2021-11-16 Thread Thomas Rebele
Hello, I don't understand what you want to do here. There's an UNNEST operator in Calcite, see the comment at the bottom of this section: https://calcite.apache.org/docs/reference.html#collection-functions. Cordialement / Best Regards, *Thomas Rebele, PhD* | R Developer | Germany | www.tibco.com

Re: Lots of warnings with latest gradle?

2021-10-13 Thread Thomas Rebele
15+36-1562) OpenJDK 64-Bit Server VM (build 15+36-1562, mixed mode, sharing) Cordialement / Best Regards, *Thomas Rebele, PhD* | R Developer | Germany | www.tibco.com On Wed, Oct 6, 2021 at 4:23 AM Jacques Nadeau wrote: > Hey all, Calcite master has the latest gradle in it now. It seems like

[jira] [Created] (CALCITE-4848) Adding a HAVING condition to a query with a dynamic parameter makes the result empty

2021-10-12 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-4848: -- Summary: Adding a HAVING condition to a query with a dynamic parameter makes the result empty Key: CALCITE-4848 URL: https://issues.apache.org/jira/browse/CALCITE-4848

Re: Runtime Exception while using SqlParse.

2021-08-17 Thread Thomas Rebele
Hi Jariv, are you sure you want to join two columns of Purchase: *Purchase.Product_ID = Purchase.ID*? If that's the cause of the exception, the error message could be improved. Cordialement / Best Regards, *Thomas Rebele, PhD* | R Developer | Germany | www.tibco.com On Mon, Aug 16, 2021 at 10

Re: Visualization of Graphviz

2021-08-13 Thread Thomas Rebele
Thank you for pointing out the visualizer in the Tempura branch. It looks quite promising. Cordialement / Best Regards, *Thomas Rebele, PhD* | R Developer | Germany | www.tibco.com On Thu, Aug 12, 2021 at 7:19 PM Julian Hyde wrote: > I don’t have a strong opinion on this, but I want to po

Visualization of Graphviz

2021-08-12 Thread Thomas Rebele
there be interest in such a tool? Cordialement / Best Regards, *Thomas Rebele, PhD* | R Developer | Germany | www.tibco.com

[jira] [Created] (CALCITE-4691) Incorrect handling of NOT IN and NULL values

2021-07-12 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-4691: -- Summary: Incorrect handling of NOT IN and NULL values Key: CALCITE-4691 URL: https://issues.apache.org/jira/browse/CALCITE-4691 Project: Calcite Issue

[jira] [Created] (CALCITE-4689) EnumerableUncollectRule causes an IllegalArgumentException: Type mismatch: the field sizes are not equal

2021-07-09 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-4689: -- Summary: EnumerableUncollectRule causes an IllegalArgumentException: Type mismatch: the field sizes are not equal Key: CALCITE-4689 URL: https://issues.apache.org/jira/browse

[jira] [Created] (CALCITE-4680) AssertionError: contains $cor1, while converting SQL query with UNNEST to logical plan

2021-07-06 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-4680: -- Summary: AssertionError: contains $cor1, while converting SQL query with UNNEST to logical plan Key: CALCITE-4680 URL: https://issues.apache.org/jira/browse/CALCITE-4680

[jira] [Created] (CALCITE-4540) The constructor of EnumerableWindow should be public

2021-03-17 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-4540: -- Summary: The constructor of EnumerableWindow should be public Key: CALCITE-4540 URL: https://issues.apache.org/jira/browse/CALCITE-4540 Project: Calcite

[jira] [Created] (CALCITE-4530) EnumerableWindow.copy(...) should adapt the rowType

2021-03-10 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-4530: -- Summary: EnumerableWindow.copy(...) should adapt the rowType Key: CALCITE-4530 URL: https://issues.apache.org/jira/browse/CALCITE-4530 Project: Calcite

[jira] [Created] (CALCITE-4404) Missing LogicalCorrelate when using FILTER_SUB_QUERY_TO_CORRELATE for nested subqueries

2020-11-17 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-4404: -- Summary: Missing LogicalCorrelate when using FILTER_SUB_QUERY_TO_CORRELATE for nested subqueries Key: CALCITE-4404 URL: https://issues.apache.org/jira/browse/CALCITE-4404

[jira] [Created] (CALCITE-4264) The query planner should take CPU cost into account

2020-09-18 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-4264: -- Summary: The query planner should take CPU cost into account Key: CALCITE-4264 URL: https://issues.apache.org/jira/browse/CALCITE-4264 Project: Calcite

[jira] [Created] (CALCITE-4256) RexSimplify should not simplify P AND P to P, if it contains a call to RAND or RAND_INTEGER

2020-09-14 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-4256: -- Summary: RexSimplify should not simplify P AND P to P, if it contains a call to RAND or RAND_INTEGER Key: CALCITE-4256 URL: https://issues.apache.org/jira/browse/CALCITE-4256

[jira] [Created] (CALCITE-4189) Simplify 'X OR IS NOT TRUE X' to 'TRUE'

2020-08-21 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-4189: -- Summary: Simplify 'X OR IS NOT TRUE X' to 'TRUE' Key: CALCITE-4189 URL: https://issues.apache.org/jira/browse/CALCITE-4189 Project: Calcite Issue Type

Re: [ANNOUNCE] Ruben Quesada Lopez joins Calcite PMC

2020-08-13 Thread Thomas Rebele
Congrats, Ruben! Cordialement / Best Regards, *Thomas Rebele* | R Developer | 18 rue du 4 septembre, 75002 Paris, France | www.tibco.com On Thu, Aug 13, 2020 at 12:54 AM Francis Chuang wrote: > Congratulations, Ruben! > > Francis > > On 13/08/2020 3:43 am, Andr

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

2020-08-10 Thread Thomas Rebele
a particular join should be translated into a hash join, merge join, or correlate. With a different cardinality of the inputs, one algorithm or the other might be better. The real-world statistics might help to decide which one to choose. Cordialement / Best Regards, *Thomas Rebele* | R Developer | 18 rue

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

2020-08-07 Thread Thomas Rebele
es.cs.cmu.edu/spring2019/papers/24-costmodels/p204-leis.pdf Cordialement / Best Regards, *Thomas Rebele* | R Developer | 18 rue du 4 septembre, 75002 Paris, France | www.tibco.com

[jira] [Created] (CALCITE-4157) Use a different sort algorithm for EnumerableDefaults.orderBy(...)

2020-08-05 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-4157: -- Summary: Use a different sort algorithm for EnumerableDefaults.orderBy(...) Key: CALCITE-4157 URL: https://issues.apache.org/jira/browse/CALCITE-4157 Project

[jira] [Created] (CALCITE-3978) RelDecorrelator on a plan with field accesses does not update field indices when adding a projection

2020-05-07 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-3978: -- Summary: RelDecorrelator on a plan with field accesses does not update field indices when adding a projection Key: CALCITE-3978 URL: https://issues.apache.org/jira/browse

[jira] [Created] (CALCITE-3977) RelDecorrelator produces incorrect plans if the input plan contains field accesses

2020-05-07 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-3977: -- Summary: RelDecorrelator produces incorrect plans if the input plan contains field accesses Key: CALCITE-3977 URL: https://issues.apache.org/jira/browse/CALCITE-3977