Dremio Query not returning Original Binary Data

When I query the VDS which is linked to parquet file in S3, the binary data is transformed and original data of parquet is not displayed for binary Data type.

columns: year_binary, original: dGVzdCBzdHJpbmc= Query in dremio returned: ZEdWemRDQnpkSEpwYm1jPQ==

columns: validation_status, original: 0x0200000008000000000000000000000000000000000000000000000000000000 Query in dremio returned: MHgwMjAwMDAwMDA4MDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAw

Why is Dremio converting this binary data in parquet and returning base64 data by default…?

To extract original data as it is through dremio query, I had to use UNBASE64 which returned original data.
I want to see original binary data as is, through dremio query, which is not happening implicitly.




I was able to reproduce this issue locally and have filed a bug. It is on the owning team’s backlog but I cannot share any timeline for this being addressed.

Thanks for calling this issue out.

Dan