This is the documentation for CDH 5.1.x. Documentation for other versions is available at Cloudera Documentation.

Supported Databases

Component

MySQL

SQLite

PostgreSQL

Oracle

Derby - see Note 4

Oozie

5.5, 5.6

–

8.4, 9.2

11gR2

Default

Flume

–

–

–

–

Default (for the JDBC Channel only)

Hue

5.5, 5.6

See Note 1

Default

8.4, 9.2

11gR2

–

Hive/Impala

5.5, 5.6

–

8.4, 9.2

11gR2

Default

Sentry

5.5, 5.6

 –

8.4, 9.2

11gR2

–

Sqoop 1

See Note 2

 –

See Note 2

See Note 2

–

Sqoop 2

See Note 3

 –

See Note 3

See Note 3

Default

Notes

  1. Cloudera's recommendations are:
    • For Red Hat and similar systems:
      • Use MySQL server version 5.0 (or higher) and version 5.0 client shared libraries on Red Hat 5 and similar systems.
      • Use MySQL server version 5.1 (or higher) and version 5.1 client shared libraries on Red Hat 6 and similar systems.

      If you use a higher server version than recommended here (for example, if you use 5.5) make sure you install the corresponding client libraries.

    • For SLES systems, use MySQL server version 5.0 (or higher) and version 5.0 client shared libraries.
    • For Ubuntu systems:
      • Use MySQL server version 5.5 (or higher) and version 5.0 client shared libraries on Precise (12.04).
  2. For the purposes of transferring data only, Sqoop 1 supports MySQL5.0 and above, PostgreSQL 8.4 and above, Oracle 10.2 and above, Teradata 13.10 and above, and Netezza TwinFin 5.0 and above. The Sqoop metastore works only with HSQLDB (1.8.0 and higher 1.x versions; the metastore does not work with any HSQLDB 2.x versions).
  3. Sqoop 2 can transfer data to and from MySQL5.0 and above, PostgreSQL 8.4 and above, Oracle 10.2 and above, and Microsoft SQL Server 2012 and above. The Sqoop 2 repository database is supported only on Derby.
  4. Derby is supported as shown in the table, but not always recommended. See the pages for individual components in the CDH 5 Installation Guide for recommendations.
Page generated September 3, 2015.