Hi team, I am facing an issue on reading from FILE...
# questions-and-troubleshooting
s
Hi team, I am facing an issue on reading from FILES when my path has a
,
, intended to be uses as a NON-path separator I tried encoding the comma
%2C
, no luck --- Is there any property that I can configure here?
Copy code
SELECT * FROM FILES(
        "path" = "s3://.../VPMM_MH_ID=0...a/PV_CATEGORY_NAME=Tea, Coffee & More/part-....c000.zstd.parquet",
        "format" = "parquet",
        "aws.s3.region" = "...",
        "aws.s3.use_instance_profile" = "true",
        "aws.s3.use_aws_sdk_default_behavior" = "true",
        "fill_mismatch_column_with" = "null",
        "columns_from_path" = "VPMM_MH_ID, PV_CATEGORY_NAME"
              );
r
is it works if escape the comma?
s
It didn't