× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
anilkalshetti reported 2015-10-08T11:26:26Z  · tariqrahiman last modified 2015-12-04T06:47:15Z

Hive- Decimal Data Type- set default precision value to '10'


Priority Low
Complexity Unknown
Component App - Visual Editing
Version 17.0

Aqua Data Studio 17.0.0-rc-8
Build #: 46242
Built on: 2015-Oct-06 04:46:44 PM                         

Database: Hive
Applicable to all supported distributions

Issue: Hive- Decimal Data Type- set default precision value to '10'

Steps:
1] Open Create Table Window, click on column data type drop down list, select data type Decimal.
Observe Precision default value is displayed as 9 . This default value should be 10

Info:
This is with reference to ADS issue#12108 - Recently Hive confluence-Language Manual is updated. 
So need to change decimal default precision range.

a] According to updated Hive confluence-Language Manual,  For Hive database [Hive 0.13 and above]- decimal datatype default range should be  Decimal(10,0) . Ref. Link - 
--For Hive 0.11 and Hive 0.12 versions the decimal default precision range should remain as is- Decimal(9,0)

b] For Impala database- decimal data type default range will remain as is.
Decimal(9,0) Ref. Link - CDH5.4  - ADS issue#12976

 

@Tom,
This change should be also reflected for ER Diagram Table Column Datatype Decimal.

2 attachments

Issue #13775

Closed
Fixed
Resolved 2015-10-08T15:59:43Z
 
 
Completion
No due date
Fixed Build ADS 17.0.0-rc-9 and ADS 18.0.0-dev-2
No time estimate

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