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. |
The following are changes in Oracle Big Data Connectors for Release 4.12.
Software Updates in This Release
| Connector | Version |
|---|---|
|
Oracle SQL Connector for HDFS (OSCH) |
3.8.2 |
|
Oracle Loader for Hadoop (OLH) |
3.9.2 |
|
Oracle Shell for Hadoop Loaders (OHSH) |
1.3.2 |
|
Oracle XQuery for Hadoop (OXH) |
4.9.1 |
|
Oracle R Advanced Analytics for Hadoop (ORAAH) |
2.8.0 |
|
Oracle DataSource for Apache Hadoop (OD4H) |
1.3.1 |
|
Oracle Data Integrator (ODI) |
12.2.1.2.6 |
New Commands for Monitoring OHSH Jobs
OHSH includes four new commands to monitor jobs and a command to remove jobs.
ohsh> show job <job_id>
Shows detailed information about the job specified by ID.
ohsh> show job summary <job_id>
Shows the performance of the completed job specified by ID.
ohsh> show job abstract <job_id>
Provides a functional description of the job .
ohsh> show jobs [failed|running|completed|finished] [extended] [<integer>]
Shows the last n jobs of a particular job status.
The first parameter specifies job status. If the status is not specified, all jobs are shown, regardless of job status.
The second parameter specifies whether to show details.
The third parameter specifies that the last n jobs of the specified status should be shown. If n is not specified, then all jobs of that status are shown.
ohsh> truncate jobs [<integer>]
Removes the last n jobs from the database. If the integer is not specified, the command removes all jobs
See Also:
See the OHSH help for descriptions of all OHSH commands:
ohsh> help
When OHSH is installed in on-premises environments (outside of Oracle Big Data cloud services), edits to the smartloader-conf.xml configuration file are required in order to enable these commands.
Other Changes
In earlier releases, usage examples for each of the Oracle Big Data Connectors are automatically installed into an examples directory under the home directory for the connector. In this release, the installation zip file for each connector includes an examples.zip file which you can unpack when you are ready to start working with the examples.
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.