hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yongzhi Chen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-11745) Alter table Exchange partition with multiple partition_spec is not working
Date Fri, 04 Sep 2015 22:35:45 GMT
Yongzhi Chen created HIVE-11745:
-----------------------------------

             Summary: Alter table Exchange partition with multiple partition_spec is not working
                 Key: HIVE-11745
                 URL: https://issues.apache.org/jira/browse/HIVE-11745
             Project: Hive
          Issue Type: Bug
          Components: Metastore
    Affects Versions: 1.1.0
            Reporter: Yongzhi Chen
            Assignee: Yongzhi Chen


Single partition works, but multiple partitions will not work.
Reproduce steps:
{noformat}
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t2;
DROP TABLE IF EXISTS t3;
DROP TABLE IF EXISTS t4;

CREATE TABLE t1 (a int) PARTITIONED BY (d1 int);
CREATE TABLE t2 (a int) PARTITIONED BY (d1 int);
CREATE TABLE t3 (a int) PARTITIONED BY (d1 int, d2 int);
CREATE TABLE t4 (a int) PARTITIONED BY (d1 int, d2 int);

INSERT OVERWRITE TABLE t1 PARTITION (d1 = 1) SELECT salary FROM jsmall LIMIT 10;
INSERT OVERWRITE TABLE t3 PARTITION (d1 = 1, d2 = 1) SELECT salary FROM jsmall LIMIT 10;

SELECT * FROM t1;

SELECT * FROM t3;

ALTER TABLE t2 EXCHANGE PARTITION (d1 = 1) WITH TABLE t1;
SELECT * FROM t1;
SELECT * FROM t2;

ALTER TABLE t4 EXCHANGE PARTITION (d1 = 1, d2 = 1) WITH TABLE t3;
SELECT * FROM t3;
SELECT * FROM t4;
{noformat}
The output:
{noformat}
0: jdbc:hive2://10.17.74.148:10000/default> SELECT * FROM t3;
+-------+--------+--------+--+
| t3.a  | t3.d1  | t3.d2  |
+-------+--------+--------+--+
+-------+--------+--------+--+
No rows selected (0.227 seconds)
0: jdbc:hive2://10.17.74.148:10000/default> SELECT * FROM t4;
+-------+--------+--------+--+
| t4.a  | t4.d1  | t4.d2  |
+-------+--------+--------+--+
+-------+--------+--------+--+
No rows selected (0.266 seconds)
{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message