hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-12994) Implement support for NULLS FIRST/NULLS LAST
Date Thu, 11 Feb 2016 10:05:18 GMT

     [ https://issues.apache.org/jira/browse/HIVE-12994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jesus Camacho Rodriguez updated HIVE-12994:
-------------------------------------------
    Attachment: HIVE-12994.04.patch

Rebasing patch.

> Implement support for NULLS FIRST/NULLS LAST
> --------------------------------------------
>
>                 Key: HIVE-12994
>                 URL: https://issues.apache.org/jira/browse/HIVE-12994
>             Project: Hive
>          Issue Type: New Feature
>          Components: CBO, Metastore, Parser, Serializers/Deserializers
>    Affects Versions: 2.1.0
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>         Attachments: HIVE-12994.01.patch, HIVE-12994.02.patch, HIVE-12994.03.patch, HIVE-12994.04.patch,
HIVE-12994.patch
>
>
> From SQL:2003, the NULLS FIRST and NULLS LAST options can be used to determine whether
nulls appear before or after non-null data values when the ORDER BY clause is used.
> SQL standard does not specify the behavior by default. Currently in Hive, null values
sort as if lower than any non-null value; that is, NULLS FIRST is the default for ASC order,
and NULLS LAST for DESC order.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message