[HIVE-26454] BINARY types within complex types are not quoted

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Csaba Ringhofer
• Created: 05/Aug/22 12:43
• Updated: 20/Mar/24 14:40

Description

While STRINGs are quoted and escaped, this is not done for BINARY members:
select named_struct("s", "a", "b", cast("a" as binary));
result:

{"s":"a","b":a}

This is mainly problematic if special characters are involved, as this can lead to totally unparseble JSON:
select named_struct("s", "a \"{", "b", cast("a \"{" as binary));
result: {"s":"a \"{","b":a "{}

As existing workloads may rely on the current behavior, I think that it would be the best to add a configuration for this.

Issue Links

• is related to: IMPALA-11491 Support BINARY nested in complex types in select list
• is related to: HIVE-16306 Encode binary fields of complex types with base64 and wrap them up with quotes