Index

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

---

A

access drivers

See drivers

access privileges, Oracle Database, 1.4.4

ALTER SESSION commands, 2.4

Apache Hadoop distribution, 1.2.2, 1.4.1, 1.4.1, 1.5.1, 1.5.1, 1.7.1.1, 3.3.2

Apache licenses, 3.11.1, 3.11.2, 3.11.3, 3.11.4

APPEND hint, 2.4

Avro license, 3.11.2

---

B

bagged.clust.R demo, 5.7.2

balancing loads in Oracle Loader for Hadoop, 3.4

bitops R package, 1.7.1.1, 5.7.2, 5.7.2, 5.7.2, 5.7.2

---

C

cd command

executing in HDFS from R, 5.7.2

CDH3 distribution, 1.5.1

CKM Hive, 4.1.2, 4.5.2.2

client libraries, 1.5.2

clients

configuring Hadoop, 1.4.2, 1.7.2.2

combiners

generating key-value pairs for in R, 5.7.2, 5.7.2

running from R, 5.7.2, 5.7.2

Comprehensive R Archive Network

See CRAN

compressed files, 2.3.4.1, 2.3.4.1

compression in R, 5.7.2

configuration settings

Hadoop client, 1.4.2, 1.7.2.2

Oracle Data Integrator agent, 4.2.3

Oracle Data Integrator interfaces, 4.5

Oracle Data Integrator Studio, 4.2.4

Oracle Direct Connector for HDFS, 2.3.3, 2.3.4

Oracle Loader for Hadoop, 3.5, 3.6

Oracle Net, 2.3.4.1

R MapReduce jobs, 5.6

Sqoop utility, 1.7.1.2

configuring a Hadoop client, 1.4.2, 1.7.2.2

connecting to Oracle Database from R, 5.5.1

connection objects

reconnecting to Oracle Database with, 5.7.2

copying data

from an Oracle database to HDFS using R, 5.7.2, 5.7.2

from HDFS to an Oracle database using R, 5.7.2

from HDFS to an R data frame, 5.7.2

from local files to HDFS using R, 5.7.2

copying files

from HDFS to Linux using R, 5.7.2

cp command

executing in HDFS from R, 5.7.2

CRAN, 5.7.2, 5.7.2

CREATE SESSION privilege, 1.4.4

CREATE TABLE command, 2.2

CREATE_TARG_TABLE option, 4.5.1, 4.5.2.1, 4.5.2.3, 4.5.3

creating external tables, 2.2.1

CSV files, 2.1, 2.2.1, 2.3.4.1, 3.1, 3.3.3, 3.6, 5.7.2

---

D

data compression in R, 5.7.2

data decompression in R, 5.7.2

data files

accessing from R, 5.7.2

copying database objects into using R, 5.7.2

copying into Oracle Database using R, 5.7.2

deleting from HDFS using R, 5.7.2

obtaining size from R, 5.7.2

sampling from R, 5.7.2

uploading local, 5.7.2

See also files; HDFS files

data frames

copying HDFS data into, 5.7.2

example of mapper output format, 5.7.2

example program using, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1

from Oracle R Enterprise, 5.7.2

generated by R mapper functions, 5.6

generated by R reducer functions, 5.6

input to mappers, 5.7.2

data integrity checking, 4.5.2.2

Data Pump files, 2.1

access parameters, 2.2

generating, 2.1, 3.3.4

publishing in Oracle Direct Connector for HDFS, 2.3.2, 2.3.4.1

specifying location in Oracle Direct Connector for HDFS, 2.2.1

Data Pump format, 3.1

data sources

defining for Oracle Data Integrator, 4.2.1

data transformations, 4.5.2.3

data types

Oracle Loader for Hadoop, 3.8.1

data validation in Oracle Data Integrator, 4.1.2, 4.5.2.3

database

copying data from using R, 5.7.2

database client installation, 4.2.3

database connections

disconnecting using R, 5.7.2

