Hi. I'm looking for some help with creating complex data type for the Hive PDM. The DDL that is generated does not include the abstract data type.
Here are the steps:
I've created a Hadoop Hive 1.0 PDM. I created the below abstract data type:
I then used it as a data type for a column:
I then created a new DDL by selecting the menu item 'Generate Database...'.
The Data type I created is selected to be part of the DDL.
The new data type I created is not included in the DDL and the data type of the column that was using it is set to:array < decimal(10,0) >:
I'm not sure if this is going to help but here is the Summary tab of the Database Generation dialog:
Script name : "HadoopTest7.sql"
Path name : "C:\Users\abc\Documents\Products\PowerDesigner\PowerDesigner Projects\Scripts\"
One file only
Generation type: Script
Check inside table
Create primary key inside table
Drop primary key
Create alternate key inside table
Drop alternate key
Primary key : false
Foreign Key : true
Alternate Key : false
Cluster : true
Others : true
Character case: Mixed case
Encoding: ANSI (Active Code Page)
Am I doing something wrong or could this be a bug?