Supported Platforms
HP Vertica Analytic Database
Software Version: 7.1.x
Legal Notices
Warranty
The only warranties for HP products and services are set forth in the express warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. HP shall not be liable for technical or editorial errors or omissions contained herein.
The information contained herein is subject to change without notice.
Restricted Rights Legend
Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license.
Copyright Notice
© Copyright 2006 - 2015 Hewlett-Packard Development Company, L.P.
Trademark Notices
Adobe® is a trademark of Adobe Systems Incorporated.
Contents
Contents
3
HP Vertica Server and HP Vertica Management Console
5
Supported Operating Systems 5
Supported Browsers for HP Vertica Management Console 5
HP Vertica Server and Management Console Compatibility 6
HP Vertica 7.1.x Client drivers
7
ADO.NET Driver 7
JDBC Driver 7
ODBC Driver 8
Vertica Analytic Database Driver/Server Compatibility 10
vsql Client 10
Perl and Python Requirements
12
Perl 12 Python 12
HP Vertica SDKs
13
C++ SDK 13 Java SDK 13 R Language Pack 13HP Vertica Integrations for Hadoop
14
Packs, Plug-Ins, and Connectors for HP Vertica Client Machines
15
Informatica PowerCenter Plug-In 15
HP Vertica on Amazon Web Services
17
HP Vertica in a Virtualized Environment
18
End of Support Plan
20
HP Vertica Server and HP Vertica
Management Console
Supported Operating Systems
Vertica Analytic Database 7.1.x runs on the following 64-bit operating systems on x86_x64 architecture:
l Red Hat Enterprise Linux 5.x* and 6.x
Note: Red Hat Enterprise Linux 7 is supported only on the AMI supplied by Hewlett-Packard for users who want to run HP Vertica on Amazon Web Services (AWS).
l SUSE Linux Enterprise Server 11.0 through 11.0 SP3
l Oracle Enterprise Linux 6 - Red Hat Compatible Kernel only - HP Vertica does not support the
unbreakable kernel (kernels with a uel suffix)
l Debian Linux 6* and 7.0 through 7.5 l Cent OS 5.x* and 6.x
l Ubuntu 12.04 LTS and 14.04 LTS
* HP is phasing out support for on these platforms. SeeEnd of Support Planfor more information.
Supported File Systems
Vertica Analytic Database Enterprise Edition has been extensively tested on all supported Linux platforms running ext3 or ext4 file systems. While other file systems have been successfully deployed by some customers, Vertica Analytic Database cannot guarantee performance or stability of the product on these file systems. In certain support situations, you may be asked to migrate off of these untested file systems to help you troubleshoot or fix an issue. In particular, several file corruption issues have been linked to the use of XFS with HP Vertica; we strongly recommend not using it in production.
Note: Vertica Analytic Database 7.1.x does not support Linux Logical Volume Manager (LVM.)
Supported Browsers for HP Vertica Management
Console
l Internet Explorer 10 and later l Firefox 24 and later
l Google Chrome 27 and later
HP Vertica Server and Management Console
Compatibility
HP Vertica 7.1.x Client drivers
HP Vertica provides JDBC, ODBC, and ADO.NET client drivers. You can choose to download:
l Client packages: All client packages contain the ODBC driver, the JDBC driver, and the HP
Vertica vsql client software for the specified operating system. 64-bit packages contain both 32-and 64-bit installers.
l The ADO.NET driver is not available in a client package, but rather is part of the HP Vertica
Microsoft Connectivity Pack. If the installer detects the presence of Microsoft SQL server, ADO.net will be installed with additional software for MS connectivity. If the installer does not detect the presence of SQL server, only the ADO.NET driver will be installed.
l Individual drivers: You can download Vertica ODBC, JDBC, and ADO.NET drivers individually.
See HP VerticaDriver/Server compatibility to see which server versions are compatible with Vertica 6.1.x drivers.
ADO.NET Driver
The ADO.NET driver is supported on the following platforms:
Platform Processor Supported Versions .NET Requirements Microsoft Windows x86 (32-bit) Windows 7
Windows 8
Microsoft .NET Framework 3.5 SP1 or later
Microsoft Windows x64 (64-bit) Windows 7 Windows 8 Microsoft Windows Server x86 (32-bit) 2008 R2 Microsoft Windows Server x64 (64-bit) 2008 R2 2012
JDBC Driver
ODBC Driver
Vertica Analytic Database provides both 32-bit and 64-bit ODBC drivers. HP Vertica 7.1.x ODBC drivers are supported on the following platforms:
Platform Processor Supported Versions Driver Manager Microsoft Windows x86 (32-bit) Windows 7
Windows 8
Microsoft ODBC MDAC 2.8
Microsoft Windows x64 (64-bit) Windows 7 Windows 8 Microsoft Windows Server x86 (32-bit) 2008 2008 R2 Microsoft Windows Server x64 (64-bit) 2008 2008 R2 2012 Red Hat Enterprise
Linux x86_64 5* and 6 iODBC 3.52.6 or later unixODBC 2.2.14 or later DataDirect 5.3 and 6.1 or later
SUSE Linux Enterprise x86_64 11
Oracle Enterprise Linux (Red Hat Compatible Kernel only)
x86_64 6
CentOS x86_64 5* and 6
Ubuntu x86_64 12.04 LTS
AIX PowerPC 5.3 and 6.1 iODBC 3.52.6 or
later
unixODBC 2.3.0 or later
DataDirect 5.3 and 6.1 or later
Platform Processor Supported Versions Driver Manager
HP-UX IA-64 11i V3 iODBC 3.52.6 or
later unixODBC 2.2.14 or later DataDirect 5.3 and 6.1 or later Solaris SPARC 10 Mac OS X x86_64 10.7, 10.8, and 10.9
Vertica Analytic Database Driver/Server
Compatibility
The following table indicates the Vertica Analytic Database driver versions that are supported by different Vertica Analytic Database server versions.
SHA password security is supported on client driver and server versions 7.1.x only
Client Driver Version Compatible Server Versions
6.1.x 6.1.x, 7.0.x, 7.1.x
7.0.x 7.0.x, 7.1.x
7.1.x 7.1.x
vsql Client
The HP Vertica vsql client is provided in all client packages. You cannot download vsql separately. The vsql client is supported on the following platforms:
Operating System Processor
Microsoft Windows
l Windows 2008 & 2008 R2, all variants l Windows 2012, all variants
l Windows 7, all variants l Windows 8.0, all variants
x86, x64
Red Hat Enterprise Linux 5 x86, x64, IA64
Red Hat Enterprise Linux 6 x86, x64
SUSE Linux Enterprise 11 x86, x64
Oracle Enterprise Linux 6 (Red Hat Compatible Kernel only) x86, x64
CentOS 5 x86, x64, IA64
CentOS 6 x86, x64
Ubuntu 12.04LTS x86, x64
Operating System Processor
Solaris 10 x86, x64, SPARC
AIX 5.3, 6.1 PowerPC
HPUX 11i V3 IA32, IA64
Mac OS X 10.7, 10.8, 10.9 x86, x64
Perl and Python Requirements
You can use HP Vertica's ODBC driver to connect applications written in Perl or Python to the Vertica Analytic Database.
Perl
To use Perl with HP Vertica, you must install the Perl driver modules (DBI and DBD::ODBC) and a HP Vertica ODBC driver on the machine where Perl is installed. The following table lists the Perl versions supported with HP Vertica 7.1.x.
Perl Version Perl Driver Modules ODBC Requirements
l 5.8 l 5.10
l DBI driver version 1.609 l DBD::ODBC version 1.22
See HP Vertica drivers table.
Python
To use Python with HP Vertica, you must install the pyodbc module and an HP Vertica ODBC driver on the machine where Python is installed. The following table lists the Python versions supported with HP Vertica 7.1.x:
Python Version Python Driver Module ODBC Requirements
2.4.6 pyodbc 2.1.6 See HP Vertica ODBC drivers table.
2.7.3 pyodbc 3.0.6
3.3.4 pyodbc 3.0.7
HP Vertica SDKs
This section details software requirements for running User Defined Extensions (UDxs) developed using the HP Vertica SDKs.
C++ SDK
The HP Vertica cluster does not have any special requirements for running UDXs written in C++.
Java SDK
Your HP Vertica cluster must have a Java runtime installed to run UDxs developed using the HP Vertica Java SDK. HP has tested the following Java Runtime Environments (JREs) with this version of the HP Vertica Java SDK:
l Oracle Java Platform Standard Edition 6 (version number 1.6) l Oracle Java Platform Standard Edition 7 (version number 1.7) l OpenJDK 6 (version number 1.6)
l OpenJDK 7 (version number 1.7)
R Language Pack
HP Vertica Integrations for Hadoop
HP Vertica 7.1.x is supported with these Hadoop distributions:
Distribution Version
Cloudera (CDH) 4.6
5.2 5.3
HortonWorks Data Platform (HDP) 2.1
2.2 (without HCatalog)
MapR 3.1.1
4.0
For HDP, if you want to use the HCatalog Connector use version 2.1. HDP 2.2 introduces a newer version of Hive that is not yet supported with HCatalog. However, you can use the ORC Reader, an alternative to the HCatalog Connector, with HDP 2.2.
HP Vertica Connector for Hadoop MapReduce
HP provides a module specific to Hadoop for HP Vertica client machines.
HP Vertica provides two different Connectors: one for Apache Hadoop 1.0.0 and earlier versions, and the other for Apache Hadoop 2.0.0. The table below details supported software versions
HP Vertica Connector for Apache Hadoop MapReduce for Hadoop 1.0.0 and earlier
HP Vertica Connector for Apache Hadoop MapReduce for Hadoop 2.0.0
Apache Hadoop and Pig
Combinations
l Apache Hadoop 0.20.2 and Pig 0.7.0 l Apache Hadoop 0.20.205.0 and Pig
0.9.1
l Apache Hadoop 1.0.0 and Pig 0.9.2
Apache Hadoop 2.0.0 and Pig 0.10.0
Cloudera Distribution Versions
Cloudera Distribution Including Apache Hadoop (CDH) 3
Cloudera Distribution Including Apache Hadoop (CDH) 4
Hortonworks Data Platform Versions
Packs, Plug-Ins, and Connectors for HP
Vertica Client Machines
HP provides the following optional modules for HP Vertica client machines.
MS Connectivity Pack
The HP Vertica Microsoft Connectivity Pack is supported on the following platforms:
Operating System
Versions Processor
Visual Studio Requirements
.Net Requirements (Versions required by ADO.net and OLE DB drivers for specific
versions of Visual Studio)
SQL Server Requirements Windows 2003 & 2003 R2, all variants Windows 2008 R2, (and later) Windows 7, all variants Windows 8, all variants Windows Server 2012, all variants x86_x64 Visual Studio 2008 Visual Studio 2008 SDK
Microsoft .NET Framework 3.5 SP1 SQL Server 2008: R2, SP2, R2 & SP2 Visual Studio 2010 Visual Studio 2010 SDK
Microsoft .NET Framework 3.5 SP1
and (both needed)
Microsoft .NET Framework 4.0
SQL Server 2012 Visual Studio 2012 Visual Studio 2012 SDK
Microsoft .NET Framework 3.5 SP1
and (both needed)
Microsoft .NET Framework 4.5 Visual Studio 2008 (and 2008 SDK) must be used with SQL Server 2008.
Informatica PowerCenter Plug-In
Plug-in
Version Operating System
Informatica PowerCenter Versions HP Vertica Versions 7.x Microsoft Windows l Windows 2003 & 2003 R2 all variants l Windows 2008 & 2008 R2 all variants
l Windows 7 all variants
HP Vertica on Amazon Web Services
HP provides a preconfigured AMI for users who want to run a Vertica Analytic Database on Amazon Web Services (AWS). This HP-supplied AMI is the officially-supported version of the Vertica Analytic Database for AWS. It allows users to configure their own storage and has been configured for and tested on AWS.
Note: HP develops AMIs for HP Vertica on a different schedule than the core software product release. Therefore, AMIs will be available after the HP Vertica software release, but not at the same time.
HP Vertica in a Virtualized Environment
HP Vertica runs in the following virtualization environment:
Host
l VMware version 5.5
l The number of virtual machines per host did not exceed the number of physical processors l CPU frequency scaling turned off at the host level and for each virtual machine
l VMware parameters for hugepages set at version. 5.5 defaults
Input/Output
l Measured byvioperfconcurrently on all Vertica nodes When running vioperf, provide the–
duration=2min optionand start on all nodes concurrently
l 25 megabytes per second per core of write l 20+20 megabytes per second per core of rewrite l 40 megabytes per second per core of read l 150 seeks per second of latency (SkipRead) l Thick provisioned disk, or pass-through-storage
Network
l Dedicated 10G NIC for each Virtual Machine
l No oversubscription at the switch layer, verified withvnetperf
Processor
l Architecture of Sandy Bridge (HP Gen8 or higher) l 8 or more virtual cores per virtual machine l No oversubscription
l vcpuperftime of no more than 12 seconds ~= 2.2 GHz clock speed
Memory
l Pre-allocate and reserve memory for the VM l 4G per virtual core of the virtual machines
HP has tested the configuration above. While other virtualization configurations may have been successfully deployed by customers in development environments, performance of these configurations may vary. If you choose to run HP Vertica on a different virtualization configuration and experience an issue, the HP VerticaSupport team may ask you to reproduce the issue using the configuration described above, or in a bare-metal environment, to aid in troubleshooting. Depending on the details of the case, the Support team may also ask you to enter a support ticket with your virtualization vendor.
End of Support Plan
HP Vertica 7.1.x is the last release for which HP will support the component/platform combinations listed below. HP Vertica 7.1.x service packs and hotfixes will continue to include these
combinations. However, new minor and major versions (7.x and 8.x and later) will not include support for these combinations.
SERVER
Platform End of Support Version
RHEL 5.x
CentOS 5.x
Debian Linux 6
ODBC Client Driver
Platform Processor End of Support Version
Red Hat Enterprise Linux x86_64 5
CentOS x86_64 5
We appreciate your feedback!
If you have comments about this document, you cancontact the documentation teamby email. If an email client is configured on this system, click the link above and an email window opens with the following information in the subject line:
Feedback on Supported Platforms (Vertica Analytic Database 7.1.x) Just add your feedback to the email and click send.