[HIVE-5867] JDBC driver and beeline should support executing an initial SQL script

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.3.0
• Component/s: Clients, JDBC
• Assignee: Jianguo Tian
• Reporter: Prasad Suresh Mujumdar
• Created: 21/Nov/13 18:55
• Updated: 21/Jul/17 18:46
• Resolved: 27/Sep/16 03:34

Description

HiveCLI support the .hiverc script that is executed at the start of the session. This is helpful for things like registering UDFs, session specific configs etc.
This functionality is missing for beeline and JDBC clients. It would be useful for JDBC driver to support an init script with SQL statements that's automatically executed after connection. The script path can be specified via JDBC connection URL. For example

jdbc:hive2://localhost:10000/default;initScript=/home/user1/scripts/init.sql

This can be added to Beeline's command line option like "-i /home/user1/scripts/init.sql"

To help transition from HiveCLI to Beeline, we can keep the default init script as $HOME/.hiverc

Issue Links

• contains: HIVE-14676 JDBC driver should support executing an initial SQL script
• is related to: HIVE-6561 Beeline should accept -i option to Initializing a SQL file
• links to: RB

Sub-Tasks

• JDBC driver should support executing an initial SQL script: Resolved
• Beeline should support executing an initial SQL script: Resolved