Skip to content

Datafusion parses interval literal error #768

@goldmedal

Description

@goldmedal

Describe the bug

Found from TPCH test.

DataFusion error: Arrow error: Parser error: Invalid input syntax for type interval: "0 YEARS 3 MONS 0 DAYS 0 HOURS 0 MINS 0.000000000 SECS seconds"

DataFusion will unparse an interval value to a full interval literal but Datafusion can't parse this result.

To Reproduce

# TODO: External error: query failed: DataFusion error: Arrow error: Parser error: Invalid input syntax for type interval: "0 YEARS 3 MONS 0 DAYS 0 HOURS 0 MINS 0.000000000 SECS seconds"
#query ITTTR
query error

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions