hive-user mailing list archives

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


Hi All,

 

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