Index

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

A

access privileges, Oracle Database, 1.4.5
adapters
Avro, 6
Oracle NoSQL Database, 6
additional_path.txt file for ODI, 4.2.2
aggregate functions for Hive, 8.3.1
ALTER SESSION commands, 2.11
annotations
Avro collection, 6
equal to Oracle Loader for Hadoop configuration properties, 6
Oracle Database adapter, 6
Oracle NoSQL Database adapter, 6
Apache Hadoop distribution, 1.2.2, 1.4.1, 1.4.1, 1.5.1, 1.5.1, 1.8.1.1
Apache licenses, 3.15.1, 3.15.2, 3.15.3, 3.15.4
APIs in ORCH, 8.1
APPEND hint, 2.11
as.ore.* functions, 8.3.1
Avro
functions for reading, 6
functions for writing, 6
Avro array,
reading as XML, 6
Avro file adapter, 6
reading Avro as XML, 6
writing XML as Avro, 6
Avro files
converting text to, 6
functions for reading, 6
querying records, 6
reading, 6
reading as XML, 6
writing, 6
Avro license, 3.15.2
Avro maps, 6
Avro maps, reading as XML, 6
Avro null values, 6
Avro primitives
reading as XML, 6
Avro records, reading as XML, 6
Avro unions, reading as XML, 6
avro:collection-avroxml function, 6
avro:get function, 6
avroxml method, 6, 6

B

bagged.clust.R demo, 8.7.1
balancing loads in Oracle Loader for Hadoop, 3.12
bashrc configuration file, 1.8.1.1
batchSize property, 6
bitops R package, 9.2.7, 9.2.7
bzip2 input files, 2.10.2

C

cd command
executing in HDFS from R, 9.2.7
CDH3 distribution, 1.5.1
character encoding, 6, 6
character methods for Hive, 8.3.2
CKM Hive, 4.1.2, 4.5.2.2
client libraries, 1.5.2
clients
configuring Hadoop, 1.4.2, 1.8.3.2
collection annotations
Avro, 6
collection function
Oracle NoSQL Database adapter, 6
combiners
generating key-value pairs for in R, 9.2.7, 9.2.7
running from R, 9.2.7, 9.2.7
compressed data files, 2.10.2
compressed files, 2.10.2
compression in R, 9.2.7
compression methods, 6
configuration properties
for Oracle XQuery for Hadoop, 6
Oracle NoSQL Database adapter, 6
configuration settings
Hadoop client, 1.4.2, 1.8.3.2
Oracle Data Integrator agent, 4.2.3
Oracle Data Integrator interfaces, 4.5
Oracle Data Integrator Studio, 4.2.4
R MapReduce jobs, 8.6
Sqoop utility, 1.8.1.2
configuring a Hadoop client, 1.4.2, 1.8.3.2
connecting to Oracle Database from R, 9.2.1
connection objects
reconnecting to Oracle Database with, 9.2.7
consistency property, 6
conversion functions in ORCH, 8.3.1
copying data
from an Oracle database to HDFS using R, 9.2.7, 9.2.7
from HDFS to an Oracle database using R, 9.2.7
from HDFS to an R data frame, 9.2.7
from local files to HDFS using R, 9.2.7
copying files
from HDFS to Linux using R, 9.2.7
cp command
executing in HDFS from R, 9.2.7
CREATE SESSION privilege, 1.4.5
CREATE TABLE privilege, 1.4.5
CREATE_TARG_TABLE option, 4.5.1, 4.5.2.1, 4.5.2.3, 4.5.3
CSV files, 2.10.2, 3.14, 9.2.7

D

