[HIVE-12994] Implement support for NULLS FIRST/NULLS LAST - ASF JIRA

XML

Word

Printable

JSON

Details

Type: New Feature
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: 2.1.0
Fix Version/s: 2.1.0
Component/s: CBO, Parser, Serializers/Deserializers
Labels:
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

- Sort By Name
- Sort By Date
- Ascending
- Descending

HIVE-12994.12.patch
01/Mar/16 13:53
1.24 MB
jcamachorodriguez
HIVE-12994.11.patch
25/Feb/16 23:02
1.23 MB
jcamachorodriguez
HIVE-12994.10.patch
24/Feb/16 17:10
809 kB
jcamachorodriguez
HIVE-12994.09.patch
23/Feb/16 17:53
791 kB
jcamachorodriguez
HIVE-12994.08.patch
17/Feb/16 09:33
791 kB
jcamachorodriguez
HIVE-12994.07.patch
15/Feb/16 19:36
793 kB
jcamachorodriguez
HIVE-12994.06.patch
13/Feb/16 19:45
792 kB
jcamachorodriguez
HIVE-12994.06.patch
13/Feb/16 19:05
792 kB
jcamachorodriguez
HIVE-12994.05.patch
12/Feb/16 20:00
792 kB
jcamachorodriguez
HIVE-12994.04.patch
11/Feb/16 10:04
796 kB
jcamachorodriguez
HIVE-12994.03.patch
09/Feb/16 19:13
796 kB
jcamachorodriguez
HIVE-12994.02.patch
09/Feb/16 00:54
795 kB
jcamachorodriguez
HIVE-12994.01.patch
05/Feb/16 17:51
219 kB
jcamachorodriguez
HIVE-12994.patch
03/Feb/16 20:47
197 kB
jcamachorodriguez

Issue Links

incorporates

HIVE-13210 Revert changes in HIVE-12994 related to metastore

Closed

links to

RB link

Activity

People

Assignee:: Jesús Camacho Rodríguez

Reporter:: Jesús Camacho Rodríguez

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 03/Feb/16 20:38

Updated:: 27/Feb/24 22:24

Resolved:: 02/Mar/16 11:01