[jira] [Commented] (CALCITE-3386) CyclicMetadataException gives misleading stack trace

[ https://issues.apache.org/jira/browse/CALCITE-3386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16947058#comment-16947058 ] Haisheng Yuan commented on CALCITE-3386: Hmm, but throwing a new exception can also be used for

[jira] [Commented] (CALCITE-3386) CyclicMetadataException gives misleading stack trace

[ https://issues.apache.org/jira/browse/CALCITE-3386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16946349#comment-16946349 ] Haisheng Yuan commented on CALCITE-3386: Hi Julian, do you still disagree? If so, I need to

[jira] [Commented] (CALCITE-2792) Stackoverflow while evaluating filter with large number of OR conditions

[ https://issues.apache.org/jira/browse/CALCITE-2792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16946307#comment-16946307 ] Haisheng Yuan commented on CALCITE-2792: A balanced binary call with only 32 levels of depth

[jira] [Commented] (CALCITE-3386) CyclicMetadataException gives misleading stack trace

[ https://issues.apache.org/jira/browse/CALCITE-3386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16946247#comment-16946247 ] Haisheng Yuan commented on CALCITE-3386: "CyclicMetadataException is intended for signaling; it

[jira] [Commented] (CALCITE-2792) Stackoverflow while evaluating filter with large number of OR conditions

[ https://issues.apache.org/jira/browse/CALCITE-2792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16946245#comment-16946245 ] Haisheng Yuan commented on CALCITE-2792: Your proposal of not expanding IN is good, however, it

[jira] [Comment Edited] (CALCITE-3386) CyclicMetadataException gives misleading stack trace

[ https://issues.apache.org/jira/browse/CALCITE-3386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16946218#comment-16946218 ] Haisheng Yuan edited comment on CALCITE-3386 at 10/7/19 9:06 PM: - It is

[jira] [Commented] (CALCITE-3386) CyclicMetadataException gives misleading stack trace

[ https://issues.apache.org/jira/browse/CALCITE-3386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16946218#comment-16946218 ] Haisheng Yuan commented on CALCITE-3386: It is an exception, not an error. Throwing an

[jira] [Resolved] (CALCITE-3386) CyclicMetadataException gives misleading stack trace

[ https://issues.apache.org/jira/browse/CALCITE-3386?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3386. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3389) Test can fail if HashSet iterates in a different order

[ https://issues.apache.org/jira/browse/CALCITE-3389?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3389. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-2792) Stackoverflow while evaluating filter with large number of OR conditions

[ https://issues.apache.org/jira/browse/CALCITE-2792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16944937#comment-16944937 ] Haisheng Yuan commented on CALCITE-2792: The reason of stackoverflow for large ORs is the left

[jira] [Commented] (CALCITE-3386) CyclicMetadataException gives misleading stack trace

[ https://issues.apache.org/jira/browse/CALCITE-3386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16944862#comment-16944862 ] Haisheng Yuan commented on CALCITE-3386: Agree > CyclicMetadataException gives misleading

[jira] [Commented] (CALCITE-3334) Refinement for Substitution-Based MV Matching

[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16944198#comment-16944198 ] Haisheng Yuan commented on CALCITE-3334: Also please remove all the unused and retired

[jira] [Commented] (CALCITE-3334) Refinement for Substitution-Based MV Matching

[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16944197#comment-16944197 ] Haisheng Yuan commented on CALCITE-3334: [~jinxing6...@126.com] I still don't quite get why you

[jira] [Commented] (CALCITE-3349) Add Function DDL into SqlKind DDL enum

[ https://issues.apache.org/jira/browse/CALCITE-3349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16944182#comment-16944182 ] Haisheng Yuan commented on CALCITE-3349: Still not able to do it. > Add Function DDL into

[jira] [Resolved] (CALCITE-3347) IndexOutOfBoundsException in FixNullabilityShuttle when using FilterIntoJoinRule

[ https://issues.apache.org/jira/browse/CALCITE-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3347. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-3186) IN expressions in UPDATE statements throws Exceptions

[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16944088#comment-16944088 ] Haisheng Yuan commented on CALCITE-3186: It has been fixed in 1.21.0, by commit

[jira] [Resolved] (CALCITE-3186) IN expressions in UPDATE statements throws Exceptions

[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3186. Resolution: Invalid Can't reproduce the bug, I believe it has been fixed, so closing it.

[jira] [Commented] (CALCITE-3349) Add Function DDL into SqlKind DDL enum

[ https://issues.apache.org/jira/browse/CALCITE-3349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16943804#comment-16943804 ] Haisheng Yuan commented on CALCITE-3349: [~ZhenqiuHuang] I am not able to assign the ticket to

[jira] [Resolved] (CALCITE-3349) Add Function DDL into SqlKind DDL enum

[ https://issues.apache.org/jira/browse/CALCITE-3349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3349. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3346) Enable some ignored tests in RelOptRuleTests

[ https://issues.apache.org/jira/browse/CALCITE-3346?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3346. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3381) When generating SQL for BigQuery (via unparsing), convert Calcite SQL types to BigQuery types

[ https://issues.apache.org/jira/browse/CALCITE-3381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3381. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-2970) Performance issue when enabling abstract converter for EnumerableConvertion

[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16943729#comment-16943729 ] Haisheng Yuan commented on CALCITE-2970: The analysis and solution looks valid at first glance,

[jira] [Commented] (CALCITE-2018) Queries failed with AssertionError: rel has lower cost than best cost of subset

[ https://issues.apache.org/jira/browse/CALCITE-2018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16943249#comment-16943249 ] Haisheng Yuan commented on CALCITE-2018: [~julianhyde] I do agree that ignoring cyclic metadata

[jira] [Commented] (CALCITE-3379) Support expand atom expression in table to relational node conversion

[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16941271#comment-16941271 ] Haisheng Yuan commented on CALCITE-3379: I don't believe the pull request is relevant with this

[jira] [Commented] (CALCITE-3376) VolcanoPlanner CannotPlanException: best rel is null even though there is an option with non-infinite cost

[ https://issues.apache.org/jira/browse/CALCITE-3376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16939845#comment-16939845 ] Haisheng Yuan commented on CALCITE-3376: [~xndai] FYI > VolcanoPlanner CannotPlanException:

[jira] [Resolved] (CALCITE-3374) Error format check result for explain plan as json

[ https://issues.apache.org/jira/browse/CALCITE-3374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3374. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Created] (CALCITE-3372) Add a rule to transform a semijoin into a join on top of aggregate

Haisheng Yuan created CALCITE-3372: -- Summary: Add a rule to transform a semijoin into a join on top of aggregate Key: CALCITE-3372 URL: https://issues.apache.org/jira/browse/CALCITE-3372 Project:

[jira] [Resolved] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match ANTI Join

[ https://issues.apache.org/jira/browse/CALCITE-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3363. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3239) Calc#accept(RexShuttle shuttle) does not update rowType

[ https://issues.apache.org/jira/browse/CALCITE-3239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3239. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3348) AssertionError while determining distribution of Calc

[ https://issues.apache.org/jira/browse/CALCITE-3348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3348. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3287) Union's getRowCount in RelMdRowCount has not consider 'union all'

[ https://issues.apache.org/jira/browse/CALCITE-3287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3287. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3357) Trivial null checking in RelSet#addAbstractConverters

[ https://issues.apache.org/jira/browse/CALCITE-3357?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3357. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Comment Edited] (CALCITE-3352) ProjectToWindowRule sets wrong collation on generated Window

[ https://issues.apache.org/jira/browse/CALCITE-3352?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16933863#comment-16933863 ] Haisheng Yuan edited comment on CALCITE-3352 at 9/19/19 11:55 PM: -- You

[jira] [Commented] (CALCITE-3352) ProjectToWindowRule sets wrong collation on generated Window

[ https://issues.apache.org/jira/browse/CALCITE-3352?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16933863#comment-16933863 ] Haisheng Yuan commented on CALCITE-3352: You mixing physical properties with logical operators.

[jira] [Commented] (CALCITE-3353) ProjectJoinTransposeRule caused AssertionError when creating a new Join

[ https://issues.apache.org/jira/browse/CALCITE-3353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16933854#comment-16933854 ] Haisheng Yuan commented on CALCITE-3353: [~jinxing6...@126.com] I agree with you. >

[jira] [Commented] (CALCITE-1178) Allow SqlBetweenOperator to compare DATE and TIMESTAMP

[ https://issues.apache.org/jira/browse/CALCITE-1178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16932868#comment-16932868 ] Haisheng Yuan commented on CALCITE-1178: Not a bug. I think it is a yet implemented feature. >

[jira] [Resolved] (CALCITE-2166) Cumulative cost of RelSubset.best RelNode is increased after calling RelSubset.propagateCostImprovements() for input RelNodes

[ https://issues.apache.org/jira/browse/CALCITE-2166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2166. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3316) Exception while deserializing LogicalCorrelate from json string

[ https://issues.apache.org/jira/browse/CALCITE-3316?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3316. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3317) Add public constructor for creating LogicalCalc with RelInput type parameter

[ https://issues.apache.org/jira/browse/CALCITE-3317?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3317. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3319) AssertionError for ReduceDecimalsRule

[ https://issues.apache.org/jira/browse/CALCITE-3319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3319. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3292) SqlToRelConverter#substituteSubQuery fails with NullPointerException when converting SqlUpdate.

[ https://issues.apache.org/jira/browse/CALCITE-3292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3292. Fix Version/s: 1.21.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3295) Aggregate call name lost in serialized json string.

[ https://issues.apache.org/jira/browse/CALCITE-3295?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3295. Fix Version/s: 1.21.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3296) Decorrelator gives empty result after decorrelating sort rel with null offset and fetch

[ https://issues.apache.org/jira/browse/CALCITE-3296?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3296. Fix Version/s: 1.21.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3283) RelSubSet's best is not existed in the set

[ https://issues.apache.org/jira/browse/CALCITE-3283?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3283. Fix Version/s: 1.21.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3204) Implement jps command for OS adapter

[ https://issues.apache.org/jira/browse/CALCITE-3204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3204. Fix Version/s: 1.21.0 Resolution: Fixed Fixed in

[jira] [Created] (CALCITE-3285) EnumerableMergeJoin should support non-equi join conditions

Haisheng Yuan created CALCITE-3285: -- Summary: EnumerableMergeJoin should support non-equi join conditions Key: CALCITE-3285 URL: https://issues.apache.org/jira/browse/CALCITE-3285 Project: Calcite

[jira] [Created] (CALCITE-3284) Enumerable hash semijoin support non-equi join conditions

Haisheng Yuan created CALCITE-3284: -- Summary: Enumerable hash semijoin support non-equi join conditions Key: CALCITE-3284 URL: https://issues.apache.org/jira/browse/CALCITE-3284 Project: Calcite

[jira] [Commented] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16912893#comment-16912893 ] Haisheng Yuan commented on CALCITE-2973: Sure, will do. > Allow theta joins that have equi

[jira] [Resolved] (CALCITE-3223) Non-RexInputRef may fails the matching of FilterToProjectUnifyRule during 'invert' by mistake.

[ https://issues.apache.org/jira/browse/CALCITE-3223?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3223. Fix Version/s: 1.21.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3257) RelMetadataQuery cache is not invalidated when log trace is enabled

[ https://issues.apache.org/jira/browse/CALCITE-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3257. Fix Version/s: 1.21.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-3257) RelMetadataQuery cache is not invalidated when log trace is enabled

[ https://issues.apache.org/jira/browse/CALCITE-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16912539#comment-16912539 ] Haisheng Yuan commented on CALCITE-3257: Yes, I do think this is a separate issue with

[jira] [Resolved] (CALCITE-3262) Refine doc of SubstitutionVisitor.java

[ https://issues.apache.org/jira/browse/CALCITE-3262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3262. Fix Version/s: 1.21.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-2302) Implicit type cast support

[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16911921#comment-16911921 ] Haisheng Yuan commented on CALCITE-2302: +1 on the patch, overall. Given the default behavior

[jira] [Resolved] (CALCITE-3259) Align 'Property' in the serialized xml string of RelXmlWriter.

[ https://issues.apache.org/jira/browse/CALCITE-3259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3259. Fix Version/s: 1.21.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3214) Add UnionToUnionRule for materialization matching

[ https://issues.apache.org/jira/browse/CALCITE-3214?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3214. Resolution: Fixed Fix Version/s: 1.21.0 Fixed in

[jira] [Resolved] (CALCITE-3249) Substitution#getRexShuttle does not consider RexLiteral

[ https://issues.apache.org/jira/browse/CALCITE-3249?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3249. Resolution: Fixed Fix Version/s: 1.21.0 Fixed in

[jira] [Commented] (CALCITE-482) Implement sql and planner hints

[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16908687#comment-16908687 ] Haisheng Yuan commented on CALCITE-482: --- I think query hints can also do the same work with table

[jira] [Commented] (CALCITE-2302) Implicit type cast support

[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16908576#comment-16908576 ] Haisheng Yuan commented on CALCITE-2302: Let me repeat my comment here. My only concern is that

[jira] [Commented] (CALCITE-3089) Deprecate EquiJoin

[ https://issues.apache.org/jira/browse/CALCITE-3089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16908526#comment-16908526 ] Haisheng Yuan commented on CALCITE-3089: +1 on the tweaks, which make more sense to call

[jira] [Commented] (CALCITE-482) Implement sql and planner hints

[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16902530#comment-16902530 ] Haisheng Yuan commented on CALCITE-482: --- Is it necessary to support 2 different styles of hints?

[jira] [Commented] (CALCITE-482) Implement sql and planner hints

[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16902331#comment-16902331 ] Haisheng Yuan commented on CALCITE-482: --- For hints like {{selectivity}}, a good place to put is

[jira] [Resolved] (CALCITE-3101) PushDownJoinConditions is not always a valid transformation

[ https://issues.apache.org/jira/browse/CALCITE-3101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3101. Resolution: Fixed Fix Version/s: 1.21.0 Fixed in

[jira] [Resolved] (CALCITE-3227) IndexOutOfBound when checking candidate parent match's input ordinal in VolcanoRuleCall

[ https://issues.apache.org/jira/browse/CALCITE-3227?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3227. Resolution: Fixed Fix Version/s: 1.21.0 Fixed in

[jira] [Commented] (CALCITE-2624) Add a rule to copy a sort below a join operator

[ https://issues.apache.org/jira/browse/CALCITE-2624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16898630#comment-16898630 ] Haisheng Yuan commented on CALCITE-2624: I am neutral on this approach. +0. > Add a rule to

[jira] [Resolved] (CALCITE-3153) Improve testing in TpcdsTest using assertEqual instead of printing results

[ https://issues.apache.org/jira/browse/CALCITE-3153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3153. Resolution: Fixed Fix Version/s: 1.21.0 Fixed in

[jira] [Resolved] (CALCITE-3031) Support for correlated ANY/SOME/ALL sub-query

[ https://issues.apache.org/jira/browse/CALCITE-3031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3031. Resolution: Fixed Fix Version/s: 1.21.0 Fixed in

[jira] [Commented] (CALCITE-2978) sorting not applied in subqueries

[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16884987#comment-16884987 ] Haisheng Yuan commented on CALCITE-2978: This is still not a valid case, unless you add {{limit

[jira] [Commented] (CALCITE-3181) Support limit per group in Window

[ https://issues.apache.org/jira/browse/CALCITE-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16881722#comment-16881722 ] Haisheng Yuan commented on CALCITE-3181: {quote} It would make sense to have an implementation

[jira] [Commented] (CALCITE-3159) Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16881684#comment-16881684 ] Haisheng Yuan commented on CALCITE-3159: Sure, thanks! > Distinct can be removed for

[jira] [Assigned] (CALCITE-3159) Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan reassigned CALCITE-3159: -- Assignee: Forward Xu > Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate

[jira] [Commented] (CALCITE-3181) Support limit per group in Window

[ https://issues.apache.org/jira/browse/CALCITE-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16881121#comment-16881121 ] Haisheng Yuan commented on CALCITE-3181: e.g. compute the total page views for the top 10

[jira] [Resolved] (CALCITE-3160) Failed to materialize when the aggregate function uses group key

[ https://issues.apache.org/jira/browse/CALCITE-3160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3160. Resolution: Fixed Fix Version/s: 1.21.0 Fixed in

[jira] [Updated] (CALCITE-3181) Support limit per group in Window

[ https://issues.apache.org/jira/browse/CALCITE-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3181: --- Description: We have a lot of queries like the following to retrieve top N tuples per

[jira] [Updated] (CALCITE-3181) Support limit per group in Window

[ https://issues.apache.org/jira/browse/CALCITE-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3181: --- Description: We have a lot of queries like the following to retrieve top N tuples per

[jira] [Created] (CALCITE-3181) Support limit per group in Window

Haisheng Yuan created CALCITE-3181: -- Summary: Support limit per group in Window Key: CALCITE-3181 URL: https://issues.apache.org/jira/browse/CALCITE-3181 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-3160) Failed to materialize when the aggregate function uses group key

[ https://issues.apache.org/jira/browse/CALCITE-3160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16878157#comment-16878157 ] Haisheng Yuan commented on CALCITE-3160: So the original description is more appropriate. I'll

[jira] [Comment Edited] (CALCITE-3160) Failed to materialize when the aggregate function uses group key

[ https://issues.apache.org/jira/browse/CALCITE-3160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16878157#comment-16878157 ] Haisheng Yuan edited comment on CALCITE-3160 at 7/3/19 8:52 PM: So the

[jira] [Updated] (CALCITE-3160) Failed to materialize when the aggregate function uses group key

[ https://issues.apache.org/jira/browse/CALCITE-3160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3160: --- Summary: Failed to materialize when the aggregate function uses group key (was:

[jira] [Commented] (CALCITE-3165) Project#accept(RexShuttle shuttle) does not update rowType

[ https://issues.apache.org/jira/browse/CALCITE-3165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876380#comment-16876380 ] Haisheng Yuan commented on CALCITE-3165: Yup, a test case might be helpful. >

[jira] [Created] (CALCITE-3160) Failed to materialize when the aggregate function uses group key

Haisheng Yuan created CALCITE-3160: -- Summary: Failed to materialize when the aggregate function uses group key Key: CALCITE-3160 URL: https://issues.apache.org/jira/browse/CALCITE-3160 Project:

[jira] [Resolved] (CALCITE-3146) Support the detection of nested aggregations for JdbcAggregate in SqlImplementor.

[ https://issues.apache.org/jira/browse/CALCITE-3146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3146. Resolution: Fixed Fix Version/s: 1.21.0 Fixed in

[jira] [Resolved] (CALCITE-3151) RexCall's Monotonicity is not considered in determining a Calc's collation

[ https://issues.apache.org/jira/browse/CALCITE-3151?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3151. Resolution: Fixed Fix Version/s: 1.21.0 Fixed in

[jira] [Commented] (CALCITE-2801) Check input type in AggregateUnionAggregateRule when remove the bottom Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-2801?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16875854#comment-16875854 ] Haisheng Yuan commented on CALCITE-2801: I have updated the patch by preserving the union

[jira] [Resolved] (CALCITE-2801) Check input type in AggregateUnionAggregateRule when remove the bottom Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-2801?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2801. Resolution: Fixed Fix Version/s: 1.21.0 Fixed in

[jira] [Resolved] (CALCITE-3149) CACHE in RelDataTypeFactoryImpl can't be garbage collected

[ https://issues.apache.org/jira/browse/CALCITE-3149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3149. Resolution: Fixed Fix Version/s: 1.21.0 Fixed in

[jira] [Updated] (CALCITE-3159) Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3159: --- Description: For the following query: {code:java} select a, min(distinct b),

[jira] [Created] (CALCITE-3159) Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate functions

Haisheng Yuan created CALCITE-3159: -- Summary: Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate functions Key: CALCITE-3159 URL: https://issues.apache.org/jira/browse/CALCITE-3159

[jira] [Resolved] (CALCITE-3060) Materialized view: "target out of range" error

[ https://issues.apache.org/jira/browse/CALCITE-3060?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3060. Resolution: Fixed Fix Version/s: 1.21.0 fixed in

[jira] [Updated] (CALCITE-3149) CACHE in RelDataTypeFactoryImpl can't be garbage collected

[ https://issues.apache.org/jira/browse/CALCITE-3149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3149: --- Description: Key and Value are pointing to the same object, even with soft value

[jira] [Updated] (CALCITE-3149) CACHE in RelDataTypeFactoryImpl can't be garbage collected

[ https://issues.apache.org/jira/browse/CALCITE-3149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3149: --- Attachment: (was: screenshot-1.png) > CACHE in RelDataTypeFactoryImpl can't be garbage

[jira] [Updated] (CALCITE-3149) CACHE in RelDataTypeFactoryImpl can't be garbage collected

[ https://issues.apache.org/jira/browse/CALCITE-3149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3149: --- Description: Key and Value are pointing to the same object, even with soft value

[jira] [Updated] (CALCITE-3149) CACHE in RelDataTypeFactoryImpl can't be garbage collected

[ https://issues.apache.org/jira/browse/CALCITE-3149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3149: --- Description: Key and Value are pointing to the same object, with soft references, the item

[jira] [Commented] (CALCITE-3149) CACHE in RelDataTypeFactoryImpl can't be garbage collected

[ https://issues.apache.org/jira/browse/CALCITE-3149?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16873834#comment-16873834 ] Haisheng Yuan commented on CALCITE-3149: We hit the OOM issue quite frequently in case of super

[jira] [Updated] (CALCITE-3149) CACHE in RelDataTypeFactoryImpl can't be garbage collected

[ https://issues.apache.org/jira/browse/CALCITE-3149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3149: --- Attachment: (was: image-2019-06-26-22-01-50-965.png) > CACHE in RelDataTypeFactoryImpl

[jira] [Updated] (CALCITE-3149) CACHE in RelDataTypeFactoryImpl can't be garbage collected

[ https://issues.apache.org/jira/browse/CALCITE-3149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3149: --- Description: Key and Value are pointing to the same object, with soft references, the item

[jira] [Updated] (CALCITE-3149) CACHE in RelDataTypeFactoryImpl can't be garbage collected

[ https://issues.apache.org/jira/browse/CALCITE-3149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3149: --- Attachment: screenshot-1.png > CACHE in RelDataTypeFactoryImpl can't be garbage collected

[jira] [Assigned] (CALCITE-3149) CACHE in RelDataTypeFactoryImpl can't be garbage collected

[ https://issues.apache.org/jira/browse/CALCITE-3149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan reassigned CALCITE-3149: -- Assignee: Haisheng Yuan > CACHE in RelDataTypeFactoryImpl can't be garbage

[jira] [Created] (CALCITE-3149) CACHE in RelDataTypeFactoryImpl can't be garbage collected

Haisheng Yuan created CALCITE-3149: -- Summary: CACHE in RelDataTypeFactoryImpl can't be garbage collected Key: CALCITE-3149 URL: https://issues.apache.org/jira/browse/CALCITE-3149 Project: Calcite

[jira] [Updated] (CALCITE-3149) CACHE in RelDataTypeFactoryImpl can't be garbage collected

[ https://issues.apache.org/jira/browse/CALCITE-3149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3149: --- Component/s: core > CACHE in RelDataTypeFactoryImpl can't be garbage collected >

[jira] [Commented] (CALCITE-3146) Support the detection of nested aggregations for JdbcAggregate in SqlImplementor.

[ https://issues.apache.org/jira/browse/CALCITE-3146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16872609#comment-16872609 ] Haisheng Yuan commented on CALCITE-3146: Agree with what Julian said. +1 on the patch. >

<    3   4   5   6   7   8   9   10   11   >