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 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: 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 ABSTRACT SYNTAX TREE: #### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage Stage-1 is a root stage Stage-2 is a root stage Stage-3 is a root stage STAGE PLANS: Stage: Stage-0 Add Partition Operator: #### A masked pattern was here #### Spec: {ds=2010-01-01} Stage: Stage-1 Add Partition Operator: #### A masked pattern was here #### Spec: {ds=2010-02-01} Stage: Stage-2 Add Partition Operator: Spec: {ds=2010-03-01} Stage: Stage-3 Add Partition Operator: #### A masked pattern was here #### Spec: {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 PREHOOK: Input: 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 POSTHOOK: Input: 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 #### 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 [] 100 100 2010-01-01 200 200 2010-02-01 400 300 2010-03-01 500 400 2010-04-01