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.9).
The following table lists the software versions installed with this release.
Table -1 Software Versions for Oracle Big Data Connectors 4.9
| Software | Version |
|---|---|
|
Oracle SQL Connector for HDFS (OSCH) |
3.8 |
|
Oracle Loader for Hadoop (OLH) |
3.9 |
|
Oracle Shell for Hadoop Loaders (OHSH) |
1.3 |
|
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.1 |
|
Copy to Hadoop |
3.1.3 |
Feature Changes in This Release
In Oracle SQL Connector for HDFS, the -publish option of the ExternalTable tool now supports partitioned Hive tables. This enables you to add a new Hive partition to an existing OSCH table.
Previously, the publish operation did not work with partitioned Hive sources and the workaround (which as of this release is no longer needed) was to drop and recreate the existing external table.
Oracle XQuery for Hadoop now supports XQuery 3.1, including the standard facilities for processing JSON, including: fn:parse-json, fn:json-to-xml, and fn:xml-to-json
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.