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

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

Thanks for the patch, [~navis]. I went thru it briefly and had the following 
questions:

1. When Beeline is started, it may not connect to any HS2. In that case, it 
probably doesn't make sense to execute the init file. This is different from 
Hive CLI, which will always have DB to work on.

2. When a Beeline makes a connection to a DB, we probably should execute the 
init file.

Thus, I was thinking that executing the init file is tied to a DB connection. 
No connection, no execution. For each connection, the init file should be 
execute once.

What is your thought on this?

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

Reply via email to