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.
