PREHOOK: query: -- HIVE-5122 locations for 2nd, 3rd... partition are ignored CREATE TABLE add_part_test (key STRING, value STRING) PARTITIONED BY (ds STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@add_part_test POSTHOOK: query: -- HIVE-5122 locations for 2nd, 3rd... partition are ignored CREATE TABLE add_part_test (key STRING, value STRING) PARTITIONED BY (ds STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@add_part_test PREHOOK: query: explain ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') location 'A' PARTITION (ds='2010-02-01') location 'B' PARTITION (ds='2010-03-01') PARTITION (ds='2010-04-01') location 'C' PREHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: query: explain ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') location 'A' PARTITION (ds='2010-02-01') location 'B' PARTITION (ds='2010-03-01') PARTITION (ds='2010-04-01') location 'C' POSTHOOK: type: ALTERTABLE_ADDPARTS STAGE DEPENDENCIES: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 Add Partition Operator: #### A masked pattern was here #### Spec: {ds=2010-01-01}, {ds=2010-02-01}, {ds=2010-03-01}, {ds=2010-04-01} PREHOOK: query: ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') location 'A' PARTITION (ds='2010-02-01') location 'B' PARTITION (ds='2010-03-01') PARTITION (ds='2010-04-01') location 'C' PREHOOK: type: ALTERTABLE_ADDPARTS #### A masked pattern was here #### PREHOOK: Output: default@add_part_test POSTHOOK: query: ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') location 'A' PARTITION (ds='2010-02-01') location 'B' PARTITION (ds='2010-03-01') PARTITION (ds='2010-04-01') location 'C' POSTHOOK: type: ALTERTABLE_ADDPARTS #### A masked pattern was here #### POSTHOOK: Output: default@add_part_test POSTHOOK: Output: default@add_part_test@ds=2010-01-01 POSTHOOK: Output: default@add_part_test@ds=2010-02-01 POSTHOOK: Output: default@add_part_test@ds=2010-03-01 POSTHOOK: Output: default@add_part_test@ds=2010-04-01 PREHOOK: query: from src TABLESAMPLE (1 ROWS) insert into table add_part_test PARTITION (ds='2010-01-01') select 100,100 insert into table add_part_test PARTITION (ds='2010-02-01') select 200,200 insert into table add_part_test PARTITION (ds='2010-03-01') select 400,300 insert into table add_part_test PARTITION (ds='2010-04-01') select 500,400 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@add_part_test@ds=2010-01-01 PREHOOK: Output: default@add_part_test@ds=2010-02-01 PREHOOK: Output: default@add_part_test@ds=2010-03-01 PREHOOK: Output: default@add_part_test@ds=2010-04-01 POSTHOOK: query: from src TABLESAMPLE (1 ROWS) insert into table add_part_test PARTITION (ds='2010-01-01') select 100,100 insert into table add_part_test PARTITION (ds='2010-02-01') select 200,200 insert into table add_part_test PARTITION (ds='2010-03-01') select 400,300 insert into table add_part_test PARTITION (ds='2010-04-01') select 500,400 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@add_part_test@ds=2010-01-01 POSTHOOK: Output: default@add_part_test@ds=2010-02-01 POSTHOOK: Output: default@add_part_test@ds=2010-03-01 POSTHOOK: Output: default@add_part_test@ds=2010-04-01 POSTHOOK: Lineage: add_part_test PARTITION(ds=2010-01-01).key SIMPLE [] POSTHOOK: Lineage: add_part_test PARTITION(ds=2010-01-01).value SIMPLE [] POSTHOOK: Lineage: add_part_test PARTITION(ds=2010-02-01).key SIMPLE [] POSTHOOK: Lineage: add_part_test PARTITION(ds=2010-02-01).value SIMPLE [] POSTHOOK: Lineage: add_part_test PARTITION(ds=2010-03-01).key SIMPLE [] POSTHOOK: Lineage: add_part_test PARTITION(ds=2010-03-01).value SIMPLE [] POSTHOOK: Lineage: add_part_test PARTITION(ds=2010-04-01).key SIMPLE [] POSTHOOK: Lineage: add_part_test PARTITION(ds=2010-04-01).value SIMPLE [] PREHOOK: query: select * from add_part_test PREHOOK: type: QUERY PREHOOK: Input: default@add_part_test PREHOOK: Input: default@add_part_test@ds=2010-01-01 PREHOOK: Input: default@add_part_test@ds=2010-02-01 PREHOOK: Input: default@add_part_test@ds=2010-03-01 PREHOOK: Input: default@add_part_test@ds=2010-04-01 #### A masked pattern was here #### POSTHOOK: query: select * from add_part_test POSTHOOK: type: QUERY POSTHOOK: Input: default@add_part_test POSTHOOK: Input: default@add_part_test@ds=2010-01-01 POSTHOOK: Input: default@add_part_test@ds=2010-02-01 POSTHOOK: Input: default@add_part_test@ds=2010-03-01 POSTHOOK: Input: default@add_part_test@ds=2010-04-01 #### A masked pattern was here #### 100 100 2010-01-01 200 200 2010-02-01 400 300 2010-03-01 500 400 2010-04-01