CINXE.COM

<!DOCTYPE html> <html lang="en-US"> <head> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1"> <meta charset="utf-8"> <meta http-equiv="Content-Type" content="UTF-8" /> <title>Preface</title> <meta name="generator" content="DITA Open Toolkit version 1.8.5 (Mode = doc)" /> <meta name="dcterms.created" content="2016-06-27T14:31:41Z" /> <meta name="robots" content="all" /> <meta name="dcterms.title" content="Big Data SQL User's Guide" /> <meta name="dcterms.identifier" content="E76071-02" /> <meta name="dcterms.isVersionOf" content="BDSUG" /> <meta name="dcterms.rights" content="Copyright © 2012, 2016, Oracle and/or its affiliates. All rights reserved." /> <link rel="Start" href="../index.htm" title="Home" type="text/html" /> <link rel="Copyright" href="../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <script type="application/javascript" src="../dcommon/js/headfoot.js"></script> <script type="application/javascript" src="../nav/js/doccd.js" charset="UTF-8"></script> <link rel="Contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="Index" href="index.htm" title="Index" type="text/html" /> <link rel="Prev" href="title.htm" title="Previous" type="text/html" /> <link rel="Next" href="concepts.htm" title="Next" type="text/html" /> <link rel="alternate" href="E76071-02.pdf" title="PDF version" type="application/pdf" /> <link rel="schema.dcterms" href="http://purl.org/dc/terms/" /> <link rel="stylesheet" href="../dcommon/css/fusiondoc.css"> <link rel="stylesheet" type="text/css" href="../dcommon/css/header.css"> <link rel="stylesheet" type="text/css" href="../dcommon/css/footer.css"> <link rel="stylesheet" type="text/css" href="../dcommon/css/fonts.css"> <link rel="stylesheet" href="../dcommon/css/foundation.css"> <link rel="stylesheet" href="../dcommon/css/codemirror.css"> <link rel="stylesheet" type="text/css" title="Default" href="../nav/css/html5.css"> <link rel="stylesheet" href="../dcommon/css/respond-480-tablet.css"> <link rel="stylesheet" href="../dcommon/css/respond-768-laptop.css"> <link rel="stylesheet" href="../dcommon/css/respond-1140-deskop.css"> <script type="application/javascript" src="../dcommon/js/modernizr.js"></script> <script type="application/javascript" src="../dcommon/js/codemirror.js"></script> <script type="application/javascript" src="../dcommon/js/jquery.js"></script> <script type="application/javascript" src="../dcommon/js/foundation.min.js"></script> <script type="text/javascript" src="//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-552992c80ef99c8d" async="async"></script> <script type="application/javascript" src="../dcommon/js/jqfns.js"></script> <script type="application/javascript" src="../dcommon/js/ohc-inline-videos.js"></script>  <link rel="stylesheet" href="../dcommon/fancybox/jquery.fancybox.css?v=2.1.5" type="text/css" media="screen" /> <script type="text/javascript" src="../dcommon/fancybox/jquery.fancybox.pack.js?v=2.1.5"></script>  <link rel="stylesheet" href="../dcommon/fancybox/helpers/jquery.fancybox-buttons.css?v=1.0.5" type="text/css" media="screen" /> <script type="text/javascript" src="../dcommon/fancybox/helpers/jquery.fancybox-buttons.js?v=1.0.5"></script> <script type="text/javascript" src="../dcommon/fancybox/helpers/jquery.fancybox-media.js?v=1.0.6"></script> <link rel="stylesheet" href="../dcommon/fancybox/helpers/jquery.fancybox-thumbs.css?v=1.0.7" type="text/css" media="screen" /> <script type="text/javascript" src="../dcommon/fancybox/helpers/jquery.fancybox-thumbs.js?v=1.0.7"></script> <script>window.ohcglobal || document.write('<script src="/en/dcommon/js/global.js">\x3C/script>')</script></head> <body> <a href="#BEGIN" class="accessibility-top skipto" tabindex="0">Go to main content</a><header></header> <div class="row" id="CONTENT"> <div class="IND large-9 medium-8 columns"> <a id="BEGIN" name="BEGIN"></a> <a id="GUID-1870FB3D-84BF-4FBB-B10D-4CA49B3ACCC5"></a> <span id="PAGE" style="display:none;">3/11</span> <a id="BIGUG101"></a> <h1 id="BDSUG-GUID-1870FB3D-84BF-4FBB-B10D-4CA49B3ACCC5" class="sect1">Preface</h1> <div> <p>The <span class="italic">Oracle Big Data SQL User's Guide</span> describes how to install and manage the Oracle Big Data SQL product.</p> </div> <a id="BIGUG102"></a> <div class="props_rev_3"><a id="GUID-C5DBC506-CB69-47A4-BC38-77B603408C46"></a> <h2 id="BDSUG-GUID-C5DBC506-CB69-47A4-BC38-77B603408C46" class="sect2">Audience</h2> <div> <p>This guide is intended for installers and users of Oracle Big Data SQL. including:</p> <ul style="list-style-type: disc;"> <li> <p>Application developers</p> </li> <li> <p>Data analysts</p> </li> <li> <p>Data scientists</p> </li> <li> <p>Database administrators</p> </li> <li> <p>System administrators</p> </li> </ul> <p>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.</p> </div> </div> <a id="BIGUG105"></a> <div class="props_rev_3"><a id="GUID-35D8979E-2409-43F4-894D-4E488842E7C7"></a> <h2 id="BDSUG-GUID-35D8979E-2409-43F4-894D-4E488842E7C7" class="sect2">Related Documents</h2> <div> <p>Users installing Oracle Big Data SQL on the Oracle Big Data Appliance can get more information about Oracle’s Big Data solutions and the Oracle Big Data Appliance in particular at the <a href="http://docs.oracle.com/en/bigdata/" target="_blank">Oracle Help Center</a></p> <p>The following publications are recommended:</p> <ul style="list-style-type: disc;"> <li> <p><a class="olink BIGOG" target="_blank" href="../BIGOG/toc.htm"><span class="italic">Oracle Big Data Appliance Owner's Guide</span></a></p> </li> <li> <p><a class="olink BIGUG" target="_blank" href="../BIGUG/toc.htm"><span class="italic">Oracle Big Data Appliance Software User’s Guide</span></a></p> </li> <li> <p><a class="olink BDCUG" target="_blank" href="../BDCUG/toc.htm"><span class="italic">Oracle Big Data Connectors User's Guide</span></a></p> </li> </ul> <p>Users installing Oracle Big Data SQL on Hortonworks HDP should refer to the Hortonworks documentation site at <a href="http://docs.hortonworks.com/index.html" target="_blank">http://docs.hortonworks.com/index.html</a> for supplementary information</p> </div> </div> <a id="BIGUG76691"></a> <div class="props_rev_3"><a id="GUID-6EF8BEA8-A885-4C67-83B6-676A00501B17"></a> <h2 id="BDSUG-GUID-6EF8BEA8-A885-4C67-83B6-676A00501B17" class="sect2">Conventions</h2> <div> <p>The following text conventions are used in this document:</p> <div class="tblformal" id="GUID-6EF8BEA8-A885-4C67-83B6-676A00501B17__GUID-AD280230-F552-48F6-9F28-6C72582F9ED9"> <hr /> <table class="cellalignment291" summary="This table summarizes conventions used in this document."> <thead align="left"> <tr> <th class="cellalignment312" id="d1317e130">Convention</th> <th class="cellalignment313" id="d1317e133">Meaning</th> </tr> </thead> <tbody> <tr> <td class="cellalignment312" id="d1317e138" headers="d1317e130"> <p><span class="bold">boldface</span></p> </td> <td class="cellalignment313" headers="d1317e138 d1317e133"> <p>Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.</p> </td> </tr> <tr> <td class="cellalignment312" id="d1317e146" headers="d1317e130"> <p><span class="italic">italic</span></p> </td> <td class="cellalignment313" headers="d1317e146 d1317e133"> <p>Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.</p> </td> </tr> <tr> <td class="cellalignment312" id="d1317e154" headers="d1317e130"> <p><code>monospace</code></p> </td> <td class="cellalignment313" headers="d1317e154 d1317e133"> <p>Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.</p> </td> </tr> <tr> <td class="cellalignment312" id="d1317e162" headers="d1317e130"> <p><code>#</code> prompt</p> </td> <td class="cellalignment313" headers="d1317e162 d1317e133"> <p>The pound (<code>#</code>) prompt indicates a command that is run as the Linux <code>root</code> user.</p> </td> </tr> </tbody> </table> <hr /></div> </div> </div> <a id="BIGUG76692"></a> <div class="props_rev_3"><a id="GUID-88E10D63-C959-42BB-986B-128FA34AA7A9"></a> <h2 id="BDSUG-GUID-88E10D63-C959-42BB-986B-128FA34AA7A9" class="sect2">Backus-Naur Form Syntax</h2> <div> <p>The syntax in this reference is presented in a simple variation of Backus-Naur Form (BNF) that uses the following symbols and conventions:</p> <div class="tblformal" id="GUID-88E10D63-C959-42BB-986B-128FA34AA7A9__GUID-6CC75E3A-D4E1-4785-8076-BCE6F5169823"> <hr /> <table class="cellalignment291" summary="Conventions used in syntax"> <thead align="left"> <tr> <th class="cellalignment314" id="d1317e202">Symbol or Convention</th> <th class="cellalignment315" id="d1317e205">Description</th> </tr> </thead> <tbody> <tr> <td class="cellalignment314" id="d1317e210" headers="d1317e202"> <p>[ ]</p> </td> <td class="cellalignment315" headers="d1317e210 d1317e205"> <p>Brackets enclose optional items.</p> </td> </tr> <tr> <td class="cellalignment314" id="d1317e217" headers="d1317e202"> <p>{ }</p> </td> <td class="cellalignment315" headers="d1317e217 d1317e205"> <p>Braces enclose a choice of items, only one of which is required.</p> </td> </tr> <tr> <td class="cellalignment314" id="d1317e224" headers="d1317e202"> <p>|</p> </td> <td class="cellalignment315" headers="d1317e224 d1317e205"> <p>A vertical bar separates alternatives within brackets or braces.</p> </td> </tr> <tr> <td class="cellalignment314" id="d1317e231" headers="d1317e202"> <p>...</p> </td> <td class="cellalignment315" headers="d1317e231 d1317e205"> <p>Ellipses indicate that the preceding syntactic element can be repeated.</p> </td> </tr> <tr> <td class="cellalignment314" id="d1317e238" headers="d1317e202"> <p>delimiters</p> </td> <td class="cellalignment315" headers="d1317e238 d1317e205"> <p>Delimiters other than brackets, braces, and vertical bars must be entered as shown.</p> </td> </tr> <tr> <td class="cellalignment314" id="d1317e245" headers="d1317e202"> <p><span class="bold">boldface</span></p> </td> <td class="cellalignment315" headers="d1317e245 d1317e205"> <p>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.</p> </td> </tr> </tbody> </table> <hr /></div> </div> </div> <div class="sect2"><a id="GUID-3FB3E7BA-399B-4016-9E27-4237AFB61642"></a> <h2 id="BDSUG-GUID-3FB3E7BA-399B-4016-9E27-4237AFB61642" class="sect2">Changes in Oracle Big Data SQL 3.0.1</h2> <div> <p>The following are changes in Oracle Big Data SQL Release 3.0.1.</p> <p>In addition to continued support for Oracle Big Data Appliance and the Exadata Database Machine, Release 3.0.1 includes further improvements to Big Data SQL support for platforms other than Oracle Engineered Systems. These currently include Hortonworks Data Platform (HDP) and Cloudera’s Distribution Including Apache Hadoop (CDH ) running on non-Big Data Appliance commodity hardware where these Hadoop systems are used in conjunction with Oracle Database running on non-Exadata servers.</p> <div class="section"> <p class="subhead2">Support for Newer CDH and HDP Platforms</p> </div>  <p>Oracle Big Data SQL 3.0.1 runs on Hortonworks Hadoop Data Platform (HDP) 2.3 – 2.4.x and Cloudera’s Distribution Including Apache Hadoop (CDH) 5.5 – 5.7.</p> <div class="section"> <p class="subhead2">Improved Installation Automation</p> </div>  <p>The installation on HDP and CDH now automatically saves the YARN resource management configuration for later restoration.</p> <p>The <code>oracle</code> user and <code>oinstall</code> group setup are now managed by the installation program.</p> <div class="section"> <p class="subhead2">Uniform Uninstall Procedure for HDP and CDH</p> </div>  <p>The uninstall procedure is now the same for both HDP and CDH systems.</p> <div class="section"> <p class="subhead2">Other Changes for HDP and CDH</p> </div>  <ul style="list-style-type: disc;"> <li> <p>The default JDK is upgraded to jdk-8u66-linux-x64</p> </li> <li> <p><code>bds-database-create-bundle.sh</code> includes a new <code>--jdk-tar-path</code> parameter for specifying a JDK other than the default.</p> </li> <li> <p><code>bds-database-install.sh</code> includes two new parameters:</p> <ul style="list-style-type: disc;"> <li> <p><code>--cell-config-dir</code></p> </li> <li> <p><code>--root-script-only</code></p> </li> </ul> </li> <li> <p>The installation process now creates and populates <code>cellinit.ora</code> if the file does not exist or is empty.</p> </li> </ul> <div class="section"> <p class="subhead2">Oracle Shell for Hadoop Loaders</p> </div>  <p>Oracle Shell for Hadoop Loaders is a helper shell that provides a simple-to-use command line interface to Copy to Hadoop, Oracle Loader for Hadoop, and Oracle SQL Connector for HDFS.</p> <div class="section"> <p class="subhead2">Support for Oracle Big Data Appliance 4.5</p> </div>  <p>Oracle Big Data SQL Release 3.0.1 is a mammoth installation option in Oracle Big Data Appliance 4.5. You can also enable Oracle Big Data SQL Release 3.0.1 at any time after the mammoth installation by using the bdacli utililty.</p> <div class="section"> <div class="infobox-note" id="GUID-3FB3E7BA-399B-4016-9E27-4237AFB61642__GUID-EC330469-2394-44B9-9859-CB9DFD143D81"> <p class="notep1">Note:</p> In Release 3.0.1, Oracle Big Data SQL does not yet support connections between Oracle Big Data Appliance and non-Exadata Oracle Database servers, or between non-Big Data Appliance Hadoop systems and the Exadata Database Machine.</div> </div> </div> </div> <div class="sect2"><a id="GUID-F5F49306-8570-4E2A-AA56-D3F29A0C4CB7"></a> <h2 id="BDSUG-GUID-F5F49306-8570-4E2A-AA56-D3F29A0C4CB7" class="sect2">Changes in Oracle Big Data SQL 3.0</h2> <div> <p>A significant change in Oracle Big Data SQL 3.0 was the expansion of support to non-Oracle servers in addition to support for Oracle Big Data Appliance/Oracle Exadata Database Machine installations. Another feature added in this release was predicate push down.</p> <div class="section"> <p class="subhead2">Support for Servers Other than Oracle Engineered Systems</p> </div>  <p>Prior to Release 3.0, Oracle Big Data SQL supported only Oracle Engineered Systems. Specifically, Oracle Big Data Appliance (on the Hadoop side), and Oracle Exadata Database Machine (on the database server side). As of Release 3.0, Oracle Big Data SQL also runs on the <span class="bold">Hortonworks Hadoop Data Platform</span> and on <span class="bold">Cloudera’s Distribution Including Apache Hadoop (CDH)</span> systems other than Oracle Big Data Appliance.</p> <p>Big Data SQL also now supports Oracle Database running on servers other than Oracle Exadata Database Machine.</p> <div class="section"> <p class="subhead2">Predicate Push Down</p> </div>  <p>Big Data SQL 3.0 takes advantage of predicate off-loading support by pushing SARGable (<span class="italic">Search ARGument ABLE)</span> predicates from Oracle Database into supporting systems. See <a href="concepts.htm#GUID-5F5D41D3-24B0-4528-B7F3-26C1E57BDE35">About Predicate Push Down</a></p> </div> </div> </div>  </div>  <footer></footer> <noscript> <p>Scripting on this page enhances content navigation, but does not change the content in any way.</p> </noscript> </body> </html>