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

Cannot use FORMAT AS JSON in COPY command #59

Closed
peterlitvak opened this issue Nov 8, 2019 · 2 comments
Closed

Cannot use FORMAT AS JSON in COPY command #59

peterlitvak opened this issue Nov 8, 2019 · 2 comments

Comments

@peterlitvak
Copy link

I've switched from FORMAT AS JSON 'auto' (which is not supported) to FORMAT AS JSON 's3://...' but is still doesn't load jsonpath file from S3 and instead trying to parse payload as CSV.
What is the supported format of the jsonpaths based COPY?

@peterlitvak
Copy link
Author

Actually the problem is in placement of TIMEFORMAT parameter, if it comes before FORMAT AS JSON the parser fails (falls back to default data format) if TIMEFORMAT is after the FORMAT AS JSON then the parser works as expected.

@peterlitvak
Copy link
Author

see #62

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