We need to store customer billing data in hadoop. First we need to store new customers bills on daily basis from a file which contains around 1M records. then after few days, we need to update the billing status of those records which was stored . So we should be able to either update the data or load it in another table.
We need this data for analytics later but mainly need it for a user facing UI application. where the user needs to fetch all records of a customer and policy. So UI has user inputs and data needs to be fetched real time and displayed in the UI application.
HBase seems to be good option for fast read but will update be easy? and will join be faster? Also heard Hbase is not good for analytics. Hive is good for analytics but data reading is slow for UI application.
Please provide suggestions how we can address this usecase.
Thanks in advance.