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
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
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 wrote:
> Without mapping /mounting the hbase table , how can I access and query
>
Without mapping /mounting the hbase table , how can I access and query
hbase table ?
Sorry for the late reply, Ashutosh.
Thanks for the pointers.
I will soon try it out with the hive version
-Sagar
On Sat, Jun 2, 2012 at 10:30 AM, Ashutosh Chauhan wrote:
> Hey Sagar,
>
> Seems like you have inserted data in your hbase table directly through
> hbase client and not through hive c
Hey Sagar,
Seems like you have inserted data in your hbase table directly through
hbase client and not through hive client. If so, you need
https://issues.apache.org/jira/browse/HIVE-1634 to correctly read
pre-existing data in hbase. Hive-1634 is available as a part of 0.9
release. So, upgrade to
I am using hive-0.7-cdh3u0
Thanks Again
On Fri, Jun 1, 2012 at 9:20 PM, sagar naik wrote:
> Hi ,
> I am seeing a very weird hive-hbase query behaviour.
> I have an externally mounted hbase table in hive
>
>
> select creation_ts, length(url), isnull(url), ! (isnull(url)) from
> task_table limit 1
Hi ,
I am seeing a very weird hive-hbase query behaviour.
I have an externally mounted hbase table in hive
select creation_ts, length(url), isnull(url), ! (isnull(url)) from
task_table limit 10;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no
Actually I think I have found the issue. I was trying to test this out
before we upgraded. And we were having classpath conflicts which
pointed to the old datanucleus JARs that came with hive 0.5.
-Xavier
On 11/24/10 11:00 AM, Xavier Stevens wrote:
> Hi John,
>
> This definitely looks like the
Hi John,
This definitely looks like the issue you linked. I'm just using the
default "datanucleus" for that configuration value.
I see in the metastore ivy.xml.
What version should I have? I see this in my build/dist/lib directory:
-rw-r--r-- 1 xstevens staff16880 Jun 24 06:34
datanucl
It looks a bit like this one where ISCOMPRESSED was used instead of
IS_COMPRESSED:
https://issues.apache.org/jira/browse/HIVE-1435
Maybe your datanucleus.identifierFactory is somehow misconfigured?
JVS
On Nov 23, 2010, at 4:16 PM, Xavier Stevens wrote:
> I'm trying to create an external table
I'm trying to create an external table to a pre-existing HBase table
using Hive trunk, like so:
CREATE EXTERNAL TABLE hbase_metrics (key string, value map)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH
SERDEPROPERTIES ("hbase.columns.mapping" = ":key,counters:")
TBLPROPERTIES (
12 matches
Mail list logo
