You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Vijay Sarathy (Jira)" <ji...@apache.org> on 2023/03/15 00:51:00 UTC
[jira] [Assigned] (ASTERIXDB-3139) cardinality in explain should not be in decimal format
[ https://issues.apache.org/jira/browse/ASTERIXDB-3139?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vijay Sarathy reassigned ASTERIXDB-3139:
----------------------------------------
Assignee: Vijay Sarathy
> 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)