Mailing-List: contact hive-user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hive-user@hadoop.apache.org
Received-SPF: pass (athena.apache.org: domain of heyongqiangict@gmail.com
 designates 209.85.216.169 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=CZti5b8T3XY9hoFkHQjXeNcWmshzeQ5IKmHO8OgOGamwXVFjt2v9BivtB/oHHDqimF
         ptrtD3S6BgHrK0tYiVYzhRHmdlXolrvAzZ5xIYmQcn6+oAh40FILA86znfx5k1f0hadw
         mssNTQKQEvPbACoSDSWdIgwHuM1WeHu/yMumY=
MIME-Version: 1.0
In-Reply-To: <E3A9B15C-9ECD-45B7-8934-2611BD272582@facebook.com>
References: <SNT135-w32F13A8E7A92FAC913B444B0600@phx.gbl>
	<SNT135-w19524CB8F918B0D1068ABDB0610@phx.gbl>
	<92FEE3DA-65C4-487E-B567-3FEDA537FAE4@facebook.com>
	<SNT135-w558DA0B5A4B8DCAA067117B0610@phx.gbl>
	<E3A9B15C-9ECD-45B7-8934-2611BD272582@facebook.com>
Date: Fri, 24 Sep 2010 10:12:52 -0700
Message-ID: <AANLkTinhW03khNtrjQjoXeeH_OYff6qSzcdKOBRbsuDb@mail.gmail.com>
Subject: Re: Create index error:FAILED: Parse Error: line 1:0 cannot recognize
 input 'create' in ddl statement
From: yongqiang he <heyongqiangict@gmail.com>
To: hive-user@hadoop.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

If you really want to use the index feature, you can just checkout
hive trunk code (svn co
http://svn.apache.org/repos/asf/hadoop/hive/trunk hive-trunk), and
start from there. Hive is mostly at the client side, and is very easy
for new deployment (even you are using Amazon EC2 and s3).
Internally in facebook, we just cut the Hive trunk every few weeks and
deploy the hive trunk. So i personally encourage you to try Hive
trunk.

On Thu, Sep 23, 2010 at 6:26 PM, John Sichi <jsichi@facebook.com> wrote:
> Since we're only just wrapping up the 0.6 release now, it's probably a bi=
t
> too early to tell. =A0Note that the index feature is still under developm=
ent,
> so the support in 0.7 may still not be ready for most end users.
> JVS
> On Sep 23, 2010, at 3:19 PM, Tali K wrote:
>
> Do you have any idea when we can expect Hive 0.7 to be released?
>
> Thanks,
> Tali
>
> ________________________________
> From:=A0jsichi@facebook.com
> To:=A0hive-user@hadoop.apache.org
> Subject: Re: Create index error:FAILED: Parse Error: line 1:0 cannot
> recognize input 'create' in ddl statement
> Date: Thu, 23 Sep 2010 21:27:14 +0000
>
> I've updated the index design doc to add this statement at the top:
> No index support will be available until Hive 0.7.
> If you really want to try it, you need to be building and running trunk.
> JVS
> On Sep 23, 2010, at 2:15 PM, Tali K wrote:
>
>
> Hi All,
>
> I've sent this e-mail yesterday, can , please, sombody help me!!!
>
> I am running hive ....version 0.5.0=A0(hive-default.xml:
> <value>lib/hive-hwi-0.5.0.war</value>)
>
> When I tried to create index I've got the following message:
>
> FAILED: Parse Error: line 1:0 cannot recognize input 'create' in ddl
> statement
>
> Here is how I've tried to create an index:
>
> =A0create index qid_index on table bit_score_less_55(query_id) as
> 'org.apache.hadoop.hive.index.compact.CompactIndexHandler';
>
> Here is=A0my table
>
> describe bit_score_less_55=A0;
>
> query_id=A0=A0=A0=A0=A0=A0=A0 string
> subject_id=A0=A0=A0=A0=A0 string
> percent_ident=A0=A0 double
> align_len=A0=A0=A0=A0=A0=A0 int
> mismatches=A0=A0=A0=A0=A0 int
> gap_openings=A0=A0=A0 int
> query_start=A0=A0=A0=A0 int
> query_end=A0=A0=A0=A0=A0=A0 int
> subject_start=A0=A0 int
> subject_end=A0=A0=A0=A0 int
> e_value double
> bit_score=A0=A0=A0=A0=A0=A0 double
> filename=A0=A0=A0=A0=A0=A0=A0 string
>
>
> Any suggestions?
>
> Thanks for help in advance,
>
>
>
> Tali
>
>
>
>