[
https://issues.apache.org/jira/browse/HIVE-10202?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14492971#comment-14492971
]
Lefty Leverenz commented on HIVE-10202:
---------------------------------------
Nope, no output example in the docs. But the Beeline Command Options section
includes some usage notes and bug fixes so it could be mentioned there. The
current text is:
{quote}
Reduce the amount of informational messages displayed (true) or not (false). It
also stops displaying the log messages for the query from HiveServer2 (Hive
0.14 and later). Default is false.
Usage: beeline --silent=true
{quote}
* [HiveServer2 Clients -- Beeline Command Options |
https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-BeelineCommandOptions]
Thanks [~spena].
> 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)
