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 

Symbols

%*
put annotation, 5.4.1
%annotation
See annotations alphabetically by name
%oracle-property annotations, 6
%ora-java
binding annotation, 5.4.4, 5.4.4
%output annotation, 6
%updating annotation, 5.4.1

A

access privileges, Oracle Database, 1.4.4
adapters
Avro, 6
Oracle NoSQL Database, 6
sequence file, 6
text file, 6
XML file, 6
additional_path.txt file for ODI, 4.2.2
aggregate function, 8.5.4
aggregate functions for Hive, 8.5.4
ALLOW_BACKSLASH_ESCAPING_ANY_CHARACTER property, 6
ALLOW_COMMENTS property, 6
ALLOW_NON_NUMERIC_NUMBERS property, 6
ALLOW_NUMERIC_LEADING_ZEROS property, 6
ALLOW_SINGLE_QUOTES property, 6
ALLOW_UNQUOTED_CONTROL_CHARS property, 6
ALLOW_UNQUOTED_FIELD_NAMES property, 6
ALTER SESSION commands, 2.11
analytic functions in R, 8.5.1
analyze-string function, 5.4.2
annotations
Avro collection, 6
equal to Oracle Loader for Hadoop configuration properties, 6
for writing to Oracle NoSQL Database, 6
Oracle Database adapter, 6
Oracle NoSQL Database adapter, 6
reading from Oracle NoSQL Database, 6
reading sequence files, 6
reading text files, 6
reading XML files, 6
writing text files, 6
See also specific annotations by name
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.5.7
avro
compress annotation, 6
file annotation, 6
put annotation, 6
schema annotation, 6
schema-file annotation, 6
schema-kv annotation, 6, 6, 6, 6
Avro
annotations for reading, 6
annotations for writing, 6
Avro array,
reading as XML, 6
Avro file adapter, 6
examples, 6
reading Avro as XML, 6
writing XML as Avro, 6
Avro files
collection annotations, 6
collection function, 6
converting text to, 6
functions for reading, 6
output file name, 6
put functions, 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 reader schema, 6, 6, 6, 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

balancing loads in Oracle Loader for Hadoop, 3.12
bashrc configuration file, 1.8.1.1
batchSize property, 6, 6
bzip2 input files, 2.10.2

C

CDH3 distribution, 1.5.1
character encoding, 6, 6
character methods for Hive, 8.3.3
CKM Hive, 4.1.2, 4.5.2.2
client libraries, 1.5.2
clients
configuring Hadoop, 1.4.2, 1.8.3.2
coersing data types in R, 8.5.7
collection annotation
text files, 6
collection annotations
Avro, 6
collection function (XQuery)
description, 5.3
collection functions
Oracle NoSQL Database adapter, 6
sequence files, 6
text files, 6
columnCount property (OSCH), 2.10.2
columnLength property (OSCH), 2.10.2, 2.10.2
columnNames property (OSCH), 2.10.2
columnType property (OSCH), 2.10.2, 2.10.2, 2.10.2
compressed data files, 2.10.2
compressed files, 2.10.2
compression
sequence files, 6
compression codec, 6
compression methods
Avro output files, 6
CompressionCodec property (OSCH), 2.10.2
configuration properties
for Oracle XQuery for Hadoop, 6
JSON file adapter, 6
Oracle NoSQL Database adapter, 6
Oracle XQuery for Hadoop, 5.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
Sqoop utility, 1.8.1.2
configuring a Hadoop client, 1.4.2, 1.8.3.2
connecting to Oracle Database from R, 8.5.5
consistency property, 6, 6
CREATE SESSION privilege, 1.4.4
CREATE TABLE
configuration properties, 7.4.2
examples, 7.4.3
syntax, 7.4.1
CREATE TABLE privilege, 1.4.4
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

D

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
Oracle Database and XQuery, 6
data type mappings, Hive (OSCH), 2.10.2
data type testing in R, 8.5.7
data types
Oracle Loader for Hadoop, 3.4.1
data validation in Oracle Data Integrator, 4.1.2, 4.5.2.3
database directories
for Oracle SQL Connector for HDFS, 1.4.3
database patches, 1.4.1, 1.5.1, 1.5.1, 2.5.2
database privileges, 1.4.4
database system, configuring to run MapReduce jobs, 1.4.2
database tables
writing using Oracle XQuery for Hadoop, 6
databaseName property, Hive (OSCH), 2.10.2
dataCompressionCodec property (OSCH), 2.10.2
dataPathFilter property (OSCH), 2.10.2
dataPaths property (OSCH), 2.10.2
DataServer objects
creating for Oracle Data Integrator, 4.2.1
dateMask property (OSCH), 2.10.2, 2.10.2
defaultDirectory property (OSCH), 2.10.2
DEFER_TARGET_LOAD option, 4.5.1
deflate compression, 6
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
delimiter
for splitting text files, 6
Direct Connector for HDFS
See SQL Connector for HDFS
directories
accessible by Oracle Data Integrator, 4.2.1
for Oracle Loader for Hadoop output, 4.5.3
ODI Application Adapter for Hadoop home, 1.6.3
Oracle SQL Connector for HDFS home, 1.4.3
Sqoop home, 1.8.1.2
See also database directories; root directory
Directory property (OSCH), 2.10.2
disable_directory_link_check access parameter, 2.5.2
distributed cache
accessing from Oracle XQuery for Hadoop, 5.4.3
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
durability property, 6

E

encoding characters, 6, 6
error logging for Oracle XQuery for Hadoop, 5.6
error Something is terribly wrong..., 1.8.1.1
exponential functions (XQuery), 5.4.2
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

fieldLength property (OSCH), 2.10.2, 2.10.2
fieldTerminator property (OSCH), 2.10.2
file formats for Oracle Data Integrator, 4.5.1
file paths
locating in XQuery, 6
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
fivenum function, 8.5.4
flex fields, 4.2.2, 4.4.2
FLOW_CONTROL option, 4.5.2.1
FLOW_TABLE_OPTIONS option, 4.5.3
FLWOR requirements, 5.4.1
fn
nilled function, 6, 6
fn functions, 5.4.2
frame methods for Hive, 8.3.3
functions
for writing to Oracle NoSQL Database, 6
Oracle NoSQL Database, 6
reading and writing sequence files, 6
reading and writing text files, 6
reading Avro files, 6
reading from Oracle NoSQL Database, 6, 6
reading JSON files, 6
reading sequence files, 6
reading text files, 6
reading XML files, 6, 6
writing Avro files, 6
writing sequence files, 6
writing text files, 6

G

get function
Oracle NoSQL Database adapter, 6
gzip input files, 2.10.2

H

Hadoop client
configuring, 1.4.2, 1.8.3.2
installing, 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.5.8
hadoop.jobs function, 8.5.8
hadoop.run function, 8.5.8
HDFS client
See Hadoop client
HDFS commands
issuing from R, 8.5.2
HDFS data
copying in R, 8.5.6
hdfs dfs command, 1.4.2
HDFS directories
creating in R, 8.5.2
HDFS files
copying into Hive, 4.5.1
loading data into an Oracle database, 3.7.6
restrictions in Oracle R Advanced Analytics for Hadoop, 8.2
hdfs_stream Bash shell script, 1.4.3
hdfs.attach function, 8.5.6
hdfs.cd function, 8.5.2
hdfs.cp function, 8.5.2
hdfs.describe function, 8.5.2
hdfs.download function, 8.5.6
hdfs.exists function, 8.5.2
hdfs.fromHive function, 8.5.3
hdfs.get function, 8.5.6
hdfs.head function, 8.5.2
hdfs.id function, 8.5.2
hdfs.ls function, 8.5.2
hdfs.mkdir function, 8.5.2
hdfs.mv function, 8.5.2
hdfs.parts function, 8.5.2
hdfs.pull function, 8.5.6
hdfs.push function, 8.5.6
hdfs.put function, 8.5.6
hdfs.pwd function, 8.5.2
hdfs.rm function, 8.5.2
hdfs.rmdir function, 8.5.2
hdfs.root function, 8.5.2
hdfs.sample function, 8.5.6
hdfs.setroot function, 8.5.2
hdfs.size function, 8.5.2
hdfs.tail function, 8.5.2
hdfs.toHive function, 8.5.3
hdfs.upload function, 8.5.6
hints for optimizing queries, 2.11
Hive access from R, 8.3
Hive access in R, 8.5.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 type mappings (OSCH), 2.10.2
Hive data types, support for, 8.3.4
Hive database for Oracle Loader for Hadoop, 1.5.1
Hive distribution, 1.5.1
Hive flex fields, 4.4.2
Hive JAR files for Oracle Loader for Hadoop, 3.10.1
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_HOME, for Oracle Data Integrator, 4.2.3
hive.columnType property (OSCH), 2.10.2
hive.databaseName property (OSCH), 2.10.2
HiveToAvroInputFormat class, 3.7.3, 3.10.1
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
installation instructions, 1
Instant Client libraries, 1.5.2
interface configurations
Oracle Data Integrator, 4.5
interquartile range, 8.5.4
IQR function, 8.5.4
is.hdfs.id function, 8.5.6
is.ore.* functions, 8.5.7

