[ https://issues.apache.org/jira/browse/HIVE-23933?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
mahesh kumar behera updated HIVE-23933: --------------------------------------- Description: Current calcite 21 does not support getRowCountInt for anti join.The selectivity calculation for anti join should be different than semi join. It should be 1-semi join selectivity. (was: The current anti join conversion does not support direct conversion of not-exists to anti join. The not exists sub query is converted first to left out join and then its converted to anti join. This may cause some of the optimization rule to be skipped. ) > Add getRowCountInt support for anti join in calcite. > ------------------------------------------------------ > > Key: HIVE-23933 > URL: https://issues.apache.org/jira/browse/HIVE-23933 > Project: Hive > Issue Type: Bug > Reporter: mahesh kumar behera > Assignee: mahesh kumar behera > Priority: Major > > Current calcite 21 does not support getRowCountInt for anti join.The > selectivity calculation for anti join should be different than semi join. It > should be 1-semi join selectivity. -- This message was sent by Atlassian Jira (v8.3.4#803005)