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.