Table of Contents
- Title and Copyright Information
- Preface
-
1
What Is Oracle Big Data SQL?
- 1.1 About Oracle External Tables
- 1.2 About the Access Drivers for Oracle Big Data SQL
- 1.3 About Smart Scan for Big Data Sources
- 1.4 About Storage Indexes
- 1.5 About Predicate Push Down
- 1.6 About Pushdown of Character Large Object (CLOB) Processing
- 1.7 About Aggregation Offload
- 1.8 About Oracle Big Data SQL Statistics
- 2 Installation
-
3
Use Oracle Big Data SQL to Access Data
- 3.1 About Creating External Tables
- 3.2 Create an External Table for Hive Data
- 3.3 Create an External Table for Oracle NoSQL Database
- 3.4 Create an Oracle External Table for Apache HBase
- 3.5 Create an Oracle External Table for HDFS Files
- 3.6 Create an Oracle External Table for Kafka Topics
- 3.7 Create an Oracle External Table for Object Store Access
- 3.8 Query External Tables
-
3.9
Oracle SQL Access to Kafka
- 3.9.1 About Oracle SQL Access to Kafka
- 3.9.2 Get Started with Oracle SQL Access to Kafka
- 3.9.3 Register a Kafka Cluster
- 3.9.4 Create Views to Access CSV Data in a Kafka Topic
- 3.9.5 Create Views to Access JSON Data in a Kafka Topic
- 3.9.6 Query Kafka Data as Continuous Stream
- 3.9.7 Explore Kafka Data from a Specific Offset
- 3.9.8 Explore Kafka Data from a Specific Timestamp
- 3.9.9 Load Kafka Data into Tables Stored in Oracle Database
- 3.9.10 Load Kafka Data into Temporary Tables
- 3.9.11 Customize Oracle SQL Access to Kafka Views
- 3.9.12 Reconfigure Existing Kafka Views
- 3.10 About Oracle Big Data SQL on the Database Server (Oracle Exadata Machine or Other)
-
4
Information Lifecycle Management: Hybrid
Access to Data in Oracle Database and Hadoop
- 4.1 Use Copy to Hadoop
- 4.2 Enable Access to Hybrid Partitioned Tables
- 5 Oracle Big Data SQL Security
-
6
Work With Query Server
- 6.1 About Oracle Big Data SQL Query Server
- 6.2 Important Terms and Concepts
- 6.3 Specify the Hive Databases to Synchronize With Query Server
- 6.4 Synchronize Query Server With Hive
- 6.5 Query Server Restarts and Metadata Persistence
-
6.6
Connect to Query Server
- 6.6.1 About Connecting to the Query Server
- 6.6.2 Copy the Client Wallet for TLS Connections
- 6.6.3 Connect to Non-Secure Hadoop Clusters
- 6.6.4 Connect to Secure Hadoop Clusters with Kerberos Authentication
- 6.6.5 Connect to Secure Hadoop Clusters with Password-Based Database Authentication
- 6.6.6 Administrative Connections
-
7
Oracle Big Data SQL Reference
-
7.1
CREATE TABLE ACCESS
PARAMETERS Clause
- 7.1.1 Syntax Rules for Specifying Properties
- 7.1.2 ORACLE_HDFS Access Parameters
- 7.1.3 ORACLE_HIVE Access Parameters
-
7.1.4
Full List of Access Parameters for
ORACLE_HDFS and ORACLE_HIVE
- 7.1.4.1 com.oracle.bigdata.buffersize
- 7.1.4.2 com.oracle.bigdata.datamode
- 7.1.4.3 com.oracle.bigdata.colmap
- 7.1.4.4 com.oracle.bigdata.erroropt
- 7.1.4.5 com.oracle.bigdata.fields
- 7.1.4.6 com.oracle.bigdata.fileformat
- 7.1.4.7 com.oracle.bigdata.log.exec
- 7.1.4.8 com.oracle.bigdata.log.qc
- 7.1.4.9 com.oracle.bigdata.overflow
- 7.1.4.10 com.oracle.bigdata.rowformat
- 7.1.4.11 com.oracle.bigdata.tablename
- 7.1.5 ORACLE_BIGDATA Access Parameters
- 7.2 Static Data Dictionary Views for Hive
- 7.3 DBMS_BDSQL PL/SQL Package
- 7.4 DBMS_BDSQS PL/SQL Package
- 7.5 DBMS_BDSQS_ADMIN PL/SQL Package
- 7.6 DBMS_HADOOP PL/SQL Package
-
7.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 Oracle Big Data SQL Software Accessibility Recommendations
-
A
Manual Steps for Using Copy to Hadoop for Staged Copies
- Index