Index

A B C D E F H I J K L M O P Q R S T U X

A

APPEND hint, 2.4

attaching unstructured data files, 5.5.4

B

balancing loads in Oracle Loader for Hadoop, 3.4

C

CKM Hive, 4.1.2, 4.5.2.2

configuration settings

Oracle Direct Connector, 2.3.2

connections to Oracle Database from R, 5.5.4, 5.5.4

copying data

from Hadoop file system to Oracle Database in R, 5.5.4

from Hadoop to R, 5.5.4

from Oracle Database to Hadoop file system, 5.5.4

from R, 5.5.4

to Hadoop from R, 5.5.4

copying Hadoop files in R, 5.5.4

D

data files

parts in HDFS, 5.5.4

unstructured, 5.5.4

Data Pump files

used by Oracle Direct Connector, 2.1

Data Pump output format

Oracle Loader for Hadoop, 3.3.4

data source

defining for Oracle Data Integrator, 4.2.1

data types

Oracle Loader for Hadoop, 3.8.1

database connections, 5.5.4

database connections from R, 5.5.4, 5.5.4, 5.5.4

DataServer objects, creating for Oracle Data Integrator, 4.2.1

delimited text output format

Oracle Loader for Hadoop, 3.3.3

DelimitedTextInputFormat, 3.2.1.2

directories

current HDFS, 5.5.4

listing in HDFS, 5.5.4

disconnecting

from Oracle Database in R, 5.5.4

downloading

from HDFS, 5.5.4

downloading software, 1.2

drivers, for Oracle Data Integrator agent, 4.2.3

E

executing MapReduce jobs in R, 5.5.4

existing objects in HDFS, 5.5.4

exiting

from Oracle Database in R, 5.5.4

external tables for Oracle Direct Connector, 2.2

ExternalTable command, 2.3.1

extracting data

from Hadoop to R, 5.5.4

F

file size in HDFS, 5.5.4

files

testing existence in HDFS, 5.5.4

unstructured, 5.5.4

flexfields, for Oracle Data Integrator, 4.2.2

H

Hadoop file system

attaching unstructured files, 5.5.4

copying data, 5.5.4

copying data from Oracle Database, 5.5.4

copying data to Oracle Database, 5.5.4

copying data to R, 5.5.4

current directory, 5.5.4

downloading files, 5.5.4

file parts, 5.5.4

file size, 5.5.4

listing directories, 5.5.4

removing directory, 5.5.4

removing files, 5.5.4

sampling data from R, 5.5.4

uploading data, 5.5.4

HADOOP_CLASSPATH, for Oracle Data Integrator, 4.2.3, 4.2.3

HADOOP_HOME, for Oracle Data Integrator, 4.2.3

hadoop.exec function, 5.5.4

hdfs.attach function, 5.5.4

hdfs.download function, 5.5.4

hdfs.exists function, 5.5.4

hdfs.get function, 5.5.4

hdfs.ls function, 5.5.4

hdfs.parts function, 5.5.4

hdfs.pull function, 5.5.4

hdfs.push function, 5.5.4

hdfs.put function, 5.5.4

hdfs.pwd function, 5.5.4

hdfs.rm function, 5.5.4

hdfs.rmdir function, 5.5.4

hdfs.sample function, 5.5.4

hdfs.size function, 5.5.4

hdfs.upload function, 5.5.4

hints for optimizing queries, 2.4

Hive data source

defining for Oracle Data Integrator, 4.2.2

Hive database for Oracle Loader for Hadoop, 1.4.1

Hive tables, reverse engineering, 4.4.2

Hive, loading data into (Oracle Data Integrator), 4.5.1

HIVE_HOME, for Oracle Data Integrator, 4.2.3

HiveToAvroInputFormat, 3.2.1.1

HiveToAvroInputFormat class, 1.4.1

I

IKM File To Hive, 4.1.2, 4.5.1

IKM File-Hive to Oracle (OLH), 4.1.2, 4.5.3

