1. User's Guide
  2. Preface

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 sufficient background knowledge about the database server and the particular Hadoop platform which will host the software in order to follow the instructions successfully.

Related Documents

See the Oracle Big Data SQL Installation Guide for instructions on installing the product.

See the Oracle Big Data Appliance Owner's Guide for information about using the Oracle Big Data SQL with Oracle Big Data Appliance.

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

Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

# prompt

The pound (#) prompt indicates a command that is run as the Linux root user.

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.

Changes in Oracle Big Data SQL 3.2.1

Oracle Big Data SQL Release 3.2.1 includes several features that are not available in Release 3.2. There are no other enhancements or defect fixes in Release 3.2.1. Release 3.2 features are also included in this summary.

Support for Oracle Database 12.2.0.1

Release 3.2.1 can be installed on both Oracle Database 12.2.0.1 and 12.1.0.2. The same Oracle Big Data SQL 3.2.1 installation on a Hadoop cluster can connect to both Oracle Database 12.2.0.1 and 12.1.0.2.

Customers using Oracle Big Data SQL 3.2 do not need to upgrade to Release 3.2.1 if they connect to Oracle Database 12.1.0.2 only.

Note:

Patches must be applied on Oracle Database 12.x and Oracle Grid Infrastructure (when used). The applicable patches depend on the database version in use. Please refer to the Oracle Support Document 2119369.1 (Oracle Big Data SQL Master Compatibility Matrix) for details.

Exclusion of Edge Nodes

The installation now automatically excludes Hadoop edge nodes. In earlier releases, the BDS agent was installed on edge nodes in order to enable Copy to Hadoop. The BDS agent checks for installation prerequisites and these checks would sometimes fail on edge nodes. The BDS agent is no longer installed by default on edge nodes.

In addition, the Oracle Big Data SQL configuration file now has an optional excluded_nodes parameter where you can manually exclude nodes. It is possible, though not likely, that the installer may not identify a node as an edge node. You can use this parameter to manually identify missed edge nodes and then re-run the installer, but should rarely need to do so.

This parameter is in the network section of the configuration file.

   excluded_nodes :  [ "<fqdn_for_edge_node 1>","<fqdn_for_edge_node_2>","<fqdn_for_edge_node_3>" ]

See Also: