8 AM
To: user@hive.apache.org
Subject: RE: how to split query result into several smaller tables without
creating temp table??
Hi, Mark
Query 1 is:
1) create table tmp__imp as select requestbegintime, count(*) from impressions2
where requestbegintime<'1239572996000';
from tmp__i
anda.com]
Sent: Wednesday, March 07, 2012 1:11 AM
To: user@hive.apache.org
Subject: Re: how to split query result into several smaller tables without
creating temp table??
Hi Wei,
In query 1, it's invalid to requestbegintime in the select list if it's not in
the group by clause. There
ade.com
"Best Trading Platform" - World Finance's Forex Awards 2009.
"The One to Watch" - Treasury Today's Adam Smith Awards 2009.
- Original Message -
From: "Wei Lu"
To: user@hive.apache.org
Sent: Tuesday, March 6, 2012 4:40:00 AM
Subject: how to
Hi,
I tried to do aggregation based on Table impressions2, and then need to save
the results to two different local files (or tables).
I tried three methods, only the first one succeeded:
1) create a new table and store aggregation results to it, and then use
multi-insert to split the results t