[jira] [Updated] (CALCITE-3028) Support FULL OUTER JOIN with AggregateJoinTransposeRule

2019-05-13 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3028: Labels: pull-request-available (was: ) > Support FULL OUTER JOIN with AggregateJoinTrans

[jira] [Commented] (CALCITE-2965) Implement string functions: REPEAT, SPACE, SOUNDEX, DIFFERENCE

2019-05-13 Thread Chunwei Lei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16839047#comment-16839047 ] Chunwei Lei commented on CALCITE-2965: -- Sure. Will do soon. > Implement string fu

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

2019-05-13 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16839028#comment-16839028 ] Danny Chan commented on CALCITE-2282: - [~julianhyde] Thx for you nice review, i jus

[jira] [Updated] (CALCITE-3066) RelToSqlConverter may incorrectly throw an AssertionError for some decimal literals

2019-05-13 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3066?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3066: Labels: pull-request-available (was: ) > RelToSqlConverter may incorrectly throw an Asse

[jira] [Created] (CALCITE-3066) RelToSqlConverter may incorrectly throw an AssertionError for some decimal literals

2019-05-13 Thread Jesus Camacho Rodriguez (JIRA)
Jesus Camacho Rodriguez created CALCITE-3066: Summary: RelToSqlConverter may incorrectly throw an AssertionError for some decimal literals Key: CALCITE-3066 URL: https://issues.apache.org/jira/browse/C

[jira] [Commented] (CALCITE-3050) Integrate SqlDialect and SqlParser.Config

2019-05-13 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838970#comment-16838970 ] Julian Hyde commented on CALCITE-3050: -- >From the [email >thread|https://lists.ap

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

2019-05-13 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838935#comment-16838935 ] Julian Hyde commented on CALCITE-2282: -- I reviewed your latest. Just one thing: {{

[jira] [Commented] (CALCITE-3005) Implement string functions: LEFT, RIGHT

2019-05-13 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838925#comment-16838925 ] Julian Hyde commented on CALCITE-3005: -- It seems they are in the JDBC spec. See ap

[jira] [Commented] (CALCITE-3065) RexLiteral#getValueAs should consider primitive type

2019-05-13 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838915#comment-16838915 ] Julian Hyde commented on CALCITE-3065: -- It really is not possible to, say, get a {

[jira] [Commented] (CALCITE-35) Support parenthesized sub-clause in JOIN

2019-05-13 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-35?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838909#comment-16838909 ] Julian Hyde commented on CALCITE-35: [~zhztheplayer], Yes exactly. I tried really har

[jira] [Resolved] (CALCITE-2803) Identify expanded IS NOT DISTINCT FROM expression when pushing project past join

