Skip to content

[CH] Nullability missmatch caused by array() #9237

@lgbo-ustc

Description

@lgbo-ustc

Backend

CH (ClickHouse)

Bug description

select a, b, n_regionkey, c from (
	select a, b, c from (
		select
		n_regionkey as a, n_nationkey as b, array() as c
		from nation where n_nationkey % 2 = 1
		union all
		select n_nationkey as a, n_regionkey as b, array('123') as c
		from nation where n_nationkey % 2 = 0
	)
)left join (
	select n_regionkey, n_nationkey from tpch_pq.nation
)
on a = n_regionkey and b = n_nationkey
Caused by: org.apache.gluten.exception.GlutenException: Bad cast from type DB::ColumnNullable to DB::ColumnString

Spark version

None

Spark configurations

No response

System information

No response

Relevant logs

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingtriage

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions