Sergio Peña created HIVE-10202:
----------------------------------
Summary: 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: Sergio Peña
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)
