Table of Contents
- Title and Copyright Information
- Preface
-
1
Introducing Oracle Big Data SQL
-
1.1
What Is Oracle Big Data SQL?
- 1.1.1 About Oracle External Tables
- 1.1.2 About the Access Drivers for Oracle Big Data SQL
- 1.1.3 About Smart Scan for Big Data Sources
- 1.1.4 About Storage Indexes
- 1.1.5 About Predicate Push Down
- 1.1.6 About Pushdown of Character Large Object (CLOB) Processing
- 1.1.7 About Aggregation Offload
- 1.1.8 About Oracle Big Data SQL Statistics
- 1.2 Installation
- 1.3 Security Overview
-
1.1
What Is Oracle Big Data SQL?
-
2
Using Oracle Big Data SQL for Data Access
-
2.1
Creating External Tables
- 2.1.1 About the SQL CREATE TABLE Statement
- 2.1.2 Creating an Oracle External Table for Hive Data
- 2.1.3 Creating an Oracle External Table for Oracle NoSQL Database
- 2.1.4 Creating an Oracle External Table for Apache HBase
- 2.1.5 Creating an Oracle External Table for HDFS Files
- 2.1.6 Creating an Oracle External Table for Kafka Topics
- 2.1.7 Creating an Oracle External Table for Object Store Access
- 2.2 Querying External Tables
- 2.3 About Oracle Big Data SQL on the Database Server (Oracle Exadata Machine or Other)
-
2.1
Creating External Tables
-
3
Storing Oracle Data in Hadoop
-
3.1
Using Copy to Hadoop
- 3.1.1 What Is Copy to Hadoop?
- 3.1.2 Getting Started Using Copy to Hadoop
- 3.1.3 Using Oracle Shell for Hadoop Loaders With Copy to Hadoop
- 3.1.4 Copy to Hadoop by Example
- 3.1.5 Querying the Data in Hive
- 3.1.6 Column Mappings and Data Type Conversions in Copy to Hadoop
- 3.1.7 Working With Spark
- 3.1.8 Using Oracle SQL Developer with Copy to Hadoop
- 3.2 Storing Oracle Tablespaces in HDFS
-
3.1
Using Copy to Hadoop
- 4 Working With Query Server
-
5
Oracle Big Data SQL Reference
-
5.1
CREATE TABLE ACCESS PARAMETERS Clause
- 5.1.1 Syntax Rules for Specifying Properties
- 5.1.2 ORACLE_HDFS Access Parameters
- 5.1.3 ORACLE_HIVE Access Parameters
-
5.1.4
Full List of Access Parameters for ORACLE_HDFS and ORACLE_HIVE
- 5.1.4.1 com.oracle.bigdata.buffersize
- 5.1.4.2 com.oracle.bigdata.datamode
- 5.1.4.3 com.oracle.bigdata.colmap
- 5.1.4.4 com.oracle.bigdata.erroropt
- 5.1.4.5 com.oracle.bigdata.fields
- 5.1.4.6 com.oracle.bigdata.fileformat
- 5.1.4.7 com.oracle.bigdata.log.exec
- 5.1.4.8 com.oracle.bigdata.log.qc
- 5.1.4.9 com.oracle.bigdata.overflow
- 5.1.4.10 com.oracle.bigdata.rowformat
- 5.1.4.11 com.oracle.bigdata.tablename
- 5.1.5 ORACLE_BIGDATA Access Parameters
- 5.2 Static Data Dictionary Views for Hive
- 5.3 DBMS_BDSQL PL/SQL Package
- 5.4 DBMS_BDSQS_ADMIN PL/SQL Package
- 5.5 DBMS_HADOOP PL/SQL Package
-
5.1
CREATE TABLE ACCESS PARAMETERS Clause
-
Appendices
-
A
Manual Steps for Using Copy to Hadoop for Staged Copies
- A.1 Generating the Data Pump Files
- A.2 Copying the Files to HDFS
- A.3 Creating a Hive Table
- A.4 Example Using the Sample Schemas
- B Using Copy to Hadoop With Direct Copy
- C Using mtactl to Manage the MTA extproc
-
D
Diagnostic Tips and Details
- D.1 Running Diagnostics with bdschecksw
- D.2 How to do a Quick Test
- D.3 Oracle Big Data SQL Database Objects
- D.4 Other Database-Side Artifacts
- D.5 Hadoop Datanode Artifacts
- D.6 Step-by-Step Process for Querying an External Table
- D.7 Step-by-Step for a Hive Data Dictionary Query
- D.8 Key Adminstration Tasks for Oracle Big Data SQL
- D.9 Additional Java Diagnostics
- D.10 Checking for Correct Oracle Big Data SQL Patches
- D.11 Debugging SQL.NET Issues
- E Change History for Previous Releases
- F Oracle Big Data SQL Software Accessibility Recommendations
-
A
Manual Steps for Using Copy to Hadoop for Staged Copies
- Index