I am trying to setup Hadoop/Hive as a data source. I was able to create a "Hive DataSource" under "ODA Data Sources", but I don’t see a way to create a new "Metadata Model" that uses my hive datasource (in the designer). Is there a way to do that?
Our ultimate goal is to setup Hadoop/Hive as the external materialization for a view. Is that supported? Has anyone tried it?
Unfortunately the Designer tooling support for Hive is currently not supported. We hope to provide it in next release. Right now the only option is to manually create the tables in the Designer in a "source" relational model, or you can use the DDL used to create the Hive tables (with some modifications) in Designer and use "import DDL" option to create tables.
As per the materialization it should be possible, however I have not tested that scenario. This topic is great interest to us, so I will work with you to make any modifications needed to make to code work. so. let us know how this spans out. May be at the end you can write a blog about it to share with everybody.