[
https://issues.apache.org/jira/browse/ASTERIXDB-3139?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vijay Sarathy updated ASTERIXDB-3139:
-------------------------------------
Description:
explain SELECT COUNT(DISTINCT r.destinationairport) FROM airport a JOIN route r
ON r.sourceairport = a.faa WHERE a.city = 'San Francisco' AND a.country =
'United States';
{
"operator": "distribute-result",
"expressions": [
"$$53"
],
"operatorId": "1.1",
"physical-operator": "DISTRIBUTE_RESULT",
"execution-mode": "UNPARTITIONED",
"optimizer-estimates":
{ "cardinality": 2.4, ---> CARDINALITY SHOULD NOT SHOW FRACTIONAL VALUE
"op-cost": 0, "total-cost": 18379.44 }
,
was:
explain SELECT COUNT(DISTINCT r.destinationairport) FROM airport a JOIN route r
ON r.sourceairport = a.faa WHERE a.city = 'San Francisco' AND a.country =
'United States';
{
"operator": "distribute-result",
"expressions": [
"$$53"
],
"operatorId": "1.1",
"physical-operator": "DISTRIBUTE_RESULT",
"execution-mode": "UNPARTITIONED",
"optimizer-estimates": {
"cardinality": 2.4, ---> CARDINALITY SHOULD NOT SHOW FRACTIONAL VALUE
"op-cost": 0,
"total-cost": 18379.44
},
> cardinality in explain should not be in decimal format
> ------------------------------------------------------
>
> Key: ASTERIXDB-3139
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3139
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Reporter: Vijay Sarathy
> Assignee: Vijay Sarathy
> Priority: Major
>
> explain SELECT COUNT(DISTINCT r.destinationairport) FROM airport a JOIN route
> r ON r.sourceairport = a.faa WHERE a.city = 'San Francisco' AND a.country =
> 'United States';
>
> {
> "operator": "distribute-result",
> "expressions": [
> "$$53"
> ],
> "operatorId": "1.1",
> "physical-operator": "DISTRIBUTE_RESULT",
> "execution-mode": "UNPARTITIONED",
> "optimizer-estimates":
> { "cardinality": 2.4, ---> CARDINALITY SHOULD NOT SHOW FRACTIONAL VALUE
>
> "op-cost": 0, "total-cost": 18379.44 }
> ,
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
