Does any one know how to make sure Hive partitioning,bucketing,stored by,stored as etc information also can be reverse engineered into model ? When I tried using script .hql file to compare merge or reverse engineer, partitioning columns and all these properties were missing in DDL tab of physical model. Please give ideas on how to fasten generating hive DDLs along with all these properties faster.
Which hive version are you using currently? What do you get when you do reverse engineer from a live database? ER/Studio does not support compare and merge/import against a hive script file. That is supported only for IBM DB2, MS SQL, Sybase, Teradata etc... . You need to compare against the live database to merge changes to the physical model. Alter script towards the live database is also not supported.