Hi Paul, Thanks for details. As of now i have not finalized on any encryption tecnique as first i wanted to understand drill capabilities on encryption and decryption. To give you more details on my requirent. I will be archiving data in JSON format from database. And that archived data will be acceased using drill for reporting pupose. I am already zipping up JSON files using gzip. But for security reasons i need to encrypt the files also. Thx
Regards Prabhakar On Sun, Apr 12, 2020, 11:38 Paul Rogers <[email protected]> wrote: > Hi Prabhakar, > > Depending on how you perform encryption, you may be able to treat it > similar to compression. Drill handles compression (zip, gzip, etc.) via an > extra layer of functionality on top of any format plugin. That means, > rather than writing a new JSON file reader, you write a new compression > plugin (which will actually do decryption). I have not added one of these, > but I'll poke around to see if I can find some pointers. > > On the other hand, if encryption is part of the access protocol (such as > S3), then you can configure it via the S3 client. > > Can you describe a bit more how you encrypt your files and what is needed > to decrypt? > > > Thanks, > - Paul > > > > On Saturday, April 11, 2020, 10:39:15 PM PDT, Prabhakar Bhosaale < > [email protected]> wrote: > > Hi Ted, > Thanks for your reply. Could you please give some more details on how to > write to create file format, how to use it. Any pointers will be > appreciated. Thx > > Regards > Prabhakar > > On Sun, Apr 12, 2020, 00:19 Ted Dunning <[email protected]> wrote: > > > Yes. > > > > You need to write a special file format for that, though. > > > > > > On Sat, Apr 11, 2020 at 6:58 AM Prabhakar Bhosaale < > [email protected]> > > wrote: > > > > > Hi All, > > > I have a encrypted JSON file. is there any way in drill to query the > > > encrypted JSON file? Thanks > > > > > > Regards > > > Prabhakar > > > > > >