IKM Hive Control Append, 4.1.2, 4.5.2.1, 4.5.2.1, 4.5.2.3

IKM Hive Transform, 4.1.2, 4.5.2.1, 4.5.2.3

IndexedRecord, 3.2.2.1

installation

Oracle Data Integrator Application Adapter for Hadoop, 1.5

Oracle Direct Connector, 1.3

Oracle Loader for Hadoop, 1.4

Oracle R Connector for Hadoop, 1.6

interface configurations

Oracle Data Integrator, 4.5

J

JAVA_LIBRARY_PATH, for Oracle Data Integrator, 4.2.3

K

knowledge modules description, 4.1.2

L

LD_LIBRARY_PATH, for Oracle Data Integrator, 4.2.3

licenses, third-party for Oracle Loader for Hadoop, 3.11

load balancing

tuning for Oracle Loader for Hadoop, 3.4.2.1

load balancing in Oracle Loader for Hadoop, 3.4

loadCI, 3.4.2.1

loader map XML schema definition, 3.9

loaderMap document, 3.2.2

M

MapReduce jobs, executing from R, 5.5.4

maxLoadFactor, 3.4.2.1

O

objects

testing existence, 5.5.4

OCI Direct Path output format, 3.3.2

ODI_HIVE_SESSION_JARS, for Oracle Data Integrator, 4.2.3

ODI_OLH_JARS, for Oracle Data Integrator, 4.2.3

ODI_OLH_SHAREDLIBS, for Oracle Data Integrator, 4.2.3

OLH_HOME, for Oracle Data Integrator, 4.2.3

Oracle Data Integrator Agent, 4.2.3

Oracle Data Integrator Application Adapter for Hadoop

description, 4.1

installing, 1.5

Oracle Data Integrator Studio configuration, 4.2.4

Oracle Database

copying data from Hadoop file system, 5.5.4

copying data to Hadoop file system, 5.5.4

Oracle Database connections, 5.5.4

Oracle Database connections from R, 5.5.4, 5.5.4, 5.5.4

Oracle Direct Connector

database privileges, 1.3.4

description, 2.1

query optimization, 2.4

Oracle Direct Connector for Hadoop

installation, 1.3

Oracle Loader for Hadoop

description, 3.1

installing, 1.4

with Oracle Data Integrator, 4.5.3

Oracle R Connector for Hadoop

installation, 1.6

ORACLE_LOADER access driver, 2.1

oraclepki.jar library, 3.2.3.1

OraLoader, 3.2.4, 3.6

oraloader-conf.xml document, 3.10

OraLoaderMetadata utility program, 3.2.3

orhc.connect function, 5.5.4

orhc.disconnect function, 5.5.4

orhc.reconnect function, 5.5.4

orhc.which function, 5.5.4

P

partitioning, 3.1, 3.8.2

pattern-matching characters in Oracle Direct HDFS, 2.3.3.1

PQ_DISTRIBUTE hint, 2.4

projects

setting up in Oracle Data Integrator, 4.3

pulling data from Hadoop file system to Oracle Database in R, 5.5.4

pushing data from Oracle Database to Hadoop file system, 5.5.4

Q

query optimization for Oracle Direct Connector, 2.4

R

reconnecting to Oracle Database from R, 5.5.4

removing directories in Hadoop, 5.5.4

removing files from HDFS, 5.5.4

RKM Hive, 4.1.2

S

sampling data

from Oracle Loader for Hadoop, 3.4.1

in Hadoop from R, 5.5.4

SerDes jars, 4.2.3

software downloads, 1.2

SQL*Loader, 3.2.5.1

T

tables

copying data from Hadoop file system, 5.5.4

copying data to Hadoop file system, 5.5.4

third-party licenses for Oracle Loader for Hadoop, 3.11

U

uploading data from R, 5.5.4

X

XML schema definition for Oracle Loader for Hadoop, 3.9