[ 
https://issues.apache.org/jira/browse/HIVE-10202?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Naveen Gangam updated HIVE-10202:
---------------------------------
    Attachment: HIVE-10202.patch

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

Reply via email to