F.2 Changes in Oracle Big Data SQL 3.0.1

The following are changes in Oracle Big Data SQL Release 3.0.1.

In addition to continued support for Oracle Big Data Appliance and the Exadata Database Machine, Release 3.0.1 includes further improvements to Big Data SQL support for platforms other than Oracle Engineered Systems. These currently include Hortonworks Data Platform (HDP) and Cloudera’s Distribution Including Apache Hadoop (CDH ) running on non-Big Data Appliance commodity hardware where these Hadoop systems are used in conjunction with Oracle Database running on non-Exadata servers.

Support for Newer CDH and HDP Platforms

Oracle Big Data SQL 3.0.1 runs on Hortonworks Hadoop Data Platform (HDP) 2.3 – 2.4.x and Cloudera’s Distribution Including Apache Hadoop (CDH) 5.4.7 – 5.7. CDH 5.4.7 support includes both commodity CDH systems and Oracle Big Data Appliance 4.3.

Improved Installation Automation

The installation on HDP and CDH now automatically saves the YARN resource management configuration for later restoration.

The oracle user and oinstall group setup are now managed by the installation program.

Uniform Uninstall Procedure for HDP and CDH

The uninstall procedure is now the same for both HDP and CDH systems.

Other Changes for HDP and CDH

  • The default JDK is upgraded to jdk-8u66-linux-x64

  • bds-database-create-bundle.sh includes a new --jdk-tar-path parameter for specifying a JDK other than the default.

  • bds-database-install.sh includes two new parameters:

    • --cell-config-dir

    • --root-script-only

  • The installation process now creates and populates cellinit.ora if the file does not exist or is empty.

Oracle Shell for Hadoop Loaders

Oracle Shell for Hadoop Loaders is a helper shell that provides a simple-to-use command line interface to Copy to Hadoop, Oracle Loader for Hadoop, and Oracle SQL Connector for HDFS.

Support for Oracle Big Data Appliance 4.5

Oracle Big Data SQL Release 3.0.1 is a mammoth installation option in Oracle Big Data Appliance 4.5. You can also enable Oracle Big Data SQL Release 3.0.1 at any time after the mammoth installation by using the bdacli utililty.

Note:

In Release 3.0.1, Oracle Big Data SQL does not yet support connections between Oracle Big Data Appliance and non-Exadata Oracle Database servers, or between non-Big Data Appliance Hadoop systems and the Exadata Database Machine.