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

bug: COPY INTO <location> with USE_RAW_PATH = TRUE stores path with percent encoded spaces #17079

Closed
1 of 2 tasks
rad-pat opened this issue Dec 18, 2024 · 0 comments · Fixed by #17109
Closed
1 of 2 tasks
Assignees
Labels
C-bug Category: something isn't working

Comments

@rad-pat
Copy link

rad-pat commented Dec 18, 2024

Search before asking

  • I had searched in the issues and found no similar issues.

Version

v1.2.672-nightly

What's Wrong?

Execute Copy Into Statement to copy data from table to GCS with path (and USE_RAW_PATH), Databend stores file at path with URL encoded spaces, e.g. /path%20to%20file/file.csv

How to Reproduce?

COPY INTO 'gcs://bucket/Pat/Test/Path With Spaces/FakeData.csv' 
CONNECTION = (
  ENDPOINT_URL = 'https://storage.googleapis.com' 
  CREDENTIAL = '<snip>' 
) FROM (SELECT * FROM t0)
FILE_FORMAT = (TYPE = CSV, RECORD_DELIMITER = '\r\n', FIELD_DELIMITER = ',', QUOTE = '"', ESCAPE = '\\', OUTPUT_HEADER = TRUE, COMPRESSION = NONE)
 SINGLE = TRUE
OVERWRITE = TRUE
INCLUDE_QUERY_ID = FALSE
USE_RAW_PATH = TRUE

Please note, saving with USE_RAW_PATH = FALSE (and a path that ends with a slash) gives the correct result:
image

Are you willing to submit PR?

  • Yes I am willing to submit a PR!
@rad-pat rad-pat added the C-bug Category: something isn't working label Dec 18, 2024
@rad-pat rad-pat changed the title bug: COPY INTO <location> stores path with url encoded spaces bug: COPY INTO <location> stores path with precent encoded spaces Dec 19, 2024
@rad-pat rad-pat changed the title bug: COPY INTO <location> stores path with precent encoded spaces bug: COPY INTO <location> with USE_RAW_PATH = TRUE stores path with percent encoded spaces Dec 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-bug Category: something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants