Re: Querying Hbase table from Hive without mounting

["kulkarni.swarnim@gmail.com" <ku...@gmail.com>]

Hi Manju,

If I am understanding correctly what you are trying to do, there is no
current great to achieve that with the existing hive hbase integration.
Ofcourse you can read and write data to HBase like you mentioned, but that
is pretty much it. If you need more fine grained access like accessing a
particular version or timestamp, I would recommend you to look at Apache
Phoenix[1].

Hope that helps.

[1] http://phoenix.incubator.apache.org/


On Mon, Mar 31, 2014 at 3:31 PM, Manju M <ma...@gmail.com>wrote:

> Usually to access Hbase from Hive,  you will map Hbase table using
> .HBaseStorageHandler and specifying Hbase table in TBLPROPERTIES.
>
> But my question is ..I have to Access Hbase records directly .
>
>
> INSERT OVERWRITE TABLE top_cool_hbase SELECT name, map(`date`, cast(coolness as int)) FROM* top_cool*
>
>
>  top_cool_hbase is hive table ( mapped to hbase table )
>
> top_cool is hbase table ( not a mapped Hive table)
>
>
>
> On Mon, Mar 31, 2014 at 12:42 PM, kulkarni.swarnim@gmail.com <
> kulkarni.swarnim@gmail.com> wrote:
>
>> Can you elaborate a little on what exactly you mean by "mounting"? The
>> least you will need to have hbase data query able in hive is to create an
>> external table on top of it.
>>
>>
>> On Mon, Mar 31, 2014 at 2:11 PM, Manju M <ma...@gmail.com>wrote:
>>
>>> Without mapping /mounting the hbase table , how can I access and query
>>> hbase table ?
>>>
>>>
>>>
>>>
>>
>>
>> --
>> Swarnim
>>
>
>


-- 
Swarnim