Dremio Query not returning Original Binary Data

1

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.

data_in_parquet
data_in_parquet1147×251 25 KB

csv_data
csv_data1820×461 23.7 KB

image
image1801×873 51.9 KB

image
image1801×873 51.9 KB

dremio_explicit_transformed_data_query
dremio_explicit_transformed_data_query1823×871 53.1 KB

2

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