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

Raghav Aggarwal commented on HIVE-29259:
----------------------------------------

Yes, I tried with *desc catalog* command as well and its working for me. 
Attaching the screeshot in attachment.

PS: For "hdfs://127.0.0.1:8028/user/hive/warehouse/hiveicetest" given in 
description has *53* char, hence with default value of maxColumnWidth i.e. 
{*}50{*}, it giving unformatted table output. If we make 
{_}maxColumnWidth{_}=100, then please ensure that in any column output the 
number of char doesn't exceed 100.

> The result format of the desc catalog is messy
> ----------------------------------------------
>
>                 Key: HIVE-29259
>                 URL: https://issues.apache.org/jira/browse/HIVE-29259
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Butao Zhang
>            Assignee: Raghav Aggarwal
>            Priority: Major
>         Attachments: MaxWidth_set_100.png, With_Default_MaxWidth.png, 
> desc_catalog_output.png
>
>
> At present, you can find the result format of desc catalog is messy & wrong, 
> e.g:
> {code:java}
> 0: jdbc:hive2://127.0.0.1:10000/default> desc catalog hive;
> +------------------+---------------------------------------------------------+------------+
> |   cat_name     |                      comment              | location  |
> +------------------+-------------------------------------------------------- 
> +-------------+
> | Catalog Name    | hive                                    | NULL    |
> | Comment       | Default catalog for Hive                       | NULL    |
> | Location      | hdfs://127.0.0.1:8028/user/hive/warehouse/hiveicetest   | 
> NULL     |
> +------------------+---------------------------------------------------------+------------+{code}
>  
>  
> *It should output the result in this format:*
> {code:java}
> 0: jdbc:hive2://127.0.0.1:10000/default> desc catalog hive;
> +------------------+-------------------------------------------------------+-------------------------------------------------------------+
> |   cat_name     |                 comment                   |              
> location                                      |
> +------------------+-------------------------------------------------------+-------------------------------------------------------------+
> |      hive       |       Default catalog for Hive              | 
> hdfs://127.0.0.1:8028/user/hive/warehouse/hiveicetest      |
> +------------------+-------------------------------------------------------+-------------------------------------------------------------+{code}
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to