Redefining existing data into something like a View

[steffen schuler <st...@gmail.com>]

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

Re: Redefining existing data into something like a View

[Ted Dunning <te...@gmail.com>]

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 <pc...@maprtech.com>
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 <
> steffen.schuler@gmail.com
> > 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
>

Re: Redefining existing data into something like a View

[Parth Chandra <pc...@maprtech.com>]

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 <steffen.schuler@gmail.com
> 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