33/33
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