#13785: Hive- In Alter Table- Clustered By block fields should be enabled

anilkalshetti reported 2015-10-19T07:25:33Z · last modified 2017-01-04T06:30:16Z

Hive- In Alter Table- Clustered By block fields should be enabled

Dev	tomconrad
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Hive
Version	18.0

Aqua Data Studio 17.0.0-rc-18
Build #: 46454
Built on: 2015-Oct-16 10:09:16 PM

Database: Hive 1.2.1
Hortonworks HDP 2.3.0 - Hive 1.2.1
Drivers Link- Hive 1.2.1
[ACID Transactions enabled]

Issue: Hive- In Alter Table-Storage Tab- Clustered By block fields should be enabled

Steps:

1. Create a Table using below script.

CREATE TABLE stock (

symbol string,

ymd string,

price_open float)

ROW FORMAT DELIMITED FIELDS TERMINATED BY ','

stored as orc TBLPROPERTIES ('transactional'='true')

2. Right click on this table and select 'Alter Table'.
3. In Alter Table, click on Storage Tab,

Observe that- Clustered By block is disabled.

Expected: This fields should be enabled.
[Number of Buckets displayed as : -1, when buckets are not applied on table.
This is right behaviour]

4. Using the below script you will be able to alter the table

ALTER TABLE stocks2
CLUSTERED BY (symbol,price_open)
INTO 51 BUCKETS
Go

5. When executed above 'Alter Table..' script in query analyzer,

and again opened 'Alter table' window, under Clustered By block.

Field values from alter table are displayed.

-- Alter Table command works properly, and values are reflected.

Once again execute the Alter Table command changing buckets value in script to 61.
ALTER TABLE stocks2
CLUSTERED BY (symbol,price_open)
INTO 51 BUCKETS
Go

Command executes successfully and the values will be reflected properly.

Expected:- Clustered By block fields should be enabled always.

Please refer screenshot1.png and
SQL script file- HiveScript2

6 attachments

screenshot1.png

2015-10-19T07:25:33Z

243 KB
HiveScript2.sql

2015-10-19T07:25:33Z

260 B
Reopened13785.png

2015-10-21T12:35:05Z

164 KB
Reopened2-ADS18-dev-6.png

2015-10-23T05:00:07Z

164 KB
Fixed13785.png

2015-10-27T11:33:17Z

192 KB
Updated_13785.png

2017-01-04T06:30:16Z

69 KB

All Comments (6) Change History

anilkalshetti 2015-10-21T12:38:15Z

Please refer screenshot-Reopened-13785.png

Fields are enabled in ADS17.0.0-rc-20[Verified]
but fields are still disabled in ADS18.0.0-dev-5 [Reopened issue]

tomconrad 2015-10-21T15:02:01Z

Hi Anil... Hmm!! This works for me. I used the same code for v17 that is in v18. Try using dev-6 although dev-5 should work. Thanks, Tom

SachinPrakash 2015-10-21T22:46:47Z

There was a build issue w/ v18 dev-5. Try again w/ v18 dev-6.

anilkalshetti 2015-10-23T05:09:13Z · (edited)

Build: ADS18.0.0-dev-6

Reopening the issue,
In ADS18.0.0-dev-6 build, Clustered By parameter fields are still disabled.
Please refer screenshot: Reopened2-ADS18-dev-6.png

-- In latest ADS17.0.0-rc-22 build, Clustered By parameter fields are enabled, in Alter Table window.

anilkalshetti 2015-10-27T11:33:33Z

Verified in ADS 17.0.0-rc-24
and ADS 18.0.0-dev-10
Please refer screenshot: Fixed13785.png

raghavsingh 2017-01-04T06:30:06Z

Verified in ADS-18.0.0-RC-16. Refer updated screenshot 'Updated_13785.png'

Search Tips

Aqua Data Studio / nhilam

Hive- In Alter Table- Clustered By block fields should be enabled

6 attachments

Issue #13785

Completion

2 issue links

Issue #13795

Issue #13797

Search Tips

Aqua Data Studio / nhilam

Title

Hive- In Alter Table- Clustered By block fields should be enabled

6 attachments

Issue #13785

Completion

2 issue links

Issue #13795

Issue #13797