You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by Navis Ryu <na...@nexr.com> on 2014/05/07 06:10:18 UTC

Re: Review Request 19984: Beeline should accept -i option to Initializing a SQL file

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/19984/
-----------------------------------------------------------

(Updated May 7, 2014, 4:10 a.m.)


Review request for hive.


Changes
-------

Addressed comments


Bugs: HIVE-6561
    https://issues.apache.org/jira/browse/HIVE-6561


Repository: hive-git


Description
-------

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}


Diffs (updated)
-----

  beeline/src/java/org/apache/hive/beeline/BeeLine.java 5773109 
  beeline/src/java/org/apache/hive/beeline/BeeLineOpts.java 44cabdf 
  beeline/src/java/org/apache/hive/beeline/Commands.java 493f963 
  beeline/src/main/resources/BeeLine.properties 697c29a 

Diff: https://reviews.apache.org/r/19984/diff/


Testing
-------


Thanks,

Navis Ryu


Re: Review Request 19984: Beeline should accept -i option to Initializing a SQL file

Posted by Navis Ryu <na...@nexr.com>.

> On May 7, 2014, 9:44 p.m., Xuefu Zhang wrote:
> > beeline/src/java/org/apache/hive/beeline/BeeLine.java, line 726
> > <https://reviews.apache.org/r/19984/diff/3/?file=575958#file575958line726>
> >
> >     In previous implementation, executing a script file happens after info(getApplicationTitle()), but new code will do that befort the call. Does this have any side-effect?

It's original behavior of script file(-f). Seemed not make additional problems, at least.


> On May 7, 2014, 9:44 p.m., Xuefu Zhang wrote:
> > beeline/src/java/org/apache/hive/beeline/BeeLine.java, line 805
> > <https://reviews.apache.org/r/19984/diff/3/?file=575958#file575958line805>
> >
> >     Does removing this line has any side-effect?

Exiting or not is decided by caller, so I resumed it's meaningless to set exit=true/close connection in here. For stdin and script(-f), always exit closing all connections. For script(-i), always not exit. In the latter case, should we close current connection? I cannot sure of it.


> On May 7, 2014, 9:44 p.m., Xuefu Zhang wrote:
> > beeline/src/java/org/apache/hive/beeline/BeeLine.java, line 810
> > <https://reviews.apache.org/r/19984/diff/3/?file=575958#file575958line810>
> >
> >     While it's good to simply and clean up the old code, in general I'd like to have separate JIRA tracking each problem. This is fine. My only concern though, is that the old code seems trying to overcome some difficulty. I'm not sure the new implementation will cover that.

I remember I've confirmed the behavior on the new code. But rolled-back as you said.


- Navis


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/19984/#review42430
-----------------------------------------------------------


On May 7, 2014, 4:10 a.m., Navis Ryu wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/19984/
> -----------------------------------------------------------
> 
> (Updated May 7, 2014, 4:10 a.m.)
> 
> 
> Review request for hive.
> 
> 
> Bugs: HIVE-6561
>     https://issues.apache.org/jira/browse/HIVE-6561
> 
> 
> Repository: hive-git
> 
> 
> Description
> -------
> 
> 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}
> 
> 
> Diffs
> -----
> 
>   beeline/src/java/org/apache/hive/beeline/BeeLine.java 5773109 
>   beeline/src/java/org/apache/hive/beeline/BeeLineOpts.java 44cabdf 
>   beeline/src/java/org/apache/hive/beeline/Commands.java 493f963 
>   beeline/src/main/resources/BeeLine.properties 697c29a 
> 
> Diff: https://reviews.apache.org/r/19984/diff/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Navis Ryu
> 
>


Re: Review Request 19984: Beeline should accept -i option to Initializing a SQL file

Posted by Xuefu Zhang <xz...@cloudera.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/19984/#review42430
-----------------------------------------------------------



