Data type mismatch in ADS Create Table GUI for ER Modeler and Cloudera distribution
In the ER Modeler, Our create table UI for Cloudera displays items like Array, Struct, Map etc which are not supported by Cloudera.
When user tries to create a table with those datatypes we get AnalysisException: Syntax error at:
See screenshot
|
306 KB
The Create table visual Editor and the Create Table in ER Modeler should match for Cloudera distribution
Aqua Data Studio 14.0.11
Build #: 37136
Built on: 2014-Apr-15 07:02:13 AM
Cloudera Quickstart VM CDH5.0 [Hive 0.12] , Distribution: Cloudera, Connection Type: Hiveserver2]
The Create table visual Editor and the Create Table in ER Modeler[table column datatypes] should match for Cloudera distribution
>>
The Create table visual Editor and the Create Table in ER Modeler[table column datatypes] are different
Please refer screenshot1
Steps to reproduce:
1.Go to ER-Modeler in menu bar, Select New option
2. New Entity Relationship diagram window is open,
3. Select Database name "Apache Hive" from list under database type pane
4. In Version Pane select distribution 'Cloudera' and double click on it
5. In 'Entity Relationship Diagram' window, click on Table Entity, and move cursor on sheet and click
6. Right click on Table to open Table Properties.
Check column datatypes in drop-down list,
It doesn't matches to Visual editor way Create Table column datatype list.
Aqua Data Studio 14.0.11
Build #: 37136
Built on: 2014-Apr-15 07:02:13 AM
Cloudera Quickstart VM CDH5.0 [Hive 0.12] , Distribution: Cloudera, Connection Type: Hiveserver2]
The Create table visual Editor and the Create Table in ER Modeler[table column datatypes] should match for Cloudera distribution
>>
The Create table visual Editor and the Create Table in ER Modeler[table column datatypes] are different
Please refer screenshot1
Steps to reproduce:
1.Go to ER-Modeler in menu bar, Select New option
2. New Entity Relationship diagram window is open,
3. Select Database name "Apache Hive" from list under database type pane
4. In Version Pane select distribution 'Cloudera' and double click on it
5. In 'Entity Relationship Diagram' window, click on Table Entity, and move cursor on sheet and click
6. Right click on Table to open Table Properties.
Check column datatypes in drop-down list,
It doesn't matches to Visual editor way Create Table column datatype list.
Issue #11865 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 14.0.10-5 |
No time estimate |
1 issue link |
relates to #11862
Issue #11862Data type mismatch in ADS Create Table GUI and Cloudera distribution |
The Create table visual Editor and the Create Table in ER Modeler should match for Cloudera distribution