hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew Sherman (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-16974) Change the sort key for the schema tool validator to be <ID>
Date Tue, 27 Jun 2017 18:29:00 GMT

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

Andrew Sherman commented on HIVE-16974:
---------------------------------------

Would it be possible to use 'order by <name> nulls last' ?
You might have to have slightly different syntax for mysql.

> Change the sort key for the schema tool validator to be <ID>
> ------------------------------------------------------------
>
>                 Key: HIVE-16974
>                 URL: https://issues.apache.org/jira/browse/HIVE-16974
>             Project: Hive
>          Issue Type: Sub-task
>          Components: HiveServer2
>    Affects Versions: 3.0.0
>            Reporter: Naveen Gangam
>            Assignee: Naveen Gangam
>
> In HIVE-16729, we introduced ordering of results/failures returned by schematool's validators.
This allows fault injection testing to expect results that can be verified. However, they
were sorted on NAME values which in the HMS schema can be NULL. So if the introduced fault
has a NULL/BLANK name column value, the result could be different depending on the backend
database(if they sort NULLs first or last).
> So I think it is better to sort on a non-null column value.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message