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"

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.0.0-alpha-1
    • Parser
    • 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.1.patch
          2 kB
          jcamachorodriguez
        2. HIVE-22281.1.patch
          2 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.3.patch
          7 kB
          Krisztian Kasa
        7. HIVE-22281.3.patch
          7 kB
          Krisztian Kasa

        Issue Links

          Activity

            People

              kkasa Krisztian Kasa
              kkasa Krisztian Kasa
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: