My Oracle Support Banner

Instructions to Download/Install/Setup Oracle SQL Connector 3.* for Hadoop Distributed File System (HDFS) (Doc ID 1908347.1)

Last updated on OCTOBER 11, 2016

Applies to:

Oracle SQL Connector for Hadoop Distributed File System - Version 2.3.0 and later
Linux x86-64

Purpose

This document provides instructions on how to download, install and setup Oracle SQL Connector 3.* for Hadoop Distributed File System (OSCH) on the machine where Oracle database resides and also on Hadoop Distributed File System (HDFS) for Hive table access.

Note:- On Oracle Big Data Appliance(BDA) X3-2/V2.*/V3.*, if Connectors are licensed and selected to be installed, then mammoth will install Oracle SQL Connector for HDFS on all nodes in /opt/oracle/orahdfs-3.0.* directory for Hive table access. Thus if using BDA  X3-2/V2.* you can skip installing OSCH on BDA and just install on database machine.

Oracle SQL Connector for Hadoop Distributed File System was formerly known as Oracle Direct Connector for Hadoop Distributed File System.

Oracle SQL Connector for HDFS enables Oracle Database to access data stored in a Hadoop Distributed File System (HDFS). The data can remain in HDFS or it can be loaded into Oracle Database.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Details
 Downloading the Software
  To download from OTN
  To download from Oracle Software Delivery Cloud: 
 Required Software
 Installing and Configuring Hadoop
 Installing Oracle SQL Connector for HDFS
 To install Oracle SQL Connector for HDFS on the Oracle Database System
 Granting User Access to Oracle SQL Connector
 Setting Up User Accounts on the Oracle Database System
 Using Oracle SQL Connector for HDFS on a Secure Hadoop Cluster
 Environment Variables
 Sample Code
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.