[
https://issues.apache.org/jira/browse/HIVE-5867?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15559594#comment-15559594
]
Jianguo Tian edited comment on HIVE-5867 at 10/9/16 8:35 AM:
-------------------------------------------------------------
I have added "initFile=<file>" option in the JDBC URL, now you can see some
changes on wiki about "Connection URL Format" and "Connection URL for Remote or
Embedded Mode".
was (Author: jonnyr):
I have added "initFile=<file>" option in the JDBC URL, now you can see some
changes about "Connection URL Format" and "Connection URL for Remote or
Embedded Mode".
> 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
> Assignee: Jianguo Tian
> Labels: TODOC2.2
> Fix For: 2.2.0
>
> Attachments: HIVE-5867.1.patch, HIVE-5867.2.patch, HIVE-5867.3 .patch
>
>
> 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.3.4#6332)
