Hive CLI runs this query just fine:
select department_type, count(*) as total_walkins, count(distinct user_id) as
unique_walkers from userstore.walkin w join locations.locations loc on
w.location_id = loc.id where loc.chain_id = 56876135 and to_date (time_stamp)
>= '2011-08-07' and to_date (time
You can data under APP as one external table.
Each folder can be added as partition
On Aug 31, 2011, at 12:02 AM, Junxian Yan wrote:
> Hi Guys
>
> I stored the production log files in folders which are named as the date. the
> structured look like APP/2011-08-31/app.log. So now I wannt t
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTable
AFAIK, you can use date and time as column names. Hive only uses string
-Ayon
See My Photos on Flickr
Also check out my Blog for answers to commonly asked questions.
_
When you launch an EMR cluster (or "job flow" in EMR terminology), it launches
new EC2 instances, optionally with an Elastic IP assigned to the cluster's
master host. One does not install EMR on existing EC2 (non-EMR) instances.
-Original Message-
From: MIS [mailto:misapa...@gmail.com]
EMR Hive and Apache Hive are versioned the same.
From: Igor Tatarinov [mailto:i...@decide.com]
Sent: Tuesday, August 30, 2011 8:27 PM
To: user@hive.apache.org; jiang licht
Subject: Re: Hive in EC2
The only caveat is that you are at Amazon's mercy in terms of the latest
version of Hive. Also, th
I forget where you find the keyword list (a quick google did not find it for
me) but you can use any name you like as a column name provided you escape
it in the CREATE TABLE statement with backticks ``
Might make you life easier not to use reserved names, mind you ...
On Wed, Aug 31, 2011 at 9:1
Hi
Is there a wiki page which contains a list of keywords in Hive?
Can we use 'time' or 'date' as column names?
Thanks
Vaibhav
ask about it @ amazon forum?
Michael
From: MIS
To: d...@hive.apache.org
Cc: "user@hive.apache.org"
Sent: Wednesday, August 31, 2011 10:37 AM
Subject: Re: Hive in EC2
But my concern is that I cannot run the Elastic Mapreduce on specific instances
which we
But my concern is that I cannot run the Elastic Mapreduce on specific
instances which we already own and have elastic IPs. If it is possible to do
so, then using Hive EMR should be fine enough.
Thanks,
MIS
On Wed, Aug 31, 2011 at 12:21 AM, Aggarwal, Vaibhav wrote:
> You could also choose to lo
Hi,
It seems like the issue is not resolved. see
https://issues.apache.org/jira/browse/HIVE-951
- Youngwoo
On Wed, Aug 31, 2011 at 4:02 PM, Junxian Yan wrote:
> Hi Guys
>
> I stored the production log files in folders which are named as the date.
> the structured look like APP/2011-08-31/app.l
Hi,
I have a hive query like this
from (
from mytable
map mytable.c1, mytable.c2, mytable.c3
using '/bin/cat' as c1,c2,c3
cluster by c1) mo
insert overwrite table mytable2
reduce mo.c1, mo.c2, mo.c3
using 'python convert.py'
as x1, x2;
Now what is happening
Hi Guys
I stored the production log files in folders which are named as the date.
the structured look like APP/2011-08-31/app.log. So now I wannt to load all
files under /app in one table. Is there any idea?
R
12 matches
Mail list logo
