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

["Prasad Mujumdar (JIRA)" <ji...@apache.org>]

Prasad Mujumdar created HIVE-5867:
-------------------------------------

             Summary: JDBC driver and beeline should support executing an initial SQL script
                 Key: HIVE-5867
                 URL: https://issues.apache.org/jira/browse/HIVE-5867
             Project: Hive
          Issue Type: Improvement
          Components: Clients, JDBC
            Reporter: Prasad Mujumdar


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 
{noformat}
jdbc:hive2://localhost:10000/default;initScript=/home/user1/scripts/init.sql
{noformat}
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





--
This message was sent by Atlassian JIRA
(v6.1#6144)