[jira] [Commented] (CALCITE-4198) Query contains AVG function, materialized view contains SUM and COUNT functions, and materialized recognition fails

2020-09-08 Thread zhishui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17192530#comment-17192530 ] zhishui commented on CALCITE-4198: -- It's quite troublesome. I think we could ask devel

[jira] [Commented] (CALCITE-4198) Query contains AVG function, materialized view contains SUM and COUNT functions, and materialized recognition fails

2020-09-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17192366#comment-17192366 ] Julian Hyde commented on CALCITE-4198: -- I agree, but I doubt that the solution is

[jira] [Commented] (CALCITE-4198) Query contains AVG function, materialized view contains SUM and COUNT functions, and materialized recognition fails

2020-09-07 Thread zhishui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17191886#comment-17191886 ] zhishui commented on CALCITE-4198: -- However, there are not equals between float NOT NU

[jira] [Commented] (CALCITE-4198) Query contains AVG function, materialized view contains SUM and COUNT functions, and materialized recognition fails

2020-09-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17191879#comment-17191879 ] Julian Hyde commented on CALCITE-4198: -- The only difference between float and java

[jira] [Commented] (CALCITE-4198) Query contains AVG function, materialized view contains SUM and COUNT functions, and materialized recognition fails

2020-09-07 Thread zhishui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17191521#comment-17191521 ] zhishui commented on CALCITE-4198: -- [~xzh_dz] I have add some fix about second and thi

[jira] [Commented] (CALCITE-4198) Query contains AVG function, materialized view contains SUM and COUNT functions, and materialized recognition fails

2020-09-06 Thread zhishui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17191477#comment-17191477 ] zhishui commented on CALCITE-4198: -- [~xzh_dz], [~julianhyde] when I try to support avg

[jira] [Commented] (CALCITE-4198) Query contains AVG function, materialized view contains SUM and COUNT functions, and materialized recognition fails

2020-09-03 Thread zhishui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17190443#comment-17190443 ] zhishui commented on CALCITE-4198: -- I'm sorry for that I don't take some cases into ac

[jira] [Commented] (CALCITE-4198) Query contains AVG function, materialized view contains SUM and COUNT functions, and materialized recognition fails

2020-09-03 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17190155#comment-17190155 ] xzh_dz commented on CALCITE-4198: - [~zhishui]  Sorry for the late reply, you can take

[jira] [Commented] (CALCITE-4198) Query contains AVG function, materialized view contains SUM and COUNT functions, and materialized recognition fails

2020-09-02 Thread zhishui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17189331#comment-17189331 ] zhishui commented on CALCITE-4198: -- I have resolve this problem in [https://github.com

[jira] [Commented] (CALCITE-4198) Query contains AVG function, materialized view contains SUM and COUNT functions, and materialized recognition fails

2020-08-31 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17187502#comment-17187502 ] Danny Chen commented on CALCITE-4198: - Thanks [~zhishui] ~, i have assigned this is

[jira] [Commented] (CALCITE-4198) Query contains AVG function, materialized view contains SUM and COUNT functions, and materialized recognition fails

2020-08-29 Thread zhishui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17186979#comment-17186979 ] zhishui commented on CALCITE-4198: -- could assign to me, I think I have a solution to h