from R, 5.7.2, 5.7.2

querying from R, 5.7.2

reconnecting from R, 5.7.2

database directories

for external tables, 2.2.1

for Oracle Direct Connector for HDFS, 1.4.3, 2.2

database objects

copying to HDFS using R, 5.7.2

database patches, 1.4.1, 1.5.1, 1.5.1, 1.5.1, 2.1

database privileges, 1.4.4

database system, configuring to run MapReduce jobs, 1.4.2

DataServer objects

creating for Oracle Data Integrator, 4.2.1

debugging in R

identifying version, 5.7.2

redirecting output, 5.7.2

turning off, 5.7.2

turning on, 5.7.2

debug.R example, 5.7.1

decompressing files, 2.3.4.1

decompression in R, 5.7.2

DEFER_TARGET_LOAD option, 4.5.1

DELETE_ALL option, 4.5.3

DELETE_TEMPORARY_OBJECTS option, 4.5.1, 4.5.2.1, 4.5.2.3, 4.5.3

delimited text output format

Oracle Loader for Hadoop, 3.3.3

DelimitedTextInputFormat class, 3.2.1.2, 3.6

Oracle Loader for Hadoop, 3.2.1.2, 3.2.1.2

DelimitedTextOutputFormat class, 3.6, 3.6

demo code for ORCH, 5.7.2

describe command

executing in HDFS using R, 5.7.2

dfs.id object

obtaining in R, 5.7.2

directories

accessible by Oracle Data Integrator, 4.2.1

creating in HDFS using R, 5.7.2

current HDFS, 5.7.2

for Oracle Loader for Hadoop output, 4.5.3

Hadoop home, 1.4.2

listing in HDFS, 5.7.2

ODI Application Adapter for Hadoop home, 1.6.3

Oracle Data Integrator agent drivers, 4.2.3

Oracle Direct Connector for HDFS home, 1.4.3

Oracle Net, 2.3.4.1

R connector examples, 5.7.1, 5.7.2

removing using R, 5.7.2

Sqoop home, 1.7.1.2

See also database directories; root directory

distance.R demo, 5.7.2

downloading software, 1.3, 1.4.1, 1.6.1, 1.7.1.1, 1.7.1.2, 1.7.1.3, 1.7.2.4, 5.7.2, 5.7.2

drivers

JDBC, 1.7.1.2, 3.3.1, 4.2.2

Oracle Data Integrator agent, 4.2.3

ORACLE_DATAPUMP, 3.1, 3.3.4, 3.3.4

ORACLE_LOADER, 2.1, 2.1, 3.1

DROP_ERROR_TABLE option, 4.5.2.2

dry run execution in R, 5.7.2

---

E

environment variables

See individual variable entries

example code for ORCH

descriptions, 5.7.1

exists function in R, 5.7.2

exporting R objects to Hadoop, 5.7.2

EXT_TAB_DIR_LOCATION option, 4.5.3

external tables

about, 2.1

creating for Oracle Direct Connector for HDFS, 2.2

example, 2.2.3

syntax, 2.2.1

EXTERNAL VARIABLE DATA parameter, 2.2

EXTERNAL_TABLE option, 4.5.1

ExternalTable command, 2.3.1

configuration settings, 2.3.3

example, 2.3.1.3

path settings, 2.3.1.1

syntax, 2.3.1.2

See also external tables

EXTRA_OLH_CONF_PROPERTIES option, 4.5.3

---

F

file formats for Oracle Data Integrator, 4.5.1

file identifiers

validating in R, 5.7.2

file size

obtaining using R, 5.7.2

file sources

defining for Oracle Data Integrator, 4.2.1

File to Hive KM, 4.1.2, 4.5.1

FILE_IS_LOCAL option, 4.5.1

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

files

decompressing, 2.3.4.1

downloading from HDFS, 5.7.2

obtaining HDFS metadata using R, 5.7.2

testing existence in HDFS from R, 5.7.2

uploading local to HDFS, 5.7.2

See also data files; HDFS files

filter1.R example, 5.7.1

filter2.R example, 5.7.1

filter3.R example, 5.7.1

flex fields, 4.2.2, 4.4.2

FLOW_CONTROL option, 4.5.2.1

FLOW_TABLE_OPTIONS option, 4.5.3

---

G

group.apply.R example, 5.7.1

---

H

Hadoop client

configuring, 1.4.2, 1.7.2.2

installing, 1.4.2

hadoop fs command, 1.4.2

HADOOP_CLASSPATH

for Oracle Data Integrator, 4.2.3, 4.2.3

for Oracle Loader for Hadoop, 1.5.2

HADOOP_CLASSPATH environment variable

for Oracle Direct Connector for HDFS, 2.3.1.1, 2.3.1.3

HADOOP_HOME

for Oracle Data Integrator, 4.2.3

for Oracle Direct Connector for HDFS, 1.4.2

HADOOP_HOME environment variable

for Oracle R Connector, 1.7.1.4

hadoop.exec function, 5.6

config argument, 5.6

example, 5.7.1, 5.7.1, 5.7.2, 5.7.2, 5.7.2, 5.7.2, 5.7.2

syntax description, 5.7.2

hadoop.run function, 5.6

config argument, 5.6

example, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.2, 5.7.2

syntax description, 5.7.2

HDFS client

See Hadoop client

HDFS commands

issuing from R, 5.5.3

HDFS data

copying in R, 5.5.2

HDFS directories

acquiring root using R, 5.7.2

changing in R, 5.7.2

changing root using R, 5.7.2

creating a dfs.id object, 5.7.2

creating in R, 5.7.2

deleting using R, 5.7.2, 5.7.2

identifying current in R, 5.7.2

listing in R, 5.7.2

publishing to external table, 2.3.1.3

HDFS file identifiers

obtaining in R, 5.7.2

validating in R, 5.7.2

HDFS file names

converting to dfs.id object in R, 5.7.2

HDFS files

access from Oracle Database, 2.1

accessing from R, 5.7.2

copying data from Oracle Database, 5.7.2

copying data from the database using R, 5.7.2

copying data to Oracle Database, 5.7.2

copying data to R, 5.7.2

copying from database objects using R, 5.7.2

copying into Hive, 4.5.1

copying into Oracle Database using R, 5.7.2

copying using R, 5.7.2

creating external tables for accessing, 2.2

deleting using R, 5.7.2

downloading to local system, 5.7.2

loading data into an Oracle database, 3.2.1

moving from R, 5.7.2

number of parts, 5.7.2

obtaining size from R, 5.7.2

sampling from R, 5.7.2

streaming data into an Oracle database, 2.3

testing existence in HDFS from R, 5.7.2

uploading local, 5.7.2

HDFS metadata

obtaining using R, 5.7.2

HDFS path

changing in R, 5.7.2

HDFS root directory

changing from R, 5.7.2

obtaining using R, 5.7.2

HDFS_BIN_PATH directory, 1.4.4

hdfs_stream Bash shell script, 1.4.3

hdfs.attach function

example, 5.7.2, 5.7.2, 5.7.2

syntax description, 5.7.2

hdfs.cd function

syntax description, 5.7.2

hdfs.cp function

syntax description, 5.7.2

hdfs.describe function

syntax example, 5.7.2

hdfs.download function

example, 5.7.1, 5.7.1, 5.7.1

syntax description, 5.7.2

hdfs.exists function

example, 5.7.1, 5.7.1

syntax description, 5.7.2

hdfs.get function

example, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.2

syntax description, 5.7.2

hdfs.id function

example, 5.7.1, 5.7.1

syntax description, 5.7.2

hdfs.ls function

syntax description, 5.7.2

hdfs.mkdir function

example, 5.7.1, 5.7.1

syntax description, 5.7.2

hdfs.mv function

syntax description, 5.7.2

