I added a column to the table of supported databases <https://cwiki.apache.org/confluence/display/Hive/AdminManual+MetastoreAdmin#AdminManualMetastoreAdmin-SupportedBackendDatabasesforMetastore> and updated a table of metastore configuration variables <https://cwiki.apache.org/confluence/display/Hive/AdminManual+MetastoreAdmin#AdminManualMetastoreAdmin-AdditionalConfigurationParameters>, removing some configs that don't exist in any branch and adding some descriptions and version information.
Reviews, corrections, and further revisions are always welcome. -- Lefty On Sat, Apr 19, 2014 at 1:46 AM, Lefty Leverenz <leftylever...@gmail.com> wrote: > I found out how MS SQL Server is represented in the patch > <https://issues.apache.org/jira/secure/attachment/12640686/HIVE-6927.patch> > for HIVE-6927 <https://issues.apache.org/jira/browse/HIVE-6927> (Add > support for MSSQL in schematool), so I guess it is obvious after all: > > public class HiveSchemaHelper { >> public static final String DB_DERBY = "derby"; >> + public static final String DB_MSSQL = "mssql"; >> public static final String DB_MYSQL = "mysql"; >> public static final String DB_POSTGRACE = "postgres"; >> public static final String DB_ORACLE = "oracle"; >> >> > -- Lefty > > > On Sat, Apr 19, 2014 at 4:25 AM, Lars Francke <lars.fran...@gmail.com> > wrote: > >> Sorry for spotting this thread only now. >> >> I don't think Postgres 9.1 is required or should be the minimum >> version considering that RHEL 6 (current version) comes with 8.4 by >> default. I'd guess that this is one of the most widely deployed >> versions and lots of clusters are running on this or CentOS 6. >> >> On Sat, Apr 19, 2014 at 8:33 AM, Lefty Leverenz <leftylever...@gmail.com> >> wrote: >> > Looks good, Ashutosh. Could you add a column >> > for javax.jdo.option.ConnectionURL examples? MySQL is already shown in >> > previous sections, but it isn't obvious what MS SQL Server should be >> called >> > in the parameter value. >> > >> > -- Lefty >> > >> > >> > On Fri, Apr 18, 2014 at 5:17 PM, Ashutosh Chauhan <hashut...@apache.org >> >wrote: >> > >> >> I have updated wiki. I decided not to put Derby since I don't think it >> >> makes sense to recommend Derby for production scenario. >> >> >> >> >> >> On Thu, Apr 17, 2014 at 8:27 PM, Lefty Leverenz < >> leftylever...@gmail.com >> >> >wrote: >> >> >> >> > +1 >> >> > >> >> > This seems to be the place for it: >> >> > >> >> >> https://cwiki.apache.org/confluence/display/Hive/AdminManual+MetastoreAdmin >> >> > . >> >> > >> >> > I won't volunteer because I've already got my hands full, and >> besides an >> >> > expert can do it faster and better. But I'll find time to edit it. >> >> > >> >> > -- Lefty >> >> > >> >> > >> >> > On Thu, Apr 17, 2014 at 9:24 PM, Thejas Nair <the...@hortonworks.com >> > >> >> > wrote: >> >> > >> >> > > +1 Sounds good to me. >> >> > > >> >> > > On Thu, Apr 17, 2014 at 2:58 PM, Ashutosh Chauhan < >> >> hashut...@apache.org> >> >> > > wrote: >> >> > > > I don't think we have documented anywhere what versions of mysql >> / >> >> > > postgres >> >> > > > / oracle / ms-sql we are supporting. It will be good to document >> >> > those. I >> >> > > > propose following versions: >> >> > > > >> >> > > > * Derby - 10.10.1.1 - defined in hive's pom, so >> all >> >> unit >> >> > > > tests run with it. >> >> > > > >> >> > > > * MySQL - 5.6.17 - minimum supported version by >> >> mysql >> >> > > > community >> >> > > > >> >> > > > * Postgres - 9.1.13 - has support for "create >> table >> >> if >> >> > > not >> >> > > > exists" which is good to have >> >> > > > >> >> > > > * Oracle - 11g - oldest oracle version >> >> available >> >> > > to >> >> > > > download from their site >> >> > > > >> >> > > > * MSSQL server - 2008 R2 - one which is currently tested >> >> against. >> >> > > > >> >> > > > >> >> > > > Thoughts? >> >> > > > >> >> > > > Ashutosh >> >> > > >> >> > > -- >> >> > > CONFIDENTIALITY NOTICE >> >> > > NOTICE: This message is intended for the use of the individual or >> >> entity >> >> > to >> >> > > which it is addressed and may contain information that is >> confidential, >> >> > > privileged and exempt from disclosure under applicable law. If the >> >> reader >> >> > > of this message is not the intended recipient, you are hereby >> notified >> >> > that >> >> > > any printing, copying, dissemination, distribution, disclosure or >> >> > > forwarding of this communication is strictly prohibited. If you >> have >> >> > > received this communication in error, please contact the sender >> >> > immediately >> >> > > and delete it from your system. Thank You. >> >> > > >> >> > >> >> >> > >