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

partition_by with "$" on local filesystem #1591

Closed
sebastianfuchsprivate opened this issue Aug 16, 2023 · 1 comment · Fixed by #1661
Closed

partition_by with "$" on local filesystem #1591

sebastianfuchsprivate opened this issue Aug 16, 2023 · 1 comment · Fixed by #1661
Labels
bug Something isn't working

Comments

@sebastianfuchsprivate
Copy link

Environment

Delta-rs version: 0.10.1

Binding: Python

Environment:

  • Cloud provider: n/a
  • OS: Linux/Ubuntu/WSL
  • Other: local filesystem (ext4)

Bug

What happened:
error in reading DeltaTable (deltalake.table.DeltaTable) - FileNotFoundError

What you expected to happen:
Load of DeltaTable

How to reproduce it:
Create a DeltaLake on local filesystem which contains a partition with "$" - deltalake.writer.write_deltalake(path, df, name = name, partition_by = partition). Try to read it dt = deltalake.table.DeltaTable(path) and access the columns df = dt.to_pandas(columns=cols).

More details:
When the DeltaLake is written with a partition_by the "$" char is replaced with "%2524". On read the $ is kept, a file not found error is thrown. In my case:
On write where partition is "Exchange_Code" which contains a value of "ID$", the directory created is "Exchange_Code=ID%2524" which contains a file 10-38fbb976-1e37-4fe1-b008-31194f837d9c-0.parquet.
On read the error is: "FileNotFoundError: Object at location path/Exchange_Code=ID$/10-38fbb976-1e37-4fe1-b008-31194f837d9c-0.parquet not found: No such file or directory (os error 2)"

The parquet file itself is accessible from OS level.

@sebastianfuchsprivate sebastianfuchsprivate added the bug Something isn't working label Aug 16, 2023
@sebastianfuchsprivate
Copy link
Author

Might be related to #1079, sorry haven't seen this earlier

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant