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 Thu, 29 Sep 2016 07:35:20 GMT

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

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

Here's how you can get wiki write access:

* [About This Wiki -- How to get permission to edit | https://cwiki.apache.org/confluence/display/Hive/AboutThisWiki#AboutThisWiki-Howtogetpermissiontoedit]

You can put a draft in the wiki and I'll edit it if any changes are needed.

> 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