[
https://issues.apache.org/jira/browse/ASTERIXDB-3126?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vijay Sarathy reopened ASTERIXDB-3126:
--------------------------------------
> CBO: hint productivity NPE if missing cardinality estimate on collection
> ------------------------------------------------------------------------
>
> Key: ASTERIXDB-3126
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3126
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Affects Versions: 0.9.6
> Reporter: Vijay Sarathy
> Assignee: Vijay Sarathy
> Priority: Major
>
> To repro, run following with productivity hint without productivity value
> |SELECT COUNT(DISTINCT r.destinationairport)|
> |FROM airport a|
> | JOIN route r ON r.sourceairport /*+ productivity */ = a.faa|
> |WHERE a.city = 'San Francisco'|
> | AND a.country = 'United States'|
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
