[
https://issues.apache.org/jira/browse/HIVE-17126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16119004#comment-16119004
]
Eric Yang commented on HIVE-17126:
----------------------------------
[~sershe] SET OPTION is removed from MySQL 5.6 and newer. There is similar
error reported to [MariaDB
community|https://mariadb.atlassian.net/browse/MDEV-6201]. Perhaps, there is
something in the driver layer that prevented the session to be set for
ANSI_QUOTES. The system was using
{{mysql-connector-java-5.1.17-6.el6.noarch}}, which came with RHEL6.x family.
This might be problematic because the driver and server are not fully
compatible with each other. I will do more testing this weekend with a new
version of MariaDB connector/J to see if we can side step this issue. I think
it is important to do a error check for SET @@session.sql_mode with more user
friendly message. The current code seems to execute SQL queries even if the
SET query failed to execute.
> 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)
