[jira] [Created] (CALCITE-2982) SqlItemOpeator should throw understandable exception message for incorrect field type

2019-04-08 Thread pengzhiwei (JIRA)
pengzhiwei created CALCITE-2982: --- Summary: SqlItemOpeator should throw understandable exception message for incorrect field type Key: CALCITE-2982 URL: https://issues.apache.org/jira/browse/CALCITE-2982

[jira] [Updated] (CALCITE-2982) SqlItemOperator should throw understandable exception message for incorrect field type

2019-04-08 Thread pengzhiwei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2982: Summary: SqlItemOperator should throw understandable exception message for incorrect field type

[jira] [Issue Comment Deleted] (CALCITE-2981) Syntax error with simple nested select query

2019-04-08 Thread pingle wang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pingle wang updated CALCITE-2981: - Comment: was deleted (was: ```sql select * from (   (select * from test1) test3 ) ```

[jira] [Commented] (CALCITE-2981) Syntax error with simple nested select query

2019-04-08 Thread pingle wang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2981?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812202#comment-16812202 ] pingle wang commented on CALCITE-2981: -- ```sql  select   *  from   (    (select * from test1)

[jira] [Updated] (CALCITE-2982) SqlItemOperator should throw understandable exception message for incorrect field type

2019-04-08 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-2982: Labels: pull-request-available (was: ) > SqlItemOperator should throw understandable

[jira] [Updated] (CALCITE-2982) SqlItemOpeator should throw understandable exception message for incorrect field type

2019-04-08 Thread pengzhiwei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2982: Description: In the follow sql: {code:java} select name[0] from dept {code} _name_ is a field of

[jira] [Issue Comment Deleted] (CALCITE-2981) Syntax error with simple nested select query

2019-04-08 Thread pingle wang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pingle wang updated CALCITE-2981: - Comment: was deleted (was: ```sql  select   *  from   (    (select * from test1) test3   ) 

[jira] [Commented] (CALCITE-2872) Support for specifying encoding in JSON representation clause

2019-04-08 Thread Forward Xu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2872?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812352#comment-16812352 ] Forward Xu commented on CALCITE-2872: - hi [~zhztheplayer] UTF8, UTF16, UTF32 do you need to

[jira] [Commented] (CALCITE-1338) JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression.

2019-04-08 Thread Chunwei Lei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812531#comment-16812531 ] Chunwei Lei commented on CALCITE-1338: -- To resolve this, I would like to proposal: * add a new

[jira] [Comment Edited] (CALCITE-1338) JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression.

2019-04-08 Thread Chunwei Lei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812531#comment-16812531 ] Chunwei Lei edited comment on CALCITE-1338 at 4/8/19 3:54 PM: -- To resolve

[jira] [Updated] (CALCITE-2982) SqlItemOperator should throw understandable exception message for incorrect field type

2019-04-08 Thread pengzhiwei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2982: Description: In the following sql: {code:java} select name[0] from dept {code} _name_ is a field

[jira] [Assigned] (CALCITE-1581) UDTF like in hive

2019-04-08 Thread pengzhiwei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei reassigned CALCITE-1581: --- Assignee: pengzhiwei (was: Sihua Zhou) > UDTF like in hive > - > >

[jira] [Comment Edited] (CALCITE-2921) nullif(null,y) throws exception in verification

2019-04-08 Thread pengzhiwei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804546#comment-16804546 ] pengzhiwei edited comment on CALCITE-2921 at 4/8/19 11:40 AM: -- Hi

[jira] [Created] (CALCITE-2984) Add the JSON_STORAGE_SIZE function

2019-04-08 Thread Forward Xu (JIRA)
Forward Xu created CALCITE-2984: --- Summary: Add the JSON_STORAGE_SIZE function Key: CALCITE-2984 URL: https://issues.apache.org/jira/browse/CALCITE-2984 Project: Calcite Issue Type: New Feature

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

2019-04-08 Thread Forward Xu (JIRA)
Forward Xu created CALCITE-2985: --- Summary: Add the JSON_STORAGE_SIZE function Key: CALCITE-2985 URL: https://issues.apache.org/jira/browse/CALCITE-2985 Project: Calcite Issue Type: New Feature

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

2019-04-08 Thread Forward Xu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Forward Xu reassigned CALCITE-2985: --- Assignee: Forward Xu > Add the JSON_STORAGE_SIZE function >

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

2019-04-08 Thread Forward Xu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Forward Xu updated CALCITE-2985: Issue Type: Sub-task (was: New Feature) Parent: CALCITE-2867 > Add the

[jira] [Assigned] (CALCITE-2981) Syntax error with simple nested select query

2019-04-08 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan reassigned CALCITE-2981: --- Assignee: Danny Chan > Syntax error with simple nested select query >

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

2019-04-08 Thread Kevin Risden (JIRA)
Kevin Risden created CALCITE-2983: - Summary: Add Avatica compatibility page for TLS and IBM Java Key: CALCITE-2983 URL: https://issues.apache.org/jira/browse/CALCITE-2983 Project: Calcite

[jira] [Commented] (CALCITE-2972) Upgrade jetty to 9.4.15.v20190215

2019-04-08 Thread Kevin Risden (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812433#comment-16812433 ] Kevin Risden commented on CALCITE-2972: --- Created CALCITE-2983 > Upgrade jetty to

[jira] [Commented] (CALCITE-2981) Syntax error with simple nested select query

2019-04-08 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2981?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812426#comment-16812426 ] Danny Chan commented on CALCITE-2981: - [~vamshi.v.kris...@gmail.com] Seems should not happen, i

[jira] [Commented] (CALCITE-2972) Upgrade jetty to 9.4.15.v20190215

2019-04-08 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812427#comment-16812427 ] Josh Elser commented on CALCITE-2972: - {quote}We should make change to the docs/website with a

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

2019-04-08 Thread Kevin Risden (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden updated CALCITE-2983: -- Fix Version/s: avatica-1.14.0 > Add Avatica compatibility page for TLS and IBM Java >

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

2019-04-08 Thread Kevin Risden (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2983?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812434#comment-16812434 ] Kevin Risden commented on CALCITE-2983: --- cc [~elserj] > Add Avatica compatibility page for TLS

[jira] [Resolved] (CALCITE-2972) Upgrade jetty to 9.4.15.v20190215

2019-04-08 Thread Kevin Risden (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2972?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden resolved CALCITE-2972. --- Resolution: Fixed > Upgrade jetty to 9.4.15.v20190215 > -

[jira] [Commented] (CALCITE-1037) Column uniqueness is calculated incorrectly for 'Correlate' expression

2019-04-08 Thread Vladimir Sitnikov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812633#comment-16812633 ] Vladimir Sitnikov commented on CALCITE-1037: Just in case, the commit was

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

2019-04-08 Thread Chunwei Lei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812942#comment-16812942 ] Chunwei Lei commented on CALCITE-2974: -- [~ValTrofFuture], Thanks for raising this. Though your

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

2019-04-08 Thread Chunwei Lei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812942#comment-16812942 ] Chunwei Lei edited comment on CALCITE-2974 at 4/9/19 2:31 AM: --

[jira] [Commented] (CALCITE-2872) Support for specifying encoding in JSON representation clause

2019-04-08 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2872?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812990#comment-16812990 ] Hongze Zhang commented on CALCITE-2872: --- I am not sure currently but SQL:2016 std does not

[jira] [Updated] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-08 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-2986: - Labels: sub-query (was: ) > Wrong results with =ANY subquery >

[jira] [Updated] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-08 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-2986: - Description: ANY/SOME subqueries are rewritten using MAX/MIN and cross-join. This is wrong

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-08 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812830#comment-16812830 ] Haisheng Yuan commented on CALCITE-2986: Sorry, I mean <> ALL is equivalent to NOT IN. for <>

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

2019-04-08 Thread Forward Xu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Forward Xu updated CALCITE-2985: Description: JSON_STORAGE_SIZE(json_val) This function returns the number of bytes used to

[jira] [Created] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-08 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-2986: Summary: Wrong results with =ANY subquery Key: CALCITE-2986 URL: https://issues.apache.org/jira/browse/CALCITE-2986 Project: Calcite Issue Type: Bug

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

2019-04-08 Thread Valeriy Trofimov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812871#comment-16812871 ] Valeriy Trofimov commented on CALCITE-2974: --- Our perf numbers are based on running selected

[jira] [Commented] (CALCITE-1338) JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression.

2019-04-08 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812997#comment-16812997 ] Haisheng Yuan commented on CALCITE-1338: I don't know if there is any better solution than

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-08 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812799#comment-16812799 ] Vineet Garg commented on CALCITE-2986: -- {{=ANY}} is equivalent to IN therefore such queries should

[jira] [Comment Edited] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-08 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812799#comment-16812799 ] Vineet Garg edited comment on CALCITE-2986 at 4/8/19 9:22 PM: -- {{=ANY}} is

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

2019-04-08 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812948#comment-16812948 ] Hongze Zhang commented on CALCITE-2985: --- Thanks, [~x1q1j1]. And we should reorganize built-in /

[jira] [Comment Edited] (CALCITE-1338) JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression.

2019-04-08 Thread Chunwei Lei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812998#comment-16812998 ] Chunwei Lei edited comment on CALCITE-1338 at 4/9/19 4:11 AM: -- {quote}We

[jira] [Commented] (CALCITE-1338) JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression.

2019-04-08 Thread Chunwei Lei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812998#comment-16812998 ] Chunwei Lei commented on CALCITE-1338: -- {quote}We may need a function in RexUtil to check the

[jira] [Assigned] (CALCITE-1338) JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression.

2019-04-08 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang reassigned CALCITE-1338: - Assignee: Chunwei Lei (was: Hongze Zhang) > JoinProjectTransposeRule makes wrong

[jira] [Commented] (CALCITE-2882) ConnectionProperties lose effectiveness when connection reopen after expired

2019-04-08 Thread Francis Chuang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812853#comment-16812853 ] Francis Chuang commented on CALCITE-2882: - [~shining] There are a few comments on your PR. Can

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-08 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812867#comment-16812867 ] Vineet Garg commented on CALCITE-2986: -- [~hyuan] I have given it some thought and as you noticed

[jira] [Comment Edited] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-08 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812867#comment-16812867 ] Vineet Garg edited comment on CALCITE-2986 at 4/8/19 11:23 PM: --- [~hyuan]

[jira] [Assigned] (CALCITE-1338) JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression.

2019-04-08 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang reassigned CALCITE-1338: - Assignee: Hongze Zhang (was: Chunwei Lei) > JoinProjectTransposeRule makes wrong

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-08 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812824#comment-16812824 ] Haisheng Yuan commented on CALCITE-2986: You are right, <> ANY is equivalent to NOT IN. >

[jira] [Comment Edited] (CALCITE-2882) ConnectionProperties lose effectiveness when connection reopen after expired

2019-04-08 Thread Francis Chuang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812853#comment-16812853 ] Francis Chuang edited comment on CALCITE-2882 at 4/8/19 10:44 PM: --

[jira] [Closed] (CALCITE-2984) Add the JSON_STORAGE_SIZE function

2019-04-08 Thread Stamatis Zampetakis (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis closed CALCITE-2984. Resolution: Duplicate > Add the JSON_STORAGE_SIZE function >

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

2019-04-08 Thread Valeriy Trofimov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812871#comment-16812871 ] Valeriy Trofimov edited comment on CALCITE-2974 at 4/9/19 12:47 AM:

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

2019-04-08 Thread Valeriy Trofimov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812871#comment-16812871 ] Valeriy Trofimov edited comment on CALCITE-2974 at 4/9/19 12:46 AM:

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

2019-04-08 Thread Forward Xu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Forward Xu updated CALCITE-2985: Description: JSON_STORAGE_SIZE(json_val) This function returns the number of bytes used to

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

2019-04-08 Thread Forward Xu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Forward Xu updated CALCITE-2985: Description: JSON_STORAGE_SIZE(json_val) This function returns the number of bytes used to

[jira] [Commented] (CALCITE-1338) JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression.

2019-04-08 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16813008#comment-16813008 ] Hongze Zhang commented on CALCITE-1338: --- It sounds to be a little tricky if we add an

[jira] [Commented] (CALCITE-1338) JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression.

2019-04-08 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16813013#comment-16813013 ] Haisheng Yuan commented on CALCITE-1338: Good idea, that seems much simpler. >