[ 
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)

Reply via email to