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 <bhosale....@gmail.com> 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 <ted.dunn...@gmail.com> wrote: > Yes. > > You need to write a special file format for that, though. > > > On Sat, Apr 11, 2020 at 6:58 AM Prabhakar Bhosaale <bhosale....@gmail.com> > wrote: > > > Hi All, > > I have a encrypted JSON file. is there any way in drill to query the > > encrypted JSON file? Thanks > > > > Regards > > Prabhakar > > >