WPS Engine for Hadoop
Data Engine Modules
Hadoop Big Data Environments
Hadoop is an ecosystem of storage and processing components that provide a scalable, fault-tolerant, software framework for the distributed storage and processing of very large datasets on computer clusters.
 |
 |
WPS is able to operate with third party Hadoop big data environments including the major distributions Cloudera, Hortonworks, MapR and native Apache Hadoop. WPS is certified for use with Cloudera version 5 and later.
Hadoop Engine
The WPS Engine for Hadoop provides access to Hive and Impala data sources in a Hadoop environment via standard or pass through SQL.
| Type of Access | Supported? |
|---|---|
| Reading |  |
| Writing | |
| Updating | |
| Creating New Tables | |
| Implicit Pass Through Support | |
| Explicit Pass Through Support |
|
| Bulk Loading |
The WPS engine for Hadoop connects to a Hadoop cluster using the JDBC interface.
Interoperating with Hadoop Big Data Environments
The WPS Interop for Hadoop module provides additional language support for interoperating with a Hadoop environment. This includes a FILENAME statement for direct HDFS connections and a HADOOP procedure for executing Pig and MapReduce commands directly within a Hadoop cluster.
Dependencies and Usage
WPS Engine for Actian Matrix can only be used on the supported platforms indicated in the table below.
Other data engine modules
WPS Engine for Actian Matrix
Library engine for accessing an Actian Matrix database
WPS Engine for DB Files
Library engine and procedures for accessing Access, Excel, SPSS and dBase files
WPS Engine for DB2
Library engine and procedures for accessing a DB2 database
WPS Engine for Greenplum
Library engine for accessing a Greenplum warehouse
WPS Engine for Hadoop
Library engine for accessing a Hadoop warehouse
WPS Engine for Informix
Library engine for accessing an Informix database
WPS Engine for Kognitio
Library engine for accessing a kognitio warehouse
WPS Engine for MySQL
Library engine for accessing a MySQL database
WPS Engine for MariaDB
Library engine for accessing a MariaDB database
WPS Engine for Netezza
Library engine for accessing a Netezza appliance
WPS Engine for ODBC
Library engine for accessing ODBC datasources
WPS Engine for OLEDB
Library engine for accessing OLEDB datasources
WPS Engine for Oracle
Library engine for accessing an Oracle database
WPS Engine for PostgreSQL
Library engine for accessing an PostgreSQL database
WPS Engine for SAND
Library engine for accessing a SAND database
WPS Engine for Snowflake
Library engine for accessing a Snowflake database
WPS Engine for SQL Server
Library engine for accessing a SQL Server database
WPS Engine for Sybase
Library engine for accessing a Sybase database
WPS Engine for Sybase IQ
Library engine for accessing a Sybase database
WPS Engine for Teradata
Library engine for accessing a Teradata warehouse
WPS Engine for Vertica
Library engine for accessing a Vertica database
WPS Engine for XLSX
Library engine for accessing Microsoft Excel spreadsheets
Have a question?
Try or buy
Standard Edition
Academic Edition
Community Edition