hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <>
Subject [jira] [Commented] (HIVE-17126) Hive Metastore is incompatible with MariaDB 10.x
Date Mon, 07 Aug 2017 20:20:00 GMT


Sergey Shelukhin commented on HIVE-17126:

Actually I guess I see the query from direct SQL and the issue is not related to the text
of the query.
"Unknown system variable 'OPTION'"
Note that direct SQL calls {noformat}SET @@session.sql_mode=ANSI_QUOTES{noformat} on mysql
to use double quotes correctly on MySQL and avoid the weird mysql qoutes.
You can disable direct SQL and see if it fixes the issue since DN itself uses the backticks
However, from the error message it doesn't look related to quotes.

> Hive Metastore is incompatible with MariaDB 10.x
> ------------------------------------------------
>                 Key: HIVE-17126
>                 URL:
>             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

View raw message