diff --git ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g index c898858..42230c5 100644 --- ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g +++ ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g @@ -247,7 +247,12 @@ charSetStringLiteral dateLiteral : - KW_DATE StringLiteral -> ^(TOK_DATELITERAL StringLiteral) + KW_DATE StringLiteral -> + { + // Create DateLiteral token, but with the text of the string value + // This makes the dateLiteral more consistent with the other type literals. + adaptor.create(TOK_DATELITERAL, $StringLiteral.text) + } ; expression diff --git ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java index 59572ac..b27ccd9 100644 --- ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java +++ ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java @@ -257,7 +257,7 @@ public Object process(Node nd, Stack stack, NodeProcessorCtx procCtx, 0, expr.getText().length() - 1)); } else if (expr.getText().endsWith("BD")) { // Literal decimal - return new ExprNodeConstantDesc(TypeInfoFactory.decimalTypeInfo, + return new ExprNodeConstantDesc(TypeInfoFactory.decimalTypeInfo, expr.getText().substring(0, expr.getText().length() - 2)); } else { v = Double.valueOf(expr.getText()); @@ -411,16 +411,12 @@ public Object process(Node nd, Stack stack, NodeProcessorCtx procCtx, ASTNode expr = (ASTNode) nd; // Get the string value and convert to a Date value. - if (expr.getChildCount() == 1) { - try { - String dateString = BaseSemanticAnalyzer.stripQuotes(expr.getChild(0).getText()); - Date date = Date.valueOf(dateString); - return new ExprNodeConstantDesc(TypeInfoFactory.dateTypeInfo, date); - } catch (IllegalArgumentException err) { - throw new SemanticException("Unable to convert date literal string to date value.", err); - } - } else { - throw new SemanticException("Expected date string after DATE keyword"); + try { + String dateString = BaseSemanticAnalyzer.stripQuotes(expr.getText()); + Date date = Date.valueOf(dateString); + return new ExprNodeConstantDesc(TypeInfoFactory.dateTypeInfo, date); + } catch (IllegalArgumentException err) { + throw new SemanticException("Unable to convert date literal string to date value.", err); } } } diff --git ql/src/test/queries/clientpositive/partition_date2.q ql/src/test/queries/clientpositive/partition_date2.q new file mode 100644 index 0000000..e5b7a7f --- /dev/null +++ ql/src/test/queries/clientpositive/partition_date2.q @@ -0,0 +1,57 @@ +drop table partition_date2_1; + +create table partition_date2_1 (key string, value string) partitioned by (dt date, region int); + +-- test date literal syntax +insert overwrite table partition_date2_1 partition(dt=date '2000-01-01', region=1) + select * from src limit 1; +insert overwrite table partition_date2_1 partition(dt=date '2000-01-01', region=2) + select * from src limit 1; +insert overwrite table partition_date2_1 partition(dt=date '1999-01-01', region=2) + select * from src limit 1; + +select distinct dt from partition_date2_1; +select * from partition_date2_1; + +-- insert overwrite +insert overwrite table partition_date2_1 partition(dt=date '2000-01-01', region=2) + select 'changed_key', 'changed_value' from src limit 2; +select * from partition_date2_1; + +-- truncate +truncate table partition_date2_1 partition(dt=date '2000-01-01', region=2); +select distinct dt from partition_date2_1; +select * from partition_date2_1; + +-- alter table add partition +alter table partition_date2_1 add partition (dt=date '1980-01-02', region=3); +select distinct dt from partition_date2_1; +select * from partition_date2_1; + +-- alter table drop +alter table partition_date2_1 drop partition (dt=date '1999-01-01', region=2); +select distinct dt from partition_date2_1; +select * from partition_date2_1; + +-- alter table set serde +alter table partition_date2_1 partition(dt=date '1980-01-02', region=3) + set serde 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'; + +-- alter table set fileformat +alter table partition_date2_1 partition(dt=date '1980-01-02', region=3) + set fileformat rcfile; +describe extended partition_date2_1 partition(dt=date '1980-01-02', region=3); + +insert overwrite table partition_date2_1 partition(dt=date '1980-01-02', region=3) + select * from src limit 2; +select * from partition_date2_1; + +-- alter table set location +alter table partition_date2_1 partition(dt=date '1980-01-02', region=3) + set location "file:///tmp/partition_date2_1"; +describe extended partition_date2_1 partition(dt=date '1980-01-02', region=3); + +-- alter table touch +alter table partition_date2_1 touch partition(dt=date '1980-01-02', region=3); + +drop table partition_date2_1; diff --git ql/src/test/results/clientpositive/partition_date2.q.out ql/src/test/results/clientpositive/partition_date2.q.out new file mode 100644 index 0000000..6d170f9 --- /dev/null +++ ql/src/test/results/clientpositive/partition_date2.q.out @@ -0,0 +1,544 @@ +PREHOOK: query: drop table partition_date2_1 +PREHOOK: type: DROPTABLE +POSTHOOK: query: drop table partition_date2_1 +POSTHOOK: type: DROPTABLE +PREHOOK: query: create table partition_date2_1 (key string, value string) partitioned by (dt date, region int) +PREHOOK: type: CREATETABLE +POSTHOOK: query: create table partition_date2_1 (key string, value string) partitioned by (dt date, region int) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@partition_date2_1 +PREHOOK: query: -- test date literal syntax +insert overwrite table partition_date2_1 partition(dt=date '2000-01-01', region=1) + select * from src limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@partition_date2_1@dt=2000-01-01/region=1 +POSTHOOK: query: -- test date literal syntax +insert overwrite table partition_date2_1 partition(dt=date '2000-01-01', region=1) + select * from src limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@partition_date2_1@dt=2000-01-01/region=1 +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: insert overwrite table partition_date2_1 partition(dt=date '2000-01-01', region=2) + select * from src limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@partition_date2_1@dt=2000-01-01/region=2 +POSTHOOK: query: insert overwrite table partition_date2_1 partition(dt=date '2000-01-01', region=2) + select * from src limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@partition_date2_1@dt=2000-01-01/region=2 +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: insert overwrite table partition_date2_1 partition(dt=date '1999-01-01', region=2) + select * from src limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@partition_date2_1@dt=1999-01-01/region=2 +POSTHOOK: query: insert overwrite table partition_date2_1 partition(dt=date '1999-01-01', region=2) + select * from src limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@partition_date2_1@dt=1999-01-01/region=2 +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: select distinct dt from partition_date2_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@partition_date2_1 +PREHOOK: Input: default@partition_date2_1@dt=1999-01-01/region=2 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: query: select distinct dt from partition_date2_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Input: default@partition_date2_1@dt=1999-01-01/region=2 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +1999-01-01 +2000-01-01 +PREHOOK: query: select * from partition_date2_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@partition_date2_1 +PREHOOK: Input: default@partition_date2_1@dt=1999-01-01/region=2 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: query: select * from partition_date2_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Input: default@partition_date2_1@dt=1999-01-01/region=2 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +238 val_238 1999-01-01 2 +238 val_238 2000-01-01 1 +238 val_238 2000-01-01 2 +PREHOOK: query: -- insert overwrite +insert overwrite table partition_date2_1 partition(dt=date '2000-01-01', region=2) + select 'changed_key', 'changed_value' from src limit 2 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@partition_date2_1@dt=2000-01-01/region=2 +POSTHOOK: query: -- insert overwrite +insert overwrite table partition_date2_1 partition(dt=date '2000-01-01', region=2) + select 'changed_key', 'changed_value' from src limit 2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@partition_date2_1@dt=2000-01-01/region=2 +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: select * from partition_date2_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@partition_date2_1 +PREHOOK: Input: default@partition_date2_1@dt=1999-01-01/region=2 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: query: select * from partition_date2_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Input: default@partition_date2_1@dt=1999-01-01/region=2 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +238 val_238 1999-01-01 2 +238 val_238 2000-01-01 1 +changed_key changed_value 2000-01-01 2 +changed_key changed_value 2000-01-01 2 +PREHOOK: query: -- truncate +truncate table partition_date2_1 partition(dt=date '2000-01-01', region=2) +PREHOOK: type: TRUNCATETABLE +PREHOOK: Output: default@partition_date2_1@dt=2000-01-01/region=2 +POSTHOOK: query: -- truncate +truncate table partition_date2_1 partition(dt=date '2000-01-01', region=2) +POSTHOOK: type: TRUNCATETABLE +POSTHOOK: Output: default@partition_date2_1@dt=2000-01-01/region=2 +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: select distinct dt from partition_date2_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@partition_date2_1 +PREHOOK: Input: default@partition_date2_1@dt=1999-01-01/region=2 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: query: select distinct dt from partition_date2_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Input: default@partition_date2_1@dt=1999-01-01/region=2 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +1999-01-01 +2000-01-01 +PREHOOK: query: select * from partition_date2_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@partition_date2_1 +PREHOOK: Input: default@partition_date2_1@dt=1999-01-01/region=2 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: query: select * from partition_date2_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Input: default@partition_date2_1@dt=1999-01-01/region=2 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +238 val_238 1999-01-01 2 +238 val_238 2000-01-01 1 +PREHOOK: query: -- alter table add partition +alter table partition_date2_1 add partition (dt=date '1980-01-02', region=3) +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@partition_date2_1 +POSTHOOK: query: -- alter table add partition +alter table partition_date2_1 add partition (dt=date '1980-01-02', region=3) +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Output: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: select distinct dt from partition_date2_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@partition_date2_1 +PREHOOK: Input: default@partition_date2_1@dt=1980-01-02/region=3 +PREHOOK: Input: default@partition_date2_1@dt=1999-01-01/region=2 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: query: select distinct dt from partition_date2_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Input: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: Input: default@partition_date2_1@dt=1999-01-01/region=2 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +1980-01-02 +1999-01-01 +2000-01-01 +PREHOOK: query: select * from partition_date2_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@partition_date2_1 +PREHOOK: Input: default@partition_date2_1@dt=1980-01-02/region=3 +PREHOOK: Input: default@partition_date2_1@dt=1999-01-01/region=2 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: query: select * from partition_date2_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Input: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: Input: default@partition_date2_1@dt=1999-01-01/region=2 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +238 val_238 1999-01-01 2 +238 val_238 2000-01-01 1 +PREHOOK: query: -- alter table drop +alter table partition_date2_1 drop partition (dt=date '1999-01-01', region=2) +PREHOOK: type: ALTERTABLE_DROPPARTS +PREHOOK: Input: default@partition_date2_1 +PREHOOK: Output: default@partition_date2_1@dt=1999-01-01/region=2 +POSTHOOK: query: -- alter table drop +alter table partition_date2_1 drop partition (dt=date '1999-01-01', region=2) +POSTHOOK: type: ALTERTABLE_DROPPARTS +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Output: default@partition_date2_1@dt=1999-01-01/region=2 +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: select distinct dt from partition_date2_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@partition_date2_1 +PREHOOK: Input: default@partition_date2_1@dt=1980-01-02/region=3 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: query: select distinct dt from partition_date2_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Input: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +1980-01-02 +2000-01-01 +PREHOOK: query: select * from partition_date2_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@partition_date2_1 +PREHOOK: Input: default@partition_date2_1@dt=1980-01-02/region=3 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: query: select * from partition_date2_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Input: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +238 val_238 2000-01-01 1 +PREHOOK: query: -- alter table set serde +alter table partition_date2_1 partition(dt=date '1980-01-02', region=3) + set serde 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe' +PREHOOK: type: ALTERPARTITION_SERIALIZER +PREHOOK: Input: default@partition_date2_1 +PREHOOK: Output: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: query: -- alter table set serde +alter table partition_date2_1 partition(dt=date '1980-01-02', region=3) + set serde 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe' +POSTHOOK: type: ALTERPARTITION_SERIALIZER +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Input: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: Output: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: -- alter table set fileformat +alter table partition_date2_1 partition(dt=date '1980-01-02', region=3) + set fileformat rcfile +PREHOOK: type: ALTERPARTITION_FILEFORMAT +PREHOOK: Input: default@partition_date2_1 +PREHOOK: Output: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: query: -- alter table set fileformat +alter table partition_date2_1 partition(dt=date '1980-01-02', region=3) + set fileformat rcfile +POSTHOOK: type: ALTERPARTITION_FILEFORMAT +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Input: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: Output: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: describe extended partition_date2_1 partition(dt=date '1980-01-02', region=3) +PREHOOK: type: DESCTABLE +POSTHOOK: query: describe extended partition_date2_1 partition(dt=date '1980-01-02', region=3) +POSTHOOK: type: DESCTABLE +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +key string None +value string None +dt date None +region int None + +# Partition Information +# col_name data_type comment + +dt date None +region int None + +#### A masked pattern was here #### +PREHOOK: query: insert overwrite table partition_date2_1 partition(dt=date '1980-01-02', region=3) + select * from src limit 2 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: query: insert overwrite table partition_date2_1 partition(dt=date '1980-01-02', region=3) + select * from src limit 2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1980-01-02,region=3).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1980-01-02,region=3).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: select * from partition_date2_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@partition_date2_1 +PREHOOK: Input: default@partition_date2_1@dt=1980-01-02/region=3 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +PREHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: query: select * from partition_date2_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Input: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=1 +POSTHOOK: Input: default@partition_date2_1@dt=2000-01-01/region=2 +#### A masked pattern was here #### +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1980-01-02,region=3).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1980-01-02,region=3).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +238 val_238 1980-01-02 3 +86 val_86 1980-01-02 3 +238 val_238 2000-01-01 1 +PREHOOK: query: -- alter table set location +alter table partition_date2_1 partition(dt=date '1980-01-02', region=3) +#### A masked pattern was here #### +PREHOOK: type: ALTERPARTITION_LOCATION +PREHOOK: Input: default@partition_date2_1 +PREHOOK: Output: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: query: -- alter table set location +alter table partition_date2_1 partition(dt=date '1980-01-02', region=3) +#### A masked pattern was here #### +POSTHOOK: type: ALTERPARTITION_LOCATION +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Input: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: Output: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1980-01-02,region=3).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1980-01-02,region=3).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: describe extended partition_date2_1 partition(dt=date '1980-01-02', region=3) +PREHOOK: type: DESCTABLE +POSTHOOK: query: describe extended partition_date2_1 partition(dt=date '1980-01-02', region=3) +POSTHOOK: type: DESCTABLE +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1980-01-02,region=3).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1980-01-02,region=3).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +key string None +value string None +dt date None +region int None + +# Partition Information +# col_name data_type comment + +dt date None +region int None + +#### A masked pattern was here #### +PREHOOK: query: -- alter table touch +alter table partition_date2_1 touch partition(dt=date '1980-01-02', region=3) +PREHOOK: type: ALTERTABLE_TOUCH +PREHOOK: Input: default@partition_date2_1 +PREHOOK: Output: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: query: -- alter table touch +alter table partition_date2_1 touch partition(dt=date '1980-01-02', region=3) +POSTHOOK: type: ALTERTABLE_TOUCH +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Input: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: Output: default@partition_date2_1@dt=1980-01-02/region=3 +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1980-01-02,region=3).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1980-01-02,region=3).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: drop table partition_date2_1 +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@partition_date2_1 +PREHOOK: Output: default@partition_date2_1 +POSTHOOK: query: drop table partition_date2_1 +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@partition_date2_1 +POSTHOOK: Output: default@partition_date2_1 +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1980-01-02,region=3).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1980-01-02,region=3).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=1999-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: partition_date2_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]