Eric Yang commented on HIVE-17126:

>From the log output, it appears that SQL statement generated by DataNucleus is 
>double quoting table names and variable names.  The syntax is invalid for 
>MariaDB.  It appears that DataNucleus failed to detect dialect properly for 
>this specific combination of OS and MariaDB.  I agree that HIVE-14870 can 
>solve this problem in the long run.  If there is something that can be done in 
>detection of SQL dialect, maybe we can have a solution sooner for this issue.

> 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