Hi,
I am trying to implement a task in Hive like Stored Procedure in SQL.
In SQL, when we write cursor, first we execute select query and then
fetching the records we perform some actions.
Likely I have fired a select query as actions in Hive.
sql="select a,c,b from tbl_name";
res=stmt.executeQuer
No. First write the result in a temp table, then load it into the original
table.
On Thu, Mar 15, 2012 at 4:53 PM, Ramkumar wrote:
> Hi,
>
> Does the MR jobs of a hive query write directly to the destination or are
> the results of the MR jobs moved to the destination at the end?
> To be more pre
Thanks, Jagat. I am convinced that I need to have linux dev env.
--Chalcy
From: Jagat [mailto:jagatsi...@gmail.com]
Sent: Thursday, March 15, 2012 11:54 AM
To: user@hive.apache.org
Subject: Re: Setting up dev environment for hive
Hi
make is a linux program and since you are trying to configure
Hi
make is a linux program and since you are trying to configure it in Windows
, its giving that error
You can check http://gnuwin32.sourceforge.net/packages/make.htm
The easiest way is to install Virtual Ubuntu ( or any other linux) into
system and configure your development and testing environ
Do not join with WHERE clauses join with ON clauses.
set hive.mapred.mode=strict;
This will help prevent you from running sub optimal queries.
On Thu, Mar 15, 2012 at 6:32 AM, 韶隆吴 wrote:
> Hi all:
> I have two tables from hbase:orders(id bigint, total map)
> ,orderitem(orderid bigint, produc
Hi,
Does the MR jobs of a hive query write directly to the destination or are the
results of the MR jobs moved to the destination at the end?
To be more precise, is it safe to write query in the following way,
insert overwrite table X
select do_something from X join Y on (some key)
Was little
Hi all:
I have two tables from hbase:orders(id bigint, total map)
,orderitem(orderid bigint, productid map)
and both table have more than 60 rows.
Now I scripts the HiveQL:select size(i.productid) from orders o join
orderitem i where o.id=i.orderid;
and it cost 426s.
BTW.the hadoop cluste
Hi
Are you looking out for HiveHbaseStorageHandler? It is meant to map an
hbase table to a hive table so that you can perform SQL like queries on the
data in hbase table using hive as a translator. If that is what you are looking
can get the details here
https://cwiki.apache.org/Hive/hbase
Hi all:
I have two tables(orders,ordersitem) in Hbase and now I want to import
them into hive.
Orders -> Ordersitem is one-to-many,and table ordersitem's keyrow is
orderid and column is
item:1 info:1 bdinfo:1
item:2 info:2 bdinfo:2
to mark the items number.
My question is how to wri
