If you meant to create a copy with your changes (performed via CTAS). You can set the store format to JSON [1]. So if done at a session level, all CTAS statements executed in that session will create underlying files in JSON format.
alter session set `store.format`='json'; [1] http://drill.apache.org/docs/create-table-as-ctas-command/ On Tue, Aug 9, 2016 at 10:50 AM, Alok Tanna <[email protected]> wrote: > We have use case where we need to query large JSON files and then we would > also like to write data back to JSON file. > > We are considering Drill to create views and query the data , but we are > looking for option to edit JSON file and save it automatically on the > server. Looking forward to options for writing back to the JSON file. > > > Thanks & Regards, > > Alok R. Tanna >
