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 HDFS
- 1.1.4 About Storage Indexes
- 1.1.5 About Predicate Push Down
- 1.1.6 Predicate Pushdown Issue with Parquet Files Created From Hive Source
- 1.1.7 About Pushdown of Character Large Object (CLOB) Processing
- 1.1.8 About Oracle Big Data SQL Statistics
- 1.2 Installation
-
1.1
What Is Oracle Big Data SQL?
-
2
Using Oracle Big Data SQL for Data Access
- 2.1 Creating an Oracle External Table for Hive Data
- 2.2 Creating an Oracle External Table for Oracle NoSQL Database
- 2.3 Creating an Oracle External Table for Apache HBase
- 2.4 Creating an Oracle External Table for HDFS Files
- 2.5 Creating an Oracle External Table for Kafka Topics
- 2.6 Using the Custom Parquet Reader for Oracle Big Data SQL
- 2.7 About the SQL CREATE TABLE Statement
- 2.8 About Data Type Conversions
- 2.9 Querying External Tables
- 2.10 About Oracle Big Data SQL on the Database Server (Oracle Exadata Machine or Other)
-
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 Using Copy to Hadoop to do Direct Copies
- 3.1.5 Using Copy to Hadoop to do Staged Copies
- 3.1.6 Querying the Data in Hive
- 3.1.7 About Column Mappings and Data Type Conversions
- 3.1.8 Working With Spark
- 3.1.9 Using Oracle SQL Developer with Copy to Hadoop
- 3.2 Storing Oracle Tablespaces in HDFS
-
3.1
Using Copy to Hadoop
-
4
Oracle Big Data SQL Reference
- 4.1 DBMS_HADOOP PL/SQL Package
- 4.2 DBMS_BDSQL PL/SQL Package
-
4.3
CREATE TABLE ACCESS PARAMETERS Clause
- 4.3.1 Syntax Rules for Specifying Properties
- 4.3.2 ORACLE_HDFS Access Parameters
- 4.3.3 ORACLE_HIVE Access Parameters
- 4.3.4 com.oracle.bigdata.buffersize
- 4.3.5 com.oracle.bigdata.colmap
- 4.3.6 com.oracle.bigdata.datamode
- 4.3.7 com.oracle.bigdata.erroropt
- 4.3.8 com.oracle.bigdata.fields
- 4.3.9 com.oracle.bigdata.fileformat
- 4.3.10 com.oracle.bigdata.log.exec
- 4.3.11 com.oracle.bigdata.log.qc
- 4.3.12 com.oracle.bigdata.overflow
- 4.3.13 com.oracle.bigdata.rowformat
- 4.3.14 com.oracle.bigdata.tablename
- 4.4 Static Data Dictionary Views for Hive
-
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
- E Licensing Information
- F Change History for Previous Releases
-
A
Manual Steps for Using Copy to Hadoop for Staged Copies
- Index