We are currently using the HCatalog API to get the Hive Database metadata. HCatClient with MetaStore uri. The HCatTable object returned by the HCatClient does not have the view SQL (view definition). As a workaround we are using the Hive Metastore API to get the view SQL from the Table (getViewOriginalText() method) object returned by the HiveMetaStoreClient. Would it be possible to fix this in the HCatalog api? Could this attribute be added to the HCatTable class?
Thanks Rachna