× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
anilkalshetti reported 2014-02-27T05:42:02Z  · tariqrahiman last modified 2014-03-21T19:28:49Z

Method not supported message is shown while creating Index


Priority Low
Complexity Unknown
Component Hive
Version 14.0

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?
 
 
1 attachment

Issue #11777

Closed
Fixed
Resolved 2014-03-10T16:03:15Z
 
 
Completion
No due date
Fixed Build ADS 15.0.0-dev-150
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017