[
https://issues.apache.org/jira/browse/HIVE-14389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16194981#comment-16194981
]
Sanman Ganthe commented on HIVE-14389:
--------------------------------------
Command:
beeline --verbose=true -f hadoop_query.hql > test.txt
Output in test.txt
+---------------+-----------------+-
| column 1 | column 2 |
+---------------+-----------------+-
| A | AAAAAA |
| A | AAAAAA |
| A | AAAAAA |
| A | AAAAAA |
I want to see the query and output. This is what we would get before HDP 2.6.2
<Query from hql file>
+---------------+-----------------+-
| column 1 | column 2 |
+---------------+-----------------+-
| A | AAAAAA |
| A | AAAAAA |
| A | AAAAAA |
| A | AAAAAA |
> Beeline should not output query and prompt to stdout
> ----------------------------------------------------
>
> Key: HIVE-14389
> URL: https://issues.apache.org/jira/browse/HIVE-14389
> Project: Hive
> Issue Type: Improvement
> Components: Beeline
> Reporter: Vihang Karajgaonkar
> Assignee: Vihang Karajgaonkar
> Priority: Minor
> Fix For: 3.0.0, 2.4.0
>
> Attachments: HIVE-14389.01.patch, HIVE-14389.02.patch,
> HIVE-14389.03.patch, HIVE-14389.04.patch
>
>
> It seems that the Beeline prints the query along with the results in the
> stdout when a script file is passed. The output file in the example below
> needs to only have the results and not the query.
> {noformat}
> .vihang-MBP:bin vihang$ ./beeline --showheader=false --outformat=tsv2 -u
> "jdbc:hive2://localhost:10000" -f /tmp/query.sql > /tmp/query.out 2>
> /tmp/query.err
> OK
> $ cat /tmp/query.out
> 1: jdbc:hive2://localhost:10000/default> select * from likes limit 4;
> +-----------+--------------+--+
> | 1 | chocolate |
> | 1 | car |
> | 1 | games |
> | 1 | chess |
> +-----------+--------------+--+
> 1: jdbc:hive2://localhost:10000/default>
> 1: jdbc:hive2://localhost:10000/default>
> $
> {noformat}
> A lot of people use HiveCLI and in order to transition from HiveCLI scripts
> to Beeline, this needs to be taken care of. The output files generated by
> beeline should contain only the results and nothing else.
> Similarly, when not in silent mode, query are being printed out on stdout,
> which is adding garbage along with results, as just like HIVE CLI does, users
> would like to have only the results on stdout, not errors/debugging info/etc,
> like the full query.
> Query could be printed out, no problem, as long as it is not on stdout (with
> results), instead, it must be printed out along with the debugging info.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
