[jira] [Commented] (CALCITE-5624) Cannot parse array function for Spark Dialect

2023-03-31 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707479#comment-17707479 ] Guillaume Massé commented on CALCITE-5624: -- Thanks for your feedback, I will m

[jira] [Updated] (CALCITE-5624) Cannot parse array function for Spark Dialect

2023-03-31 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Guillaume Massé updated CALCITE-5624: - Description: The following query is valid in Apache Spark. {code:java} spark-shell sca

[jira] [Commented] (CALCITE-5625) Expand SEARCH RexNode when converting toJson

2023-03-31 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707467#comment-17707467 ] Julian Hyde commented on CALCITE-5625: -- You don't need to support every {{Comparab

[jira] [Commented] (CALCITE-5625) Expand SEARCH RexNode when converting toJson

2023-03-31 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707462#comment-17707462 ] Julian Hyde commented on CALCITE-5625: -- The problem with expanding ranges is that

[jira] [Commented] (CALCITE-5625) Expand SEARCH RexNode when converting toJson

2023-03-31 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707458#comment-17707458 ] Julian Hyde commented on CALCITE-5625: -- Did you notice RangeSets.Consumer and Rang

[jira] [Commented] (CALCITE-5624) Cannot parse array function for Spark Dialect

2023-03-31 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707457#comment-17707457 ] Julian Hyde commented on CALCITE-5624: -- The current PR is what I call a "drill a h

[jira] [Commented] (CALCITE-5624) Cannot parse array function for Spark Dialect

2023-03-31 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707454#comment-17707454 ] Julian Hyde commented on CALCITE-5624: -- Before we dive into PRs, can we get to a p

[jira] [Comment Edited] (CALCITE-5614) Serialize and deserialize Sarg objects

2023-03-31 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707440#comment-17707440 ] Oliver Lee edited comment on CALCITE-5614 at 3/31/23 11:08 PM: --

[jira] [Comment Edited] (CALCITE-5614) Serialize and deserialize Sarg objects

2023-03-31 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707440#comment-17707440 ] Oliver Lee edited comment on CALCITE-5614 at 3/31/23 11:00 PM: --

[jira] [Commented] (CALCITE-5614) Serialize and deserialize Sarg objects

2023-03-31 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707440#comment-17707440 ] Oliver Lee commented on CALCITE-5614: - I have a draft PR that is working for serial

[jira] [Assigned] (CALCITE-3959) Implement INSTR function

2023-03-31 Thread Joey Moore (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joey Moore reassigned CALCITE-3959: --- Assignee: Joey Moore > Implement INSTR function > > >

[jira] [Commented] (CALCITE-5614) Serialize and deserialize Sarg objects

2023-03-31 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707412#comment-17707412 ] Oliver Lee commented on CALCITE-5614: - The difficulty comes from serializing {{Rang

[jira] [Updated] (CALCITE-5628) Cannot parse map function for Spark Dialect

2023-03-31 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5628?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5628: Labels: pull-request-available (was: ) > Cannot parse map function for Spark Dialect > -

[jira] [Created] (CALCITE-5628) Cannot parse map function for Spark Dialect

2023-03-31 Thread Jira
Guillaume Massé created CALCITE-5628: Summary: Cannot parse map function for Spark Dialect Key: CALCITE-5628 URL: https://issues.apache.org/jira/browse/CALCITE-5628 Project: Calcite Issue

[jira] [Comment Edited] (CALCITE-5625) Expand SEARCH RexNode when converting toJson

2023-03-31 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707374#comment-17707374 ] TJ Banghart edited comment on CALCITE-5625 at 3/31/23 5:56 PM: --

[jira] [Comment Edited] (CALCITE-5625) Expand SEARCH RexNode when converting toJson

2023-03-31 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707374#comment-17707374 ] TJ Banghart edited comment on CALCITE-5625 at 3/31/23 5:55 PM: --

[jira] [Comment Edited] (CALCITE-5625) Expand SEARCH RexNode when converting toJson

2023-03-31 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707374#comment-17707374 ] TJ Banghart edited comment on CALCITE-5625 at 3/31/23 5:55 PM: --

[jira] [Commented] (CALCITE-5625) Expand SEARCH RexNode when converting toJson

2023-03-31 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707374#comment-17707374 ] TJ Banghart commented on CALCITE-5625: -- Hey [~julianhyde] thanks for taking a look

[jira] [Updated] (CALCITE-5624) Cannot parse array function for Spark Dialect

2023-03-31 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Guillaume Massé updated CALCITE-5624: - Description: AtomicRowExpression should not have ArrayConstructor for Apache Spark. Arr

[jira] [Commented] (CALCITE-5624) Cannot parse array function for Spark Dialect

2023-03-31 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707347#comment-17707347 ] Guillaume Massé commented on CALCITE-5624: -- [~julianhyde] : [https://github.co

[jira] [Commented] (CALCITE-5627) The rule of 'CoreRules.FILTER_INTO_JOIN' executed error, if some condition is sub-query

2023-03-31 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707274#comment-17707274 ] Xurenhe commented on CALCITE-5627: -- [~libenchao]  Thanks for your quick reply. In som

[jira] [Commented] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic

2023-03-31 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707249#comment-17707249 ] Jiajun Xie commented on CALCITE-5506: - [~libenchao] , yes. RelFieldTrimmer is corr

[jira] [Commented] (CALCITE-5627) The rule of 'CoreRules.FILTER_INTO_JOIN' executed error, if some condition is sub-query

2023-03-31 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707244#comment-17707244 ] Benchao Li commented on CALCITE-5627: - I agree that the correlation id and sub-quer

[jira] [Updated] (CALCITE-5619) Support PostgreSQL's TO_CHAR function

2023-03-31 Thread Tim Nieradzik (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5619?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tim Nieradzik updated CALCITE-5619: --- Description: PostgreSQL has three to_char() functions: {{to_char ( timestamp, text ) → tex

[jira] [Created] (CALCITE-5627) The rule of 'CoreRules.FILTER_INTO_JOIN' executed error, if some condition is sub-query

2023-03-31 Thread Xurenhe (Jira)
Xurenhe created CALCITE-5627: Summary: The rule of 'CoreRules.FILTER_INTO_JOIN' executed error, if some condition is sub-query Key: CALCITE-5627 URL: https://issues.apache.org/jira/browse/CALCITE-5627 Pro