Vijay Sarathy created ASTERIXDB-3139:
----------------------------------------

             Summary: 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


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)

Reply via email to