You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Raghav Aggarwal (Jira)" <ji...@apache.org> on 2025/12/03 17:20:00 UTC
[jira] [Commented] (HIVE-29259) The result format of the desc catalog is messy
[ https://issues.apache.org/jira/browse/HIVE-29259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18042569#comment-18042569 ]
Raghav Aggarwal commented on HIVE-29259:
----------------------------------------
Hi [~zhangbutao] , I have faced similar issue in show processlist command. Attaching the screenshots for reference in the Jira under Attachement section.
After debugging I found, the that the maxColumnWidth needs to be configured in the following place. As the default value of maxColumnWidth is 50, any BufferedRow which has width more than 50, the header will have max width as 50 causing this "messy output"
[https://github.com/apache/hive/blob/ba0217ff17501fb849d8999e808d37579db7b4f1/beeline/src/java/org/apache/hive/beeline/BufferedRows.java#L87]
Please try to launch the beeline the following way. It is working for me.
{code:java}
beeline --maxColumnWidth=100{code}
Let me know your thoughts!
> 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
> Priority: Major
>
> 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)