[jira] [Commented] (SPARK-16951) Alternative implementation of NOT IN to Anti-join

[ https://issues.apache.org/jira/browse/SPARK-16951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17102336#comment-17102336 ] linna shuang commented on SPARK-16951: -- In TPC-H test, we met performance issue of Q16, which used

[jira] [Commented] (SPARK-16951) Alternative implementation of NOT IN to Anti-join

[ https://issues.apache.org/jira/browse/SPARK-16951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15880694#comment-15880694 ] Nattavut Sutyanyong commented on SPARK-16951: - I am going to close off this JIRA at this

[jira] [Commented] (SPARK-16951) Alternative implementation of NOT IN to Anti-join

[ https://issues.apache.org/jira/browse/SPARK-16951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15767904#comment-15767904 ] Nattavut Sutyanyong commented on SPARK-16951: - I was wrong on case 3 when the subquery

[jira] [Commented] (SPARK-16951) Alternative implementation of NOT IN to Anti-join

[ https://issues.apache.org/jira/browse/SPARK-16951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15452430#comment-15452430 ] Nattavut Sutyanyong commented on SPARK-16951: - For the record, I opened SPARK-17337 for the

[jira] [Commented] (SPARK-16951) Alternative implementation of NOT IN to Anti-join

[ https://issues.apache.org/jira/browse/SPARK-16951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15415350#comment-15415350 ] Nattavut Sutyanyong commented on SPARK-16951: - On the incorrect result in Case 1, it is good

[jira] [Commented] (SPARK-16951) Alternative implementation of NOT IN to Anti-join

[ https://issues.apache.org/jira/browse/SPARK-16951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15415340#comment-15415340 ] Nattavut Sutyanyong commented on SPARK-16951: - I think I will make this the last comment on

[jira] [Commented] (SPARK-16951) Alternative implementation of NOT IN to Anti-join

[ https://issues.apache.org/jira/browse/SPARK-16951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15413817#comment-15413817 ] Herman van Hovell commented on SPARK-16951: --- If you read the paper a bit further along (second

[jira] [Commented] (SPARK-16951) Alternative implementation of NOT IN to Anti-join

[ https://issues.apache.org/jira/browse/SPARK-16951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15413773#comment-15413773 ] Nattavut Sutyanyong commented on SPARK-16951: - I found this

[jira] [Commented] (SPARK-16951) Alternative implementation of NOT IN to Anti-join

[ https://issues.apache.org/jira/browse/SPARK-16951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15413753#comment-15413753 ] Nattavut Sutyanyong commented on SPARK-16951: - Thanks, @hvanhovelll, for the VLDB paper. It

[jira] [Commented] (SPARK-16951) Alternative implementation of NOT IN to Anti-join

[ https://issues.apache.org/jira/browse/SPARK-16951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15413153#comment-15413153 ] Herman van Hovell commented on SPARK-16951: --- Case 1 is a result of an optimizer bug. Apparently

[jira] [Commented] (SPARK-16951) Alternative implementation of NOT IN to Anti-join

[ https://issues.apache.org/jira/browse/SPARK-16951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15412882#comment-15412882 ] Nattavut Sutyanyong commented on SPARK-16951: - The following output is tested on Spark master

[jira] [Commented] (SPARK-16951) Alternative implementation of NOT IN to Anti-join

[ https://issues.apache.org/jira/browse/SPARK-16951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15412878#comment-15412878 ] Nattavut Sutyanyong commented on SPARK-16951: - The semantic of {{NOT IN}} is described in