Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-12994

Implement support for NULLS FIRST/NULLS LAST

    XMLWordPrintableJSON

    Details

      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

        1. HIVE-12994.12.patch
          1.24 MB
          Jesus Camacho Rodriguez
        2. HIVE-12994.11.patch
          1.23 MB
          Jesus Camacho Rodriguez
        3. HIVE-12994.10.patch
          809 kB
          Jesus Camacho Rodriguez
        4. HIVE-12994.09.patch
          791 kB
          Jesus Camacho Rodriguez
        5. HIVE-12994.08.patch
          791 kB
          Jesus Camacho Rodriguez
        6. HIVE-12994.07.patch
          793 kB
          Jesus Camacho Rodriguez
        7. HIVE-12994.06.patch
          792 kB
          Jesus Camacho Rodriguez
        8. HIVE-12994.06.patch
          792 kB
          Jesus Camacho Rodriguez
        9. HIVE-12994.05.patch
          792 kB
          Jesus Camacho Rodriguez
        10. HIVE-12994.04.patch
          796 kB
          Jesus Camacho Rodriguez
        11. HIVE-12994.03.patch
          796 kB
          Jesus Camacho Rodriguez
        12. HIVE-12994.02.patch
          795 kB
          Jesus Camacho Rodriguez
        13. HIVE-12994.01.patch
          219 kB
          Jesus Camacho Rodriguez
        14. HIVE-12994.patch
          197 kB
          Jesus Camacho Rodriguez

          Issue Links

            Activity

              People

              • Assignee:
                jcamachorodriguez Jesus Camacho Rodriguez
                Reporter:
                jcamachorodriguez Jesus Camacho Rodriguez
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: