Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
HBase >> mail # user >> querying hbase

Copy link to this message
Re: querying hbase
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 <[EMAIL PROTECTED]>
>> 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 <[EMAIL PROTECTED]>
>>>   Maybe Phoenix (http://phoenix-hbase.**blogspot.com/<http://phoenix-hbase.blogspot.com/>)
>>>> is what you are
>>>> looking for.
>>>> -- Lars
>>>> ______________________________**__
>>>> From: Aji Janis <[EMAIL PROTECTED]>
>>>> To: user <[EMAIL PROTECTED]>
>>>> 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 <[EMAIL PROTECTED]
>>>>> wrote:
>>>>> The shell allows you to use filters just like the standard HBase API but
>>>>> 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 <[EMAIL PROTECTED]> wrote:
>>>>>   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 use