hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thejas M Nair (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6928) Beeline should not chop off "describe extended" results by default
Date Sat, 14 Jun 2014 03:24:03 GMT

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

Thejas M Nair commented on HIVE-6928:
-------------------------------------

I have a few concerns about this patch.
This will change the output format on the fly. It is possible that for a query that was returning
results in table format would suddenly change to vertical format when some records in the
input changes. This sort of surprise is not good. I agree that truncating columns is also
not good.
I think we should instead improve the table format to wrap around the lines instead of truncating
them. Or look at how other databases command lines tend to format their results.

There is also a change proposed in HIVE-7224 that changes default to incremental output to
avoid OOM. This patch will result in disabling table format output with that option.


> Beeline should not chop off "describe extended" results by default
> ------------------------------------------------------------------
>
>                 Key: HIVE-6928
>                 URL: https://issues.apache.org/jira/browse/HIVE-6928
>             Project: Hive
>          Issue Type: Bug
>          Components: CLI
>            Reporter: Szehon Ho
>            Assignee: Chinna Rao Lalam
>         Attachments: HIVE-6928.1.patch, HIVE-6928.2.patch, HIVE-6928.patch
>
>
> By default, beeline truncates long results based on the console width like:
> {code}
> +-----------------------------+----------------------------------------------------------------------------------------------------------------------+
> |          col_name           |                                                     
                                                                |
> +-----------------------------+----------------------------------------------------------------------------------------------------------------------+
> | pat_id                      | string                                              
                                                                |
> | score                       | float                                               
                                                                |
> | acutes                      | float                                               
                                                                |
> |                             |                                                     
                                                                |
> | Detailed Table Information  | Table(tableName:refills, dbName:default, owner:hdadmin,
createTime:1393882396, lastAccessTime:0, retention:0, sd:Sto |
> +-----------------------------+----------------------------------------------------------------------------------------------------------------------+
> 5 rows selected (0.4 seconds)
> {code}
> This can be changed by !outputformat, but the default should behave better to give a
better experience to the first-time beeline user.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message