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
