Changes in This Release for Oracle Big Data Connectors User's Guide

This preface contains the changes in Oracle Big Data Connectors Release 3 (3.0).

Changes in Oracle Big Data Connectors Release 3 (3.0)

The following are changes in Oracle Big Data Connectors User's Guide for Oracle Big Data Connectors Release 3 (3.0).

This table shows the software versions installed with Oracle Big Data Connectors 3.0:

Connector	Version
Oracle SQL Connector for HDFS	3.0.0
Oracle Loader for Hadoop	3.0.0
Oracle Data Integrator Application Adapter for Hadoop	11.1.7.0
Oracle XQuery for Hadoop	3.0.0
Oracle R Advanced Analytics for Hadoop	2.4

New Features

Oracle Big Data Connectors support Cloudera's Distribution including Apache Hadoop version 5 (CDH5). For other supported platforms, see the individual connectors in Chapter 1.

• Oracle SQL Connector for Hadoop Distributed File System

  • Supports partitioned Hive tables. You can query a partition or a range of partitions, and load only what you need for further analysis into tables in Oracle Database.

    See "Creating External Tables from Hive Tables".

  • Provides two new commands, -drop and -describe, to the command-line tool. These commands facilitate administering the external tables and location files generated by Oracle SQL Connector for HDFS.

    See "Using the ExternalTable Command-Line Tool".

  • Supports new data types introduced in Hive versions 0.12.0 and 0.13.0, and included in CDH5: char, date, decimal(p,s), and varchar.

    See "Data Type Mappings".

• Oracle Loader for Hadoop

  Supports partitioned Hive tables, so that you can load one or more partitions into Oracle Database as an alternative to the entire table.

  See "Hive Table Input Format".

• Oracle XQuery for Hadoop

  • Enables you to run Oracle XQuery for Hadoop queries from Apache Oozie. See "Running Queries from Apache Oozie".

  • Provides an Apache Solr adapter.

    See "Solr Adapter".

Deprecated Features

The following features are deprecated in this release, and may be desupported in a future release:

• Oracle SQL Connector for HDFS

  The -getDDL and -listLocations commands are superseded by -describe.

  See "ExternalTable Command-Line Tool Syntax".