#11777: Method not supported message is shown while creating Index

anilkalshetti reported 2014-02-27T05:42:02Z · last modified 2014-03-21T19:28:49Z

Method not supported message is shown while creating Index

Dev	tomconrad
QA	tariqrahiman

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')

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

Screenshot2.png

2014-02-27T05:42:03Z

313 KB

All Comments (13) Change History

SachinPrakash 2014-02-27T18:52:52Z

Can you specify what distribution you are using? (Cloudera, HortonWorks, MapR, etc?)

anilkalshetti 2014-02-28T03:50:41Z

Distribution: Apache

SachinPrakash 2014-02-28T05:23:54Z

How was the server installed? Did you download the binaries from apache & install hadoop server & hive server from scratch? Or did you use a pre-packaged distribution such as HortonWorks, Cloudera, etc?

anilkalshetti 2014-02-28T05:35:54Z

Downloaded the binaries from apache and installed Hadoop 0.23.10 and Hive 0.12 on CentOS 6.4 [64-bit] OS.
Started hiveserver1.

In ADS, Register Server Window parameters:
Connection Type: HiveServer1
Distribution: Apache

tomconrad 2014-03-03T17:11:27Z

Mapr doesn't support executeupdate..

anilkalshetti 2014-03-06T11:33:05Z

Aqua Data Studio 15.0.0-dev-142
Build #: 36450
Built on: 2014-Mar-04 02:16:34 PM

For Apache Distribution,

"Method not supported" message is still shown while creating Table/View/Index by visual way [UI interface].

Please refer,

Issue #8678

Need to use execute() method.

tomconrad 2014-03-06T18:08:12Z

Hi Anilkumar,

Good catch.. I don't have an actual Apache distribution to test with so forgot to add that in with Mapr. The test now looks for Apache or Mapr distributions that are Hive Server 1. Looks like Hive Server 2 is OK with executeUpdate.

Thanks,

Tom

SachinPrakash 2014-03-06T18:12:06Z

Please back port this to v14 as well

tomconrad 2014-03-06T20:46:15Z

OK.. Retrofitted in v14

anilkalshetti 2014-03-07T17:33:07Z · (edited)

Verified on ADS 15.0.0-dev-145

A]Distribution: Apache -> Message is not shown anymore

B]Distribution: Cloudera [HiveServer1]
Cloudera Quickstart VM CDH4.4 [Hive 0.10] Running HiveServer1 -> Message is still shown

tomconrad 2014-03-07T18:31:40Z

Need to fix for all Hive server 1 distributions since HS1 Apache always throws an exception for executeUpdate.

anilkalshetti 2014-03-13T04:27:07Z

Verified in ADS 15.0.0-dev-156

tariqrahiman 2014-03-21T19:28:49Z

Verified in 14.0.10-1 against Mapr HiveServer1 and was able to create the index and no message was displayed

Search Tips

Aqua Data Studio / nhilam

Method not supported message is shown while creating Index

1 attachment

Issue #8678

Issue #8678

Issue #11777

Completion

1 issue link

Issue #8678

Search Tips

Aqua Data Studio / nhilam

Title

Method not supported message is shown while creating Index

1 attachment

Issue #8678

Issue #8678

Issue #11777

Completion

1 issue link

Issue #8678