data compression in R, 9.2.7
data decompression in R, 9.2.7
data files
accessing from R, 9.2.7
copying database objects into using R, 9.2.7
copying into Oracle Database using R, 9.2.7
deleting from HDFS using R, 9.2.7
obtaining size from R, 9.2.7
sampling from R, 9.2.7
uploading local, 9.2.7
See also files; HDFS files
data frames
copying HDFS data into, 9.2.7
example of mapper output format, 9.2.7
example program using, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2
from Oracle R Enterprise, 9.2.7
input to mappers, 9.2.7
data integrity checking, 4.5.2.2
Data Pump files, 2.5.2
XML template, 2.5.2.3, 2.5.2.3
data sources
defining for Oracle Data Integrator, 4.2.1
data transformations, 4.5.2.3
data type mappings
between XQuery and Avro, 6
between XQuery and Oracle Database, 6
data types
Oracle Loader for Hadoop, 3.4.1
data validation in Oracle Data Integrator, 4.1.2, 4.5.2.3
database
copying data from using R, 9.2.7
database connections
disconnecting using R, 9.2.7
from R, 9.2.7, 9.2.7, 9.2.7
querying from R, 9.2.7
reconnecting from R, 9.2.7
database directories
for Oracle SQL Connector for HDFS, 1.4.3
database objects
copying to HDFS using R, 9.2.7
database patches, 1.4.1, 1.5.1, 1.5.1, 2.5.2
database privileges, 1.4.5
database system, configuring to run MapReduce jobs, 1.4.2
DataServer objects
creating for Oracle Data Integrator, 4.2.1
debugging in R
displaying last error, 9.2.7
identifying version, 9.2.7
redirecting output, 9.2.7
turning off, 9.2.7
turning on, 9.2.7
decompression in R, 9.2.7
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 files
XML templates, 2.5.4.4
DelimitedTextInputFormat class, 3.7.1, 3.14, 3.14
Oracle Loader for Hadoop, 3.7.1.3
DelimitedTextOutputFormat class, 3.14
demo code for ORCH, 8.7.1
describe command
executing in HDFS using R, 9.2.7
dfs.id object
obtaining in R, 9.2.7
directories
accessible by Oracle Data Integrator, 4.2.1
creating in HDFS using R, 9.2.7
current HDFS, 9.2.7
for Oracle Loader for Hadoop output, 4.5.3
listing in HDFS, 9.2.7
ODI Application Adapter for Hadoop home, 1.6.3
Oracle SQL Connector for HDFS home, 1.4.3
R Advanced Analytics examples, 8.7.2
removing using R, 9.2.7
Sqoop home, 1.8.1.2
See also database directories; root directory
disable_directory_link_check access parameter, 2.5.2
downloading software, 1.3, 1.4.1, 1.6.1, 1.8.1.1, 1.8.1.2, 1.8.1.4, 1.8.3.4
drivers
JDBC, 1.8.1.2, 3.9.1.1, 4.2.2
Oracle Data Integrator agent, 4.2.3
ORACLE_DATAPUMP, 3.9.4.1
ORACLE_LOADER, 2.9, 2.9
DROP_ERROR_TABLE option, 4.5.2.2
dry run execution in R, 9.2.7
durability property, 6

E

encoding characters, 6, 6
error Something is terribly wrong..., 1.8.1.1
example code for ORCH
descriptions, 8.7.2
exists function in R, 9.2.7
exporting R objects to Hadoop, 9.2.7
EXT_TAB_DIR_LOCATION option, 4.5.3
external tables
about, 2.1
EXTERNAL VARIABLE DATA access parameter, 2.5.2
EXTERNAL_TABLE option, 4.5.1
ExternalTable command
syntax, 2.4.2
EXTRA_OLH_CONF_PROPERTIES option, 4.5.3

F

file formats for Oracle Data Integrator, 4.5.1
file identifiers
validating in R, 9.2.7
file sampling in R, 9.2.7, 9.2.7
file size
obtaining using R, 9.2.7
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
downloading from HDFS, 9.2.7
obtaining HDFS metadata using R, 9.2.7
testing existence in HDFS from R, 9.2.7
uploading local to HDFS, 9.2.7
See also data files; HDFS files
filter1.R example, 8.7.2
filter2.R example, 8.7.2
filter3.R example, 8.7.2
flex fields, 4.2.2, 4.4.2
FLOW_CONTROL option, 4.5.2.1
FLOW_TABLE_OPTIONS option, 4.5.3
frame methods for Hive, 8.3.2
functions
for reading from Oracle NoSQL Database, 6
for writing to Oracle NoSQL Database, 6
Oracle NoSQL Database, 6
reading and writing sequence files, 6
reading Avro files, 6
reading from Oracle NoSQL Database, 6
writing Avro files, 6

