Aqua Data Studio 15.0.0-dev-56
Build #: 35304
Built on: 2013-Dec-20 07:02:58 AM

Operating Environment:  Windows7  64-bit
Database: Hive 0.12
Hadoop 2.1.0-beta, Multi-node Configuration
ADS connected to Hiveserver1

Issue : Indexes are not showing in given sequence order in Apache Hive.

Steps to reproduce:
1. Open Query Analyzer, paste below script,

CREATE TABLE `default`.`partition1`  (  viewtime  int,userid bigint, page_url string, referrer_url    string,ip  string  COMMENT 'IP Address of the User' )

COMMENT 'This is the page view table'
ROW FORMAT DELIMITED
STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat'
GO

2. Open Query Analyzer, paste below script,

CREATE INDEX `i1_partition1`
ON TABLE `partition1`(`ip`, `userid`, `page_url`) AS 'compact' WITH DEFERRED REBUILD
GO

3. Go to Indexes tree node, Expand index “i1_partition1”
You can see that columns are not shown in that sequence  that we have given while creating index.