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 engines and procedures for accessing Access, Excel, SPSS and dBase files

    WPS Engine for DB2

    Library engines and procedures for accessing a DB2 database

    WPS Engine for Greenplum

    Library engines for accessing a Greenplum warehouse

    WPS Engine for Hadoop

    Library engines for accessing a Hadoop warehouse

    WPS Engine for Informix

    Library engines for accessing an Informix database

    WPS Engine for Kognitio

    Library engines for accessing a kognitio warehouse

    WPS Engine for MySQL

    Library engines for accessing a MySQL database

    WPS Engine for MariaDB

    Library engines for accessing a MariaDB database

    WPS Engine for Netezza

    Library engines for accessing a Netezza appliance

    WPS Engine for ODBC

    Library engines for accessing ODBC datasources

    WPS Engine for OLEDB

    Library engines for accessing OLEDB datasources

    WPS Engine for Oracle

    Library engines for accessing an Oracle database

    WPS Engine for PostgreSQL

    Library engine for accessing an PostgreSQL database

    WPS Engine for SAND

    Library engines for accessing a SAND database

    WPS Engine for SQL Server

    Library engines for accessing a SQL Server database

    WPS Engine for Sybase

    Library engines for accessing a Sybase database

    WPS Engine for Sybase IQ

    Library engines for accessing a Sybase database

    WPS Engine for Teradata

    Library engines for accessing a Teradata warehouse

    WPS Engine for Vertica

    Library engines for accessing a Vertica database

    WPS Engine for XLSX

    Library engines for accessing Microsoft Excel spreadsheets

    Have a question?

    Get in touch with our sales team

    Try or buy

    Standard Edition
    Academic Edition
    Community Edition