Hive Metastore supports various backend databases, among which MySQL is the most commonly used. However, in real-world scenarios, MySQL’s shortcoming is obvious: as metadata grows in Hive, MySQL is limited by its standalone performance and can’t deliver good performance. When individual MySQL databases form a cluster, the complexity drastically increases. In scenarios with huge amounts of metadata (for example, a single table has more than 10 million or even 100 million rows of data), MySQL is not a good choice.
https://ankaa-pmo.com/wp-content/uploads/2020/09/create-a-scale-out-hive-cluster-with-a-distributed-mysql-compatible-database.jpg 313 500 Service comm. https://ankaa-pmo.com/wp-content/uploads/2017/04/Logo-Ankaa-engineering.png Service comm.2020-09-25 04:33:132020-09-25 04:33:13Create a Scale-Out Hive Cluster With a Distributed, MySQL-Compatible Database