You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2013/07/30 19:22:57 UTC

svn commit: r1508534 - in /hive/trunk/ql/src: java/org/apache/hadoop/hive/ql/parse/ test/queries/clientpositive/ test/results/clientpositive/

Author: hashutosh
Date: Tue Jul 30 17:22:57 2013
New Revision: 1508534

URL: http://svn.apache.org/r1508534
Log:
HIVE-4928 : Date literals do not work properly in partition spec clause (Jason Dere via Ashutosh Chauhan)

Added:
    hive/trunk/ql/src/test/queries/clientpositive/partition_date2.q
    hive/trunk/ql/src/test/results/clientpositive/partition_date2.q.out
Modified:
    hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g
    hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java

Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g?rev=1508534&r1=1508533&r2=1508534&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g Tue Jul 30 17:22:57 2013
@@ -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

Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java?rev=1508534&r1=1508533&r2=1508534&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java Tue Jul 30 17:22:57 2013
@@ -257,7 +257,7 @@ public final class TypeCheckProcFactory 
                 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 final class TypeCheckProcFactory 
       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);
       }
     }
   }

Added: hive/trunk/ql/src/test/queries/clientpositive/partition_date2.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/partition_date2.q?rev=1508534&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/partition_date2.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/partition_date2.q Tue Jul 30 17:22:57 2013
@@ -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;

Added: hive/trunk/ql/src/test/results/clientpositive/partition_date2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/partition_date2.q.out?rev=1508534&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/partition_date2.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/partition_date2.q.out Tue Jul 30 17:22:57 2013
@@ -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), ]