Recently we have made Hive 0.8.0 connectivity with SAP BO 4.0 Sp5. We are able to get table from Hive to Infromation design tool and able to generate report for testing purpose.
As per my knowledge there is no refrential integrity present in hive. So if we want to generate report like as we are generating report based on oracle ,DB2, or sql server what colud be data model present in Hive so that we can achive the same through Hive?.
Any suggetsion or help on this would be appreciated.
Thanks in advance.