[
https://issues.apache.org/jira/browse/HIVE-17126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16117193#comment-16117193
]
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 afaik.
However, from the error message it doesn't look related to quotes.
> 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)
