Aqua Data Studio 17.0.0-dev-68
Build #: 44582
Built on: 2015-Jul-01 06:18:01 PM
Database - MapR 4.0.1 Hive 0.12
Connection Type - HiveServer 2
Scenario 1 - For hive 0.12 'char' datatype should be removed from column datatype drop down list.
1.Connect to MapR Hive database.
2.Expand MapR Hive database .
3.Right click on Table tree node and select option 'Create Table'.
In Create table visual editor,column datatype drop down list should not show 'char' datatype.
Scenario 2 - For hive 0.12 precision and scale option should be disabled for decimal datatype.
1.Connect to MapR Hive database.
2.Expand MapR Hive database .
3.Right click on Table tree node and select option 'Create Table'.
4.Add new column with name t1 and data type 'decimal'.
In Column tab for 'decimal' data type 'Precision' and 'Scale' option should be disabled because Hive 0.12 does not support user defined Precision and Scale.
Note -
1.In ADS v16 for Hive 0.12 "char" data type is not display in column datatype drop down list and also for decimal data type 'Precision' and 'Scale' option is disabled
2.char data type supported from hive 0.13
3.User defined precision and scale is supported from hive 0.13
4.Issue reproducible only for ADS v17
(Note-For MapR-Hive I have uploaded all used drivers in QA-Dimentrix )
Database - MapR 3.1.0 Hive 0.11
I] For hive 0.11 following datatype should be removed from column datatype drop down list .