G

get function
Oracle NoSQL Database adapter, 6
group.apply.R example, 8.7.2
gzip input files, 2.10.2

H

Hadoop client
configuring, 1.4.2, 1.8.3.2
installing, 1.4.2
hadoop fs command, 1.4.2
HADOOP_CLASSPATH
for Oracle Data Integrator, 4.2.3, 4.2.3
HADOOP_HOME
for Oracle Data Integrator, 4.2.3
HADOOP_HOME environment variable, 1.8.1.1
HADOOP_LIBEXEC_DIR environment variable, 1.8.1.1
hadoop.exec function, 8.6
config argument, 8.6
example, 8.7.1, 8.7.1, 8.7.2, 8.7.2, 9.2.7
syntax description, 9.2.7
hadoop.run function, 8.6
config argument, 8.6
example, 8.7.1, 8.7.1, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 9.2.7
syntax description, 9.2.7
HDFS client
See Hadoop client
HDFS commands
issuing from R, 9.2.3
HDFS data
copying in R, 9.2.2
HDFS directories
acquiring root using R, 9.2.7
changing in R, 9.2.7
changing root using R, 9.2.7
creating a dfs.id object, 9.2.7
creating in R, 9.2.7
deleting using R, 9.2.7, 9.2.7
identifying current in R, 9.2.7
listing in R, 9.2.7
HDFS file identifiers
obtaining in R, 9.2.7
validating in R, 9.2.7
HDFS file names
converting to dfs.id object in R, 9.2.7
HDFS files
accessing from R, 9.2.7
copying data from Oracle Database, 9.2.7
copying data from the database using R, 9.2.7
copying data to Oracle Database, 9.2.7
copying data to R, 9.2.7
copying from database objects using R, 9.2.7
copying into Hive, 4.5.1
copying into Oracle Database using R, 9.2.7
copying using R, 9.2.7
deleting using R, 9.2.7
downloading to local system, 9.2.7
loading data into an Oracle database, 3.7.6
moving from R, 9.2.7
number of parts, 9.2.7
obtaining size from R, 9.2.7
restrictions in Oracle R Advanced Analytics for Hadoop, 8.2
sampling from R, 9.2.7
testing existence in HDFS from R, 9.2.7
uploading local, 9.2.7
HDFS metadata
obtaining using R, 9.2.7
HDFS path
changing in R, 9.2.7
HDFS root directory
changing from R, 9.2.7
obtaining using R, 9.2.7
hdfs_datatrans R demo, 8.7.1
hdfs_dir R demo, 8.7.1
hdfs_putget R demo, 8.7.1
hdfs_stream Bash shell script, 1.4.3
hdfs.attach function
example, 8.7.1, 9.2.7, 9.2.7, 9.2.7
syntax description, 9.2.7
hdfs.cd function
example, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1
syntax description, 9.2.7
hdfs.cp function
example, 8.7.1
syntax description, 9.2.7
hdfs.cpmv R demo, 8.7.1
hdfs.describe function
example, 8.7.1, 8.7.1
syntax example, 9.2.7
hdfs.download function
example, 8.7.1, 8.7.1, 8.7.2, 8.7.2, 8.7.2
syntax description, 9.2.7
hdfs.exists function
example, 8.7.1, 8.7.1, 8.7.1, 8.7.2, 8.7.2
syntax description, 9.2.7
hdfs.get function
example, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2
syntax description, 9.2.7
hdfs.head function
syntax description, 9.2.7
hdfs.id function
example, 8.7.1, 8.7.2, 8.7.2
syntax description, 9.2.7
hdfs.ls function
example, 8.7.1, 8.7.1
syntax description, 9.2.7
hdfs.mkdir function
example, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.2, 8.7.2
syntax description, 9.2.7
hdfs.mv function
example, 8.7.1
syntax description, 9.2.7
hdfs.parts function
syntax description, 9.2.7
hdfs.pull function
example, 8.7.1
syntax description, 9.2.7
hdfs.push function
syntax description, 9.2.7
hdfs.put function
example, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2
syntax description, 9.2.7
hdfs.pwd function
example, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1
syntax description, 9.2.7
hdfs.rm function
example, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1
syntax example, 9.2.7
hdfs.rmdir function
example, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.2, 8.7.2
syntax description, 9.2.7
hdfs.root function
example, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1
syntax description, 9.2.7
hdfs.sample function
example, 8.7.1, 8.7.1
syntax description, 9.2.7
hdfs.setroot function
example, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1, 8.7.1
syntax description, 9.2.7
hdfs.size function
example, 8.7.1
syntax description, 9.2.7
hdfs.tail function
syntax description, 9.2.7
hdfs.upload function
example, 8.7.1, 8.7.1, 8.7.2, 8.7.2, 8.7.2
syntax description, 9.2.7
hints for optimizing queries, 2.11
Hive access from R, 8.3
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 data types, support for, 8.3.3
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
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
XML format, 2.5.3.5
Hive Transform KM, 4.1.2, 4.5.2.3
hive_aggregate R demo, 8.7.1
hive_analysis R demo, 8.7.1
hive_basic R demo, 8.7.1
hive_binning R demo, 8.7.1
hive_columnfns R demo, 8.7.1
HIVE_HOME, for Oracle Data Integrator, 4.2.3
hive_nulls R demo, 8.7.1
hive_pushpull R demo, 8.7.1
hive_sequencefile R demo, 8.7.1
HiveToAvroInputFormat class, 3.7.3
hosts property, 6

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.8.1
InputFormat class
Oracle Loader for Hadoop, 3.7.1.3
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 Loader for Hadoop, 1.5
Oracle R Advanced Analytics for Hadoop, 1.8
Oracle SQL Connector for HDFS, 1.4
Sqoop utility, 1.8.1.2
Instant Client libraries, 1.5.2
interface configurations
Oracle Data Integrator, 4.5
is.hdfs.id function
example, 8.7.1
syntax description, 9.2.7
is.ore.* functions, 8.3.1

