You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2013/01/19 11:06:13 UTC

[jira] [Commented] (HIVE-3884) Better align columns in DESCRIBE table_name output to make more human-readable

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

Hudson commented on HIVE-3884:
------------------------------

Integrated in hive-trunk-hadoop1 #28 (See [https://builds.apache.org/job/hive-trunk-hadoop1/28/])
    HIVE-3884 Better align columns in DESCRIBE table_name output to make more
human-readable (Dilip Joseph via namit) (Revision 1435503)

     Result = ABORTED
namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1435503
Files : 
* /hive/trunk/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java
* /hive/trunk/conf/hive-default.xml.template
* /hive/trunk/ql/ivy.xml
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/JsonMetaDataFormatter.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/MetaDataFormatUtils.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/MetaDataFormatter.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/MetaDataPrettyFormatUtils.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/TextMetaDataFormatter.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/DescTableDesc.java
* /hive/trunk/ql/src/test/queries/clientpositive/describe_pretty.q
* /hive/trunk/ql/src/test/results/clientpositive/describe_pretty.q.out

                
> Better align columns in DESCRIBE table_name output to make more human-readable
> ------------------------------------------------------------------------------
>
>                 Key: HIVE-3884
>                 URL: https://issues.apache.org/jira/browse/HIVE-3884
>             Project: Hive
>          Issue Type: Improvement
>          Components: CLI
>    Affects Versions: 0.9.0
>            Reporter: Dilip Joseph
>            Assignee: Dilip Joseph
>            Priority: Minor
>             Fix For: 0.11.0
>
>         Attachments: describe_test_table.png, HIVE-3884.1.patch.txt, HIVE-3884.2.patch.txt
>
>
> If a table contains very long comments or very long column names, the output of DESCRIBE table_name is not aligned nicely.  The attached screenshot shows the following two problems:
> 1. Rows with long column names do not align well with other columns.
> 2. Rows with long comments wrap to the next line, and make it hard to read the output.  The wrapping behavior depends on the width of the user's terminal width.
> It will be nice to have a DESCRIBE PRETTY table_name command that will produce nicely formatted output that avoids the two problems mentioned above.  It is better to introduce a new DESCRIBE PRETTY command rather than change the behavior of the existing DESCRIBE or DESCRIBE FORMATTED commands, so that we avoid breaking any scripts that automatically parse the output.
> Since the pretty formatting depends on the current terminal width, we need a new hive conf parameter to tell the CLI to auto-detect the current terminal width or to use a fixed width (needed for unit tests).

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira