You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Edward Capriolo (JIRA)" <ji...@apache.org> on 2010/12/16 21:41:03 UTC

[jira] Commented: (HIVE-355) print column:value format in hive cli "select * limit k"

    [ https://issues.apache.org/jira/browse/HIVE-355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12972204#action_12972204 ] 

Edward Capriolo commented on HIVE-355:
--------------------------------------

I understand the idea to support \G. However that will actually be tricky. Currently a ticket is open to print column headers that uses a set variable. We could add a variable that outputs in this matter but \G would be hacky. Is that ok?

> print column:value format in hive cli "select * limit k"
> --------------------------------------------------------
>
>                 Key: HIVE-355
>                 URL: https://issues.apache.org/jira/browse/HIVE-355
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Venky Iyer
>
> > select ...... \G
> metric: wallpost_volume
>    day: 2009-03-17
>  value: 9.31625e+07
> For tables with a lot of columns, it's very difficult to actually match up column to value. MySQL supports a \G terminator that causes it to print in a colname: value format which is very nice for this sort of thing. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.