hdfs.parts function

syntax description, 5.7.2

hdfs.pull function

syntax description, 5.7.2

hdfs.push function

syntax description, 5.7.2

hdfs.put function

example, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.2, 5.7.2, 5.7.2

syntax description, 5.7.2

hdfs.pwd function

syntax description, 5.7.2

hdfs.rm function

syntax example, 5.7.2

hdfs.rmdir function

example, 5.7.1, 5.7.1

syntax description, 5.7.2

hdfs.root function

syntax description, 5.7.2

hdfs.sample function

example, 5.7.2

syntax description, 5.7.2

hdfs.setroot function

syntax description, 5.7.2

hdfs.size function

syntax description, 5.7.2

hdfs.upload function

example, 5.7.1, 5.7.1, 5.7.1

syntax description, 5.7.2

hints for optimizing queries, 2.4

Hive application adapters, 4.1.2, 4.5.2.2

Hive Control Append KM, 4.1.2, 4.5.2.1

Hive data source for Oracle Data Integrator, 4.2.2

Hive database for Oracle Loader for Hadoop, 1.5.1

Hive distribution, 1.5.1

Hive flex fields, 4.4.2

Hive Query Language (HiveQL), 4.1.1

Hive tables

copying data to Oracle Database, 3.2.1.1

loading data into (Oracle Data Integrator), 4.5.1

reverse engineering, 4.1.2, 4.4.2

reverse engineering in Oracle Data Integrator, 4.4.2

Hive Transform KM, 4.1.2, 4.5.2.3

HIVE_HOME, for Oracle Data Integrator, 4.2.3

HiveToAvroInputFormat class, 1.5.1, 3.2.1.1

---

I

IKM File to Hive, 4.1.2, 4.5.1, 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

InputFormat class

Oracle Loader for Hadoop, 3.2.1.2, 3.2.1.2

INSERT_UPDATE mode, 4.2.2

installation

Apache Hadoop, 1.4.2

CDH, 1.4.2

Hadoop client, 1.4.2

Oracle Data Integrator Application Adapter for Hadoop, 1.6

Oracle Direct Connector for HDFS, 1.4

Oracle Loader for Hadoop, 1.5

Oracle R Connector for Hadoop, 1.7

Sqoop utility, 1.7.1.2

Instant Client libraries, 1.5.2

interface configurations

Oracle Data Integrator, 4.5

is.hdfs.id function

example, 5.7.2, 5.7.2, 5.7.2

syntax description, 5.7.2

---

J

JAVA_HOME environment variable

for R connector, 1.7.1.4

JAVA_LIBRARY_PATH environment variable

for Oracle Data Integrator, 4.2.3

for Oracle Loader for Hadoop, 3.3.2

JDBC drivers, 1.7.1.2, 3.3.1, 4.2.2

See drivers

job names

specifying in Oracle Loader for Hadoop, 3.6

specifying in R, 5.6, 5.7.2, 5.7.2, 5.7.2

---

K

keyval function

See orch.keyval

key-value pairs

generating from R objects, 5.7.2, 5.7.2

kmeans.R demo, 5.7.2

kmeans.R example, 5.7.1

knowledge modules

description, 4.1.2

See also CKM, IKM, and RKM entries

---

L

LD_LIBRARY_PATH environment variable

for Oracle Data Integrator, 4.2.3

for Oracle Loader for Hadoop, 3.3.2

licenses, third-party, 3.11

lmqr.R example, 5.7.1

lm.R example, 5.7.1

load balancing

in Oracle Loader for Hadoop, 3.4, 3.4.2.1

loadCI, 3.4.2.1

loader map XML schema definition, 3.9

loaderMap document, 3.2.2

loading data files into Hive, 4.5.1

loading options for Oracle Data Integrator, 4.5.1

local files

copying into Hive, 4.5.1

downloading from HDFS, 5.7.2

LOG_FILE_NAME option, 4.4.2

logreg.R example, 5.7.1

