Jesus Camacho Rodriguez created HIVE-12994:
----------------------------------------------

             Summary: 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


>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)

Reply via email to