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

Reply via email to