hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xuefu Zhang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6561) Beeline should accept -i option to Initializing a SQL file
Date Thu, 03 Apr 2014 18:33:17 GMT

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

Xuefu Zhang commented on HIVE-6561:
-----------------------------------

While it's possible for Beeline to do some initialization w/o a connection, such as set color
or execute a shell command (HIVE-6694), per my experience, init script for Hive is mostly
used to control server behavior, such as loading jars or setting conf variables. Without a
connection, these become meaningless.

Hive CLI doesn't have the issue because a connection always exist, either embedded "server"
or a remote server. Beeline can be started w/o either an embedded server or remote server,
on the other hand.

When I said "doing it after connection", I really meant "doing immediately WHEN the connection
is made", which is the current Beeline behavior for variables that come either from connection
string or command line. I'd propose that we execute additional commands specified in the init
file whenever a connection is made. This is consistent with both Hive CLI and existing Beeline
behavior. Under this proposal, client-side initialization is skipped w/o a connection, but
I think we should be Okay: 1. most of time beeline will have a connection when started; 2.
user can do "!run script.init" to execute a script file w/o a connection.

> Beeline should accept -i option to Initializing a SQL file
> ----------------------------------------------------------
>
>                 Key: HIVE-6561
>                 URL: https://issues.apache.org/jira/browse/HIVE-6561
>             Project: Hive
>          Issue Type: Improvement
>    Affects Versions: 0.10.0, 0.11.0, 0.12.0
>            Reporter: Xuefu Zhang
>            Assignee: Navis
>         Attachments: HIVE-6561.1.patch.txt
>
>
> Hive CLI has -i option. From Hive CLI help:
> {code}
> ...
>  -i <filename>                    Initialization SQL file
> ...
> {code}
> However, Beeline has no such option:
> {code}
> xzhang@xzlt:~/apa/hive3$ ./packaging/target/apache-hive-0.14.0-SNAPSHOT-bin/apache-hive-0.14.0-SNAPSHOT-bin/bin/beeline
-u jdbc:hive2:// -i hive.rc
> ...
> Connected to: Apache Hive (version 0.14.0-SNAPSHOT)
> Driver: Hive JDBC (version 0.14.0-SNAPSHOT)
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> -i (No such file or directory)
> Property "url" is required
> Beeline version 0.14.0-SNAPSHOT by Apache Hive
> ...
> {code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message