---

M

map.df.R example, 5.7.1

map.list.R example, 5.7.1

mappers

configuration settings, 5.6

examples, 5.7.1

generating key-value pairs for in R, 5.7.2, 5.7.2

running from R, 5.7.2, 5.7.2

MAPRED_OUTPUT_BASE_DIR option, 4.5.3

mapred.config class

syntax description, 5.6

using, 5.7.2, 5.7.2, 5.7.2

MapReduce functions, 5.5.4

writing in R

Oracle R Connector for Hadoop, 5.5.4

MapReduce jobs

configuring in R, 5.6

exporting R objects to, 5.7.2

running from R, 5.7.2, 5.7.2

MapReduce programming examples in R, 5.7

MapReduce programs

data compression in R, 5.7.2

data decompression in R, 5.7.2

maxLoadFactor property, 3.4.2.1

mkdir command

running in R, 5.7.2

model.plot.R example, 5.7.1

model.prep.R example, 5.7.1

mv command

running from R, 5.7.2

---

O

OCI Direct Path

See Oracle OCI Direct Path output formats

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

ojdbc6.jar file, 2.3.1.1

OLH_HOME environment variable, 1.5.2, 4.2.3

OLH_OUTPUT_MODE option, 4.5.3

operating system user permissions, 1.4.3

Oracle Data Integrator agent

configuring, 4.2.3

drivers, 4.2.3

Oracle Data Integrator Application Adapter

description, 4.1

Oracle Data Integrator Application Adapter for Hadoop

creating models, 4.4.1

data sources, 4.2.1

flex fields, 4.4.2

installing, 1.6

loading options, 4.5.1

loading output using Oracle Direct Connector for HDFS, 2.1

security, 4.1.3

setting up projects, 4.3

topology setup, 4.2

Oracle Data Integrator Companion CD, 1.6.3

Oracle Data Integrator Studio configuration, 4.2.4

Oracle Data Pump

See Data Pump files; Data Pump format

Oracle Database

connecting from R, 5.5.1

copying data from HDFS, 5.7.2

copying data to HDFS, 5.7.2

querying connections from R, 5.7.2

R access, 5.1.2

reconnecting from R, 5.7.2

user privileges, 1.4.4

Oracle Database client installation, 4.2.3

Oracle Database connections

disconnecting from R, 5.7.2

from R, 5.7.2, 5.7.2

reconnecting from R, 5.7.2

See also Oracle Database

Oracle Direct Connector for HDFS

accessing Data Pump files, 2.2

configuration settings, 2.3.3, 2.3.4

creating external tables for, 2.2

Data Pump files, 2.3.2

database directories, 2.2

database privileges, 1.4.4

decompressing files, 2.3.4.1

description, 2.1

ExternalTable command, 2.3.1

installation, 1.4

loading options, 2.1

pattern-matching characters, 2.3.4.1

publishing data paths, 2.3

publishing Data Pump files, 2.3.4.1

query optimization, 2.4

URL connections, 2.3.4.1

Oracle Instant Client libraries, 1.5.2

Oracle Loader for Hadoop

description, 3.1

input formats, 3.2.1

installing, 1.5

supported database versions, 1.5.1

using in Oracle Data Integrator, 4.1.2, 4.2.3, 4.5.3

Oracle Net Services, 2.3.4.1

Oracle OCI Direct Path interface, 3.6

Oracle OCI Direct Path output format, 3.1, 3.3.2, 3.3.2, 3.6

Oracle OCI Direct Path output formats, 3.6

Oracle permissions, 1.4.3

Oracle R Connector for Hadoop

access to HDFS files, 5.7.2

access to Oracle Database, 5.1.2

alphabetical list of functions, 5.4

categorical list of functions, 5.5

connecting to Oracle Database, 5.5.1

copying HDFS data, 5.5.2

debugging functions, 5.5.5

description, 5.1

executing scripts, 5.5.6

HDFS commands issued from, 5.5.3

installation, 1.7

obtaining the ORCH version number, 5.7.2

programming examples, 5.7

See also individual function names

Oracle R Enterprise, 5.7.2, 5.7.2

Oracle Software Delivery Cloud, 1.3

Oracle Technology Network

certifications, 1.6.1

downloads, 1.3, 1.7.1.2

Oracle wallet, 2.3.1.1, 2.3.4.1

ORACLE_DATAPUMP driver, 3.1, 3.3.4, 3.3.4

ORACLE_LOADER driver, 2.1, 2.1, 3.1

oracle.hadoop.hdfs.exttab.* property descriptions, 2.3.4.1

oraclepki.jar file, 2.3.1.1, 3.2.3.1

orahdfs-version/bin directory, 1.4.3

orahdfs-version.zip file, 1.4.3

OraLoader, 3.2.4, 3.6, 3.10

oraloader-conf.xml document, 3.10

OraLoaderMetadata utility program, 3.2.3

oraloader-version directory, 1.5.2

oraloader-version.zip file, 1.5.2

ORCH package

installation, 1.7.1.1, 1.7.1.4

programming examples, 5.7

version numbers, 5.7.2

See also Oracle R Connector for Hadoop

orch.connect function

syntax description, 5.7.2

orch.dbcon function

syntax description, 5.7.2

orch.dbg.off function

syntax description, 5.7.2

orch.dbg.on function

example, 5.7.1

syntax description, 5.7.2

orch.dbg.output function

example, 5.7.1

syntax description, 5.7.2

orch.dbinfo function

syntax description, 5.7.2

orch.disconnect function

syntax description, 5.7.2

orch.dryrun function

syntax description, 5.7.2

orch.export function

example, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.2, 5.7.2, 5.7.2

syntax description, 5.7.2

orch.keyval function

example, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.2, 5.7.2, 5.7.2, 5.7.2, 5.7.2

syntax description, 5.7.2

orch.keyvals function

example, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.1

syntax description, 5.7.2

orch.pack function

example, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.2, 5.7.2, 5.7.2, 5.7.2, 5.7.2

syntax description, 5.7.2

orch.reconnect function

syntax description, 5.7.2

orch.tgz package, 1.7.1.4

orch.unpack function

example, 5.7.1, 5.7.1, 5.7.1, 5.7.1, 5.7.2, 5.7.2, 5.7.2, 5.7.2, 5.7.2

syntax description, 5.7.2

orch.version function

syntax description, 5.7.2

orch.which function

See orch.dbcon function

ore.frame objects, 5.7.2, 5.7.2

See data frames

ore.pull function, 5.7.1

OVERRIDE_INPUTFORMAT option, 4.5.3

OVERRIDE_ROW_FORMAT option, 4.5.1

---

P

parallel processing, 1.2.1, 2.2.1, 2.4, 5.6, 5.6, 5.7.1, 5.7.2

partitioning, 3.1, 3.8.2

path, changing in R, 5.7.2

pattern-matching characters in Oracle Direct Connector for HDFS, 2.3.4.1

pca.R demo, 5.7.2

pearson.R demo, 5.7.2

POST_TRANSFORM_DISTRIBUTE option, 4.5.2.3

POST_TRANSFORM_SORT option, 4.5.2.3

PQ_DISTRIBUTE hint, 2.4

PRE_TRANSFORM_DISTRIBUTE option, 4.5.2.3

PRE_TRANSFORM_SORT option, 4.5.2.3

PREPROCESSOR clause in CREATE TABLE command, 2.2

privileges, Oracle Database, 1.4.4

program execution, local dry run in R, 5.7.2

projects

setting up in Oracle Data Integrator, 4.3

pwd command

running from R, 5.7.2

---

Q

query optimization for Oracle Direct Connector for HDFS, 2.4

---

R

R connector

See Oracle R Connector for Hadoop

R distribution, 1.7.1.1, 1.7.2.1

