Skip to content

Unable to merge uppercase column names #1960

Closed
@gdubya

Description

@gdubya

Environment

Delta-rs version:
python = "^3.11"
deltalake = "^0.13.0"
pandas = "^2.1.3"

Environment:

  • OS: Ubuntu

Bug

What happened:
_internal.DeltaError: Generic DeltaTable error: Schema error: No field named source.y. Valid fields are source.x, source."Y", source.__delta_rs_source, target.x, target."Y", target.__delta_rs_target.

What you expected to happen:
Successful merge.

How to reproduce it:

    from deltalake import DeltaTable, write_deltalake
    import pyarrow as pa
    data = pa.table({"x": [1, 2, 3], "Y": [4, 5, 6]})
    write_deltalake(tmp_path, data)
    dt = DeltaTable(tmp_path)
    new_data = pa.table({"x": [1], "Y": [7]})
    (
        dt.merge(
            source=new_data,
            predicate="target.x = source.x",
            source_alias="source",
            target_alias="target")
        .when_matched_update_all()
        .execute()
    )

More details:
Note that the delta table was originally created with an uppercase Y column. This was intentional.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions