Aqua Data Studio 15.0.0-dev-128
Build #: 36312
Built on: 2014-Feb-25 03:20:50 PM
Operating Environment: Ubuntu 12.04.3 LTS 64-bit
Database: Apache Hive0.12 [connected to HiveServer1]
Hadoop 0.23.10
Distribution: Apache
Issue: Method not supported message is shown while creating Index
Steps to reproduce Issue:
1. Close currently running ADS, open new ADS window.
2. Connect to Hive Database server.
3. Expand Tables node, Run below query to create a table
// create table script
CREATE TABLE `default`.`test_datatypes1` (
c1_array array<int>,
c2_bigint bigint,
c3_binary binary,
c4_boolean boolean,
c5_decimal decimal,
c6_double double,
c7_float float,
c8_int int,
c9_map map<string, array<int>>,
c10_smallint smallint,
c11_string string)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' COLLECTION ITEMS TERMINATED BY '/' MAP KEYS TERMINATED BY ':' LINES TERMINATED BY '\n'
STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
TBLPROPERTIES ('numFiles'='2', 'numPartitions'='0', 'numRows'='0', 'rawDataSize'='0', 'totalSize'='1740')
GO
4. Right click on Indexes, to create Index, select Create Index.
5. In Create Index window, enter index name, enter sequence for some columns, click on Create.
6. It will show Alert Message "Method not supported. Click Ok in alert message box .
7. Expand Indexes in tree node, you will observe that Index has been created.
Then why its showing Method not supported message while creating Index?
Verified in ADS 14.0.10