When inserting Strings in type ANY those are not able to join on later on (when using HashMatch operator) since the hashcode is not generated the same for UTF8String and java.lang.String
To fix this we should transform all known values to PLB types when inserting into a temporary table.
Can be a complex task regarding nested types like object/table/arrays.
When inserting Strings in type ANY those are not able to join on later on (when using HashMatch operator) since the hashcode is not generated the same for UTF8String and java.lang.String
To fix this we should transform all known values to PLB types when inserting into a temporary table.
Can be a complex task regarding nested types like object/table/arrays.