Skip to content

bug: Unable to insert map(str, array[str]) type of data into duckdb table #11360

Open
@vspinu

Description

@vspinu

What happened?

duck = ibis.duckdb.connect()
schema = ibis.schema([
    ('id', 'string'),
    ('filter', 'map<string, array<string>>')
])
duck.create_table("tmp", schema=schema, overwrite=True)
duck.insert("tmp", [{"id": "1", "filter": {"field": ["a", "b"]}}])

# ConversionException: Conversion Error: Unimplemented type for cast (STRUCT(field VARCHAR[]) -> MAP(VARCHAR, VARCHAR[]))

What version of ibis are you using?

10.5.0

What backend(s) are you using, if any?

duckdb

Relevant log output

Code of Conduct

  • I agree to follow this project's Code of Conduct

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugIncorrect behavior inside of ibis

    Type

    No type

    Projects

    Status

    backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions