[
https://issues.apache.org/jira/browse/HIVE-4858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13713959#comment-13713959
]
Edward Capriolo commented on HIVE-4858:
---------------------------------------
[~ashutoshc] That is interesting. I think we are better off fixing the problem
at the source. Most things are easier to understand if they are sorted, unless
there is a performance hit, or there is some other benefit to the a non sorted
order, for example if you want to know which grant was created first.
Do you get what I am saying? Like if you had to manually audit 1000 grants and
they were not sorted the first thing you would probably do is drop them into a
spread sheet and sort them.
Some things should not be sorted, like hives column definitions are in the
order of the columns in the text file.
> Sort "show grant" result to improve usability and testability
> -------------------------------------------------------------
>
> Key: HIVE-4858
> URL: https://issues.apache.org/jira/browse/HIVE-4858
> Project: Hive
> Issue Type: Improvement
> Components: CLI
> Affects Versions: 0.10.0, 0.11.0
> Reporter: Xuefu Zhang
> Assignee: Xuefu Zhang
> Priority: Minor
> Fix For: 0.11.1
>
> Attachments: HIVE-4858.1.patch, HIVE-4858.patch
>
>
> Currently Hive outputs the result of "show grant" command in no deterministic
> order. It outputs the set of each privilege type in the order of whatever
> returned from DB (DataNucleus). Randomness can arise and tests (depending on
> the order) can fail, especially in events of library upgrade (DN or JVM
> upgrade). Sorting the result will avoid the potential randomness and make the
> output more deterministic, thus not only improving the readability of the
> output but also making the test more robust.
--
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
