[
https://issues.apache.org/jira/browse/HIVE-17126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16115511#comment-16115511
]
Eric Yang commented on HIVE-17126:
----------------------------------
>From the log output, it appears that SQL statement generated by DataNucleus is
>double quoting table names and variable names. The syntax is invalid for
>MariaDB. It appears that DataNucleus failed to detect dialect properly for
>this specific combination of OS and MariaDB. I agree that HIVE-14870 can
>solve this problem in the long run. If there is something that can be done in
>detection of SQL dialect, maybe we can have a solution sooner for this issue.
> Hive Metastore is incompatible with MariaDB 10.x
> ------------------------------------------------
>
> Key: HIVE-17126
> URL: https://issues.apache.org/jira/browse/HIVE-17126
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 1.2.0, 1.1.0, 2.0.0
> Reporter: Eric Yang
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
