[Feature Request]: EXTERNAL table support "*" folder in filepath

[xzxiong]

Is there an existing issue for the same feature request?

• [X] I have checked the existing issues.

Is your feature request related to a problem?

No response

Describe the feature you'd like

background external table not support * folder in filepath, for example: */filename.csv, or path/to/file/*/filename.csv

what we need metric/log data, want to store in path like {account}/{merged,log}/yyyy/mm/dd/metric/*.csv (more detail in PR https://github.com/matrixorigin/matrixone/pull/5599)

then, sys account needs access all data from one external table, so table options infile would like infile="*/*/*/*/*/metric/*.csv"

others right now, seams NO need to support folder like path/to/folder_*/file.csv

Describe implementation you've considered

No response

Documentation, Adoption, Use Case, Migration Strategy

No response

Additional information

No response