[
https://issues.apache.org/jira/browse/HIVE-29259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18042569#comment-18042569
]
Raghav Aggarwal edited comment on HIVE-29259 at 12/3/25 5:27 PM:
-----------------------------------------------------------------
Hi [~zhangbutao] , I have faced similar issue in show processlist command.
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!
was (Author: JIRAUSER295901):
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)
