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.patch
          197 kB
          jcamachorodriguez
        2. HIVE-12994.12.patch
          1.24 MB
          jcamachorodriguez
        3. HIVE-12994.11.patch
          1.23 MB
          jcamachorodriguez
        4. HIVE-12994.10.patch
          809 kB
          jcamachorodriguez
        5. HIVE-12994.09.patch
          791 kB
          jcamachorodriguez
        6. HIVE-12994.08.patch
          791 kB
          jcamachorodriguez
        7. HIVE-12994.07.patch
          793 kB
          jcamachorodriguez
        8. HIVE-12994.06.patch
          792 kB
          jcamachorodriguez
        9. HIVE-12994.06.patch
          792 kB
          jcamachorodriguez
        10. HIVE-12994.05.patch
          792 kB
          jcamachorodriguez
        11. HIVE-12994.04.patch
          796 kB
          jcamachorodriguez
        12. HIVE-12994.03.patch
          796 kB
          jcamachorodriguez
        13. HIVE-12994.02.patch
          795 kB
          jcamachorodriguez
        14. HIVE-12994.01.patch
          219 kB
          jcamachorodriguez

        Issue Links

          Activity

            People

              jcamacho Jesús Camacho Rodríguez
              jcamacho Jesús Camacho Rodríguez
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: