Preface
The Oracle Big Data SQL User's Guide describes how to use and manage the Oracle Big Data SQL product.
Audience
This guide is intended for administrators and users of Oracle Big Data SQL, including:
-
Application developers
-
Data analysts
-
Data scientists
-
Database administrators
-
System administrators
The guide assumes that the reader has basic knowledge of Oracle Database single-node and multinode systems, the Hadoop framework, the Linux operating system, and networking concepts.
Documentation Accessibility
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.
Related Documents
See the Oracle Big Data SQL User’s Guide for instructions on using the product.
The following publications provide information about the use of Oracle Big Data SQL with the Oracle Big Data Appliance and Oracle Big Data Connectors:
You can find more information about Oracle’s Big Data solutions and Oracle Database at the Oracle Help Center
For more information on Hortonworks HDP and Ambari, refer to the Hortonworks documentation site at http://docs.hortonworks.com/index.html.
For more information on Cloudera CDH and Configuration Manager, see http://www.cloudera.com/documentation.html
Conventions
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 pound ( |
Backus-Naur Form Syntax
The syntax in this reference 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. |
boldface |
Words appearing in boldface are keywords. They must be typed as shown. (Keywords are case-sensitive in some, but not all, operating systems.) Words that are not in boldface are placeholders for which you must substitute a name or value. |
Who Should Install Release 3.2.1.2?
If you need to support connections from Oracle Database 12.2.0.1, or, you are running Grid 12.2.0.1, then install Oracle Big Data SQL 3.2.1.2.
Support for connections from Oracle Database 12.1.0.2 to Hadoop does not require an upgrade from Big Data SQL 3.2 to 3.2.1.2, unless:
- The 12.1.0.2 database is managed by Oracle Grid Infrastructure 12.2, or,
- The 12.1 database is connecting to a Hadoop cluster with Big Data SQL 3.2.1 installed.
Note:
If you do install Release 3.2.1.2 on the Hadoop cluster, remember to apply the new database deployment bundle from the Hadoop cluster installation to the database tier.
Please check the Oracle Big Data SQL Master Compatibility Matrix (Doc ID 2119369.1 in My Oracle Support) for further details.