Databases

Component

MySQL

SQLite

PostgreSQL

Oracle

Derby

Oozie

5.5

8.4

11gR2

Default

Flume

Default (for the JDBC Channel only)

Hue

5.5

Default

8.4

Hive

5.5

8.3

11gR2

Default

Sqoop

See Note 1

 

See Note 1

See Note 1

 

Sqoop 2

See Note 2

 

See Note 2

See Note 2

Default

  Note:
  1. For connectivity purposes only, Sqoop supports MySQL5.1, PostgreSQL 9.1.4, Oracle 10.2, Teradata 13.1, and Netezza TwinFin 5.0. 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).
  2. Sqoop 2 can transport data to and from MySQL5.1, PostgreSQL 9.1.4, Oracle 10.2, and Microsoft SQL Server 2012. The Sqoop 2 repository is supported only on Derby.