hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tali K <ncherr...@hotmail.com>
Subject RE: Create index error:FAILED: Parse Error: line 1:0 cannot recognize input 'create' in ddl statement
Date Thu, 23 Sep 2010 22:19:28 GMT

Do you have any idea when we can expect Hive 0.7 to be released?
 
Thanks,
Tali
 


From: jsichi@facebook.com
To: hive-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 (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:

 create index qid_index on table bit_score_less_55(query_id) as 'org.apache.hadoop.hive.index.compact.CompactIndexHandler';

Here is my table 

describe bit_score_less_55 ;

query_id        string
subject_id      string
percent_ident   double
align_len       int
mismatches      int
gap_openings    int
query_start     int
query_end       int
subject_start   int
subject_end     int
e_value double
bit_score       double
filename        string


Any suggestions?

Thanks for help in advance,

 

Tali

 		 	   		  
Mime
View raw message