look into it any further since we have this workaround.
> **
>
> *From:* Joe Crobak [mailto:joec...@gmail.com]
> *Sent:* Tuesday, August 28, 2012 10:22 PM
> *To:* user@hive.apache.org
> *Subject:* Re: Hive on Amazon EC2 with S3
>
> ** **
>
> Hi Suman,
>
Thank you Joe. It works now. I will try to read up on the differences between
CombineHiveInputFormat and HiveInputFormat.
From: Joe Crobak [mailto:joec...@gmail.com]
Sent: Tuesday, August 28, 2012 10:22 PM
To: user@hive.apache.org
Subject: Re: Hive on Amazon EC2 with S3
Hi Suman,
We've
Hi Suman,
I think you need to have another directory in hive as test. Copy the
data into s3://com.x/hive/test/
Thank You,
Manish.
On Fri, 2012-08-24 at 20:43 +, suman.adda...@sanofipasteur.com
wrote:
> Hi,
>
> I have setup a Hadoop cluster on Amazon EC2 with my data stored on S3.
> I w
Hi Suman,
We've seen this happen due to a bug in Hive's CombineHiveInputFormat. Try
disabling that before querying by issuing:
SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
HTH,
Joe
On Fri, Aug 24, 2012 at 4:43 PM, wrote:
> Hi,
>
> I have setup a Hadoop cluster on A
Hi,
I have setup a Hadoop cluster on Amazon EC2 with my data stored on S3. I would
like to use Hive to process the data on S3.
I created an external table in hive using the following:
CREATE EXTERNAL TABLE mytable1
(
HIT_TIME_GMTstring,
SERVICE string
) ROW FORMAT