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)
@Tom,
This change should be also reflected for ER Diagram Table Column Datatype Decimal.
|
162 KB
|
102 KB
Verified in ADS17.0.0-rc-11
Tested for below distributions:
a] Hortonworks HDP2.3.0- Hive 1.2.1
b] MapR5.0-Hive 1.0.0
Please refer screenshots: Fixed-HDp23Hive121.png and Fixed-MapR5Hive100.png
Issue #13775 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 17.0.0-rc-9 and ADS 18.0.0-dev-2 |
No time estimate |
1 issue link |
relates to #13753
Issue #13753Spark-SQL - Default decimal range should be set as Decimal(10,0) |
Verified in ADS17.0.0-rc-11
Tested for below distributions:
a] Hortonworks HDP2.3.0- Hive 1.2.1
b] MapR5.0-Hive 1.0.0
Please refer screenshots: Fixed-HDp23Hive121.png and Fixed-MapR5Hive100.png