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