https://github.com/linkedin/coral/releases/tag/v2.2.9
[Coral-Trino] Cast char fields, if necessary, to varchar type in the set operation - SqlCallTransformer https://github.com/linkedin/coral/pull/442
Due to wrong coercion between varchar and char in Trino, as described in https://github.com/trinodb/trino/issues/9031
, a work-around needs to be applied in case of translating Hive views which contain a UNION dealing with char and varchar types. The work-around consists in the explicit cast of the field having char type towards varchar type corresponding of the set operation output type.
Overview of the past releases is available at https://github.com/linkedin/coral/releases
Relevant releases:
How was the PR tested
Ran successfully locally on
trinodb/trino
the tests from the PR https://github.com/trinodb/trino/pull/19275