+1 great idea On Wed, Mar 16, 2016 at 10:00 PM, Thejas Nair <thejas.n...@gmail.com> wrote:
> + Sergio, Szehon, Ashutosh, Sushanth, Sergey, > > Any thoughts on this ? > > > On Tue, Mar 15, 2016 at 7:08 PM, Thejas Nair <thejas.n...@gmail.com> > wrote: > > There seems to be increasing interest in supporting MariaDB as an > > option for storing metastore metadata. Supporting it as a database > > option is also easy as it is compatible with mysql. I thought it would > > be useful to discuss supporting it in the dev list before creating any > > jiras. > > > > There are two aspects I would like to discuss - > > > > 1. Changes in hive to support MariaDB > > > > The existing mysql schema creation/upgrade scripts in hive should just > > work for mariadb as well. > > However, MariaDB has some additional optimizations that we might want > > to use in future to optimize queries for it. That would mean creating > > specific scripts for mariadb. > > > > However, until we introduce such MariaDB specific tuning, I think it > > is better to avoid duplicating the mysql scripts. > > > > To make the transition to possibly using MariaDB optimized scripts > > easier, one option is to have schematool consider it as an alias for > > mysql until that happens. > > > > > > 2. Testing with MariaDB > > It would be useful to have tests for mariadb as well on the lines of > > what is available for mysql in > > https://issues.apache.org/jira/browse/HIVE-9800, to ensure that > > mariadb support is not broken. > > > > Thanks, > > Thejas >
