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

Support range partition

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.2.0
    • None
    • SQL
    • None

    Description

      Support RANGE PARTITION to improvement performance:

      CREATE TABLE employees  (
          id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
          fname VARCHAR(25) NOT NULL,
          lname VARCHAR(25) NOT NULL,
          store_id INT NOT NULL,
          department_id INT NOT NULL
      ) 
          PARTITION BY RANGE(id)  (
              PARTITION p0 VALUES LESS THAN (5),
              PARTITION p1 VALUES LESS THAN (10),
              PARTITION p2 VALUES LESS THAN (15),
              PARTITION p3 VALUES LESS THAN MAXVALUE
      );
      

      https://dev.mysql.com/doc/refman/5.6/en/partitioning-selection.html

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              yumwang Yuming Wang
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: