We also need to add some view examples on the main Wiki page (under SQL Commands).
Bob On Tue, Sep 30, 2014 at 4:25 PM, Neeraja Rentachintala < [email protected]> wrote: > Kyrill > Check out > > https://cwiki.apache.org/confluence/display/DRILL/Lesson+2%3A+Run+Queries+with+ANSI+SQL > for a view example. > > > On Tue, Sep 30, 2014 at 4:20 PM, Kyrill Alyoshin <[email protected]> > wrote: > > > Tomer, > > > > Thanks for the quick reply! I'd been browsing Drill's wiki and docs prior > > to posting that question and got a sense that "non-materialized" views > are > > possible in Drill but literally found zero examples of how to set them > up. > > Would you be so kind to provide a pointer on the web? Google queries > > literally return nothing. > > > > Thanks again! ;) > > > > -Kyrill > > > > On Tue, Sep 30, 2014 at 7:07 PM, Tomer Shiran <[email protected]> > > wrote: > > > > > Check out Drill views. You can define a view that exposes the HBase > table > > > in whatever way you want, including aliases. > > > > > > On Tue, Sep 30, 2014 at 3:14 PM, Kyrill Alyoshin <[email protected]> > > > wrote: > > > > > > > Guys, > > > > > > > > We have an HBase system (MapR M7 to be precise) where we store data > in > > > > HBase tables under aliased columns. What I mean is that the column > keys > > > are > > > > physically named as '1', '2', '3', etc. This is done to save on > storage > > > of > > > > data. Typically we use Cascading/Cascalog to query this data. We were > > > able > > > > to add an aliasing layer in our Cascading queries (through Cascading > > > > extension) to allow human readable queries (i.e. using 'firstName' > > alias > > > > instead of '1'). > > > > > > > > We'd like to try out Drill for SQL based access. Where should we > start > > > > "drilling" in the Drill's code base to develop similar extensions? I > am > > > > assuming that Drill currently provides no such functionality out of > the > > > > box. > > > > > > > > In other words, instead of our HBase query looking like this: > > > > > > > > SELECT cast(account[*‘1’*] as varchar(20)) as `Address` > > > > > > > > we'd like it to look like this from a user perspective: > > > > > > > > SELECT cast(account[*‘address’*] as varchar(20)) as `Address` > > > > > > > > Any help in direction is greatly appreciated. We can easily volunteer > > to > > > > provide such a contribution ourselves, just let us know where to > start > > > > "drilling". :-) > > > > > > > > Thank you very much! > > > > > > > > -Kyrill > > > > > > > > > > > > > > > > -- > > > Tomer Shiran > > > VP Product Management | MapR Technologies | 650-804-8657 > > > > > >