J

JDBC drivers, 1.8.1.2, 3.9.1.1, 4.2.2
json
get function, 6
parse-as-xml function, 6
JSON data formats
converting to XML, 6
JSON file adapter
configuration properties, 6
JSON files
reading, 6
JSON module, 6
examples, 6

K

keyval function
See orch.keyval
knowledge modules
description, 4.1.2
See also CKM, IKM, and RKM entries
kv
collection annotation, 6
collection-avroxml function, 6
collection-binxml function, 6
collection-text function, 6
collection-xml function, 6
get annotation, 6
get-avroxml function, 6
get-binxml function, 6
get-text function, 6
get-xml function, 6
key annotation, 6, 6
key-range function, 6, 6
put annotation, 6
put-binxml function, 6
put-text function, 6
put-xml function, 6
KVAvroInputFormat class, 3.10.2
kv.hosts property, 6
kv.kvstore property, 6
kvstore property, 6, 6

L

licenses, 5.7
licenses, third-party, 3.15
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
LOG_FILE_NAME option, 4.4.2
log4j.logger.oracle.hadoop.xquery property, 5.6
logical methods for Hive, 8.3.3

M

mapping
JSON to XML, 6
mappings
Oracle Database and XQuery data types, 6
mappings, Hive to Oracle Database (OSCH), 2.10.2
MAPRED_OUTPUT_BASE_DIR option, 4.5.3
MapReduce functions
writing in R, 8.5.8
MasterPolicy durability, 6
matrix methods for Hive, 8.3.3
maxLoadFactor property, 3.12.2
median function, 8.5.4

N

nilled elements, 6
nilled function, 6
null values in Avro, 6
numeric methods for Hive, 8.3.3

O

