hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lefty Leverenz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-5867) JDBC driver and beeline should support executing an initial SQL script
Date Wed, 28 Sep 2016 06:39:21 GMT

    [ https://issues.apache.org/jira/browse/HIVE-5867?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15528603#comment-15528603
] 

Lefty Leverenz commented on HIVE-5867:
--------------------------------------

Doc note:  This needs to be documented in the wiki for release 2.2.0.

* [HiveServer2 Clients -- JDBC | https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-JDBC]

Added a TODOC2.2 label.

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

Mime
View raw message