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)