OCI Direct Path, 3.14
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
columns annotation, 6
put annotation, 6
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
annotations for writing, 6
connecting from R, 8.5.5
put function, 6
user privileges, 1.4.4
Oracle Database access from ORCH, 8.4
Oracle Database adapter, 6
configuration properties, 6
examples, 6
Oracle Database Adapter
using Oracle Loader for Hadoop, 6
Oracle Direct Connector for HDFS
See Oracle SQL Connector for HDFS
Oracle Exadata Database Machine
installing a Hadoop client, 1.4.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 NoSQL Database
annotations for writing, 6
Oracle NoSQL Database adapter, 6
annotations for reading, 6
collection function, 6
get function, 6
reading Avro as XML, 6
writing XML as Avro, 6
Oracle NoSQL Database Adapter
configuration properties, 6
examples, 6
Oracle NoSQL Database functions, 6
Oracle OCI Direct Path, 3.14, 3.14
Oracle permissions, 1.4.3
Oracle R Advanced Analytics for Hadoop
categorical list of functions, 8.5
connecting to Oracle Database, 8.5.5
copying HDFS data, 8.5.6
debugging functions, 8.5.9
description, 8.1
HDFS commands issued from, 8.5.2
installation, 1.8
MapReduce functions, 8.5.8
Oracle RAC systems, installing a Hadoop client, 1.4.2
Oracle Software Delivery Cloud, 1.3
Oracle SQL Connector for HDFS
description, 2.1
installation, 1.4
pattern-matching characters, 2.10.2
query optimization, 2.11
Oracle Technology Network
certifications, 1.6.1
downloads, 1.3, 1.8.1.2
Oracle XQuery for Hadoop, 5
accessing the distributed cache, 5.4.3
accessing user-defined XQuery library modules and XML schemas, 5.4.5
basic transformation examples, 5.4.6
calling custom Java external functions, 5.4.4
configuration properties, 5.6
configuring Oracle NoSQL Database server, 6
description, 5.1
error logging levels, 5.6
error recovery setting, 5.6
hadoop command, 5.5
JSON module, 6
Oracle NoSQL Database adapter, 6
output directory, 5.6
running queries, 5.5
running queries locally, 5.5.3
sequence file adapter, 6
temp directory, 5.6
text file adapter, 6
time zone, 5.6
XML file adapter, 6
Oracle XQuery for Hadoop adapters
overview, 5.3.1
Oracle XQuery for Hadoop modules
overview, 5.3.2
ORACLE_DATAPUMP driver, 3.9.4.1
ORACLE_LOADER driver, 2.9, 2.9
oracle.hadoop.loader.logBadRecords property, 3.11.1
oracle.hadoop.loader.rejectLimit property, 3.11.2
oracle.hadoop.loader.sampler.enableSampling property, 3.12.1
oracle.hadoop.xquery.* properties, 5.6
oracle.hadoop.xquery.json.parser.*
See individual properties by name
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, 6
oracle.kv.kvstore configuration property, 6
oracle.kv.kvstore property, 6, 6
oracle.kv.timeout property, 6
oracle-property annotation, 6
orahdfs-version/bin directory, 1.4.3
orahdfs-version.zip file, 1.4.3
ora-java
binding annotation, 5.4.4, 5.4.4
OraLoader, 3.10, 3.14
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
ORCH package version, 8.5.9
orch.connect function, 8.5.5
orch.connected function, 8.5.5
orch.dbcon function, 8.5.5
orch.dbg.lasterr function, 8.5.9
orch.dbg.on/off function, 8.5.9
orch.dbg.output function, 8.5.9
orch.dbinfo function, 8.5.5
orch.disconnect function, 8.5.5
orch.dryrun function, 8.5.8
orch.evaluate function, 8.5.1
orch.export function, 8.5.8
orch.export.fit function, 8.5.1
orch.getXlevels function, 8.5.1
orch.glm function, 8.5.1
orch.keyval function, 8.5.8
orch.keyvals function, 8.5.8
orch.kmeans function, 8.5.1
orch.lm function, 8.5.1
orch.lmf function, 8.5.1
orch.neural function, 8.5.1
orch.nmf function, 8.5.1
orch.nmf.NMFalgo function, 8.5.1
orch.pack functions, 8.5.8
orch.recommend function, 8.5.1
orch.reconnect function, 8.5.5
orch.temp.path function, 8.5.8
orch.tgz package, 1.8.1.5
orch.unpack function, 8.5.8
orch.version function, 8.5.9
ORE functions for Hive, 8.3.2
ore.create function, 8.3.5, 8.5.3
ore.drop function, 8.5.3
ore.exec function, 8.3.5
ore.get function, 8.5.3
ore.pull function, 8.5.3
ore.push function, 8.5.3
ore.recode function, 8.5.3
ore.warn.order option, 8.3.5
OSCH_BIN_PATH directory, 1.4.4
output
encoding annotation, 6, 6, 6, 6
output annotation, 6, 6
output directory for Oracle XQuery for Hadoop, 5.6
OVERRIDE_INPUTFORMAT option, 4.5.3
OVERRIDE_ROW_FORMAT option, 4.5.1
oxh
find function, 6
increment-counter function, 6
property function, 6
oxh utility, 5.5
oxh-charset property, 7.4.2
oxh-column property, 7.4.2
oxh-elements property, 7.4.2
oxh-entity.name property, 7.4.2
oxh-namespace.prefix property, 7.4.2
OXMLSerDe, 7.4.1

P

parallel processing, 1.2.1, 2.11
parse-xml function, 5.4.2
parsing options for JSON files, 6
partitioning, 3.4.2
PathFilter property (OSCH), 2.10.2
Paths property (OSCH), 2.10.2
pattern matching (OSCH), 2.10.2
pattern-matching characters in Oracle SQL 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
preprocessor access parameter, 2.5.2
privileges, Oracle Database, 1.4.4
projects
setting up in Oracle Data Integrator, 4.3
put function (XQuery)
description, 5.3
put functions
Oracle NoSQL Database adapter, 6
sequence files, 6
text files, 6

Q

quantile function, 8.5.4
queries
running in Oracle XQuery for Hadoop, 5.5
running locally in Oracle XQuery for Hadoop, 5.5.3
query optimization for Oracle SQL Connector for HDFS, 2.11

R

R data types, converting and testing, 8.5.7
R distribution, 1.8.1.1, 1.8.3.1
R Distribution, 1.8.1.4, 1.8.3.4
R functions
categorical listing, 8.5
R functions for Hive, 8.3.3
random order messages, 8.3.5
reading Avro files, 6
reading sequence files, 6
reading text files, 6
records, rejected, 3.11.2
RECYCLE_ERRORS option, 4.5.2.1
rejected records, 3.11.2
ReplicaAck policy, 6
ReplicaPolicy durability, 6
requestLimit property, 6
requestTimeout property, 6, 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

