hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Yang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-17126) Hive Metastore is incompatible with MariaDB 10.x
Date Tue, 08 Aug 2017 20:46:00 GMT

    [ 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)

Mime
View raw message