[SQOOP-3216] Expanded Metastore support for MySql, Oracle, Postgresql, MSSql, and DB2

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Component/s: metastore
• Assignee: Zach Berkowitz
• Reporter: Zach Berkowitz
• Created: 02/Aug/17 09:02
• Updated: 10/Apr/18 09:23
• Resolved: 25/Sep/17 11:19

Description

Reconfigured HsqldbJobStorage class to support MySql, Oracle, Postgresql, MSSql, and DB2 databases in addition to Hsqldb, renamed HsqldbJobStorage GenericJobStorage. This new class also serves the function of AutoHsqldbStorage, which has been removed.

Two new commands, --meta-username and --meta-password have been added to connect to metastore databases that require a username and password.

Added an enum class JdbcDrivers that holds Jdbc connection information.

Added two testClasses, MetaConnectIncrementalImportTest and JobToolTest, and modified TestSavedJobs (now SavedJobsTest) to test with all supported database services.

Issue Links

• is related to: SQOOP-3301 Document SQOOP-3216 - metastore related change
• relates to: SQOOP-3255 Sqoop ignores metastore properties defined in sqoop-site.xml
• links to: ReviewBoard