The Oracle Big Data Connectors User's Guide describes how to install and use Oracle Big Data Connectors:
Oracle Loader for Hadoop
Oracle SQL Connector for Hadoop Distributed File System
Oracle XQuery for Hadoop
Oracle R Advanced Analytics for Hadoop
Oracle Datasource for Apache Hadoop
This document is intended for users of Oracle Big Data Connectors, including the following:
Application developers
Java programmers
XQuery programmers
System administrators
Database administrators
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
The following text conventions are used in this document:
| Convention | Meaning |
|---|---|
|
boldface |
Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary. |
|
italic |
Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values. |
|
|
Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter. |
The syntax is presented in a simple variation of Backus-Naur Form (BNF) that uses the following symbols and conventions:
| Symbol or Convention | Description |
|---|---|
|
[ ] |
Brackets enclose optional items. |
|
{ } |
Braces enclose a choice of items, only one of which is required. |
|
| |
A vertical bar separates alternatives within brackets or braces. |
|
... |
Ellipses indicate that the preceding syntactic element can be repeated. |
|
delimiters |
Delimiters other than brackets, braces, and vertical bars must be entered as shown. |
This section is an overview of changes in Oracle Big Data Connectors, Release 4 (4.10).
The following table lists the software versions installed with this release.
Table -1 Software Versions for Oracle Big Data Connectors 4.10
| Software | Version |
|---|---|
|
Oracle SQL Connector for HDFS (OSCH) |
3.8.1 |
|
Oracle Loader for Hadoop (OLH) |
3.9.1 |
|
Oracle Shell for Hadoop Loaders (OHSH) |
1.3.1 |
|
Oracle XQuery for Hadoop (OXH) |
4.9.0 |
|
Oracle R Advanced Analytics for Hadoop (ORAAH) |
2.7.0 |
|
Oracle DataSource for Apache Hadoop (OD4H) |
1.2.0.0 |
|
Oracle Data Integrator (ODI) |
12.2.1.2.6 |
Feature Changes in This Release
Load Error Diagnostics Available Through an SQL Client
Two new Oracle SQL Connector for HDFS properties enable you to identify and review data load errors from within your SQL client, as an alternative to examining the .log and .bad files directly.
See oracle.hadoop.exttab.badFileFormatUsePercentA and oracle.hadoop.exttab.logFileFormatUsePercentA in this guide. These properties can create diagnostic external tables over .log and .bad files that you can use to determine whether the load was successful or to review the reason for any rejected rows.
Footnote Legend
Footnote 1:Oracle Big Data Connectors includes a restricted use license for the Oracle Data Integrator when licensed on an Oracle Big Data Appliance. However, additional licensing is required for using it on other Hadoop clusters.