On Sun, Nov 22, 2009 at 7:25 PM, Carl Steinbach <[email protected]> wrote: > Hi Tomer, > > Generally speaking the Hive Metastore can run on top of any datastore that > supports JDBC, and many people have used MySQL for this purpose. The > Metatore Admin page on the Hive wiki has more information about the > different configuration options: > http://wiki.apache.org/hadoop/Hive/AdminManual/MetastoreAdmin > > Hope this helps. > > Carl > > On Sun, Nov 22, 2009 at 3:11 PM, Tomer Shiran <[email protected]> wrote: >> >> Is it possible to set up Hive with a metastore in MySQL or NFS? >> >> I think that changing the configuration parameters (e.g., >> javax.jdo.option.ConnectionURL) would make it possible to use MySQL, but I >> haven't seen any documentation on that. Also, what about using files instead >> of a database? >> >> Thanks, >> Tomer > >
I have never heard anyone attest to any performance gains of using mysql. The MetaData information stored in JPOX should be fairly small. Long lived hive queries spend more of the time operating on data in hdfs, not meta data in derby. As a result, I think there would not be much performance gain using MySQL, though there may be something to gain on the management side. Although derby has master/slave and backup capability. Anyone have a great reason that MySQL is better then Derby?
