drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Rogers <par0...@yahoo.com.INVALID>
Subject Re: Required help in apache drill
Date Fri, 20 Apr 2018 19:10:42 GMT
This is Base64 encoding. You an write a UDF (user defined function) to implement this.


- Paul


    On Friday, April 20, 2018, 10:48:26 AM PDT, Kunal Khatua <kunal@apache.org> 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
On 4/20/2018 8:46:56 AM, Lavanya Nuthalapati <lnuthala.obiee@gmail.com> wrote:
Hi Team,

I have data with the encoded values "MTExNDUwMjM3OA==" , i wanted to decode
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.

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message