Thanks. I see this: CREATE INDEX index_name ON TABLE base_table_name (col_name, ...) AS index_type [WITH DEFERRED REBUILD] [IDXPROPERTIES (property_name=property_value, ...)] [IN TABLE index_table_name] [ [ ROW FORMAT ...] STORED AS ... | STORED BY ... ] [LOCATION hdfs_path] [TBLPROPERTIES (...)] [COMMENT "index comment"]
Sadly, there's no explanation what IDXPROPERTIES could be. It looks to be similar to TBLPROPERTIES, but that isn't documented well either. On 2011/09/12, at 19:11, Ashutosh Chauhan wrote: > https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create%2FDropIndexhas > DDL commands using which you can create and manipulate indices in > Hive. > > Hope it helps, > Ashutosh > > On Mon, Sep 12, 2011 at 05:46, Adriaan Tijsseling > <adri...@tijsseling.com>wrote: > >> Does anyone know the proper documentation for using the "CREATE INDEX" >> command in hive? The hive homepage doesn't have the information. >> >> Cheers, >> >> Adriaan >> >>
