[jira] [Commented] (CALCITE-3002) Case statement fails with: SqlValidatorException: Cannot apply '=' to arguments of type ' = '.

[ https://issues.apache.org/jira/browse/CALCITE-3002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823738#comment-16823738 ] Julian Hyde commented on CALCITE-3002: -- In sql1992 it says bq. The data type of e

[jira] [Assigned] (CALCITE-3003) AssertionError when GROUP BY nested field

[ https://issues.apache.org/jira/browse/CALCITE-3003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Will Yu reassigned CALCITE-3003: Assignee: Will Yu > AssertionError when GROUP BY nested field >

[jira] [Commented] (CALCITE-3003) AssertionError when GROUP BY nested field

[ https://issues.apache.org/jira/browse/CALCITE-3003?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823683#comment-16823683 ] Will Yu commented on CALCITE-3003: -- [~julianhyde] Thanks for detailed context and sugg

[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&focusedCommentId=16823659#comment-16823659 ] Lai Zhou commented on CALCITE-2973: --- I modified EnumerableJoin to be able to deal wit

[jira] [Commented] (CALCITE-2969) Improve design of join-like relational expressions

[ https://issues.apache.org/jira/browse/CALCITE-2969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823651#comment-16823651 ] Danny Chan commented on CALCITE-2969: - [~julianhyde] Thanks for your review, i have

[jira] [Comment Edited] (CALCITE-2453) Enhance the SQL parser in order to optionally support semicolon at the end of the sql statements

[ https://issues.apache.org/jira/browse/CALCITE-2453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823643#comment-16823643 ] Chunwei Lei edited comment on CALCITE-2453 at 4/23/19 3:13 AM: --

[jira] [Comment Edited] (CALCITE-2453) Enhance the SQL parser in order to optionally support semicolon at the end of the sql statements

[ https://issues.apache.org/jira/browse/CALCITE-2453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823643#comment-16823643 ] Chunwei Lei edited comment on CALCITE-2453 at 4/23/19 3:11 AM: --

[jira] [Comment Edited] (CALCITE-2453) Enhance the SQL parser in order to optionally support semicolon at the end of the sql statements

[ https://issues.apache.org/jira/browse/CALCITE-2453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823643#comment-16823643 ] Chunwei Lei edited comment on CALCITE-2453 at 4/23/19 3:10 AM: --

[jira] [Commented] (CALCITE-2453) Enhance the SQL parser in order to optionally support semicolon at the end of the sql statements

[ https://issues.apache.org/jira/browse/CALCITE-2453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823643#comment-16823643 ] Chunwei Lei commented on CALCITE-2453: -- Thanks for your review, [~julianhyde]. PR

[jira] [Commented] (CALCITE-2453) Enhance the SQL parser in order to optionally support semicolon at the end of the sql statements

[ https://issues.apache.org/jira/browse/CALCITE-2453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823641#comment-16823641 ] pengzhiwei commented on CALCITE-2453: - Hi [~Chunwei Lei], It works well for me  in

[jira] [Comment Edited] (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&focusedCommentId=16823090#comment-16823090 ] Lai Zhou edited comment on CALCITE-2973 at 4/23/19 2:16 AM:

[jira] [Commented] (CALCITE-2282) Allow OperatorTable to be pluggable in the parser

[ https://issues.apache.org/jira/browse/CALCITE-2282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823623#comment-16823623 ] Danny Chan commented on CALCITE-2282: - [~julianhyde] Seems that this code snippet i

[jira] [Assigned] (CALCITE-2846) Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference

[ https://issues.apache.org/jira/browse/CALCITE-2846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan reassigned CALCITE-2846: --- Assignee: Danny Chan > Document Oracle-specific functions, such as NVL and LTRIM, in the S

[jira] [Commented] (CALCITE-2846) Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference

[ https://issues.apache.org/jira/browse/CALCITE-2846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823614#comment-16823614 ] Danny Chan commented on CALCITE-2846: - [~julianhyde] i would like to take this issu

[jira] [Commented] (CALCITE-3002) Case statement fails with: SqlValidatorException: Cannot apply '=' to arguments of type ' = '.

[ https://issues.apache.org/jira/browse/CALCITE-3002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823491#comment-16823491 ] Egor Ryashin commented on CALCITE-3002: --- I don't see it's incorrect as per  [http

[jira] [Updated] (CALCITE-3002) Case statement fails with: SqlValidatorException: Cannot apply '=' to arguments of type ' = '.

[ https://issues.apache.org/jira/browse/CALCITE-3002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Egor Ryashin updated CALCITE-3002: -- Attachment: image-2019-04-23-00-29-31-703.png > Case statement fails with: SqlValidatorExcept

[jira] [Commented] (CALCITE-2846) Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference

[ https://issues.apache.org/jira/browse/CALCITE-2846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823488#comment-16823488 ] Julian Hyde commented on CALCITE-2846: -- [~stutigupta], Any progress on this? I'd l

[jira] [Comment Edited] (CALCITE-2820) Avoid reducing certain aggregate functions when it is not necessary

[ https://issues.apache.org/jira/browse/CALCITE-2820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16782271#comment-16782271 ] Julian Hyde edited comment on CALCITE-2820 at 4/22/19 9:14 PM: --

[jira] [Commented] (CALCITE-2820) Avoid reducing certain aggregate functions when it is not necessary

[ https://issues.apache.org/jira/browse/CALCITE-2820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823479#comment-16823479 ] Julian Hyde commented on CALCITE-2820: -- Fixed in [a75a689ef|https://github.com/apa

[jira] [Commented] (CALCITE-2889) IndexOutOfBoundsException in EnumUtils#fromInternal when handling methods with varargs

[ https://issues.apache.org/jira/browse/CALCITE-2889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823473#comment-16823473 ] Julian Hyde commented on CALCITE-2889: -- Let's try to get this into 1.20. [~zabetak

[jira] [Resolved] (CALCITE-1373) select date column will fail in 1.8.0

[ https://issues.apache.org/jira/browse/CALCITE-1373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-1373. -- Resolution: Fixed Fix Version/s: 1.19.0 Fixed in 1.19 (and possibly long before). > s

[jira] [Closed] (CALCITE-1373) select date column will fail in 1.8.0

[ https://issues.apache.org/jira/browse/CALCITE-1373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-1373. > select date column will fail in 1.8.0 > - > > K

[jira] [Updated] (CALCITE-2820) Avoid reducing certain aggregate functions when it is not necessary

[ https://issues.apache.org/jira/browse/CALCITE-2820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2820: - Fix Version/s: 1.20.0 > Avoid reducing certain aggregate functions when it is not necessary > -

[jira] [Updated] (CALCITE-2889) IndexOutOfBoundsException in EnumUtils#fromInternal when handling methods with varargs

[ https://issues.apache.org/jira/browse/CALCITE-2889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2889: - Fix Version/s: 1.20.0 > IndexOutOfBoundsException in EnumUtils#fromInternal when handling metho

[jira] [Resolved] (CALCITE-2914) Improve how LatticeSuggester deduces foreign keys

[ https://issues.apache.org/jira/browse/CALCITE-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-2914. -- Resolution: Fixed Fixed in [906183a35|https://github.com/apache/calcite/commit/906183a35]. >

[jira] [Commented] (CALCITE-2871) Implement JSON_TABLE table function

[ https://issues.apache.org/jira/browse/CALCITE-2871?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823455#comment-16823455 ] Julian Hyde commented on CALCITE-2871: -- Sounds good. For the record, I totally agr

[jira] [Resolved] (CALCITE-2928) Make UDF lookup default to case insensitive

[ https://issues.apache.org/jira/browse/CALCITE-2928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-2928. -- Resolution: Fixed Fixed in [136c9c5d7|https://github.com/apache/calcite/commit/136c9c5d7]; th

[jira] [Resolved] (CALCITE-3002) Case statement fails with: SqlValidatorException: Cannot apply '=' to arguments of type ' = '.

[ https://issues.apache.org/jira/browse/CALCITE-3002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3002. -- Resolution: Invalid Fix Version/s: 1.20.0 The validator is correct. Your statement is

[jira] [Commented] (CALCITE-3003) AssertionError when GROUP BY nested field

[ https://issues.apache.org/jira/browse/CALCITE-3003?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823426#comment-16823426 ] Julian Hyde commented on CALCITE-3003: -- [~my7ym] You are correct. The {{assert}} i

[jira] [Commented] (CALCITE-2282) Allow OperatorTable to be pluggable in the parser

[ https://issues.apache.org/jira/browse/CALCITE-2282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823413#comment-16823413 ] Julian Hyde commented on CALCITE-2282: -- The {{opTab}} field is only used in one pl

[jira] [Commented] (CALCITE-3008) Making AuxiliaryConverter Pluggable

[ https://issues.apache.org/jira/browse/CALCITE-3008?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823389#comment-16823389 ] Julian Hyde commented on CALCITE-3008: -- AuxiliaryConverter goes Rex -> Rex, wherea

[jira] [Commented] (CALCITE-2453) Enhance the SQL parser in order to optionally support semicolon at the end of the sql statements

[ https://issues.apache.org/jira/browse/CALCITE-2453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823377#comment-16823377 ] Julian Hyde commented on CALCITE-2453: -- * Need more javadoc in {{SqlParserTest}}.

[jira] [Commented] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

[ https://issues.apache.org/jira/browse/CALCITE-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823370#comment-16823370 ] Julian Hyde commented on CALCITE-3014: -- [~zabetak] Thanks. Exactly what I was goin

[jira] [Commented] (CALCITE-2900) RelStructuredTypeFlattener generates wrong types on nested columns

[ https://issues.apache.org/jira/browse/CALCITE-2900?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1682#comment-1682 ] Will Yu commented on CALCITE-2900: -- Thanks [~zabetak] for your detailed and constructi

[jira] [Commented] (CALCITE-3008) Making AuxiliaryConverter Pluggable

[ https://issues.apache.org/jira/browse/CALCITE-3008?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823316#comment-16823316 ] Rong Rong commented on CALCITE-3008: I also think changing the AuxiliaryConverter s

[jira] [Commented] (CALCITE-2969) Improve design of join-like relational expressions

[ https://issues.apache.org/jira/browse/CALCITE-2969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823296#comment-16823296 ] Julian Hyde commented on CALCITE-2969: -- I have reviewed. This looks very promising

[jira] [Commented] (CALCITE-3015) Add rule to remove constants in group keys

[ https://issues.apache.org/jira/browse/CALCITE-3015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823154#comment-16823154 ] Chunwei Lei commented on CALCITE-3015: -- Oops, {{AggregateProjectPullUpConstantsRul

[jira] [Closed] (CALCITE-3015) Add rule to remove constants in group keys

[ https://issues.apache.org/jira/browse/CALCITE-3015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei closed CALCITE-3015. Resolution: Invalid > Add rule to remove constants in group keys > --

[jira] [Commented] (CALCITE-3015) Add rule to remove constants in group keys

[ https://issues.apache.org/jira/browse/CALCITE-3015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823149#comment-16823149 ] Chunwei Lei commented on CALCITE-3015: -- I don't get what you mean completely. In m

[jira] [Comment Edited] (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&focusedCommentId=16823090#comment-16823090 ] Lai Zhou edited comment on CALCITE-2973 at 4/22/19 2:18 PM:

[jira] [Commented] (CALCITE-2985) Add the JSON_STORAGE_SIZE function

[ https://issues.apache.org/jira/browse/CALCITE-2985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823110#comment-16823110 ] Hongze Zhang commented on CALCITE-2985: --- Thanks, Julian! And CALCITE-3010 is now

[jira] [Commented] (CALCITE-3015) Add rule to remove constants in group keys

[ https://issues.apache.org/jira/browse/CALCITE-3015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823107#comment-16823107 ] Haisheng Yuan commented on CALCITE-3015: Nah, if the table is empty, you are sc

[jira] [Commented] (CALCITE-2983) Add Avatica compatibility page for TLS and IBM Java

[ https://issues.apache.org/jira/browse/CALCITE-2983?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823102#comment-16823102 ] Kevin Risden commented on CALCITE-2983: --- I wouldn't hold the release up for it. I

[jira] [Updated] (CALCITE-2983) Add Avatica compatibility page for TLS and IBM Java

[ https://issues.apache.org/jira/browse/CALCITE-2983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden updated CALCITE-2983: -- Component/s: site > Add Avatica compatibility page for TLS and IBM Java > ---

[jira] [Resolved] (CALCITE-3010) In SQL parser, move JsonValueExpression into Expression

[ https://issues.apache.org/jira/browse/CALCITE-3010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang resolved CALCITE-3010. --- Resolution: Fixed Fix Version/s: 1.20.0 Fixed in [02eb106bcd1b0fdb1d0be06d117a94edd

[jira] [Comment Edited] (CALCITE-3010) In SQL parser, move JsonValueExpression into Expression

[ https://issues.apache.org/jira/browse/CALCITE-3010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16822865#comment-16822865 ] Hongze Zhang edited comment on CALCITE-3010 at 4/22/19 1:23 PM: -

[jira] [Created] (CALCITE-3015) Add rule to remove constants in group keys

Chunwei Lei created CALCITE-3015: Summary: Add rule to remove constants in group keys Key: CALCITE-3015 URL: https://issues.apache.org/jira/browse/CALCITE-3015 Project: Calcite Issue Type: Im

[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&focusedCommentId=16823090#comment-16823090 ] Lai Zhou commented on CALCITE-2973: --- [~zabetak],[~hyuan], should we keep EnumerableJo

[jira] [Commented] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

[ https://issues.apache.org/jira/browse/CALCITE-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823080#comment-16823080 ] Stamatis Zampetakis commented on CALCITE-3014: -- Hey [~hhlai1990], it is be

[jira] [Resolved] (CALCITE-1624) Inefficient plan for NOT IN correlated subqueries

[ https://issues.apache.org/jira/browse/CALCITE-1624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved CALCITE-1624. -- Resolution: Not A Problem Fix Version/s: 1.20.0 I am marking this as r

[jira] [Reopened] (CALCITE-1624) Inefficient plan for NOT IN correlated subqueries

[ https://issues.apache.org/jira/browse/CALCITE-1624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reopened CALCITE-1624: -- > Inefficient plan for NOT IN correlated subqueries > ---

[jira] [Closed] (CALCITE-1624) Inefficient plan for NOT IN correlated subqueries

[ https://issues.apache.org/jira/browse/CALCITE-1624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan closed CALCITE-1624. --- Resolution: Fixed > Inefficient plan for NOT IN correlated subqueries > ---

[jira] [Commented] (CALCITE-1624) Inefficient plan for NOT IN correlated subqueries

[ https://issues.apache.org/jira/browse/CALCITE-1624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823049#comment-16823049 ] Danny Chan commented on CALCITE-1624: - There is no problem with this pattern now, i

[jira] [Commented] (CALCITE-1624) Inefficient plan for NOT IN correlated subqueries

[ https://issues.apache.org/jira/browse/CALCITE-1624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823047#comment-16823047 ] Danny Chan commented on CALCITE-1624: - [~vgarg] Yeah, you are right, i missed that

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

[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Sitnikov reassigned CALCITE-482: - Assignee: Danny Chan (was: Vladimir Sitnikov) > Implement sql and planner hint

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

[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Sitnikov reassigned CALCITE-482: - Assignee: Vladimir Sitnikov > Implement sql and planner 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&focusedCommentId=16823027#comment-16823027 ] Danny Chan commented on CALCITE-482: [~julianhyde] may i take this issue ?:D > Impl

[jira] [Updated] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

[ https://issues.apache.org/jira/browse/CALCITE-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-3014: -- Description: [~julianhyde]  I found SqlConformanceEnum is hard coded in a few places. [https://githu

[jira] [Created] (CALCITE-3014) SqlConformanceEnum is hard coded in a few places

Lai Zhou created CALCITE-3014: - Summary: SqlConformanceEnum is hard coded in a few places Key: CALCITE-3014 URL: https://issues.apache.org/jira/browse/CALCITE-3014 Project: Calcite Issue Type: Bu

[jira] [Commented] (CALCITE-2974) Timestamp conversion performance can be improved

[ https://issues.apache.org/jira/browse/CALCITE-2974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16822946#comment-16822946 ] Danny Chan commented on CALCITE-2974: - [~ValTrofFuture] Thx for your perf data repo