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
