Details
-
New Feature
-
Status: Closed
-
Major
-
Resolution: Fixed
-
2.1.0
-
None
Description
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.
Attachments
Attachments
Issue Links
- incorporates
-
HIVE-13210 Revert changes in HIVE-12994 related to metastore
-
- Closed
-
- links to