hi all,

I am trying the below query

Create database xxxx
Location '/my/preferred/directory'

But getting the below error

FAILED: Parse Error : line 2:0 mismatched input 'LOCATION' excepting EOF near 'xxxx'

I am using hive 0.7

Regards
Abhi

This feature (HIVE-1537) was added in Hive 0.8.

On 12/4/12 7:37 PM, "abhishek" <[EMAIL PROTECTED]> wrote:

>hi all,
>
>I am trying the below query
>
>Create database xxxx
>Location '/my/preferred/directory'
>
>But getting the below error
>
>FAILED: Parse Error : line 2:0 mismatched input 'LOCATION' excepting EOF
>near 'xxxx'
>
>I am using hive 0.7
>
>Regards
>Abhi

Thanks Thiruvel

Sent from my iPhone

On Dec 4, 2012, at 10:09 AM, Thiruvel Thirumoolan <[EMAIL PROTECTED]> wrote:

> This feature (HIVE-1537) was added in Hive 0.8.
>
> On 12/4/12 7:37 PM, "abhishek" <[EMAIL PROTECTED]> wrote:
>
>> hi all,
>>
>> I am trying the below query
>>
>> Create database xxxx
>> Location '/my/preferred/directory'
>>
>> But getting the below error
>>
>> FAILED: Parse Error : line 2:0 mismatched input 'LOCATION' excepting EOF
>> near 'xxxx'
>>
>> I am using hive 0.7
>>
>> Regards
>> Abhi
>