R Distribution, 1.7.1.3, 1.7.2.4

R functions

alphabetical listing, 5.4

categorical listing, 5.5

See also Oracle R Connector for Hadoop

R packages

bitops, 1.7.1.1, 5.7.2, 5.7.2, 5.7.2

R programs

examples, 5.7

local execution, 5.7.2

R_HOME environment variable

for Oracle R Connector, 1.7.1.4

RECYCLE_ERRORS option, 4.5.2.1

reducers

configuration settings, 5.6

examples, 5.7.1

generating key-value pairs for in R, 5.7.2, 5.7.2

running from R, 5.7.2, 5.7.2

reverse engineering in Hive, 4.1.2, 4.4.2

reverse-engineering Hive tables, 4.4.2

reverse.log file, 4.4.2

RKM Hive, 4.1.2, 4.4.2

rlm.R example, 5.7.1

rm command

issuing from R, 5.7.2

rmdir command

issuing from R, 5.7.2

root directory

changing from R, 5.7.2

obtaining using R, 5.7.2

---

S

sampling data

from Oracle Loader for Hadoop, 3.4.1

scripts

debugging in R, 5.5.5

executing in R, 5.5.6

snippets, 4.1.1

SerDes JAR files, 4.2.3

snippets in Oracle Data Integrator, 4.1.1

software downloads, 1.3, 1.4.1, 1.6.1, 1.7.1.1, 1.7.1.2, 1.7.1.3, 1.7.2.4, 5.7.2, 5.7.2

split.map.R example, 5.7.1

split.reduce.R example, 5.7.1

SQL*Loader, 3.2.5.1

SQL*Loader utility, 3.1

sqlnet.ora file, 2.3.4.1

Sqoop utility

installing on a Hadoop client, 1.7.2.3

installing on a Hadoop cluster, 1.7.1.2

SQOOP_HOME environment variable

for Oracle R Connector, 1.7.1.4

STATIC_CONTROL option, 4.5.2.1

STOP_ON_FILE_NOT_FOUND option, 4.5.1

streaming data to the database, 2.3

sum.R example, 5.7.1

---

T

tables

copying data from HDFS, 3.1

copying data from HDFS to Oracle Database, 5.7.2

copying data from Oracle Database to HDFS, 5.7.2

loading data into Oracle Database, 3.2.2

See also Hive tables

TEMP_DIR option, 4.5.3

teragen2.xy.R example, 5.7.1

teragen.matrix.R example, 5.7.1

teragen.xy.R example, 5.7.1

terasort.R example, 5.7.1

third-party licenses, 3.11

TNS_ADMIN environment variable, 2.3.4.1

TNSNAMES entries, 2.3.4.1

tnsnames.ora file, 2.3.4.1

TRANSFORM_SCRIPT option, 4.5.2.3

TRANSFORM_SCRIPT_NAME option, 4.5.2.3

transforming data

in Oracle Data Integrator, 4.1, 4.5.2.1

TRUNCATE option, 4.5.1, 4.5.2.1, 4.5.3

---

U

uncompressed files, 2.3.4.1

Universal Resource Identifiers, 2.3

URL connections, for Oracle Direct Connector for HDFS, 2.3.4.1

USE_HIVE_STAGING_TABLE option, 4.5.3

USE_LOG option, 4.4.2

USE_ORACLE_STAGING_TABLE option, 4.5.3

USE_STAGING_TABLE option, 4.5.1

userlib directory, 4.2.4

UTL_FILE package, 1.4.4

---

V

validating data

in Oracle Data Integrator, 4.1, 4.1.2, 4.5.2.1

---

W

wildcard characters

in resource names, 4.5.1

setting up data sources in ODI using, 4.2.1

support in IKM File To Hive (Load Data), 4.1.2

using to restrict input in Oracle Loader for Hadoop, 3.2.1.1

---

X

XML schema definition for Oracle Loader for Hadoop, 3.9

xml-reference directory, 1.6.3, 4.2.2