Re: Querying Hbase table from Hive without mounting

2014-04-02 Thread R W
Interesting on why you need to do so? On Tue, Apr 1, 2014 at 3:11 AM, Manju M manjumohapatra1...@gmail.comwrote: Without mapping /mounting the hbase table , how can I access and query hbase table ?

Querying Hbase table from Hive without mounting

2014-03-31 Thread Manju M
Without mapping /mounting the hbase table , how can I access and query hbase table ?

Re: Querying Hbase table from Hive without mounting

2014-03-31 Thread kulkarni.swar...@gmail.com
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 manjumohapatra1...@gmail.comwrote: Without mapping /mounting the hbase table ,

Re: Querying Hbase table from Hive without mounting

2014-03-31 Thread Manju M
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*

Re: Querying Hbase table from Hive without mounting

2014-03-31 Thread kulkarni.swar...@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

Re: querying hbase

2013-06-02 Thread Andrew Purtell
On Sun, Jun 2, 2013 at 4:44 AM, Michael Segel michael_se...@hotmail.comwrote: Sure, but that wont change the fact that Coprocessors should go under a massive rewrite. Can you elaborate a bit? I would say we had our reasons for how things are but I don't want to defend the design here, I'd

Re: querying hbase

2013-06-02 Thread Andrew Purtell
On Sat, Jun 1, 2013 at 10:20 PM, James Taylor jtay...@salesforce.comwrote: These approaches all sound somewhat brittle and unlikely to be relied on for a production system (more here: https://issues.apache.org/** jira/browse/HBASE-8607 https://issues.apache.org/jira/browse/HBASE-8607). Sounds

Re: querying hbase

2013-06-02 Thread Andrew Purtell
On Sat, Jun 1, 2013 at 8:15 PM, Michael Segel michael_se...@hotmail.comwrote: What happens when you restart the RS? I think 1) the master is given a heads-up, 2) all of the regions are closed, 3) the JVM is bounced and everything is reloaded, 4) the RS comes back up and checks in with the

Re: querying hbase

2013-06-01 Thread Michel Segel
Is there a benefit to restarting a regionserver in an OSGi container versus restarting a Java process? Was that rhetorical? Absolutely. Think of a production environment where you are using HBase to serve data in real time. Sent from a remote device. Please excuse any typos... Mike Segel

Re: querying hbase

2013-06-01 Thread Andrew Purtell
Isn't the time to restart and the steps necessary more or less the same? Or will the objects that hold the in memory state survive across the reload? Will they still share a classloader (maintain equality tests)? What if the implementation / bundle version changes? We are taking about an upgrade

Re: querying hbase

2013-06-01 Thread Michael Segel
Well, What happens when you restart the RS? Suppose I'm running a scan on a completely different table and you restart the RS? What happens to me? I havent thought through the whole problem, but you need to put each table's CP in to its own sandbox. (There's more to it and would require

Re: querying hbase

2013-06-01 Thread James Taylor
These approaches all sound somewhat brittle and unlikely to be relied on for a production system (more here: https://issues.apache.org/jira/browse/HBASE-8607). Sounds like a rolling restart is the best option in the near/medium term. Our pain points are more around how to get to the point

Re: querying hbase

2013-06-01 Thread Michael Segel
Sure, but that wont change the fact that Coprocessors should go under a massive rewrite. You're hitting a problem that Sybase faced while Informix (datablades) didn't when it came to running end user code within the engine. But I'm dating myself... On Jun 1, 2013, at 3:20 PM, James Taylor

Re: querying hbase

2013-05-31 Thread James Taylor
On 05/24/2013 02:50 PM, Andrew Purtell wrote: On Thu, May 23, 2013 at 5:10 PM, James Taylor jtay...@salesforce.comwrote: Has there been any discussions on running the HBase server in an OSGi container? I believe the only discussions have been on avoiding talk about coprocessor reloading, as

Re: querying hbase

2013-05-24 Thread Andrew Purtell
On Thu, May 23, 2013 at 5:10 PM, James Taylor jtay...@salesforce.comwrote: Has there been any discussions on running the HBase server in an OSGi container? I believe the only discussions have been on avoiding talk about coprocessor reloading, as it implies either a reimplementation of or

Re: querying hbase

2013-05-23 Thread Jean-Marc Spaggiari
: 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

Re: querying hbase

2013-05-23 Thread James Taylor
__**__ From: Aji Janis aji1...@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

Re: querying hbase

2013-05-22 Thread Ian Varley
://phoenix-hbase.blogspot.com/) is what you are looking for. -- Lars From: Aji Janis aji1...@gmail.commailto:aji1...@gmail.com To: user user@hbase.apache.orgmailto:user@hbase.apache.org Sent: Tuesday, May 21, 2013 3:43 PM Subject: Re: querying hbase I haven't tried

Re: querying hbase

2013-05-22 Thread Shahab Yunus
: 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

Re: querying hbase

2013-05-22 Thread Aji Janis
These tools seem just like what I want! Thank you. I am trying to play with it now but looks like in our Hbase configuration HBASE_MANAGE_ZK is set to False in hbase-env and hbase.zookeeper.property.clientPort is not set in hbase-site and therefore I can't use hbasemanager or hrider. I am new to

Re: querying hbase

2013-05-22 Thread James Taylor
(http://phoenix-hbase.blogspot.com/) is what you are looking for. -- Lars From: Aji Janis aji1...@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

Re: querying hbase

2013-05-22 Thread James Taylor
Hi Aji, With Phoenix, you pass through the client port in your connection string, so this would not be an issue. If you're familiar with SQL Developer, then Phoenix supports something similar with SQuirrel: https://github.com/forcedotcom/phoenix#sql-client Regards, James On 05/22/2013 07:42

querying hbase

2013-05-21 Thread Aji Janis
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 this

Re: querying hbase

2013-05-21 Thread Viral Bajaria
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 aji1...@gmail.com wrote: are there any tools out there that can help in

Re: querying hbase

2013-05-21 Thread Aji Janis
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

Re: querying hbase

2013-05-21 Thread lars hofhansl
Maybe Phoenix (http://phoenix-hbase.blogspot.com/) is what you are looking for. -- Lars From: Aji Janis aji1...@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

Re: querying hbase

2013-05-21 Thread Jean-Marc Spaggiari
...@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