[jira] [Commented] (DRILL-5468) TPCH Q18 regressed ~3x due to execution plan changes

[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16227570#comment-16227570 ] Dechang Gu commented on DRILL-5468: --- I tried this setting on SF100, Q18 did not show the 3x regression,

[jira] [Commented] (DRILL-5468) TPCH Q18 regressed ~3x due to execution plan changes

[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086558#comment-16086558 ] Jinfeng Ni commented on DRILL-5468: --- [~amansinha100], thanks. I think Option 1 makes sense for 1.11.

[jira] [Commented] (DRILL-5468) TPCH Q18 regressed ~3x due to execution plan changes

[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086552#comment-16086552 ] Aman Sinha commented on DRILL-5468: --- [~jni] Option 1 would be my preference for 1.11 .. it can be done

[jira] [Commented] (DRILL-5468) TPCH Q18 regressed ~3x due to execution plan changes

[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086540#comment-16086540 ] Jinfeng Ni commented on DRILL-5468: --- Looks like we have a couple of options: - Option 1 : leave the

[jira] [Commented] (DRILL-5468) TPCH Q18 regressed ~3x due to execution plan changes

[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16086530#comment-16086530 ] Jinfeng Ni commented on DRILL-5468: --- [~amansinha100], turns out that the reason Drill did not pick

[jira] [Commented] (DRILL-5468) TPCH Q18 regressed ~3x due to execution plan changes

[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16084522#comment-16084522 ] Jinfeng Ni commented on DRILL-5468: --- [~amansinha100], you are right that the HAVING predicate {{having