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

2024-02-06 Thread Thomas Rebele
ep=90&dir=0 Cordialement / Best Regards, *Dr. Thomas Rebele* | R&D 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: A

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

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

[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&D 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,

[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); > } >

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&D 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 anyth

Re: [DISCUSS] Github PR link to JIRA issue

2022-03-30 Thread Thomas Rebele
e link has been removed because the ticket is not available? Cordialement / Best Regards, *Thomas Rebele, PhD* | R&D 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 > t

[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&D Developer | Germany | www.tibco.com On

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&D Developer | Germany | www.tibco.com On Thu, Jan 27, 2022 at 7:38 AM Aitozi wrote: > Hi community: > I'm new to ca

Re: Failing task :linq4j:jandexMain when executing CheckerFramework

2021-12-17 Thread Thomas Rebele
/:$PATH" 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&D Developer | Germany |

[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

Failing task :linq4j:jandexMain when executing CheckerFramework

2021-12-16 Thread Thomas Rebele
an exception. ... Is there an easy way to fix the problem? The fallback solution is to rely on the Github CI, which has passed for the same commit. Cordialement / Best Regards, *Thomas Rebele, PhD* | R&D Developer | Germany | www.tibco.com

[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&D Devel

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&D 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 see

[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&D Developer | Germany | www.tibco.com On Mon, Aug 16

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&D 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

Visualization of Graphviz

2021-08-12 Thread Thomas Rebele
Would there be interest in such a tool? Cordialement / Best Regards, *Thomas Rebele, PhD* | R&D 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

Re: [ANNOUNCE] Ruben Quesada Lopez joins Calcite PMC

2020-08-13 Thread Thomas Rebele
Congrats, Ruben! Cordialement / Best Regards, *Thomas Rebele* | R&D 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,

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

2020-08-10 Thread Thomas Rebele
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&D Developer

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

2020-08-07 Thread Thomas Rebele
https://15721.courses.cs.cmu.edu/spring2019/papers/24-costmodels/p204-leis.pdf Cordialement / Best Regards, *Thomas Rebele* | R&D 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