[HIVE-9302] Beeline add commands to register local jdbc driver names and jars

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0
• Labels: TODOC1.2

Release Note

Add one new command for beeline: addlocaljar. With this command, users are able to add local jdbc driver jar file in the beeline side.

There are two kinds of use cases. One is to add an existing known driver like mysql driver or postgres driver. Current supported driver are postgres and mysql.
{noformat}
# beeline
beeline> !addlocaldriverjar /path/to/mysql-connector-java-5.1.27-bin.jar
beeline> !connect mysql://host:3306/testdb
{noformat}
And another is to add a customized driver.
{noformat}
# beeline
beeline>!addlocaldriverjar /path/to/DummyDriver-1.0-SNAPSHOT.jar
beeline>!addlocaldrivername org.apache.dummy.DummyDrive
beeline> !connect mysql://host:3306/testdb
{noformat}

• Assignee: Ferdinand Xu
• Reporter: Brock Noland
• Created: 08/Jan/15 00:12
• Updated: 01/Dec/19 06:37
• Resolved: 06/Mar/15 22:47

Description

At present if a beeline user uses add jar the path they give is actually on the HS2 server. It'd be great to allow beeline users to add local jdbc driver jars and register custom jdbc driver names.

Issue Links

• is related to: HIVE-11041 Update tests for HIVE-9302 after removing binaries
• relates to: HIVE-10674 jars should not be checked in to the source control repo
• links to: review board entry