hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jtay...@salesforce.com>
Subject Re: querying hbase
Date Fri, 24 May 2013 00:10:08 GMT
Actually, with the great work you guys have been doing and the 
resolution of HBASE-1936 by Jimmy Xiang, we'll be able to ease the 
installation of Phoenix in our next release. You'll still need to bounce 
the regions servers to reload our custom filters and coprocessors, but 
you won't need to manually add the phoenix jar to the hbase classpath on 
each region server (as long as the installing user has permission to 
write into HDFS).

Has there been any discussions on running the HBase server in an OSGi 
container? That would potentially even alleviate the need to bounce the 
region servers. I didn't see a JIRA, so I created this one: 


On 05/23/2013 04:17 PM, Jean-Marc Spaggiari wrote:
> Hi James,
> Thanks for joining the thread to provide more feedback and valuable
> information about Phoenix. I don't have a big knowledge on it, so better to
> see you around.
> The only thing I was referring is that applications I sent the links for
> are simple jars that you can download locally and run without requiring any
> specific rights to install/upload anything on any server. Just download,
> click on it.
> I might be wrong because I did not try Phoenix yet, but I think you need to
> upload the JAR on all the region servers first, and then restart them,
> right? People might not have the rights to do that. That's why I thought
> Pheonix was overkill regarding the need to just list a table content on a
> screen.
> JM
> 2013/5/22 James Taylor <jtaylor@salesforce.com>
>> Hey JM,
>> Can you expand on what you mean? Phoenix is a single jar, easily deployed
>> to any HBase cluster. It can map to existing HBase tables or create new
>> ones. It allows you to use SQL (a fairly popular language) to query your
>> data, and it surfaces it's functionality as a JDBC driver so that it can
>> interop with the SQL ecosystem (which has been around for a while).
>> Thanks,
>> James
>> On 05/21/2013 08:41 PM, Jean-Marc Spaggiari wrote:
>>> Using Phoenix for that is like trying to kill a mosquito with an atomic
>>> bomb, no? ;)
>>> Few easy to install and use tools which I already tried:
>>> - http://sourceforge.net/**projects/haredbhbaseclie/**files/<http://sourceforge.net/projects/haredbhbaseclie/files/>
>>> - http://sourceforge.net/**projects/hbasemanagergui/<http://sourceforge.net/projects/hbasemanagergui/>
>>> - https://github.com/**NiceSystems/hrider/wiki<https://github.com/NiceSystems/hrider/wiki>
>>> There might be other, but those one at least are doing the basic things to
>>> look into you tables.
>>> JM
>>> 2013/5/21 lars hofhansl <larsh@apache.org>
>>>   Maybe Phoenix (http://phoenix-hbase.**blogspot.com/<http://phoenix-hbase.blogspot.com/>)
>>>> is what you are
>>>> looking for.
>>>> -- Lars
>>>> ______________________________**__
>>>> From: Aji Janis <aji1705@gmail.com>
>>>> To: user <user@hbase.apache.org>
>>>> Sent: Tuesday, May 21, 2013 3:43 PM
>>>> Subject: Re: querying hbase
>>>> I haven't tried that because I don't know how to. Still I think I am
>>>> looking for a nice GUI interface that can take in HBase connection info
>>>> and
>>>> help me view the data something like pgadmin (or its php version), sql
>>>> developer, etc
>>>> On Tue, May 21, 2013 at 6:16 PM, Viral Bajaria <viral.bajaria@gmail.com
>>>>> wrote:
>>>>> The shell allows you to use filters just like the standard HBase API
>>>>> with jruby syntax. Have you tried that or that is too painful and you
>>>> want
>>>>> a simpler tool ?
>>>>> -Viral
>>>>> On Tue, May 21, 2013 at 2:58 PM, Aji Janis <aji1705@gmail.com>
>>>>>   are there any tools out there that can help in visualizing data stored
>>>>> in
>>>>> Hbase? I know the shell lets you do basic stuff. But if I don't know
>>>>> what
>>>>> rowid I am looking for or if I want to rows with family say *name* (yes
>>>>> SQL
>>>>>> like) are there any tools that can help with this? Not trying to
>>>>> this
>>>>> on production (although that would be nice) just dev env for now. Thank
>>>>> you
>>>>>> for any suggestionns

View raw message