This is Base64 encoding. You an write a UDF (user defined function) to
implement this.
Thanks,
- Paul
On Friday, April 20, 2018, 10:48:26 AM PDT, Kunal Khatua <[email protected]>
wrote:
First, you're posting on the wrong mailing list. This should be posted in the
user mailing list, because this is meant for discussion of development features
about Drill. As a result, I'll cc to the dev list (so that you don't miss the
reply), but you should carry on the conversation in the User list.
Now, coming back to your question, the encoded values you shared could be
anything. What you seem to be looking for is a way to decipher what the bytes
that appear as "MTExNDUwMjM3OA==" actually mean. This is tricky, if not
impossible. Do you know what is the source of this data? That might be carrying
information about the encoding.
If not, there might be online tools that can (perhaps) decode the bytes
correctly.
Drill provides that capability with the convert_to function :
https://drill.apache.org/docs/supported-data-types/#data-types-for-convert_to-and-convert_from-functions
, but it seems you've already tried that.
At this point, your best bet is to find the encoding of the source from where
you got this data.
On 4/20/2018 8:46:56 AM, Lavanya Nuthalapati <[email protected]> wrote:
Hi Team,
I have data with the encoded values "MTExNDUwMjM3OA==" , i wanted to decode
it.
Have tried convert_from and cast to varchar, nothing is working out.
Can you please help on the same.
It is very urgent your response is appreciated.
Regards,
Lavanya.
