[jira] [Commented] (CALCITE-5411) Update Spark Dialect to support ROLLUP & CUBE aggregate functions.

2023-03-27 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705816#comment-17705816 ] Benchao Li commented on CALCITE-5411: - Exactly, thanks for your comment [~julianhyde] . > Update

[jira] [Commented] (CALCITE-5513) Add Support Use Sql to recommend Materialized View

2023-03-27 Thread jhonye (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705808#comment-17705808 ] jhonye commented on CALCITE-5513: - Thanks [~julianhyde]. I know the Lattice and just read the

[jira] [Commented] (CALCITE-5588) ArrayIndexOutOfBoundsException on "on not exists" or "on exists"

2023-03-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705788#comment-17705788 ] Julian Hyde commented on CALCITE-5588: -- Yes, we could have changed the summary. But we chose

[jira] [Commented] (CALCITE-1308) Implement remaining DatabaseMetaData operations in RemoteMeta

2023-03-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1308?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705787#comment-17705787 ] Julian Hyde commented on CALCITE-1308: -- No news. Contributions welcome. > Implement remaining

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

2023-03-27 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5614?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Oliver Lee updated CALCITE-5614: Description: Context: Bounded filter conditions (e.g. {{{}SUM(field> > 1 AND SUM(field) <

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

2023-03-27 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5614?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Oliver Lee updated CALCITE-5614: Description: Context: Bounded filter conditions (e.g. {{{}SUM(field> > 1 AND SUM(field) <

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

2023-03-27 Thread Oliver Lee (Jira)
Oliver Lee created CALCITE-5614: --- Summary: Serialize and deserialize Sarg objects Key: CALCITE-5614 URL: https://issues.apache.org/jira/browse/CALCITE-5614 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-5613) Add assert for number of args for metadata methods at CacheGeneratorUtil

2023-03-27 Thread Sergey Nuyanzin (Jira)
Sergey Nuyanzin created CALCITE-5613: Summary: Add assert for number of args for metadata methods at CacheGeneratorUtil Key: CALCITE-5613 URL: https://issues.apache.org/jira/browse/CALCITE-5613

[jira] [Commented] (CALCITE-3312) TIMESTAMPDIFF cannot be converted to SQL

2023-03-27 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705703#comment-17705703 ] TJ Banghart commented on CALCITE-3312: -- Hey [~winipanda] have you started work on this? If not I'd

[jira] [Commented] (CALCITE-5411) Update Spark Dialect to support ROLLUP & CUBE aggregate functions.

2023-03-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705692#comment-17705692 ] Julian Hyde commented on CALCITE-5411: -- Thanks for this PR. To be pedantic, {{ROLLUP}} and

[jira] [Commented] (CALCITE-1308) Implement remaining DatabaseMetaData operations in RemoteMeta

2023-03-27 Thread Magnus Mogren (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1308?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705677#comment-17705677 ] Magnus Mogren commented on CALCITE-1308: Any news on this one? Would really be helpful if the

[jira] [Commented] (CALCITE-5588) ArrayIndexOutOfBoundsException on "on not exists" or "on exists"

2023-03-27 Thread Magnus Mogren (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705675#comment-17705675 ] Magnus Mogren commented on CALCITE-5588: Alright, the subject is changed now. Same exception

[jira] [Updated] (CALCITE-5588) ArrayIndexOutOfBoundsException on "on not exists" or "on exists"

2023-03-27 Thread Magnus Mogren (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5588?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Magnus Mogren updated CALCITE-5588: --- Summary: ArrayIndexOutOfBoundsException on "on not exists" or "on exists" (was:

[jira] [Assigned] (CALCITE-5612) Babel parser should support PostgreSQL's SET TRANSACTION command

2023-03-27 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin reassigned CALCITE-5612: -- Assignee: Dmitry Sysolyatin > Babel parser should support PostgreSQL's SET

[jira] [Commented] (CALCITE-5403) Babel parser should parse PostgreSQL's SET, RESET, BEGIN, SHOW, ROLLBACK, COMMIT commands

2023-03-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705359#comment-17705359 ] Julian Hyde commented on CALCITE-5403: -- I don’t mind whether you do them as “another task” but

[jira] [Commented] (CALCITE-5612) Babel parser should support PostgreSQL's SET TRANSACTION command

2023-03-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705345#comment-17705345 ] Julian Hyde commented on CALCITE-5612: -- Can you add some documentation for the (additional) syntax

[jira] [Commented] (CALCITE-5513) Add Support Use Sql to recommend Materialized View

2023-03-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705344#comment-17705344 ] Julian Hyde commented on CALCITE-5513: -- Did you investigate using Lattice and LatticeSuggester? >

[jira] [Created] (CALCITE-5612) Babel parser should support PostgreSQL's SET TRANSACTION command

2023-03-27 Thread Dmitry Sysolyatin (Jira)
Dmitry Sysolyatin created CALCITE-5612: -- Summary: Babel parser should support PostgreSQL's SET TRANSACTION command Key: CALCITE-5612 URL: https://issues.apache.org/jira/browse/CALCITE-5612

[jira] [Comment Edited] (CALCITE-5513) Add Support Use Sql to recommend Materialized View

2023-03-27 Thread jhonye (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705244#comment-17705244 ] jhonye edited comment on CALCITE-5513 at 3/27/23 10:43 AM: --- Design doc:

[jira] [Commented] (CALCITE-5513) Add Support Use Sql to recommend Materialized View

2023-03-27 Thread jhonye (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705244#comment-17705244 ] jhonye commented on CALCITE-5513: - Design doc:

[jira] [Updated] (CALCITE-5513) Add Support Use Sql to recommend Materialized View

2023-03-27 Thread jhonye (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jhonye updated CALCITE-5513: Attachment: image-2023-03-27-16-30-45-886.png > Add Support Use Sql to recommend Materialized View >