Parth is, of course, exactly correct. Drill doesn't do CRUD. On the other hand, that isn't the end of the story. Because of the treatment of directories as tables and the ability to create files (as tables), you can get the effect of atomic for large scale inserts. Likewise for file-at-a-time deletions via drop.
Moreover, a modicum of trickery outside of Drill can make a lot of other kinds of mutation work as well. On Mon, Oct 24, 2016 at 3:16 PM, Parth Chandra <[email protected]> wrote: > Yes, you can create views [1] > However, Drill does not support CRUD being primarily for read only > analytical queries. (The only write operation is 'create table as' [2] ) > > > > > > [1] https://drill.apache.org/docs/create-view/ > [2] http://drill.apache.org/docs/create-table-as-ctas/ > > On Sun, Oct 23, 2016 at 11:47 PM, steffen schuler < > [email protected] > > wrote: > > > Hi Drill-Users, > > > > I have a fundamental question about refining existing data structures > with > > drill. > > > > Is it possible with drill to (re-)define something like a „View“ > > (combination of existing > > data tables) and have all of the CRUD functionality available against > this > > new „View“? > > > > Any hint is welcome : ) > > > > Kind Regards, > > > > Steffen Schuler >
