Offload Oracle Data to HDFS using RO Tablespaces

Purpose:

Offloading Oracle Data to HDFS

Prerequisites:

Hortonworks NFS Gateway is running Please, Please visit the post below

Configuring NFS Gateway for HDFS [HDP]

Creating Oracle External Table (12c) on HDFS using HDP NFS Gateway

Purpose:

Offloading Oracle Data to HDFS

Prerequisites:

Hortonworks NFS Gateway is running 

Configuring NFS Gateway for HDFS [HDP]

The NFS Gateway for HDFS allows clients to mount HDFS and interact with it through NFS, as if it were part of their local file system. The gateway supports NFSv3.

After mounting HDFS, a user can:

Configure Hortonworks Hive ODBC Driver for Oracle HS

The Hortonworks Hive ODBC Driver is used for direct SQL and HiveQL access to Apache

Hadoop / Hive distributions, enabling Business Intelligence (BI), analytics, and reporting on

Hadoop / Hive-based data. The driver efficiently transforms an application’s SQL query into

the equivalent form in HiveQL.

Query Teradata Presto from Oracle using ODBC Heterogeneous Gateway [RHEL 7]

Presto is a distributed SQL query engine designed to query large data sets distributed over one or more heterogeneous data sources. In Italian, “Presto” means fast. In the tech world, it means an open-source distributed SQL query engine for Apache™ Hadoop® that runs interactive analytic queries against data sources of all sizes. Through a single query, data is accessed where it resides. Typically, this means data in a Hadoop Distributed File System (HDFS). However, unlike other SQL on Hadoop engines, Presto can query data sources such as Apache Cassandra™, relational databases or even proprietary data stores.