Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (athena.apache.org: domain of edlinuxguru@gmail.com
 designates 209.85.223.176 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <B7AC7B44-D08E-4047-B774-C6E3CBD18660@thinkbiganalytics.com>
References: 
 <CAN9TFXRoAjnO16jnJGzNCC0zCxNf10UU4AQ5TqftHcZEQGr7wQ@mail.gmail.com>
	<CADciBaMgjsHCYBA6d6OT-rvMD8eHDohJRhK6=mgmUyDuWfk-NQ@mail.gmail.com>
	<CAN9TFXQ4JqGiQ-F46-MCpw63rKxCk2WTbCiXheh3FJqDSOksBw@mail.gmail.com>
	<B7AC7B44-D08E-4047-B774-C6E3CBD18660@thinkbiganalytics.com>
Date: Mon, 5 Nov 2012 10:56:10 -0500
Message-ID: 
 <CAENxBwyQhmR7WZi3WKYbtKn4x0M+F7H87mVXvGa9+WT9wR5Tsg@mail.gmail.com>
Subject: Re: Alter table is giving error
From: Edward Capriolo <edlinuxguru@gmail.com>
To: user@hive.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Recover partitions should work the same way for different file systems.

Edward

On Mon, Nov 5, 2012 at 9:33 AM, Dean Wampler
<dean.wampler@thinkbiganalytics.com> wrote:
> Writing a script to add the external partitions individually is the only way
> I know of.
>
> Sent from my rotary phone.
>
>
> On Nov 5, 2012, at 8:19 AM, Chunky Gupta <chunky.gupta@vizury.com> wrote:
>
> Hi Dean,
>
> Actually I was having Hadoop and Hive cluster on EMR and I have S3 storage
> containing logs which updates daily and having partition with date(dt). And
> I was using this recover partition.
> Now I wanted to shift to EC2 and have my own Hadoop and Hive cluster. So,
> what is the alternate of using recover partition in this case, if you have
> any idea ?
> I found one way of individually partitioning all dates, so I have to write
> script for that to do so for all dates. Is there any easiest way other than
> this ?
>
> Thanks,
> Chunky
>
>
>
> On Mon, Nov 5, 2012 at 6:28 PM, Dean Wampler
> <dean.wampler@thinkbiganalytics.com> wrote:
>>
>> The RECOVER PARTITIONS is an enhancement added by Amazon to their version
>> of Hive.
>>
>>
>> http://docs.amazonwebservices.com/ElasticMapReduce/latest/DeveloperGuide/emr-hive-additional-features.html
>>
>> <shameless-plus>
>>   Chapter 21 of Programming Hive discusses this feature and other aspects
>> of using Hive in EMR.
>> </shameless-plug>
>>
>> dean
>>
>>
>> On Mon, Nov 5, 2012 at 5:34 AM, Chunky Gupta <chunky.gupta@vizury.com>
>> wrote:
>>>
>>> Hi,
>>>
>>> I am having a cluster setup on EC2 with Hadoop version 0.20.2 and Hive
>>> version 0.8.1 (I configured everything) . I have created a table using :-
>>>
>>> CREATE EXTERNAL TABLE XXX ( YYY )PARTITIONED BY ( ZZZ )ROW FORMAT
>>> DELIMITED FIELDS TERMINATED BY 'WWW' LOCATION 's3://my-location/data/';
>>>
>>> Now I am trying to recover partition using :-
>>>
>>> ALTER TABLE XXX RECOVER PARTITIONS;
>>>
>>> but I am getting this error :- "FAILED: Parse Error: line 1:12 cannot
>>> recognize input near 'XXX' 'RECOVER' 'PARTITIONS' in alter table statement"
>>>
>>> Doing same steps on a cluster setup on EMR with Hadoop version 1.0.3 and
>>> Hive version 0.8.1 (Configured by EMR), works fine.
>>>
>>> So is this a version issue or am I missing some configuration changes in
>>> EC2 setup ?
>>> I am not able to find exact solution for this problem on internet. Please
>>> help me.
>>>
>>> Thanks,
>>> Chunky.
>>>
>>>
>>>
>>
>>
>>
>> --
>> Dean Wampler, Ph.D.
>> thinkbiganalytics.com
>> +1-312-339-1330
>>
>>
>