You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by abhishek <ab...@gmail.com> on 2012/12/04 15:07:05 UTC

CREATE DATABASE WITH LOCATION

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

Re: CREATE DATABASE WITH LOCATION

Posted by abhishek <ab...@gmail.com>.

Thanks Thiruvel 

Sent from my iPhone

On Dec 4, 2012, at 10:09 AM, Thiruvel Thirumoolan <th...@yahoo-inc.com> wrote:

> This feature (HIVE-1537) was added in Hive 0.8.
> 
> On 12/4/12 7:37 PM, "abhishek" <ab...@gmail.com> 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
>

Re: CREATE DATABASE WITH LOCATION

Posted by Thiruvel Thirumoolan <th...@yahoo-inc.com>.

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

On 12/4/12 7:37 PM, "abhishek" <ab...@gmail.com> 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