[jira] [Commented] (CALCITE-6188) Multi-query optimization

[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17810169#comment-17810169 ] Julian Hyde commented on CALCITE-6188: -- Thank you, [~zabetak]! I knew Hive had such a syntax, but

[jira] [Commented] (CALCITE-6188) Multi-query optimization

[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17809478#comment-17809478 ] Stamatis Zampetakis commented on CALCITE-6188: -- Regarding the Multi DML use case, some

[jira] [Commented] (CALCITE-6188) Multi-query optimization

[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17804855#comment-17804855 ] Julian Hyde commented on CALCITE-6188: -- I forgot an important case. Two or more queries that can

[jira] [Commented] (CALCITE-6188) Multi-query optimization

[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17804548#comment-17804548 ] Jay Narale commented on CALCITE-6188: - Makes sense, and I think we could reuse our scheduling dag

[jira] [Commented] (CALCITE-6188) Multi-query optimization

[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17804010#comment-17804010 ] Julian Hyde commented on CALCITE-6188: -- The DML options are probably syntactic sugar. Note that

[jira] [Commented] (CALCITE-6188) Multi-query optimization

[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803759#comment-17803759 ] Jay Narale commented on CALCITE-6188: - I think the second syntax will work well! This is awesome! 

[jira] [Commented] (CALCITE-6188) Multi-query optimization

[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803732#comment-17803732 ] Julian Hyde commented on CALCITE-6188: -- I had an idea for DML. The idea is that each DML operation

[jira] [Commented] (CALCITE-6188) Multi-query optimization

[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803691#comment-17803691 ] Jay Narale commented on CALCITE-6188: - In our case for CTE materialization, the series and the

[jira] [Commented] (CALCITE-6188) Multi-query optimization

[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803650#comment-17803650 ] Julian Hyde commented on CALCITE-6188: -- I got some feedback on twitter that we need to be able to

[jira] [Commented] (CALCITE-6188) Multi-query optimization

[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803376#comment-17803376 ] Jay Narale commented on CALCITE-6188: - Not sure if it is the same but currently we treat the

[jira] [Commented] (CALCITE-6188) Multi-query optimization

[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803373#comment-17803373 ] Julian Hyde commented on CALCITE-6188: -- Thank you, [~jaynarale]! The sequence node is not

[jira] [Commented] (CALCITE-6188) Multi-query optimization

[ https://issues.apache.org/jira/browse/CALCITE-6188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17803368#comment-17803368 ] Jay Narale commented on CALCITE-6188: - We in Presto have recently supported CTE materialization