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

[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707479#comment-17707479 ] Guillaume Massé commented on CALCITE-5624: -- Thanks for your feedback, I will make the

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

[ 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

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

[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707467#comment-17707467 ] Julian Hyde commented on CALCITE-5625: -- You don't need to support every {{Comparable}}. It is

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

[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707462#comment-17707462 ] Julian Hyde commented on CALCITE-5625: -- The problem with expanding ranges is that they sometimes

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

[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707458#comment-17707458 ] Julian Hyde commented on CALCITE-5625: -- Did you notice RangeSets.Consumer and RangeSets.Handler?

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

[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707457#comment-17707457 ] Julian Hyde commented on CALCITE-5624: -- The current PR is what I call a "drill a hole" change. It

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

[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707454#comment-17707454 ] Julian Hyde commented on CALCITE-5624: -- Before we dive into PRs, can we get to a precise

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

[ https://issues.apache.org/jira/browse/CALCITE-5614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707440#comment-17707440 ] Oliver Lee edited comment on CALCITE-5614 at 3/31/23 11:08 PM: --- I have a

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

[ https://issues.apache.org/jira/browse/CALCITE-5614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707440#comment-17707440 ] Oliver Lee edited comment on CALCITE-5614 at 3/31/23 11:00 PM: --- I have a

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

[ https://issues.apache.org/jira/browse/CALCITE-5614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707440#comment-17707440 ] Oliver Lee commented on CALCITE-5614: - I have a draft PR that is working for

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

[ 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

[ https://issues.apache.org/jira/browse/CALCITE-5614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707412#comment-17707412 ] Oliver Lee commented on CALCITE-5614: - The difficulty comes from serializing {{RangeSet}} and its

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

[ 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

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

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

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

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

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

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

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

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

[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707374#comment-17707374 ] TJ Banghart commented on CALCITE-5625: -- Hey [~julianhyde] thanks for taking a look! When

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

[ 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.

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

[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707347#comment-17707347 ] Guillaume Massé commented on CALCITE-5624: -- [~julianhyde] :

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

[ https://issues.apache.org/jira/browse/CALCITE-5627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707274#comment-17707274 ] Xurenhe commented on CALCITE-5627: -- [~libenchao]  Thanks for your quick reply. In some cases, keeping

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

[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707249#comment-17707249 ] Jiajun Xie commented on CALCITE-5506: - [~libenchao] , yes. RelFieldTrimmer is correct.   I found

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

[ https://issues.apache.org/jira/browse/CALCITE-5627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707244#comment-17707244 ] Benchao Li commented on CALCITE-5627: - I agree that the correlation id and sub-query is not easy

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

[ 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 ) →

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

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

[jira] [Commented] (CALCITE-5616) Allow unparsing of SqlIntervalQualifier in EXTRACT to be overridden by dialects

[ https://issues.apache.org/jira/browse/CALCITE-5616?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707153#comment-17707153 ] Julian Hyde commented on CALCITE-5616: -- Did you consider overriding {{SqlDialect.unparseCall}}?

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

[ https://issues.apache.org/jira/browse/CALCITE-5619?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5619: - Fix Version/s: 1.35.0 > Support PostgreSQL's TO_CHAR function >

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

[ https://issues.apache.org/jira/browse/CALCITE-5619?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707148#comment-17707148 ] Julian Hyde commented on CALCITE-5619: -- Thanks for the PR, [~tnieradzik]. In his fix for

[jira] [Commented] (CALCITE-5590) NullPointerException when converting 'in' expression that is used inside select list and group by

[ https://issues.apache.org/jira/browse/CALCITE-5590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707140#comment-17707140 ] Benchao Li commented on CALCITE-5590: - [~dmsysolyatin] Thanks for the quick response and