[HIVE-17126] Hive Metastore is incompatible with MariaDB 10.x

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 1.1.0, 1.2.0, 2.0.0
• Component/s: Metastore
• Assignee: Unassigned
• Reporter: Eric Yang
• Created: 19/Jul/17 16:23
• Updated: 09/Aug/17 20:59
• Resolved: 09/Aug/17 20:59

Description

MariaDB 10.x is commonly used for cheap RDBMS high availability. Hive usage of Datanucleus is currently preventing Hive Metastore to use MariaDB 10.x as highly available metastore. Datanucleus generate SQL statements that are not parsable by MariaDB 10.x when dropping Hive table or database schema. Without MariaDB HA setup, the SQL statement problem also exists for metastore interaction with MariaDB 10.x.