Details
-
Improvement
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Do we have suggestions to support date format in a file path when using filesystem as source?
For example:
CREATE TABLE fs_table (
...
) WITH (
'connector'='filesystem',
'path'='ftp:/tmp/{yyyy-MM-dd}/data',
'format'='parquet'
);
the {yyyy-MM-dd} expression in path will be replaced with actual system time.
Why support this?
date expression support will be used in some scheduled jobs, such as running a daily job to read current day data from FTP which will create a new file path using date expression every day.