Hive binary type doesn't work correctly due to Ion Blob<>bytes conversion

[cheqianh]

Description

ion-hive-serde IonBlob <-> binary conversion currently returns the byte array’s reference in memory. It should returns at least a text representation of the Ion Blob value.

Reproduction

One example when query Ion Blob values through AWS Athena

Schema:

content has a type of binary

CREATE EXTERNAL TABLE test_blob (
    `payload` struct < 
    id: string,
    content: binary >
)
ROW FORMAT SERDE 'com.amazon.ionhiveserde.IonHiveSerDe'
WITH SERDEPROPERTIES (
    'ion.encoding' = 'BINARY',
    'ion.fail_on_overflow' = 'true',
    'ion.path_extractor.case_sensitive' = 'false',
    'ion.timestamp.serialization_offset' = 'Z',
    'ion.serialize_null' = 'OMIT',
    'ion.ignore_malformed' = 'false'
)
STORED AS INPUTFORMAT 'com.amazon.ionhiveserde.formats.IonInputFormat' OUTPUTFORMAT 'com.amazon.ionhiveserde.formats.IonOutputFormat'
LOCATION 's3://test-athena-ion-shorthand/';

File

Below is the Ion file, content has an IonBlob value.

{"payload": 
  { id:"2022-12-08T17:08:11.174Z#5a5b185a-9b13-482c-bb78-fe1894f39000",
    content:    {{e3BhdHRlcm46W3tsTJDKVEO#JD3r942kdkvDNVfdGltZToyMDIyLTEyLTA4VDE3OjA4OjA5LjU2MFosc291cmNlOntjdXN0b21lcl9pZDo2NTc3NjI5NjAwMixza3U6IkIwQk5OTVBTTjgiLHNrdV92ZXJzaW9uOjJ9fV19fV19}},
}}

Query

select * from test_blob

Result

{
    id=2022-12-08T17:08:11.174Z#5a5b185a-9b13-482c-bb78-fe1894f39000, 
    content=[B@4e3f3378, 
}

Notice that content value changed from an Ion Blob to B@4e3f3378, which is a bug in ion-hive-serde.

[treyyi]

@cheqianh
Hi Eric,
This is Trey who addressed this issue to you.
Please assign this issue to me and I'm going to work on it :)

Thanks!