Table of Contents
- Title and Copyright Information
- Preface
-
Part I Setup
-
1
Getting Started with Oracle Big Data Connectors
- About Oracle Big Data Connectors
- Big Data Concepts and Technologies
- Download and Install Oracle Big Data Connectors
- Certified Hadoop Platforms
- Secure Connection to Oracle Database
-
Oracle SQL Connector for Hadoop Distributed File System Setup
- Software Requirements
- Install and Configure a Hadoop Client on the Oracle Database System
- Install Oracle SQL Connector for HDFS
- Oracle Database Privileges for OSCH Users
- OS-Level Requirements for OSCH Users
- Use Oracle SQL Connector for HDFS on a Secure Hadoop Cluster
- Use OSCH in Oracle SQL Developer
- Oracle Loader for Hadoop Setup
- Oracle Shell for Hadoop Loaders Setup
- Oracle XQuery for Hadoop Setup
- Oracle R Advanced Analytics for Hadoop Setup
- Oracle Data Integrator
- Oracle Datasource for Apache Hadoop Setup
-
1
Getting Started with Oracle Big Data Connectors
-
Part II Oracle Database Connectors
-
2
Oracle SQL Connector for Hadoop Distributed File System
- About Oracle SQL Connector for HDFS
- Getting Started With Oracle SQL Connector for HDFS
- Configure Your System for Oracle SQL Connector for HDFS
- Use Oracle SQL Connector for HDFS with Oracle Big Data Appliance and Oracle Exadata
- Use the ExternalTable Command-Line Tool
-
Create External Tables
- Create External Tables with the ExternalTable Tool
- Create External Tables from Data Pump Format Files
- Create External Tables from Hive Tables
- Create External Tables from Delimited Text Files
- Create External Tables in SQL
- Update External Tables
- Explore External Tables and Location Files
- Drop Database Objects Created by Oracle SQL Connector for HDFS
- More About External Tables Generated by the ExternalTable Tool
- Configure Oracle SQL Connector for HDFS
- Performance Tips for Querying Data in HDFS
-
3
Oracle Loader for Apache Hadoop
- What Is Oracle Loader for Hadoop?
- Interfaces to Oracle Loader For Hadoop
- Get Started With Oracle Loader for Hadoop
-
Use Oracle Loader for Hadoop With the Hadoop
Command Line Utility
- About the Modes of Operation
- Create the Target Table
- Create a Job Configuration File
- Establish Secure Connections to Oracle Database Using SSL and Oracle Wallet
- About Input Formats
- Mapping Input Fields to Target Table Columns
- About Output Formats
- Run a Loader Job
- Handling Rejected Records
- Balancing Loads When Loading Data into Partitioned Tables
- Optimize Communications Between Oracle Engineered Systems
- Oracle Loader for Hadoop Configuration Property Reference
- 4 Ease of Use Tools for Oracle Big Data Connectors
-
2
Oracle SQL Connector for Hadoop Distributed File System
-
Part III Oracle XQuery for Apache Hadoop
- 5 Using Oracle XQuery for Apache Hadoop
-
6
Oracle XQuery for Apache Hadoop
Reference
- Avro File Adapter
- JSON File Adapter
- Oracle Database Adapter
-
Oracle NoSQL Database Adapter
- Prerequisites for Using the Oracle NoSQL Database Adapter
- Built-in Functions for Reading from and Writing to Oracle NoSQL Database
- Built-in Functions for Reading from and Writing to Oracle NoSQL Database using Table API
- Built-in Functions for Reading from and Writing to Oracle NoSQL Database using Large Object API
- Custom Functions for Reading Values from Oracle NoSQL Database
- Custom Functions for Retrieving Single Values from Oracle NoSQL Database
- Custom Functions for Reading Values from Oracle NoSQL Database using Table API
- Custom Functions for Reading Single Row from Oracle NoSQL Database using Table API
- Custom Functions for Retrieving Single Values from Oracle NoSQL Database using Large Object API
- Custom Functions for Writing to Oracle NoSQL Database
- Custom Functions for Writing Values to Oracle NoSQL Database using Table API
- Custom Functions for Writing Values to Oracle NoSQL Database using Large Object API
- Examples of Oracle NoSQL Database Adapter Functions
- Oracle NoSQL Database Adapter Configuration Properties
- Sequence File Adapter
- Solr Adapter
- Text File Adapter
- Tika File Adapter
- XML File Adapter
- Utility Module
- Hadoop Module
- Serialization Annotations
-
7
Oracle XML Extensions for Hive
- What are the XML Extensions for Hive?
- Use the Hive Extensions From the Command Line
- Use the Hive Extensions in HiveServer2
- About the Hive Functions
- Permanently Declaring the Hive Functions
- Create XML Tables
- Oracle XML Functions for Hive Reference
- Online Documentation of Functions
- xml_exists
- xml_query
- xml_query_as_primitive
- xml_table
-
Part IV Oracle R Advanced Analytics for Apache Hadoop
- 8 Oracle R Advanced Analytics for Apache Hadoop
- Part V Oracle DataSource for Apache Hadoop
- Appendices
- Index