[jira] [Commented] (IMPALA-1682) Support '\G' in shell

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ 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 <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>


> 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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org