CINXE.COM
Oracle Big Data SQL - Big Data SQL
<!DOCTYPE html><html lang="en"><head> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="/sp_common/site-template/ohc-site-template/css/site.css"> <script data-main="/sp_common/site-template/ohc-site-template/js/site-config" src="/sp_common/site-template/requirejs/require.js"></script> <script> if(window.require === undefined) { document.write('<script data-main="sp_common/site-template/ohc-site-template/js/site-config" src="sp_common/site-template/requirejs/require.js"><\/script>'); document.write('<link href="sp_common/site-template/ohc-site-template/css/site.css" rel="stylesheet">'); } </script> <link rel="shortcut icon" href="/sp_common/site-template/ohc-common/img/favicon.ico"> <title>Oracle Big Data SQL - Big Data SQL</title> <meta name="description" content> <meta property="og:description" content> <meta property="og:site_name" content="Oracle Help Center"> <meta name="generator" content="Oracle Interface Page Generator 1.7.07.20"> <meta property="og:title" content="Oracle Big Data SQL - Big Data SQL"> <link rel="schema.dcterms" href="http://purl.org/dc/terms/"> <meta name="dcterms.created" content="2022-06-02T23:53:05.907Z"> <meta name="dcterms.dateCopyrighted" content="2022"> <meta name="dcterms.category" content="bigdata"> <meta name="dcterms.product" content="en/bigdata/big-data-sql"> <meta name="dcterms.title" content="Oracle Big Data SQL"> <meta name="dcterms.identifier" content="en/bigdata/big-data-sql"> <script id="ssot-metadata" type="application/json"> {"primary":{"category":{"short_name":"bigdata","element_name":"Big Data","display_in_url":true},"suite":{"short_name":"not-applicable","element_name":"Not Applicable","display_in_url":false},"product_group":{"short_name":"not-applicable","element_name":"Not applicable","display_in_url":false},"product":{"short_name":"big-data-sql","element_name":"Big Data SQL","display_in_url":true}}} </script> <script type="application/ld+json"> {"@context":"https://schema.org","@type":"WebPage","name":"Oracle Big Data SQL - Big Data SQL","description":"","datePublished":"2019-07-08 22:17:31 GMT","dateModified":"2022-06-02 23:54:24 GMT"} </script> <script>window.ohcglobal || document.write('<script src="/en/dcommon/js/global.js">\x3C/script>')</script></head> <body> <noscript> <div>JavaScript must be enabled to correctly display this content</div> </noscript> <div class="ohc-grid"> <div role="banner"> <div> <a href="#" class="offscreen skipto-top skipto">Go to main content</a> <nav class="navbar navbar-default"> <div class="container"> <div class="navbar-header"> <a class="navbar-brand" href="/"> <img alt="Oracle Help Center" src="https://docs.oracle.com/sp_common/site-template/ohc-common/img/ohc-logo.png" onerror="this.onerror='';this.src='sp_common/site-template/ohc-common/img/ohc-logo.png';"> </a> <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse-1"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> </div> <div class="collapse navbar-collapse" id="navbar-collapse-1"> <p class="navbar-text navbar-right logged-in-content hidden"><span class="append-firstname-greeting"></span> <a class="logout-link" href="#">Sign Out</a></p> <p class="navbar-text navbar-right logged-out-content hidden"><a class="login-link" href="#"><i class="fa fa-user"></i> Sign In</a></p> <form class="navbar-form ohc-search-form visible-xs-block" action="https://docs.oracle.com/apps/search/search.jsp" method="get"> <div class="form-group"> <div class="input-group"> <input type="text" class="form-control" name="q" aria-label="Search Query Field" placeholder="Search for..."> <span class="input-group-btn"> <button type="submit" class="btn btn-default" aria-label="Submit Search Query"> <span class="glyphicon glyphicon-search" aria-hidden="true"></span> <span class="sr-only">Search</span> </button> </span> </div> </div> <input type="hidden" name="category" value="bigdata"> <input type="hidden" name="product" value="en/bigdata/big-data-sql"> </form> <ul class="nav navbar-nav visible-xs-block"> <li><a href="/en/bigdata/index.html">Big Data</a></li> <li><a href="https://docs.oracle.com/en/bigdata/big-data-appliance/index.html">Big Data Appliance</a></li> <li><a href="https://docs.oracle.com/en/bigdata/big-data-connectors/index.html">Big Data Connectors</a></li> <li><a href="https://docs.oracle.com/cd/E93962_01/index.html">Big Data Discovery</a></li> <li><a href="https://docs.oracle.com/en/bigdata/big-data-spatial-graph/index.html">Big Data Spatial and Graph</a></li> <li><a href="index.html">Big Data SQL</a></li> </ul> </div> </div> </nav> </div> </div> <main> <div> <div class="ohc-grid"> <div> <div class="ohc-sidebar hidden-xs"> <form class="ohc-search-form" action="https://docs.oracle.com/apps/search/search.jsp" method="get"> <div class="form-group"> <div class="input-group"> <input type="text" class="form-control" name="q" aria-label="Search Query Field" placeholder="Search for..."> <span class="input-group-btn"> <button type="submit" class="btn btn-default" aria-label="Submit Search Query"> <span class="glyphicon glyphicon-search" aria-hidden="true"></span> <span class="sr-only">Search</span> </button> </span> </div> </div> <input type="hidden" name="category" value="bigdata"> <input type="hidden" name="product" value="en/bigdata/big-data-sql"> </form> <ul class="up"> <li><a href="/"><span class="glyphicon glyphicon-chevron-left" aria-hidden="true"> </span>Help Center Home</a></li> </ul> <ul class="links"> <li> <a href="/en/bigdata/index.html">Big Data </a> </li> </ul> <hr> <ul class="links"> <li> <a href="https://docs.oracle.com/en/bigdata/big-data-appliance/index.html">Big Data Appliance </a> </li> <li> <a href="https://docs.oracle.com/en/bigdata/big-data-connectors/index.html">Big Data Connectors </a> </li> <li> <a href="https://docs.oracle.com/cd/E93962_01/index.html">Big Data Discovery </a> </li> <li> <a href="https://docs.oracle.com/en/bigdata/big-data-spatial-graph/index.html">Big Data Spatial and Graph </a> </li> <li> <a href="index.html">Big Data SQL </a> </li> </ul> </div> <article class="container-fluid learning-path" role="main"> <img class="pull-right hidden-xs hidden-sm" src="sp_common/shared-images/12-bigdata.png" alt> <ol class="breadcrumb" vocab="http://schema.org/" typeof="BreadcrumbList"> <li property="itemListElement" typeof="ListItem"><a href="../../../../index.html" property="item" typeof="WebPage"><span property="name">Home</span></a><meta property="position" content="0"></li> <li property="itemListElement" typeof="ListItem"><a href="../index.html" property="item" typeof="WebPage"><span property="name">Big Data</span></a><meta property="position" content="1"></li> <li property="itemListElement" typeof="ListItem"><a href="index.html" property="item" typeof="WebPage"><span property="name">Big Data SQL</span></a><meta property="position" content="2"></li> </ol> <h1>Oracle Big Data SQL</h1> <div class="description"><p>Oracle Big Data SQL lets you use the full power of Oracle SQL to seamlessly access and integrate data stored across Oracle Database, Hadoop, Kafka, NoSQL, and object store sources. It extends Oracle Database security to all of your data. Its unique Smart Scan leverages the cluster to parse, intelligently filter and aggregate data where it resides. By distributing processing and minimizing data movement, Smart Scan maximizes query performance.</p></div> <h2 id="BigDataSQLReleases">Big Data SQL Releases</h2> <div class="section row"> </div> <form style="margin-top:12px;" autocomplete="off"> <select aria-label="Showing content for " style="width:auto" class="form-control section-selector"> <option data-target="#tab-0" aria-controls="tab-0">Big Data SQL 4.1.2</option> <option data-target="#tab-1" aria-controls="tab-1">Earlier Releases</option> </select> </form> <div class="tab-content"> <div class="tab-pane fade in active" id="tab-0"> <h2 id="LearnAboutBigDataSQL0">Learn About Big Data SQL</h2> <ul class="topics"> <li> <a href="4.1.2/index.html">Get Started </a> </li> </ul> <div class="section row"> </div> <h2 id="Tasks0">Tasks</h2> <ul class="topics"> <li> <a href="4.1.2/install.html">Install and Configure </a> </li> </ul> <div class="section row"> </div> <h2 id="Resources0">Resources</h2> <ul class="topics"> <li> <a href="4.1.2/books.html">Books </a> </li> <li> <a href="4.1.2/resources.html">Additional Resources </a> </li> </ul> <div class="section row"> </div> </div> <div class="tab-pane fade" id="tab-1"> <h2 id="EarlierReleases1">Earlier Releases</h2> <ul class="topics"> <li> <a href="https://docs.oracle.com/en/bigdata/big-data-sql/4.1.1/index.html">Oracle Big Data SQL 4.1.1 </a> </li> <li> <a href="https://docs.oracle.com/en/bigdata/big-data-sql/4.1/index.html">Oracle Big Data SQL 4.1 </a> </li> <li> <a href="https://docs.oracle.com/en/bigdata/big-data-sql/4.0/index.html">Oracle Big Data SQL 4.0 </a> </li> <li> <a href="https://docs.oracle.com/en/bigdata/big-data-sql/3.2.1.2/index.html">Oracle Big Data SQL 3.2.1.2 </a> </li> <li> <a href="https://docs.oracle.com/en/bigdata/big-data-sql/3.2.1.1/index.html">Oracle Big Data SQL 3.2.1.1 </a> </li> <li> <a href="https://docs.oracle.com/en/bigdata/big-data-sql/3.2.1/index.html">Oracle Big Data SQL 3.2.1 </a> </li> <li> <a href="https://docs.oracle.com/en/bigdata/big-data-sql/3.2/index.html">Oracle Big Data SQL 3.2 </a> </li> <li> <a href="https://docs.oracle.com/bigdata/bds31/index.htm">Oracle Big Data SQL 3.1 </a> </li> <li> <a href="https://docs.oracle.com/bigdata/bda45/BDSUG/preface.htm#BIGUG101">Oracle Big Data SQL 3.0.1 </a> </li> </ul> <div class="section row"> </div> </div> </div> </article> <div><div><!-- resizable column --></div></div> </div> </div> </div> </main> <a href="#" class="offscreen skipto-bottom skipto">Back to main content</a> <footer> <div> <div class="container"> <div class="pull-left footer-left"> <ul class="footer-nav list-inline"> <li><a href="https://docs.oracle.com/pls/topic/lookup?ctx=en/legal&id=about">About Oracle</a></li> <li><a href="https://docs.oracle.com/pls/topic/lookup?ctx=en/legal&id=contact">Contact Us</a></li> <li><a href="https://docs.oracle.com/pls/topic/lookup?ctx=en/legal&id=privacy">Terms of Use and Privacy</a></li> <li><div id="teconsent" style="display: inline-block;"></div></li> </ul> <span class="copyright"><a href="https://docs.oracle.com/pls/topic/lookup?ctx=en/legal&id=cpyr">Copyright 漏 2022, Oracle and/or its affiliates.</a></span> </div> </div> </div> </footer> </div> </body></html>