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

Setting default nulls last does not take effect when order direction is specified

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.0.0
    • Component/s: Parser
    • Labels:
      None
    • Target Version/s:

      Description

      SET hive.default.nulls.last=true;
      SELECT * FROM t_test ORDER BY col1 ASC;
      
      POSTHOOK: query: SELECT * FROM t_test ORDER BY col1 ASC
      POSTHOOK: type: QUERY
      POSTHOOK: Input: default@t_test
      #### A masked pattern was here ####
      NULL
      NULL
      NULL
      NULL
      3
      5
      5
      

      https://github.com/apache/hive/blob/cb83da943c8919e2ab3751244de5c2879c8fda1d/ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g#L2510

       

      cc. Jesus Camacho Rodriguez

        Attachments

        1. HIVE-22321.5.patch
          25 kB
          Krisztian Kasa
        2. HIVE-22321.4.patch
          24 kB
          Krisztian Kasa
        3. HIVE-22321.3.patch
          24 kB
          Krisztian Kasa
        4. HIVE-22321.2.patch
          23 kB
          Krisztian Kasa
        5. HIVE-22321.1.patch
          1 kB
          Krisztian Kasa

          Issue Links

            Activity

              People

              • Assignee:
                kkasa Krisztian Kasa
                Reporter:
                kkasa Krisztian Kasa
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: