hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Naveen Gangam (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-10202) Beeline outputs prompt+query on standard output when used in non-interactive mode
Date Fri, 17 Apr 2015 18:14:00 GMT

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

Naveen Gangam commented on HIVE-10202:
--------------------------------------

[~spena] I dont think thats desirable. My take is that --silent should supress additional
info but not the prompt in interactive mode. I will take another look. Perhaps a modification
to the fix for HIVE-10087. We atleast have  workaround to not use --silent for now. Thanks
for pointing this out.

> Beeline outputs prompt+query on standard output when used in non-interactive mode
> ---------------------------------------------------------------------------------
>
>                 Key: HIVE-10202
>                 URL: https://issues.apache.org/jira/browse/HIVE-10202
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 1.0.0
>            Reporter: Sergio Peña
>            Assignee: Naveen Gangam
>             Fix For: 1.2.0
>
>         Attachments: HIVE-10202.patch
>
>
> When passing a SQL script file to Hive CLI, the prompt+query is not sent to the standard
output nor standard error. This is totally fine because users might want to send only the
query results to the standard output, and parse the results from it.
> In the case of BeeLine, the promp+query is sent to the standard output causing extra
parsing on the user scripts to avoid reading the prompt+query. 
> Another drawback is in the security side. Sensitive queries are logged directly to the
files where the standard output is redirected.
> How to reproduce:
> {noformat}
> $ cat /tmp/query.sql 
> select * 
> from test
> limit 1;
> $ beeline --showheader=false --outputformat=tsv2 -u jdbc:hive2://localhost:10000 -f /tmp/query.sql
> /tmp/output.log 2> /tmp/error.log
> $ cat /tmp/output.log
> 0: jdbc:hive2://localhost:10000> select * 
> . . . . . . . . . . . . . . . .> from test
> . . . . . . . . . . . . . . . .> limit 1; 
> 451	451.713	false	y2dh7	["866","528","936"]
> 0: jdbc:hive2://localhost:10000>
> {noformat}
> We should avoid sending the prompt+query to the standard output/error whenever a script
file is passed to BeeLine.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message