[
https://issues.apache.org/jira/browse/IMPALA-1682?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17553720#comment-17553720
]
ASF subversion and git services commented on IMPALA-1682:
---------------------------------------------------------
Commit c7784bde55d86a25388f5a61e64cda47a3ccaeee in impala's branch
refs/heads/master from yx91490
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=c7784bde5 ]
IMPALA-1682: Support printing the output of a query (rows) vertically.
In vertical mode, impala-shell will print each row in the format:
firstly print a line contains line number, then print this row's columns
line by line, each column line started with it's name and a colon.
To enable it: use shell option '-E' or '--vertical', or 'set VERTICAL=
true' in interactive mode. to disable it in interactive mode: 'set
VERTICAL=false'. NOTICE: it will be disabled if '-B' option or 'set
WRITE_DELIMITED=true' is specified.
Tests:
add methods in test_shell_interactive.py and test_shell_commandline.py.
Change-Id: I5cee48d5a239d6b7c0f51331275524a25130fadf
Reviewed-on: http://gerrit.cloudera.org:8080/18549
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>
> Support '\G' in shell
> ---------------------
>
> Key: IMPALA-1682
> URL: https://issues.apache.org/jira/browse/IMPALA-1682
> Project: IMPALA
> Issue Type: New Feature
> Components: Clients
> Affects Versions: Impala 2.1
> Reporter: Philip Martin
> Assignee: yx91490
> Priority: Minor
> Labels: shell
>
> MySQL has a feature {{\G}} to return query results in the transform, with one
> column per line, like so:
> {code}
> mysql> select * from tests limit 1 \G
> *************************** 1. row ***************************
> id: 2
> run_id: 1
> module: test_activity_monitoring
> class: ActivityMonitoringTests
> func: test_kill_job
> start_time: 2012-08-07 10:45:37
> end_time: 2012-08-07 10:46:06
> result: pass
> error_message: NULL
> stacktrace: NULL
> 1 row in set (0.01 sec)
> {code}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
