Go to main content
22/22
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
%annotations
6.1.3
,
6.7.2
,
6.7.3
%ora-java
binding annotation
5.4.4
%output annotation
6.4.10
%output encoding annotation
6.8.2
%output media-type annotation
6.8.2
%updating annotation
5.4.1
A
access privileges, Oracle Database
1.5.4
adapters
Avro
6.1
Oracle NoSQL Database
6.4
sequence file
6.5
text file
6.7
tika
6.8
XML file
6.9
aggregate functions for Hive
8.5.4
ALLOW_BACKSLASH_ESCAPING_ANY_CHARACTER property
6.2.4
ALLOW_COMMENTS property
6.2.4
ALLOW_NON_NUMERIC_NUMBERS property
6.2.4
ALLOW_NUMERIC_LEADING_ZEROS property
6.2.4
ALLOW_SINGLE_QUOTES property
6.2.4
ALLOW_UNQUOTED_CONTROL_CHARS property
6.2.4
ALLOW_UNQUOTED_FIELD_NAMES property
6.2.4
ALTER SESSION commands
2.12
analytic functions in R
8.5.1
annotations
Avro collection
6.1.2
equal to Oracle Loader for Hadoop configuration properties
6.3.3
for writing to Oracle NoSQL Database
6.4.10
Oracle Database adapter
6.3.1
Oracle NoSQL Database adapter
6.4.5
parsing tika files
6.8.2
reading from Oracle NoSQL Database
6.4.6
reading sequence files
6.5.2
reading text files
6.7.2
reading XML files
6.9.2
writing text files
6.7.3
Apache Hadoop distribution
1.2.2
,
1.9.1.1
Apache licenses
3.6.1
,
3.6.2
,
B.1
avro
compress annotation
6.1.3
file annotation
6.1.3
put annotation
6.1.3
schema annotation
6.1.3
schema-file annotation
6.1.3
schema-kv annotation
6.1.3
,
6.4.5
,
6.4.6
,
6.4.10
Avro
annotations for reading
6.1.2
annotations for writing
6.1.3
avro((colon))collection-avroxml function
6.1.1.1
avro((colon))get function
6.1.1.2
Avro array,
reading as XML
6.1.5.1.3
Avro file adapter
6.1
examples
6.1.4
reading Avro as XML
6.1.5.1
writing XML as Avro
6.1.5.2
Avro files
collection annotations
6.1.2
collection function
6.1.2
converting text to
6.1.4
functions for reading
6.1.1
output file name
6.1.3
put functions
6.1.3
querying records
6.1.4
reading
6.1.2
reading as XML
6.1.5.1
writing
6.1.3
Avro license
3.6.1
Avro maps
6.1.1.2
Avro maps, reading as XML
6.1.5.1.2
Avro null values
6.1.5.1.5
Avro primitives
reading as XML
6.1.5.1.5
Avro reader schema
6.1.2
,
6.1.3
,
6.4.6
Avro records, reading as XML
6.1.5.1.1
Avro unions, reading as XML
6.1.5.1.4
avroxml method
6.1.5.1
,
6.1.5.2
B
balancing loads in Oracle Loader for Hadoop
3.4.10
batchSize property
6.4.14
bzip2 input files
2.11.2
C
character encoding
6.4.5
,
6.4.6
character methods for Hive
8.3.3
client libraries
1.6.2
clients
configuring Hadoop
1.9.3.2
coersing data types in R
8.5.7
collection annotation
text files
6.7.2
tika files
6.8.2
collection annotations
Avro
6.1.2
collection function (XQuery)
description
5.3
collection functions
Oracle NoSQL Database adapter
6.4.5
sequence files
6.5.2
text files
6.7.2
tika files
6.8.2
collection-tika function
6.4.2.5
,
6.5.1.4
columnCount property (OSCH)
2.11.2
columnLength property (OSCH)
2.11.2
columnNames property (OSCH)
2.11.2
columnType property (OSCH)
2.11.2
compressed data files
2.11.2
compressed files
2.11.2
compression
data in database tables
2.2
sequence files
6.5.3
compression codec
6.1.3
CompressionCodec property (OSCH)
2.11.2
compression methods
Avro output files
6.1.3
configuration properties
for Oracle XQuery for Hadoop
6.3.3
JSON file adapter
6.2.4
Oracle NoSQL Database adapter
6.4.14
Oracle XQuery for Hadoop
5.7
configuration settings
Hadoop client
1.9.3.2
Sqoop utility
1.9.1.2
configuring a Hadoop client
1.9.3.2
connecting to Oracle Database from R
8.5.5
consistency property
6.4.14
createBadFiles property
2.11.2
createLogFiles property
2.11.2
CREATE TABLE
configuration properties
7.6.2
examples
7.6.3
syntax
7.6.1
CREATE TABLE privilege
1.5.4
CSV files
2.11.2
,
3.5
D
database directories
for Oracle SQL Connector for HDFS
1.5.3
databaseName property, Hive (OSCH)
2.11.2
database patches
1.6.1
,
2.6.2
database privileges
1.5.4
database system, configuring to run MapReduce jobs
1.5.2
database tables
writing using Oracle XQuery for Hadoop
6.3
dataCompressionCodec property (OSCH)
2.11.2
dataPathFilter property (OSCH)
2.11.2
dataPaths property (OSCH)
2.11.2
Data Pump files
2.6.2
XML template
2.6.2.3
data type mappings
between XQuery and Avro
6.1.5.1.5
between XQuery and Oracle Database
6.3.1
Oracle Database and XQuery
6.3.1
data type mappings, Hive (OSCH)
2.11.2
data types
Oracle Loader for Hadoop
3.4.2.1
data type testing in R
8.5.7
dateMask property (OSCH)
2.11.2
defaultDirectory property (OSCH)
2.11.2
deflate compression
6.1.3
delimited text files
XML templates
2.6.4.4
DelimitedTextInputFormat class
3.4.5.1
,
3.5
Oracle Loader for Hadoop
3.4.5.1.3
delimiter
for splitting text files
6.7.2
Direct Connector for HDFS
2.11.2
directories
1.5.3
default HDFS for XQuery
5.7
Oracle SQL Connector for HDFS home
1.5.3
Sqoop home
1.9.1.2
Directory property (OSCH)
2.11.2
disable_directory_link_check access parameter
2.6.2
distributed cache
accessing from Oracle XQuery for Hadoop
5.4.3
downloading software
1.3
,
1.9.1.1
,
1.9.1.2
,
1.9.1.4
,
1.9.3.4
,
1.9.1.5
drivers
JDBC
1.9.1.2
,
3.4.7.1.1
ORACLE_DATAPUMP
3.4.7.4.1
ORACLE_LOADER
2.10
durability property
6.4.14
E
encoding characters
6.4.5
,
6.4.6
ExternalTable command
syntax
2.5.2
external tables
about
2.1
F
fieldLength property (OSCH)
2.11.2
fieldTerminator property (OSCH)
2.11.2
file paths
locating in XQuery
6.11.1.1
FLWOR requirements
5.4.1
fn
nilled function
6.1.5.1.1
,
6.1.5.1.2
frame methods for Hive
8.3.3
functions
for writing to Oracle NoSQL Database
6.4.10
Oracle NoSQL Database
6.4.2
,
6.4.3
,
6.4.4
parsing tika files
6.8.1
,
6.8.2
reading and writing sequence files
6.5.1
reading and writing text files
6.7.1
reading Avro files
6.1.2
reading from Oracle NoSQL Database
6.4.5
,
6.4.6
reading JSON files
6.2.1
reading sequence files
6.5.2
reading text files
6.7.2
reading XML files
6.9.1
,
6.9.2
writing Avro files
6.1.3
writing sequence files
6.5.3
writing text files
6.7.3
G
get function
Oracle NoSQL Database adapter
6.4.6
get-tika function
6.4.2.13
gzip input files
2.11.2
H
HADOOP_HOME environment variable
1.9.1.1
HADOOP_LIBEXEC_DIR environment variable
1.9.1.1
Hadoop client
configuring
1.9.3.2
installing
1.5.2
hdfs_stream Bash shell script
1.5.3
HDFS commands
issuing from R
8.5.2
HDFS data
copying in R
8.5.6
HDFS directories
creating in R
8.5.2
HDFS directory
5.7
HDFS files
loading data into an Oracle database
3.4.5.6
restrictions in Oracle R Advanced Analytics for Hadoop
8.2
hive.columnType property (OSCH)
2.11.2
hive.databaseName property (OSCH)
2.11.2
hive.partitionFilter property
2.11.2
hive.tableName property
2.11.2
Hive access from R
8.3
Hive access in R
8.5.3
Hive data type mappings (OSCH)
2.11.2
Hive data types, support for
8.3.4
Hive JAR files for Oracle Loader for Hadoop
3.4.8.1
Hive tables
XML format
2.6.3.5
HiveToAvroInputFormat class
3.4.5.3
,
3.4.8.1
Hortonworks Data Platform distribution
1.5.1
hosts property
6.4.14
I
initialFieldEncloser property
2.11.2
InputFormat class
Oracle Loader for Hadoop
3.4.5.1.3
installation
Hadoop client
1.5.2
Oracle Data Integrator Application Adapter for Hadoop
1.10
Oracle Loader for Hadoop
1.6
Oracle R Advanced Analytics for Hadoop
1.9
Oracle Shell for Hadoop Loaders Setup
1.7
Oracle SQL Connector for HDFS
1.5
Sqoop utility
1.9.1.2
installation instructions
1
Instant Client libraries
1.6.2
J
JDBC drivers
1.9.1.2
,
3.4.7.1.1
json
get function
6.2.1.3
parse-as-xml function
6.2.1.2
JSON data formats
converting to XML
6.2.5
JSON file adapter
configuration properties
6.2.4
JSON files
reading
6.2.1
JSON module
6.2
examples
6.2.3
K
kv
collection annotation
6.4.5
collection-avroxml function
6.4.2.2
collection-binxml function
6.4.2.4
collection-text function
6.4.2.1
collection-xml function
6.4.2.3
get annotation
6.4.6
get-avroxml function
6.4.2.10
get-binxml function
6.4.2.12
get-text function
6.4.2.9
get-xml function
6.4.2.11
key annotation
6.4.5
,
6.4.6
key-range function
6.4.2.14
,
6.4.2.15
put annotation
6.4.10
put-binxml function
6.4.2.8
put-text function
6.4.2.6
put-xml function
6.4.2.7
KVAvroInputFormat class
3.4.8.2
kv-lob
get-binxml
6.4.4.3
get-text
6.4.4.1
get-tika
6.4.4.4
get-xml
6.4.4.2
put-binxml
6.4.4.7
put-text
6.4.4.5
put-xml
6.4.4.6
kvstore property
6.4.14
kv-table
collection-jsontext
6.4.3.1
L
licenses
5.8
,
8.8
licenses, third-party
3.6
,
4.1.2
load balancing
in Oracle Loader for Hadoop
3.4.10
LOBSuffixproperty
6.4.14
LOBTimeout property
6.4.14
locationFileCount property
2.11.2
log4j.logger.oracle.hadoop.xquery property
5.7
logDirectory property
2.11.2
logical methods for Hive
8.3.3
M
mapping
JSON to XML
6.2.5.3
mappings
Oracle Database and XQuery data types
6.3.1
mappings, Hive to Oracle Database (OSCH)
2.11.2
MapReduce functions
writing in R
8.5.8
MasterPolicy durability
6.4.14
matrix methods for Hive
8.3.3
N
nilled elements
6.1.5.1.1
nilled function
6.1.5.1.5
null values in Avro
6.1.5.1.5
numeric methods for Hive
8.3.3
O
OCI Direct Path
3.5
OHSH
1.7
operating system user permissions
1.5.3
oracle
columns annotation
6.3.1
put annotation
6.3.1
ORACLE_DATAPUMP driver
3.4.7.4.1
ORACLE_LOADER driver
2.10
oracle.hadoop.exttab.colMap.column_name.nullIfSpecifier property
2.11.2
oracle.hadoop.exttab.createBadFiles property
2.11.2
oracle.hadoop.exttab.createLogFiles property
2.11.2
oracle.hadoop.exttab.hive.tableName property
2.11.2
oracle.hadoop.exttab.initialFieldEncloser property
2.11.2
oracle.hadoop.exttab.locationFileCount property
2.11.2
oracle.hadoop.exttab.logDirectory property
2.11.2
oracle.hadoop.exttab.nullIfSpecifier property
2.11.2
oracle.hadoop.exttab.preprocessorDirectory property
2.11.2
oracle.hadoop.exttab.preprocessorScript
2.11.2
oracle.hadoop.exttab.recordDelimiter property
2.11.2
oracle.hadoop.exttab.sourceType property
2.11.2
oracle.hadoop.exttab.stringSizes property
2.11.2
oracle.hadoop.exttab.tableName property
2.11.2
oracle.hadoop.xquery.* properties
5.7
oracle.hadoop.xquery.json.parser.*
6.2.4
oracle.hadoop.xquery.kv.config.durability property
6.4.14
oracle.hadoop.xquery.kv.config.requestLimit property
6.4.14
oracle.hadoop.xquery.kv.config.requestTimeout property
6.4.14
oracle.hadoop.xquery.kv.config.socketOpenTimeout property
6.4.14
oracle.hadoop.xquery.kv.config.socketReadTimeout property
6.4.14
oracle.hadoop.xquery.kv property
6.4.14
oracle.hadoop.xquery.lib.share property
5.7
oracle.hadoop.xquery.tika.html.asis property
6.8.4
oracle.hadoop.xquery.tika.locale property
6.8.4
oracle.kv.batchSize property
6.4.14
oracle.kv.consistency property
6.4.14
oracle.kv.hosts configuration property
6.4.14
oracle.kv.hosts property
6.4.14
oracle.kv.kvstore configuration property
6.4.14
oracle.kv.kvstore property
6.4.14
oracle.kv.timeout property
6.4.14
Oracle Database
annotations for writing
6.3.1
connecting from R
8.5.5
put function
6.3.1
user privileges
1.5.4
Oracle Database access from ORCH
8.4
Oracle Database adapter
6.3
configuration properties
6.3.3
examples
6.3.2
Oracle Database Adapter
using Oracle Loader for Hadoop
6.3
Oracle Data Integrator Application Adapter for Hadoop
installing
1.10
Oracle Direct Connector for HDFS
2.11.2
Oracle Exadata Database Machine
installing a Hadoop client
1.5.2
Oracle Instant Client libraries
1.6.2
Oracle Loader for Hadoop
description
3.1
input formats
3.4.5.6
installing
1.6
supported database versions
1.6.1
Oracle NoSQL Database
annotations for writing
6.4.10
Oracle NoSQL Database adapter
6.4
annotations for reading
6.4.5
collection function
6.4.5
get function
6.4.6
reading Avro as XML
6.1.5.1
writing XML as Avro
6.1.5.2
Oracle NoSQL Database Adapter
configuration properties
6.4.14
examples
6.4.13
Oracle NoSQL Database functions
6.4.2
,
6.4.3
,
6.4.4
Oracle OCI Direct Path
3.5
Oracle permissions
1.5.3
oracle-property annotation
6.3.1
Oracle RAC systems, installing a Hadoop client
1.5.2
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
1.1
,
8.1.2
HDFS commands issued from
8.5.2
installation
1.9
MapReduce functions
8.5.8
Oracle Shell for Hadoop Loaders Setup
installing
1.7
Oracle Software Delivery Cloud
1.3
Oracle SQL Connector for HDFS
description
2.1
installation
1.5
pattern-matching characters
2.11.2
query optimization
2.12
Oracle Technology Network
downloads
1.3
,
1.9.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.7
configuring Oracle NoSQL Database server
6.4.1
description
5.1
error logging levels
5.7
error recovery setting
5.7
hadoop command
5.5
JSON module
6.2
Oracle NoSQL Database adapter
6.4
output directory
5.7
running queries
5.5
running queries locally
5.5.3
sequence file adapter
6.5
temp directory
5.7
text file adapter
6.7
tika adapter
6.8
time zone
5.7
XML file adapter
6.9
Oracle XQuery for Hadoop adapters
overview
5.3.1
Oracle XQuery for Hadoop modules
overview
5.3.2
orahdfs-version/bin directory
1.5.3
orahdfs-version.zip file
1.5.3
ora-java
binding annotation
5.4.4
OraLoader
3.5
oraloader-<version>.zip file
1.8.2
OraLoaderMetadata utility program
3.4.4.2
oraloader-version.zip
1.6.3
oraloader-version.zip file
1.5.3
,
1.6.2
oraloader-version directory
1.6.2
,
1.8.2
orch.tgz package
1.9.1.6
ORCH package
installation
1.9.1.1
,
1.9.1.6
ore.create function
8.3.5
ore.exec function
8.3.5
ore.warn.order option
8.3.5
ORE functions for Hive
8.3.2
OSCH_BIN_PATH directory
1.5.4
output
encoding annotation
6.4.5
,
6.4.6
,
6.5.2
,
6.9.2
parameter annotation
6.7.3
output annotation
6.5.3
output directory for Oracle XQuery for Hadoop
5.7
oxh
find function
6.11.1.1
increment-counter function
6.11.1.2
println function
6.11.1.3
println-xml function
6.11.1.4
property function
6.11.1.5
oxh-charset property
7.6.2
oxh-column property
7.6.2
oxh-default-namespace property
7.6.2
oxh-elements property
7.6.2
oxh-entity.name property
7.6.2
oxh-namespace.prefix property
7.6.2
OXMLSerDe
7.6.1
P
parallel processing
1.2.1
,
2.12
parsing options for JSON files
6.2.4
parsing tika files
6.8.1
partitioning
3.4.2.2
PathFilter property (OSCH)
2.11.2
Paths property (OSCH)
2.11.2
pattern matching
5.7
pattern matching (OSCH)
2.11.2
pattern-matching characters in Oracle SQL Connector for HDFS
2.11.2
preprocessor access parameter
2.6.2
preprocessorDirectory property
2.11.2
privileges, Oracle Database
1.5.4
put function (XQuery)
description
5.3
put functions
Oracle NoSQL Database adapter
6.4.10
sequence files
6.5.3
text files
6.7.3
Q
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.12
R
random order messages
8.3.5
R data types, converting and testing
8.5.7
R distribution
1.9.1.1
,
1.9.3.1
R Distribution
1.9.1.4
,
1.9.3.4
,
1.9.1.5
reading Avro files
6.1.2
reading sequence files
6.5.1
reading text files
6.7.1
readZones property
6.4.14
recordDelimiter property
2.11.2
records, rejected
3.4.9.2
rejected records
3.4.9.2
ReplicaAck policy
6.4.14
ReplicaPolicy durability
6.4.14
requestLimit property
6.4.14
requestTimeout property
6.4.14
R functions
categorical listing
8.5
R functions for Hive
8.3.3
S
sampling data
from Oracle Loader for Hadoop
3.4.10.1
scripts
debugging in R
8.5.9
security property
6.4.14
seq
collection annotation
6.5.2
collection-binxml function
6.5.1.3
collection function
6.5.1.1
collection-xml function
6.5.1.2
compress annotation
6.5.3
file annotation
6.5.3
key annotation
6.5.2
put annotation
6.5.3
put-binxml function
6.5.1.7
put functions
6.5.1.5
put-xml function
6.5.1.6
split-max annotation
6.5.2
split-min annotation
6.5.2
sequence file adapter
6.5
annotations for writing
6.5.3
collection function
6.5.2
examples
6.5.4
sequence file adapter functions
6.5.1
sequence files
compression
6.5.3
output file name
6.5.3
reading
6.5.2
split size
6.5.2
writing
6.5.3
serialization parameter
6.4.10
,
6.7.3
serialization parameters
6.12
skiperrors.counters property
5.7
skiperrors.log.max property
5.7
skiperrors.max property
5.7
skiperrors property for Oracle XQuery for Hadoop
5.7
snappy compression
6.1.3
socketOpenTimeout property
6.4.14
socketReadTimeout property
6.4.14
software downloads
1.3
,
1.9.1.1
,
1.9.1.2
,
1.9.1.4
,
1.9.3.4
,
1.9.1.5
sourceType property
2.11.2
split size
for Avro files
6.1.2
sequence files
6.5.2
text files
6.7.2
split sizes
6.1.2
splitting XML files
6.9.2
SQL*Loader
3.4.7.3.1
Sqoop
8.4.1
Sqoop utility
installing on a Hadoop client
1.9.3.3
installing on a Hadoop cluster
1.9.1.2
stringSizes property
2.11.2
subrange specification, Oracle NoSQL Database adapter
6.4.5
T
tables
compression in database
2.2
copying data from HDFS
3.1
writing to Oracle Database
6.3.1
temp directory, setting for Oracle XQuery for Hadoop
5.7
text
collection annotation
6.7.2
collection function
6.7.1.1
collection-xml function
6.7.1.2
compress annotations
6.7.3
file annotation
6.7.3
put annotation
6.7.3
put function
6.7.1.3
put-xml function
6.7.1.4
split annotation
6.7.2
split-max annotation
6.7.2
trace function
6.7.1.5
text file adapter
6.7
collection function
6.7.2
put function
6.7.3
text files
converting to Avro
6.1.4
delimiter
6.7.2
reading
6.7.2
reading and writing
6.7.1
split size
6.7.2
writing
6.7.3
third-party licenses
3.6
,
4.1.2
,
5.8
,
8.8
tika
%output encoding annotation
6.8.2
%output media-type annotation
6.8.2
collection annotation
6.8.2
collection function
6.8.1.1
helper function
6.8.1.2
parse function
6.8.1.2
parse textual data
6.8.1.2
tika adapter
6.8
tika file adapter
collection function
6.8.2
parsing
6.8.1
tika files
parsing
6.8.2
timeout property
6.4.14
timestampMask property (OSCH)
2.11.2
timestampTZMask property (OSCH)
2.11.2
timezone property for Oracle XQuery for Hadoop
5.7
time zones in XQuery
6.3.1
type mappings
between XQuery and Avro
6.1.5.1.5
between XQuery and Oracle Database
6.3.1
U
uncompressed files
2.11.2
updating functions
5.4.1
UTF-8 encoding
6.4.5
,
6.4.6
UTL_FILE package
1.5.4
V
vector methods for Hive
8.3.3
W
wildcards
5.7
writing Avro files
6.1.3
writing sequence files
6.5.1
writing text files
6.7.1
writing to Oracle tables
6.3
X
XML
writing as Avro arrays
6.1.5.2.3
writing as Avro maps
6.1.5.2.2
writing as Avro primitives
6.1.5.2.5
writing as Avro records
6.1.5.2.1
writing as Avro unions
6.1.5.2.4
XML_EXISTS function
7.9
XML_QUERY_AS_primitive function
7.11
XML_QUERY function
7.10
XML_TABLE function
7.12
xmlf
collection annotation
6.9.2
collection functions
6.9.1.1
split annotation
6.9.2
split-entity annotation
6.9.2
split-max annotation
6.9.2
split-min annotation
6.7.2
,
6.9.2
split-namespace annotation
6.9.2
XML file adapter
6.9
examples
6.9.3
XML files
reading
6.9.1
,
6.9.2
restrictions on splitting
6.9.2
XML schemas
accessing user-defined
5.4.5
XML template for Data Pump files
2.6.2.3
XML templates
Data Pump files
2.6.2.3
delimited text files
2.6.4.4
Hive tables
2.6.3.5
XQuery
5
xquery.output property
5.7
xquery.scratch property
5.7
xquery.skiperrors.counters property
5.7
xquery.skiperrors.log.max property
5.7
xquery.skiperrors.max property
5.7
xquery.skiperrors property
5.7
xquery.timezone property
5.7
XQuery library modules
accessing user-defined
5.4.5
XQuery specification support
5.4.2
XQuery transformations
requirements
5.4.1
xsi
nil attribute
6.1.5.1.1
Scripting on this page enhances content navigation, but does not change the content in any way.