The wiki docs are incorrect here. CREATE INDEX does not yet supported a
PARTITIONED BY clause; that was added in the spec to support HIVE-1499, which
hasn't been implemented yet.
For now, the index partitioning always follows the table partitioning exactly.
JVS
On Aug 14, 2011, at 3:22 AM, Da
create table part (a int,b int) PARTITIONED by (c int);
create index part_idx on table part(b,c) AS
'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler' WITH DEFERRED
REBUILD
partitioned by (a) ;
hive> create index part_idx on table part(b,c) AS
'org.apache.hadoop.hive.ql.index.comp
