Skip to content

Files() meta columns not materialized when data column is not read #66976

@eshishki

Description

@eshishki
SELECT * FROM files( 'path'='s3://xxx/col=test/*.csv.gz',     "compression" = "gzip",     'format'='csv','columns_from_path'='col'  ) limit 10;
+-----------+------+
| $1        | col  |
+-----------+------+
|  28361.22 | test |
|  28361.22 | test |
| 28361.221 | test |
| 28361.222 | test |
| 28361.223 | test |
| 28361.224 | test |
| 28361.225 | test |
| 28361.226 | test |
| 28361.227 | test |
| 28361.228 | test |
+-----------+------+
10 rows in set (0.30 sec)

SELECT col,count(*) FROM
files(  'path'='s3://xxx/col=test/*.csv.gz',     "compression" = "gzip",     'format'='csv','columns_from_path'='col'  ) group by 1;
Empty set (0.29 sec)

Metadata

Metadata

Assignees

No one assigned

    Labels

    type/bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions