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.
>> >> > >
>> >> >
>> >>
>>
>
>

Reply via email to