Limitations of hive in its latest version

[#1]

what are the limitations of hive in its latest version , as Hive has also added ACID support . What are limitations there where hive is not suitable .

[#2]

@Anurag Mishra Hive is used as a traditional data warehouse. It provides scalability, in-memory processing, ACID support for CDC, and full TPCS DW ANSI compliance. Hive is a great tool for BI analytics and visualization with reporting tools such Tableau. Hive is not a tool for machine learning, realtime streaming, complex event processing, or simple event processing (though it can be a key component in all those architectures). There are other tools in the stack which would provide much better functionality for those specific use cases.