[jira] [Created] (HIVE-20216) Support range partition

["Yuming Wang (JIRA)" <ji...@apache.org>]

Yuming Wang created HIVE-20216:
----------------------------------

             Summary: Support range partition
                 Key: HIVE-20216
                 URL: https://issues.apache.org/jira/browse/HIVE-20216
             Project: Hive
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 3.2.0
            Reporter: Yuming Wang


Support RANGE PARTITION to improvement performance:
{code:sql}
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
);
{code}

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



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)