J

JDBC drivers, 1.8.1.2, 3.9.1.1, 4.2.2
Jellyfish R demo, 8.7.1
job names
specifying in R, 8.6, 9.2.7, 9.2.7, 9.2.7

K

keyval function
See orch.keyval
key-value pairs
generating from R objects, 9.2.7, 9.2.7
kmeans.R demo, 8.7.1
kmeans.R example, 8.7.2
knowledge modules
description, 4.1.2
See also CKM, IKM, and RKM entries
kv
collection-avroxml function, 6, 6, 6
collection-binxml function, 6, 6, 6, 6
collection-text function, 6, 6, 6
collection-xml function, 6, 6, 6
get-avroxml function, 6
get-binxml function, 6
get-text function, 6
get-xml function, 6
key-range function, 6, 6
put-binxml function, 6
put-text function, 6
put-xml function, 6
kvstore property, 6

L

licenses, third-party, 3.15
linear model R demo, 8.7.1
LMF Jellyfish R demo, 8.7.1
LMF mahout ALS-WR demo, 8.7.1
lm.R example, 8.7.2
load balancing
in Oracle Loader for Hadoop, 3.12, 3.12
loadCI, 3.12.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, 9.2.7
LOG_FILE_NAME option, 4.4.2
logical methods for Hive, 8.3.2
logreg.R example, 8.7.2

M

mahout ALS-WR demo, 8.7.1
map.df.R example, 8.7.2
map.list.R example, 8.7.2
mappers
configuration settings, 8.6
examples, 8.7.2
generating key-value pairs for in R, 9.2.7, 9.2.7
running from R, 9.2.7, 9.2.7
mapred_basic R demo, 8.7.1
mapred_modelBuild R demo, 8.7.1
MAPRED_OUTPUT_BASE_DIR option, 4.5.3
mapred.config class
syntax description, 8.6
using, 9.2.7, 9.2.7, 9.2.7
MapReduce functions
writing in R, 9.2.4
MapReduce jobs
configuring in R, 8.6
exporting R objects to, 9.2.7
running from R, 9.2.7, 9.2.7
MapReduce programs
data compression in R, 9.2.7
data decompression in R, 9.2.7
MasterPolicy durability, 6
matrix methods for Hive, 8.3.2
maxLoadFactor property, 3.12.2
mkdir command
running in R, 9.2.7
model.plot.R example, 8.7.2
model.prep.R example, 8.7.2
mv command
running from R, 9.2.7

