Skip to content

bug: explain estimated rows is zero when select * from stage #9884

Open
@BohuTANG

Description

@BohuTANG

Summary

Count:

mysql> select count() from @lake (pattern => '.*parquet');
+----------+
| count()  |
+----------+
| 10000000 |
+----------+

explain:

mysql> explain select * from @lake (pattern => '.*parquet');
+--------------------------------------------------+
| explain                                          |
+--------------------------------------------------+
| TableScan                                        |
| ├── table: default.system.read_parquet           |
| ├── read rows: 10000000                          |
| ├── read bytes: 1552567904                       |
| ├── partitions total: 9766                       |
| ├── partitions scanned: 9766                     |
| ├── push downs: [filters: [], limit: NONE]       |
| └── estimated rows: 0.00                         |
+--------------------------------------------------+

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-plannerArea: planner/optimizerC-bugCategory: something isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions