[jira] [Commented] (CALCITE-4754) Invalid Redshift SQL when executing a PIVOT query

2021-11-18 Thread Javier Rivas Rodriguez (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17446139#comment-17446139 ] Javier Rivas Rodriguez commented on CALCITE-4754: - Hi [~julianhyde] I h

[jira] [Resolved] (CALCITE-4841) Support decimal column type in CSV and File adapter

2021-11-18 Thread Jacques Nadeau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Nadeau resolved CALCITE-4841. - Fix Version/s: 1.29.0 Resolution: Fixed Resolved in [065e323da89ca73a46bec195ef

[jira] [Updated] (CALCITE-4894) MV rewriting fails for expressions with more than a field reference in the view/query projection

2021-11-18 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4894: Labels: pull-request-available (was: ) > MV rewriting fails for expressions with more th

[jira] [Commented] (CALCITE-4894) MV rewriting fails for expressions with more than a field reference in the view/query projection

2021-11-18 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17446032#comment-17446032 ] Alessandro Solimando commented on CALCITE-4894: --- It's probably half-way b

[jira] [Commented] (CALCITE-4894) MV rewriting fails for expressions with more than a field reference in the view/query projection

2021-11-18 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17445963#comment-17445963 ] Vladimir Sitnikov commented on CALCITE-4894: I do not understand your use c

[jira] [Commented] (CALCITE-4888) Unexpected `RexNode` when call `RelBuilder.in` to create an `IN` predicate with a list of varchar literals which have different length

2021-11-18 Thread duan xiong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17445959#comment-17445959 ] duan xiong commented on CALCITE-4888: - [~qingru zhang] Hi. I'm very glad about you'

[jira] [Commented] (CALCITE-4894) MV rewriting fails for expressions with more than a field reference in the view/query projection

2021-11-18 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17445954#comment-17445954 ] Alessandro Solimando commented on CALCITE-4894: --- My rule of thumb for ass

[jira] [Commented] (CALCITE-4894) MV rewriting fails for expressions with more than a field reference in the view/query projection

2021-11-18 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17445939#comment-17445939 ] Vladimir Sitnikov commented on CALCITE-4894: Just wondering: should it be a

[jira] [Commented] (CALCITE-4894) MV rewriting fails for expressions with more than a field reference in the view/query projection

2021-11-18 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17445937#comment-17445937 ] Alessandro Solimando commented on CALCITE-4894: --- I agree, [~vladimirsitni

[jira] [Assigned] (CALCITE-4894) MV rewriting fails for expressions with more than a field reference in the view/query projection

2021-11-18 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-4894: - Assignee: Alessandro Solimando > MV rewriting fails for expressions wi

[jira] [Commented] (CALCITE-4892) Conversion from String in cursor accessors

2021-11-18 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17445850#comment-17445850 ] Stamatis Zampetakis commented on CALCITE-4892: -- Thanks for logging this [~

[jira] [Commented] (CALCITE-4884) Provide a new constructor for RelJsonWriter to allow customized JsonBuilder

2021-11-18 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4884?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17445839#comment-17445839 ] Stamatis Zampetakis commented on CALCITE-4884: -- Great thanks [~Chunwei Lei

[jira] [Commented] (CALCITE-4894) MV rewriting fails for expressions with more than a field reference in the view/query projection

2021-11-18 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17445811#comment-17445811 ] Vladimir Sitnikov commented on CALCITE-4894: The comment should have been a

[jira] [Updated] (CALCITE-4894) MV rewriting fails for expressions with more than a field reference in the view/query projection

2021-11-18 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-4894: -- Description: MV rewrite fails when at least one expression in the project of

[jira] [Updated] (CALCITE-4894) MV rewriting fails for expressions with more than a field reference in the view/query projection

2021-11-18 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-4894: -- Description: MV rewrite fails when at least one expression in the project of

[jira] [Created] (CALCITE-4894) MV rewriting fails for expressions with more than a field reference in the view/query projection

2021-11-18 Thread Alessandro Solimando (Jira)
Alessandro Solimando created CALCITE-4894: - Summary: MV rewriting fails for expressions with more than a field reference in the view/query projection Key: CALCITE-4894 URL: https://issues.apache.org/jira/b

[jira] [Updated] (CALCITE-4893) JsonParseException happens when externalizing expressions with escape character from JSON

2021-11-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-4893: - Description: When the expression has escape characters, such as "\r", "\t" and so on, it canno

[jira] [Updated] (CALCITE-4893) JsonParseException happens when externalizing expressions with escape character from JSON

2021-11-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-4893: - Description: When the expression has escape characters, such as "\r", "'\\'" and so on, it can

[jira] [Updated] (CALCITE-4893) JsonParseException happens when externalizing expressions with escape character from JSON

2021-11-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-4893: - Description: {{When the expression has escape characters, such as "\r", "\\" and so on, it can

[jira] [Updated] (CALCITE-4893) JsonParseException happens when externalizing expressions with escape character from JSON

2021-11-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-4893: - Description: When the expression has escape characters, such as "\r", "\\\" and so on, it cann

[jira] [Updated] (CALCITE-4893) JsonParseException happens when externalizing expressions with escape character from JSON

2021-11-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-4893: - Description: When the expression has escape characters, such as "\r", "\\" and so on, it canno

[jira] [Updated] (CALCITE-4893) JsonParseException happens when externalizing expressions with escape character from JSON

2021-11-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-4893: - Description: When the expression has escape characters, such as "\r", "\\" and so on, it canno

[jira] [Comment Edited] (CALCITE-4887) Filter subQuery remove not fully optimized

2021-11-18 Thread bingfeng.guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4887?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17445754#comment-17445754 ] bingfeng.guo edited comment on CALCITE-4887 at 11/18/21, 9:14 AM: ---

[jira] [Comment Edited] (CALCITE-4887) Filter subQuery remove not fully optimized

2021-11-18 Thread bingfeng.guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4887?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17445754#comment-17445754 ] bingfeng.guo edited comment on CALCITE-4887 at 11/18/21, 9:14 AM: ---

[jira] [Commented] (CALCITE-4884) Provide a new constructor for RelJsonWriter to allow customized JsonBuilder

2021-11-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4884?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17445759#comment-17445759 ] Chunwei Lei commented on CALCITE-4884: -- [~zabetak] , I opened another issue([CALC

[jira] [Comment Edited] (CALCITE-4884) Provide a new constructor for RelJsonWriter to allow customized JsonBuilder

2021-11-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4884?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17445759#comment-17445759 ] Chunwei Lei edited comment on CALCITE-4884 at 11/18/21, 9:07 AM:

[jira] [Updated] (CALCITE-4893) JsonParseException happens when externalizing expressions with escape character from JSON

2021-11-18 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-4893: - Description: The following test can reproduce the error. {code:java} // RelWriterTest.java @Tes

[jira] [Created] (CALCITE-4893) JsonParseException happens when externalizing expressions with escape character from JSON

2021-11-18 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-4893: Summary: JsonParseException happens when externalizing expressions with escape character from JSON Key: CALCITE-4893 URL: https://issues.apache.org/jira/browse/CALCITE-4893

[jira] [Commented] (CALCITE-4887) Filter subQuery remove not fully optimized

2021-11-18 Thread bingfeng.guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4887?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17445754#comment-17445754 ] bingfeng.guo commented on CALCITE-4887: --- https://issues.apache.org/jira/browse/CA

[jira] [Updated] (CALCITE-4888) Unexpected `RexNode` when call `RelBuilder.in` to create an `IN` predicate with a list of varchar literals which have different length

2021-11-18 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4888?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4888: Labels: pull-request-available (was: ) > Unexpected `RexNode` when call `RelBuilder.in`

[jira] [Updated] (CALCITE-4883) The traitset of Exchange operator losses the distribution when externalizing Exchange operator from JSON

2021-11-18 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4883: Labels: pull-request-available (was: ) > The traitset of Exchange operator losses the di