S

sampling data
from Oracle Loader for Hadoop, 3.12.1
scripts
debugging in R, 8.5.9
snippets, 4.1.1
sd function, 8.5.4
seq
collection annotation, 6
collection function, 6
collection-binxml function, 6
collection-xml function, 6
compress annotation, 6
file annotation, 6
key annotation, 6
put annotation, 6
put functions, 6
put-binxml function, 6
put-xml function, 6
split-max annotation, 6
split-min annotation, 6
sequence file adapter, 6
annotations for writing, 6
collection function, 6
examples, 6
sequence file adapter functions, 6
sequence files
compression, 6
output file name, 6
reading, 6
split size, 6
writing, 6
SerDes JAR files, 4.2.3, 4.2.3
serialization parameter, 6, 6
serialization parameters, 6
serialize function, 5.4.2
skiperrors property for Oracle XQuery for Hadoop, 5.6
skiperrors.counters property, 5.6
skiperrors.log.max property, 5.6
skiperrors.max property, 5.6
snappy compression, 6
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 size
for Avro files, 6
sequence files, 6
text files, 6
split sizes, 6
splitting XML files, 6
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
standard deviation, 8.5.4
STATIC_CONTROL option, 4.5.2.1
STOP_ON_FILE_NOT_FOUND option, 4.5.1
subrange specification, Oracle NoSQL Database adapter, 6

T

tables
copying data from HDFS, 3.1
writing to Oracle Database, 6
temp directory, setting for Oracle XQuery for Hadoop, 5.6
TEMP_DIR option, 4.5.3
text
collection annotation, 6
collection function, 6
collection-xml function, 6
compress annotation, 6
file annotation, 6
put annotation, 6
put function, 6
put-xml function, 6
split annotation, 6
split-max annotation, 6
trace function, 6
text file adapter, 6
collection function, 6
put function, 6
text files
converting to Avro, 6
delimiter, 6
reading, 6
reading and writing, 6
split size, 6
writing, 6
third-party licenses, 3.15, 5.7
time zones in XQuery, 6
timeout property, 6, 6
timestampMask property (OSCH), 2.10.2, 2.10.2
timestampTZMask property (OSCH), 2.10.2, 2.10.2
timezone property for Oracle XQuery for Hadoop, 5.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
trignonometric functions (XQuery), 5.4.2
TRUNCATE option, 4.5.1, 4.5.2.1, 4.5.3
Tukey’s five-number summary, 8.5.4
type mappings
between XQuery and Avro, 6
between XQuery and Oracle Database, 6

U

uncompressed files, 2.10.2
unparsed-text function, 5.4.2, 5.4.3
unparsed-text-available function, 5.4.2
unparsed-text-lines function, 5.4.3
unparsed-text-lines functions, 5.4.2
updating functions, 5.4.1, 5.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
UTF-8 encoding, 6, 6
UTL_FILE package, 1.4.4

V

validating data
in Oracle Data Integrator, 4.1, 4.1.2, 4.5.2.1
var function, 8.5.4
variance calculation, 8.5.4
vector methods for Hive, 8.3.3
version, R software, 8.5.9

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
writing sequence files, 6
writing text files, 6
writing to Oracle tables, 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 file adapter, 6
examples, 6
XML files
reading, 6, 6
restrictions on splitting, 6
XML schemas
accessing user-defined, 5.4.5
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_EXISTS function, 7.4.3.3
XML_QUERY function, 7.4.3.3
XML_QUERY_AS_primitive function, 7.4.3.3
XML_TABLE function, 7.4.3.3
xmlf
collection annotation, 6
collection functions, 6
split annotation, 6
split-entity annotation, 6
split-max annotation, 6
split-min annotation, 6, 6
split-namespace annotation, 6
xml-reference directory, 1.6.3, 4.2.2
XQuery
See Oracle XQuery for Hadoop
XQuery library modules
accessing user-defined, 5.4.5
XQuery specification support, 5.4.2
XQuery transformations
requirements, 5.4.1
xquery.output property, 5.6
xquery.scratch property, 5.6
xquery.skiperrors property, 5.6
xquery.skiperrors.counters property, 5.6
xquery.skiperrors.log.max property, 5.6
xquery.skiperrors.max property, 5.6
xquery.timezone property, 5.6
xsi
nil attribute, 6