N

neural network R demo, 8.7.1
nilled function, 6
NMF R demo, 8.7.1
null values in Avro, 6
numeric methods for Hive, 8.3.2

O

OCI Direct Path
See Oracle OCI Direct Path output formats
ODI_ADDITIONAL_CLASSPATH environment variable, 4.2.3
ODI_HIVE_SESSION_JARS, for Oracle Data Integrator, 4.2.3, 4.2.3
ODI_OLH_JARS, for Oracle Data Integrator, 4.2.3
OLH_HOME environment variable, 1.5.2, 1.5.3, 1.7.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
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 Database
connecting from R, 9.2.1
copying data from HDFS, 9.2.7
copying data to HDFS, 9.2.7
querying connections from R, 9.2.7
reconnecting from R, 9.2.7
user privileges, 1.4.5
Oracle Database access from ORCH, 8.4
Oracle Database adapter, 6
configuration properties, 6
Oracle Database connections
disconnecting from R, 9.2.7
from R, 9.2.7, 9.2.7, 9.2.7
reconnecting from R, 9.2.7
See also Oracle Database
Oracle Direct Connector for HDFS
pattern-matching characters, 2.10.2
Oracle Instant Client libraries, 1.5.2
Oracle Loader for Hadoop
description, 3.1
input formats, 3.7.6
installing, 1.5
supported database versions, 1.5.1
using in Oracle Data Integrator, 4.1.2, 4.2.3, 4.5.3
Oracle Loader for Hadoop configuration properties
used by Oracle XQuery for Hadoop, 6
Oracle NoSQL Database
writing to, 6
Oracle NoSQL Database adapter, 6
collection function, 6
functions for reading, 6
reading Avro as XML, 6
writing XML as Avro, 6
Oracle NoSQL Database Adapter
configuration properties, 6
Oracle NoSQL Database functions, 6
Oracle OCI Direct Path interface, 3.14
Oracle OCI Direct Path output formats, 3.14
Oracle permissions, 1.4.3
Oracle R Advanced Analytics for Hadoop
description, 8.1
installation, 1.8
obtaining the ORCH version number, 9.2.7
Oracle R Connector for Hadoop
access to HDFS files, 9.2.7
alphabetical list of functions, 9.1
categorical list of functions, 9.2
connecting to Oracle Database, 9.2.1
copying HDFS data, 9.2.2
debugging functions, 9.2.5
HDFS commands issued from, 9.2.3
MapReduce functions, 9.2.4
Oracle Software Delivery Cloud, 1.3
Oracle SQL Connector for HDFS
description, 2.1
installation, 1.4
query optimization, 2.11
Oracle Technology Network
certifications, 1.6.1
downloads, 1.3, 1.8.1.2
Oracle XQuery for Hadoop, 5
ORACLE_DATAPUMP driver, 3.9.4.1
ORACLE_LOADER driver, 2.9, 2.9
oracle.hadoop.xquery.kv.config.durability property, 6
oracle.hadoop.xquery.kv.config.requestLimit property, 6
oracle.hadoop.xquery.kv.config.requestTimeout property, 6
oracle.hadoop.xquery.kv.config.socketOpenTimeout property, 6
oracle.hadoop.xquery.kv.config.socketReadTimeout property, 6
oracle.kv.batchSize property, 6
oracle.kv.consistency property, 6
oracle.kv.hosts configuration property, 6
oracle.kv.hosts property, 6
oracle.kv.kvstore configuration property, 6
oracle.kv.kvstore property, 6
oracle.kv.timeout property, 6
orahdfs-version/bin directory, 1.4.3
orahdfs-version.zip file, 1.4.3, 1.4.4
OraLoader, 3.10, 3.14, 5.5
OraLoaderMetadata utility program, 3.6.2
oraloader-version directory, 1.5.2, 1.7.2
oraloader-version.zip file, 1.4.3, 1.5.2, 1.5.3, 1.7.2
ORCH package
installation, 1.8.1.1, 1.8.1.5
version numbers, 9.2.7
See also Oracle R Advanced Analytics for Hadoop
orch_lm R demo, 8.7.1
orch_lmf_jellyfish R demo, 8.7.1
orch_lmf_mahout_als R demo, 8.7.1
orch_neural R demo, 8.7.1
orch.connect function
syntax description, 9.2.7
orch.connected function
example, 8.7.1
syntax description, 9.2.7
orch.dbcon function
syntax description, 9.2.7
orch.dbg.lasterr function
syntax description, 9.2.7
orch.dbg.off function
syntax description, 9.2.7
orch.dbg.on function
syntax description, 9.2.7
orch.dbg.output function
syntax description, 9.2.7
orch.dbinfo function
syntax description, 9.2.7
orch.disconnect function
syntax description, 9.2.7
orch.dryrun function
syntax description, 9.2.7
orch.evaluate function, 8.5
example, 8.7.1, 8.7.1
orch.export function
example, 8.7.1, 8.7.1, 8.7.1, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2
syntax description, 9.2.7
orch.export.fit function, 8.5
example, 8.7.1
orch.keyval function
example, 8.7.1, 8.7.1, 8.7.1, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2
syntax description, 9.2.7
orch.keyvals function
example, 8.7.2, 8.7.2, 8.7.2, 8.7.2, 8.7.2
syntax description, 9.2.7
orch.lm function, 8.5
example, 8.7.1
orch.lmf function, 8.5
example, 8.7.1, 8.7.1
orch.neural function, 8.5
example, 8.7.1
orch.nmf demo, 8.7.1
orch.nmf function, 8.5
orch.nmf.NMFalgo function, 8.5
example, 8.7.1
orch.pack function
example, 8.7.1, 8.7.1, 8.7.1, 8.7.2, 8.7.2, 8.7.2
syntax description, 9.2.7
orch.recommend function, 8.5
example, 8.7.1
orch.reconnect function
syntax description, 9.2.7
orch.temp.path function, 9.2.7
orch.tgz package, 1.8.1.5
orch.unpack function
example, 8.7.1, 8.7.1, 8.7.1, 8.7.2, 8.7.2, 8.7.2
syntax description, 9.2.7
orch.version function
syntax description, 9.2.7
orch.which function
See orch.dbcon function
ore functions for Hive, 8.3.1
ORE functions for Hive, 8.3.1
ore.attach function
example, 8.7.1, 8.7.1, 8.7.1
ore.connect function
example, 8.7.1, 8.7.1, 8.7.1
ore.create function, 8.3.4
example, 8.7.1
ore.drop function
example, 8.7.1, 8.7.1
ore.exec function, 8.3.4
example, 8.7.1
ore.frame objects, 9.2.7, 9.2.7
See data frames
ore.is.connected function
example, 8.7.1
ore.pull function
example, 8.7.1
ore.push function
example, 8.7.1
ore.sync function
example, 8.7.1
ore.warn.order option, 8.3.4
OSCH_BIN_PATH directory, 1.4.5
OVERRIDE_INPUTFORMAT option, 4.5.3
OVERRIDE_ROW_FORMAT option, 4.5.1

P

parallel processing, 1.2.1, 2.11, 8.6, 8.6, 8.7.2, 9.2.7
partitioning, 3.4.2
path, changing in R, 9.2.7
pattern-matching characters in Oracle Direct Connector for HDFS, 2.10.2
POST_TRANSFORM_DISTRIBUTE option, 4.5.2.3
POST_TRANSFORM_SORT option, 4.5.2.3
PQ_DISTRIBUTE hint, 2.11
PRE_TRANSFORM_DISTRIBUTE option, 4.5.2.3
PRE_TRANSFORM_SORT option, 4.5.2.3
predict.orch.lm function, 8.5
example, 8.7.1
preprocessor access parameter, 2.5.2
print.orch.lm function, 8.5
print.summary.orch.lm function, 8.5
privileges, Oracle Database, 1.4.5
program execution, local dry run in R, 9.2.7
projects
setting up in Oracle Data Integrator, 4.3
put function
Oracle NoSQL Database adapter, 6
pwd command
running from R, 9.2.7

Q

query optimization for Oracle SQL Connector for HDFS, 2.11

R

R connector
See Oracle R Connector for Hadoop
R distribution, 1.8.1.1, 1.8.3.1
R Distribution, 1.8.1.4, 1.8.3.4
R functions
alphabetical listing, 9.1
categorical listing, 9.2
See also Oracle R Connector for Hadoop
R functions for Hive, 8.3.2
R packages
bitops, 9.2.7
R programs
local execution, 9.2.7
random order messages, 8.3.4
reading Avro files, 6
RECYCLE_ERRORS option, 4.5.2.1
reducers
configuration settings, 8.6
examples, 8.7.2
generating key-value pairs for in R, 9.2.7, 9.2.7
running from R, 9.2.7, 9.2.7
ReplicaAck policy, 6
ReplicaPolicy durability, 6
requestLimit property, 6
requestTimeout property, 6
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, 8.7.2
rm command
issuing from R, 9.2.7
rmdir command
issuing from R, 9.2.7
root directory
changing from R, 9.2.7
obtaining using R, 9.2.7

S

sampling data
from Oracle Loader for Hadoop, 3.12.1
sampling HDFS files, 9.2.7, 9.2.7
scripts
debugging in R, 9.2.5
snippets, 4.1.1
seq
collection function, 6
collection-binxml function, 6
collection-xml function, 6
put function, 6
put functions, 6
put-binxml function, 6, 6
put-xml function, 6, 6
sequence file adapter, 6
sequence file adapter functions, 6
SerDes JAR files, 4.2.3, 4.2.3
snippets in Oracle Data Integrator, 4.1.1
socketOpenTimeout property, 6
socketReadTimeout property, 6
software downloads, 1.3, 1.4.1, 1.6.1, 1.8.1.1, 1.8.1.2, 1.8.1.4, 1.8.3.4
Something is terribly wrong with Hadoop MapReduce message, 1.8.1.1
split sizes, 6
split.map.R example, 8.7.2
split.reduce.R example, 8.7.2
SQL*Loader, 3.9.3.1
Sqoop, 8.4.1
Sqoop utility
installing on a Hadoop client, 1.8.3.3
installing on a Hadoop cluster, 1.8.1.2
STATIC_CONTROL option, 4.5.2.1
STOP_ON_FILE_NOT_FOUND option, 4.5.1
subrange specification, Oracle NoSQL Database adapter, 6
summary.orch.lm function, 8.5
sum.R example, 8.7.2

T

tables
copying data from HDFS, 3.1
copying data from HDFS to Oracle Database, 9.2.7
copying data from Oracle Database to HDFS, 9.2.7
TEMP_DIR option, 4.5.3
temporary HDFS path for R, 9.2.7
teragen2.xy.R example, 8.7.2
teragen.matrix.R example, 8.7.2
teragen.xy.R example, 8.7.2
terasort.R example, 8.7.2
testing functions in R, 8.3.1
text files
converting to Avro, 6
third-party licenses, 3.15
timeout property, 6
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
type mappings
between XQuery and Avro, 6
between XQuery and Oracle Database, 6

U

uncompressed files, 2.10.2
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
UTF-8 encoding, 6, 6
UTL_FILE package, 1.4.5

V

validating data
in Oracle Data Integrator, 4.1, 4.1.2, 4.5.2.1
vector methods for Hive, 8.3.2

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
writing Avro files, 6

X

XML
writing as Avro arrays, 6
writing as Avro maps, 6
writing as Avro primitives, 6
writing as Avro records, 6
writing as Avro unions, 6
XML template for Data Pump files, 2.5.2.3
XML templates
Data Pump files, 2.5.2.3
delimited text files, 2.5.4.4
Hive tables, 2.5.3.5
xml-reference directory, 1.6.3, 4.2.2
XQuery
See Oracle XQuery for Hadoop