I would like to handle (add, modify) external tables in ODM.
You can create it in relational model and then go to physical model and set its organization to external.
Is it possible in ODM to map external attribute names to attribute names in an external table?
I'm not sure I get it correctly, can you explain it? - you can look here Import from Hive and Oracle 12c External tables
In relational model you can set for table and columns dynamic property "hiveName" and set different name for table and columns then if access driver is "oracle_hive" those names will be set
I missed the organisation setting and therefore I could not get the proper DDL-Preview :-(
Do you by change know if there is something similar while working wiht CSV files instead of Hive/Hadoop? We are still working with 11g :-(