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

Create table statement fails with "not supported NULLS LAST for ORDER BY in ASC order"

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

      Description

      CREATE TABLE table_core2c4ywq7yjx (     k1 STRING,     f1 STRING,     sequence_num BIGINT,     create_bsk BIGINT,     change_bsk BIGINT,     op_code STRING ) PARTITIONED BY (run_id BIGINT) CLUSTERED BY (k1) SORTED BY (k1, change_bsk, sequence_num) INTO 4 BUCKETS STORED AS ORC
      
      Error while compiling statement: FAILED: SemanticException create/alter table: not supported NULLS LAST for ORDER BY in ASC order
      

        Attachments

        1. HIVE-22281.3.patch
          7 kB
          Krisztian Kasa
        2. HIVE-22281.3.patch
          7 kB
          Krisztian Kasa
        3. HIVE-22281.2.patch
          7 kB
          Krisztian Kasa
        4. HIVE-22281.2.patch
          7 kB
          Krisztian Kasa
        5. HIVE-22281.2.patch
          7 kB
          Krisztian Kasa
        6. HIVE-22281.1.patch
          2 kB
          Krisztian Kasa
        7. HIVE-22281.1.patch
          2 kB
          Jesus Camacho Rodriguez

          Activity

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              kkasa Krisztian Kasa Assign to me
              Reporter:
              kkasa Krisztian Kasa

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment