[
https://issues.apache.org/jira/browse/ASTERIXDB-3126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17698644#comment-17698644
]
Vijay Sarathy commented on ASTERIXDB-3126:
------------------------------------------
Bug was reopened as there were other cases of NPE with cardinality hints as
shown below:
|cbq> SELECT COUNT(DISTINCT r.destinationairport) FROM airport a JOIN route r
ON r.sourceairport /*+ productivity 100.0*/ = a.faa WHERE a.city = 'San
Francisco' AND a.country = 'United States';|
|{|
|"requestID": "c3adfae9-c2c9-494b-a0ec-979196b8a27a",|
|"errors": [{ |
|"code": 25000, "msg": "Internal error" } |
|],|
|"status": "fatal",|
|cbq> SELECT COUNT(DISTINCT r.destinationairport) FROM airport a JOIN route r
ON r.sourceairport /*+ productivity a*/ = a.faa WHERE a.city = 'San Francisco'
AND a.country = 'United States';|
|{|
|"requestID": "a932161c-cd00-4565-aa78-727b669f4acb",|
|"errors": [{ |
|"code": 25000, "msg": "Internal error" } |
|],|
|"status": "fatal",|
|SELECT COUNT(DISTINCT r.destinationairport)|
|FROM airport a|
| JOIN route r ON r.sourceairport /*+ productivity r 100*/ = a.faa|
|WHERE a.city = 'San Francisco'|
| AND a.country = 'United States'|
Fixed by checking for other possible incorrect hint formulations and provided
appropriate warnings in such cases instead of crashing.
> 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)