beeline/src/java/org/apache/hive/beeline/BeeLine.java
<https://reviews.apache.org/r/19984/#comment76223>

    In previous implementation, executing a script file happens after info(getApplicationTitle()), but new code will do that befort the call. Does this have any side-effect?



beeline/src/java/org/apache/hive/beeline/BeeLine.java
<https://reviews.apache.org/r/19984/#comment76224>

    Does removing this line has any side-effect?



beeline/src/java/org/apache/hive/beeline/BeeLine.java
<https://reviews.apache.org/r/19984/#comment76225>

    While it's good to simply and clean up the old code, in general I'd like to have separate JIRA tracking each problem. This is fine. My only concern though, is that the old code seems trying to overcome some difficulty. I'm not sure the new implementation will cover that.


- Xuefu Zhang


On May 7, 2014, 4:10 a.m., Navis Ryu wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/19984/
> -----------------------------------------------------------
> 
> (Updated May 7, 2014, 4:10 a.m.)
> 
> 
> Review request for hive.
> 
> 
> Bugs: HIVE-6561
>     https://issues.apache.org/jira/browse/HIVE-6561
> 
> 
> Repository: hive-git
> 
> 
> Description
> -------
> 
> 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}
> 
> 
> Diffs
> -----
> 
>   beeline/src/java/org/apache/hive/beeline/BeeLine.java 5773109 
>   beeline/src/java/org/apache/hive/beeline/BeeLineOpts.java 44cabdf 
>   beeline/src/java/org/apache/hive/beeline/Commands.java 493f963 
>   beeline/src/main/resources/BeeLine.properties 697c29a 
> 
> Diff: https://reviews.apache.org/r/19984/diff/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Navis Ryu
> 
>


Re: Review Request 19984: Beeline should accept -i option to Initializing a SQL file

Posted by Thejas Nair <th...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/19984/#review42621
-----------------------------------------------------------


Can you also include a unit test for this ? It can go into TestBeeLineWithArgs.java


- Thejas Nair


On May 7, 2014, 4:10 a.m., Navis Ryu wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/19984/
> -----------------------------------------------------------
> 
> (Updated May 7, 2014, 4:10 a.m.)
> 
> 
> Review request for hive.
> 
> 
> Bugs: HIVE-6561
>     https://issues.apache.org/jira/browse/HIVE-6561
> 
> 
> Repository: hive-git
> 
> 
> Description
> -------
> 
> 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}
> 
> 
> Diffs
> -----
> 
>   beeline/src/java/org/apache/hive/beeline/BeeLine.java 5773109 
>   beeline/src/java/org/apache/hive/beeline/BeeLineOpts.java 44cabdf 
>   beeline/src/java/org/apache/hive/beeline/Commands.java 493f963 
>   beeline/src/main/resources/BeeLine.properties 697c29a 
> 
> Diff: https://reviews.apache.org/r/19984/diff/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Navis Ryu
> 
>


Re: Review Request 19984: Beeline should accept -i option to Initializing a SQL file

Posted by Navis Ryu <na...@nexr.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/19984/
-----------------------------------------------------------

(Updated June 17, 2014, 1:49 a.m.)


Review request for hive.


Changes
-------

Addressed comments


Bugs: HIVE-6561
    https://issues.apache.org/jira/browse/HIVE-6561


Repository: hive-git


Description
-------

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}


Diffs (updated)
-----

  beeline/src/java/org/apache/hive/beeline/BeeLine.java dcdd6f2 
  beeline/src/java/org/apache/hive/beeline/BeeLineOpts.java 44cabdf 
  beeline/src/java/org/apache/hive/beeline/Commands.java 94f74d2 
  beeline/src/main/resources/BeeLine.properties 697c29a 
  itests/hive-unit/src/test/java/org/apache/hive/beeline/TestBeeLineWithArgs.java 4d15e3c 

Diff: https://reviews.apache.org/r/19984/diff/


Testing
-------


Thanks,

Navis Ryu