2019-05-13 Thread Laurent Goujon (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2803?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laurent Goujon resolved CALCITE-2803. - Resolution: Fixed > Identify expanded IS NOT DISTINCT FROM expression when pushing proj

[jira] [Updated] (CALCITE-2803) Identify expanded IS NOT DISTINCT FROM expression when pushing project past join

2019-05-13 Thread Laurent Goujon (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2803?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laurent Goujon updated CALCITE-2803: Fix Version/s: 1.20.0 > Identify expanded IS NOT DISTINCT FROM expression when pushing pr

[jira] [Assigned] (CALCITE-2803) Identify expanded IS NOT DISTINCT FROM expression when pushing project past join

2019-05-13 Thread Laurent Goujon (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2803?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laurent Goujon reassigned CALCITE-2803: --- Assignee: Laurent Goujon > Identify expanded IS NOT DISTINCT FROM expression when

[jira] [Commented] (CALCITE-2965) Implement string functions: REPEAT, SPACE, SOUNDEX, DIFFERENCE

2019-05-13 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838806#comment-16838806 ] Julian Hyde commented on CALCITE-2965: -- Now that CALCITE-3016 and CALCITE-3053 are

[jira] [Commented] (CALCITE-3052) Error while applying rule MaterializedViewAggregateRule(Project-Aggregate): ArrayIndexOutOfBoundsException

2019-05-13 Thread Jesus Camacho Rodriguez (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838758#comment-16838758 ] Jesus Camacho Rodriguez commented on CALCITE-3052: -- I could not reprod

[jira] [Updated] (CALCITE-3052) Error while applying rule MaterializedViewAggregateRule(Project-Aggregate): ArrayIndexOutOfBoundsException

2019-05-13 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3052: Labels: pull-request-available (was: ) > Error while applying rule MaterializedViewAggre

[jira] [Commented] (CALCITE-3062) Do not populate provenanceMap if not used

2019-05-13 Thread Laurent Goujon (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3062?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838652#comment-16838652 ] Laurent Goujon commented on CALCITE-3062: - To my knowledge, I don't recollect l

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

2019-05-13 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838611#comment-16838611 ] Lai Zhou commented on CALCITE-2973: --- [~rubenql], I agree with you. It's a good idea t

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

2019-05-13 Thread Ruben Quesada Lopez (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838592#comment-16838592 ] Ruben Quesada Lopez commented on CALCITE-2973: -- [~hhlai1990], I have just

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

2019-05-13 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-2624: Labels: pull-request-available (was: ) > Add a rule to copy a sort below a join operator

[jira] [Assigned] (CALCITE-2979) Add a block-based nested loop join algorithm

2019-05-13 Thread Stamatis Zampetakis (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-2979: Assignee: Khawla Mouhoubi (was: Stamatis Zampetakis) > Add a block-base

[jira] [Commented] (CALCITE-35) Support parenthesized sub-clause in JOIN

2019-05-13 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-35?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838531#comment-16838531 ] Hongze Zhang commented on CALCITE-35: - I can imagine you have spent quite a few time 

[jira] [Comment Edited] (CALCITE-3065) RexLiteral#getValueAs should consider primitive type

2019-05-13 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838504#comment-16838504 ] Danny Chan edited comment on CALCITE-3065 at 5/13/19 12:30 PM: --

[jira] [Commented] (CALCITE-3065) RexLiteral#getValueAs should consider primitive type

2019-05-13 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838504#comment-16838504 ] Danny Chan commented on CALCITE-3065: - Please give us more details about why this i

[jira] [Updated] (CALCITE-3065) RexLiteral#getValueAs should consider primitive type

2019-05-13 Thread Jiatao Tao (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3065?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiatao Tao updated CALCITE-3065: Attachment: image-2019-05-13-12-04-36-365.png > RexLiteral#getValueAs should consider primitive t

[jira] [Updated] (CALCITE-3065) RexLiteral#getValueAs should consider primitive type

2019-05-13 Thread Jiatao Tao (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3065?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiatao Tao updated CALCITE-3065: Attachment: (was: image-2019-05-13-11-58-54-852.png) > RexLiteral#getValueAs should consider

[jira] [Updated] (CALCITE-3065) RexLiteral#getValueAs should consider primitive type

2019-05-13 Thread Jiatao Tao (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3065?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiatao Tao updated CALCITE-3065: Description: !image-2019-05-13-12-04-36-365.png! (was: !image-2019-05-13-11-58-54-852.png!) > R

[jira] [Updated] (CALCITE-3065) RexLiteral#getValueAs should consider primitive type

2019-05-13 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3065?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3065: Labels: pull-request-available (was: ) > RexLiteral#getValueAs should consider primitive

[jira] [Commented] (CALCITE-3065) RexLiteral#getValueAs should consider primitive type

2019-05-13 Thread Jiatao Tao (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838493#comment-16838493 ] Jiatao Tao commented on CALCITE-3065: - I would like to take this JIRA if community

[jira] [Updated] (CALCITE-3065) RexLiteral#getValueAs should consider primitive type

2019-05-13 Thread Jiatao Tao (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3065?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiatao Tao updated CALCITE-3065: Environment: (was: I would like to take this JIRA if community think this is indeed a problem

[jira] [Created] (CALCITE-3065) RexLiteral#getValueAs should consider primitive type

2019-05-13 Thread Jiatao Tao (JIRA)
Jiatao Tao created CALCITE-3065: --- Summary: RexLiteral#getValueAs should consider primitive type Key: CALCITE-3065 URL: https://issues.apache.org/jira/browse/CALCITE-3065 Project: Calcite Issue

[jira] [Commented] (CALCITE-3017) Improve null handling of JsonValueExpressionOperator

2019-05-13 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3017?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838458#comment-16838458 ] Hongze Zhang commented on CALCITE-3017: --- Since the issue blocks the attempt on re

[jira] [Commented] (CALCITE-2173) Sample implementation of ArrowAdapter

2019-05-13 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838403#comment-16838403 ] Lai Zhou commented on CALCITE-2173: --- [~masayuki038], I'll take some time to review yo

[jira] [Resolved] (CALCITE-3061) Query with WITH clause fails when alias is the same as the table with rolled up column

2019-05-13 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved CALCITE-3061. -- Resolution: Fixed Fixed in [d0a06f7|https://github.com/apache/calcite/commit

[jira] [Resolved] (CALCITE-3064) [JDBC function escape] String not implemented REPEAT

2019-05-13 Thread Chunwei Lei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei resolved CALCITE-3064. -- Resolution: Duplicate Fix Version/s: (was: 1.19.0) > [JDBC function escape] String

[jira] [Reopened] (CALCITE-3064) [JDBC function escape] String not implemented REPEAT

2019-05-13 Thread Chunwei Lei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reopened CALCITE-3064: -- Reopen to mark it duplicated. > [JDBC function escape] String not implemented REPEAT > -

[jira] [Updated] (CALCITE-2601) Support REVERSE(str) in SqlFunctions

2019-05-13 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-2601: Labels: pull-request-available (was: ) > Support REVERSE(str) in SqlFunctions >

[jira] [Commented] (CALCITE-2601) Support REVERSE(str) in SqlFunctions

2019-05-13 Thread pingle wang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838347#comment-16838347 ] pingle wang commented on CALCITE-2601: -- [~julianhyde]  mysql, sql server, hive, po