I want to store my data on Hadoop such that all the computation for my KPI's haapen on Big Data Platform rather than on my reporting tool. One way i thought was to create a base table in hive and then an intermediate aggregate table from which my final table would take data to calculate my final KPI's. But issue with this is, I want to define business rule for my KPI's so that whenever a new KPI or column is added it follows the rules defined earlier. Can anyone shed some light or ideas on this part, how can i do this?
... View more