Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

import from multiple csv files using FROM ALL FILENAMES #1519

Closed
d3r3ktm opened this issue Aug 23, 2023 · 0 comments
Closed

import from multiple csv files using FROM ALL FILENAMES #1519

d3r3ktm opened this issue Aug 23, 2023 · 0 comments

Comments

@d3r3ktm
Copy link

d3r3ktm commented Aug 23, 2023

I am trying to import from multiple csv files using FROM ALL FILENAMES but it is not working as per my understanding.

LOAD CSV
from all filenames matching ~<ods_sda_supp_cat_mktg_source*.csv>

These are the csv files are in the same directory as the load file,

ods_sda_supp_cat_mktg_source_2.csv
ods_sda_supp_cat_mktg_source_3.csv

I am getting this error messages,

Loading code from #P"/apps/edw/script/pgloader/allfunc.lisp"
2023-08-23T14:53:56.033000+08:00 LOG pgloader version "3.6.3~devel"
KABOOM!
FATAL error: No file matching 'ods_sda_supp_cat_mktg_source*.csv' in expanded archive in '/apps/edw/derek/'
An unhandled error condition has been signalled:
No file matching 'ods_sda_supp_cat_mktg_source*.csv' in expanded archive in '/apps/edw/derek/'

What I am doing here?

No file matching 'ods_sda_supp_cat_mktg_source*.csv' in expanded archive in '/apps/edw/derek/'

@d3r3ktm d3r3ktm closed this as completed Aug 23, 2023
@d3r3ktm d3r3ktm reopened this Aug 23, 2023
@d3r3ktm d3r3ktm closed this as completed Aug 23, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant