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/27 23:20:06 UTC
svn commit: r1507713 [4/6] - in /hive/trunk: data/files/
jdbc/src/java/org/apache/hadoop/hive/jdbc/
jdbc/src/java/org/apache/hive/jdbc/
jdbc/src/test/org/apache/hadoop/hive/jdbc/
jdbc/src/test/org/apache/hive/jdbc/ ql/src/gen/protobuf/gen-java/org/apac...
Added: hive/trunk/ql/src/test/results/clientpositive/date_serde.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/date_serde.q.out?rev=1507713&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/date_serde.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/date_serde.q.out Sat Jul 27 21:20:03 2013
@@ -0,0 +1,731 @@
+PREHOOK: query: drop table if exists date_serde_regex
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table if exists date_serde_regex
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table date_serde_lb
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table date_serde_lb
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table date_serde_ls
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table date_serde_ls
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table date_serde_c
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table date_serde_c
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table date_serde_lbc
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table date_serde_lbc
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table date_serde_orc
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table date_serde_orc
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: --
+-- RegexSerDe
+--
+create table date_serde_regex (
+ ORIGIN_CITY_NAME string,
+ DEST_CITY_NAME string,
+ FL_DATE date,
+ ARR_DELAY float,
+ FL_NUM int
+)
+row format serde 'org.apache.hadoop.hive.serde2.RegexSerDe'
+with serdeproperties (
+ "input.regex" = "([^]*)([^]*)([^]*)([^]*)([0-9]*)"
+)
+stored as textfile
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: --
+-- RegexSerDe
+--
+create table date_serde_regex (
+ ORIGIN_CITY_NAME string,
+ DEST_CITY_NAME string,
+ FL_DATE date,
+ ARR_DELAY float,
+ FL_NUM int
+)
+row format serde 'org.apache.hadoop.hive.serde2.RegexSerDe'
+with serdeproperties (
+ "input.regex" = "([^]*)([^]*)([^]*)([^]*)([0-9]*)"
+)
+stored as textfile
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@date_serde_regex
+PREHOOK: query: load data local inpath '../data/files/flights_tiny.txt.1' overwrite into table date_serde_regex
+PREHOOK: type: LOAD
+PREHOOK: Output: default@date_serde_regex
+POSTHOOK: query: load data local inpath '../data/files/flights_tiny.txt.1' overwrite into table date_serde_regex
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@date_serde_regex
+PREHOOK: query: select * from date_serde_regex
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_regex
+#### A masked pattern was here ####
+POSTHOOK: query: select * from date_serde_regex
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_regex
+#### A masked pattern was here ####
+Baltimore New York 2010-10-20 -30.0 1064
+Baltimore New York 2010-10-20 23.0 1142
+Baltimore New York 2010-10-20 6.0 1599
+Chicago New York 2010-10-20 42.0 361
+Chicago New York 2010-10-20 24.0 897
+Chicago New York 2010-10-20 15.0 1531
+Chicago New York 2010-10-20 -6.0 1610
+Chicago New York 2010-10-20 -2.0 3198
+Baltimore New York 2010-10-21 17.0 1064
+Baltimore New York 2010-10-21 105.0 1142
+Baltimore New York 2010-10-21 28.0 1599
+Chicago New York 2010-10-21 142.0 361
+Chicago New York 2010-10-21 77.0 897
+Chicago New York 2010-10-21 53.0 1531
+Chicago New York 2010-10-21 -5.0 1610
+Chicago New York 2010-10-21 51.0 3198
+Baltimore New York 2010-10-22 -12.0 1064
+Baltimore New York 2010-10-22 54.0 1142
+Baltimore New York 2010-10-22 18.0 1599
+Chicago New York 2010-10-22 2.0 361
+Chicago New York 2010-10-22 24.0 897
+Chicago New York 2010-10-22 16.0 1531
+Chicago New York 2010-10-22 -6.0 1610
+Chicago New York 2010-10-22 -11.0 3198
+Baltimore New York 2010-10-23 18.0 272
+Baltimore New York 2010-10-23 -10.0 1805
+Baltimore New York 2010-10-23 6.0 3171
+Chicago New York 2010-10-23 3.0 384
+Chicago New York 2010-10-23 32.0 426
+Chicago New York 2010-10-23 1.0 650
+Chicago New York 2010-10-23 11.0 3085
+Baltimore New York 2010-10-24 12.0 1599
+Baltimore New York 2010-10-24 20.0 2571
+Chicago New York 2010-10-24 10.0 361
+Chicago New York 2010-10-24 113.0 897
+Chicago New York 2010-10-24 -5.0 1531
+Chicago New York 2010-10-24 -17.0 1610
+Chicago New York 2010-10-24 -3.0 3198
+Baltimore New York 2010-10-25 -25.0 1064
+Baltimore New York 2010-10-25 92.0 1142
+Baltimore New York 2010-10-25 106.0 1599
+Chicago New York 2010-10-25 31.0 361
+Chicago New York 2010-10-25 -1.0 897
+Chicago New York 2010-10-25 43.0 1531
+Chicago New York 2010-10-25 6.0 1610
+Chicago New York 2010-10-25 -16.0 3198
+Baltimore New York 2010-10-26 -22.0 1064
+Baltimore New York 2010-10-26 123.0 1142
+Baltimore New York 2010-10-26 90.0 1599
+Chicago New York 2010-10-26 12.0 361
+Chicago New York 2010-10-26 0.0 897
+Chicago New York 2010-10-26 29.0 1531
+Chicago New York 2010-10-26 -17.0 1610
+Chicago New York 2010-10-26 6.0 3198
+Baltimore New York 2010-10-27 -18.0 1064
+Baltimore New York 2010-10-27 49.0 1142
+Baltimore New York 2010-10-27 92.0 1599
+Chicago New York 2010-10-27 148.0 361
+Chicago New York 2010-10-27 -11.0 897
+Chicago New York 2010-10-27 70.0 1531
+Chicago New York 2010-10-27 8.0 1610
+Chicago New York 2010-10-27 21.0 3198
+Baltimore New York 2010-10-28 -4.0 1064
+Baltimore New York 2010-10-28 -14.0 1142
+Baltimore New York 2010-10-28 -14.0 1599
+Chicago New York 2010-10-28 2.0 361
+Chicago New York 2010-10-28 2.0 897
+Chicago New York 2010-10-28 -11.0 1531
+Chicago New York 2010-10-28 3.0 1610
+Chicago New York 2010-10-28 -18.0 3198
+Baltimore New York 2010-10-29 -24.0 1064
+Baltimore New York 2010-10-29 21.0 1142
+Baltimore New York 2010-10-29 -2.0 1599
+Chicago New York 2010-10-29 -12.0 361
+Chicago New York 2010-10-29 -11.0 897
+Chicago New York 2010-10-29 15.0 1531
+Chicago New York 2010-10-29 -18.0 1610
+Chicago New York 2010-10-29 -4.0 3198
+Baltimore New York 2010-10-30 14.0 272
+Baltimore New York 2010-10-30 -1.0 1805
+Baltimore New York 2010-10-30 5.0 3171
+Chicago New York 2010-10-30 -6.0 384
+Chicago New York 2010-10-30 -10.0 426
+Chicago New York 2010-10-30 -5.0 650
+Chicago New York 2010-10-30 -5.0 3085
+Baltimore New York 2010-10-31 -1.0 1599
+Baltimore New York 2010-10-31 -14.0 2571
+Chicago New York 2010-10-31 -25.0 361
+Chicago New York 2010-10-31 -18.0 897
+Chicago New York 2010-10-31 -4.0 1531
+Chicago New York 2010-10-31 -22.0 1610
+Chicago New York 2010-10-31 -15.0 3198
+Cleveland New York 2010-10-30 -23.0 2018
+Cleveland New York 2010-10-30 -12.0 2932
+Cleveland New York 2010-10-29 -4.0 2630
+Cleveland New York 2010-10-29 -19.0 2646
+Cleveland New York 2010-10-29 -12.0 3014
+Cleveland New York 2010-10-28 3.0 2630
+Cleveland New York 2010-10-28 -6.0 2646
+Cleveland New York 2010-10-28 1.0 3014
+Cleveland New York 2010-10-27 16.0 2630
+Cleveland New York 2010-10-27 27.0 3014
+Cleveland New York 2010-10-26 4.0 2630
+Cleveland New York 2010-10-26 -27.0 2646
+Cleveland New York 2010-10-26 -11.0 2662
+Cleveland New York 2010-10-26 13.0 3014
+Cleveland New York 2010-10-25 -4.0 2630
+Cleveland New York 2010-10-25 81.0 2646
+Cleveland New York 2010-10-25 42.0 3014
+Cleveland New York 2010-10-24 5.0 2254
+Cleveland New York 2010-10-24 -11.0 2630
+Cleveland New York 2010-10-24 -20.0 2646
+Cleveland New York 2010-10-24 -9.0 3014
+Cleveland New York 2010-10-23 -21.0 2932
+Cleveland New York 2010-10-22 1.0 2630
+Cleveland New York 2010-10-22 -25.0 2646
+Cleveland New York 2010-10-22 -3.0 3014
+Cleveland New York 2010-10-21 3.0 2630
+Cleveland New York 2010-10-21 29.0 2646
+Cleveland New York 2010-10-21 72.0 3014
+Cleveland New York 2010-10-20 -8.0 2630
+Cleveland New York 2010-10-20 -15.0 3014
+Washington New York 2010-10-23 -25.0 5832
+Washington New York 2010-10-23 -21.0 5904
+Washington New York 2010-10-23 -18.0 5917
+Washington New York 2010-10-30 -27.0 5904
+Washington New York 2010-10-30 -16.0 5917
+Washington New York 2010-10-20 -2.0 7291
+Washington New York 2010-10-21 22.0 7291
+Washington New York 2010-10-23 -16.0 7274
+Washington New York 2010-10-24 -26.0 7282
+Washington New York 2010-10-25 9.0 7291
+Washington New York 2010-10-26 4.0 7291
+Washington New York 2010-10-27 26.0 7291
+Washington New York 2010-10-28 45.0 7291
+Washington New York 2010-10-29 1.0 7291
+Washington New York 2010-10-31 -18.0 7282
+PREHOOK: query: select fl_date, count(*) from date_serde_regex group by fl_date
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_regex
+#### A masked pattern was here ####
+POSTHOOK: query: select fl_date, count(*) from date_serde_regex group by fl_date
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_regex
+#### A masked pattern was here ####
+2010-10-20 11
+2010-10-21 12
+2010-10-22 11
+2010-10-23 12
+2010-10-24 12
+2010-10-25 12
+2010-10-26 13
+2010-10-27 11
+2010-10-28 12
+2010-10-29 12
+2010-10-30 11
+2010-10-31 8
+PREHOOK: query: --
+-- LazyBinary
+--
+create table date_serde_lb (
+ c1 date,
+ c2 int
+)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: --
+-- LazyBinary
+--
+create table date_serde_lb (
+ c1 date,
+ c2 int
+)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@date_serde_lb
+PREHOOK: query: alter table date_serde_lb set serde 'org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe'
+PREHOOK: type: ALTERTABLE_SERIALIZER
+PREHOOK: Input: default@date_serde_lb
+PREHOOK: Output: default@date_serde_lb
+POSTHOOK: query: alter table date_serde_lb set serde 'org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe'
+POSTHOOK: type: ALTERTABLE_SERIALIZER
+POSTHOOK: Input: default@date_serde_lb
+POSTHOOK: Output: default@date_serde_lb
+PREHOOK: query: insert overwrite table date_serde_lb
+ select fl_date, fl_num from date_serde_regex limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_regex
+PREHOOK: Output: default@date_serde_lb
+POSTHOOK: query: insert overwrite table date_serde_lb
+ select fl_date, fl_num from date_serde_regex limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_regex
+POSTHOOK: Output: default@date_serde_lb
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+PREHOOK: query: select * from date_serde_lb
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_lb
+#### A masked pattern was here ####
+POSTHOOK: query: select * from date_serde_lb
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_lb
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+2010-10-20 1064
+PREHOOK: query: select c1, sum(c2) from date_serde_lb group by c1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_lb
+#### A masked pattern was here ####
+POSTHOOK: query: select c1, sum(c2) from date_serde_lb group by c1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_lb
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+2010-10-20 1064
+PREHOOK: query: --
+-- LazySimple
+--
+create table date_serde_ls (
+ c1 date,
+ c2 int
+)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: --
+-- LazySimple
+--
+create table date_serde_ls (
+ c1 date,
+ c2 int
+)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@date_serde_ls
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+PREHOOK: query: alter table date_serde_ls set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+PREHOOK: type: ALTERTABLE_SERIALIZER
+PREHOOK: Input: default@date_serde_ls
+PREHOOK: Output: default@date_serde_ls
+POSTHOOK: query: alter table date_serde_ls set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+POSTHOOK: type: ALTERTABLE_SERIALIZER
+POSTHOOK: Input: default@date_serde_ls
+POSTHOOK: Output: default@date_serde_ls
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+PREHOOK: query: insert overwrite table date_serde_ls
+ select c1, c2 from date_serde_lb limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_lb
+PREHOOK: Output: default@date_serde_ls
+POSTHOOK: query: insert overwrite table date_serde_ls
+ select c1, c2 from date_serde_lb limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_lb
+POSTHOOK: Output: default@date_serde_ls
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+PREHOOK: query: select * from date_serde_ls
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_ls
+#### A masked pattern was here ####
+POSTHOOK: query: select * from date_serde_ls
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_ls
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+2010-10-20 1064
+PREHOOK: query: select c1, sum(c2) from date_serde_ls group by c1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_ls
+#### A masked pattern was here ####
+POSTHOOK: query: select c1, sum(c2) from date_serde_ls group by c1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_ls
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+2010-10-20 1064
+PREHOOK: query: --
+-- Columnar
+--
+create table date_serde_c (
+ c1 date,
+ c2 int
+) stored as rcfile
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: --
+-- Columnar
+--
+create table date_serde_c (
+ c1 date,
+ c2 int
+) stored as rcfile
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@date_serde_c
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+PREHOOK: query: alter table date_serde_c set serde 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
+PREHOOK: type: ALTERTABLE_SERIALIZER
+PREHOOK: Input: default@date_serde_c
+PREHOOK: Output: default@date_serde_c
+POSTHOOK: query: alter table date_serde_c set serde 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
+POSTHOOK: type: ALTERTABLE_SERIALIZER
+POSTHOOK: Input: default@date_serde_c
+POSTHOOK: Output: default@date_serde_c
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+PREHOOK: query: insert overwrite table date_serde_c
+ select c1, c2 from date_serde_ls limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_ls
+PREHOOK: Output: default@date_serde_c
+POSTHOOK: query: insert overwrite table date_serde_c
+ select c1, c2 from date_serde_ls limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_ls
+POSTHOOK: Output: default@date_serde_c
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+PREHOOK: query: select * from date_serde_c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_c
+#### A masked pattern was here ####
+POSTHOOK: query: select * from date_serde_c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_c
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+2010-10-20 1064
+PREHOOK: query: select c1, sum(c2) from date_serde_c group by c1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_c
+#### A masked pattern was here ####
+POSTHOOK: query: select c1, sum(c2) from date_serde_c group by c1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_c
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+2010-10-20 1064
+PREHOOK: query: --
+-- LazyBinaryColumnar
+--
+create table date_serde_lbc (
+ c1 date,
+ c2 int
+) stored as rcfile
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: --
+-- LazyBinaryColumnar
+--
+create table date_serde_lbc (
+ c1 date,
+ c2 int
+) stored as rcfile
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@date_serde_lbc
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+PREHOOK: query: alter table date_serde_lbc set serde 'org.apache.hadoop.hive.serde2.columnar.LazyBinaryColumnarSerDe'
+PREHOOK: type: ALTERTABLE_SERIALIZER
+PREHOOK: Input: default@date_serde_lbc
+PREHOOK: Output: default@date_serde_lbc
+POSTHOOK: query: alter table date_serde_lbc set serde 'org.apache.hadoop.hive.serde2.columnar.LazyBinaryColumnarSerDe'
+POSTHOOK: type: ALTERTABLE_SERIALIZER
+POSTHOOK: Input: default@date_serde_lbc
+POSTHOOK: Output: default@date_serde_lbc
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+PREHOOK: query: insert overwrite table date_serde_lbc
+ select c1, c2 from date_serde_c limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_c
+PREHOOK: Output: default@date_serde_lbc
+POSTHOOK: query: insert overwrite table date_serde_lbc
+ select c1, c2 from date_serde_c limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_c
+POSTHOOK: Output: default@date_serde_lbc
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c1 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c2 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+PREHOOK: query: select * from date_serde_lbc
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_lbc
+#### A masked pattern was here ####
+POSTHOOK: query: select * from date_serde_lbc
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_lbc
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c1 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c2 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+2010-10-20 1064
+PREHOOK: query: select c1, sum(c2) from date_serde_lbc group by c1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_lbc
+#### A masked pattern was here ####
+POSTHOOK: query: select c1, sum(c2) from date_serde_lbc group by c1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_lbc
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c1 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c2 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+2010-10-20 1064
+PREHOOK: query: --
+-- ORC
+--
+create table date_serde_orc (
+ c1 date,
+ c2 int
+) stored as orc
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: --
+-- ORC
+--
+create table date_serde_orc (
+ c1 date,
+ c2 int
+) stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@date_serde_orc
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c1 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c2 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+PREHOOK: query: alter table date_serde_orc set serde 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
+PREHOOK: type: ALTERTABLE_SERIALIZER
+PREHOOK: Input: default@date_serde_orc
+PREHOOK: Output: default@date_serde_orc
+POSTHOOK: query: alter table date_serde_orc set serde 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
+POSTHOOK: type: ALTERTABLE_SERIALIZER
+POSTHOOK: Input: default@date_serde_orc
+POSTHOOK: Output: default@date_serde_orc
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c1 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c2 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+PREHOOK: query: insert overwrite table date_serde_orc
+ select c1, c2 from date_serde_lbc limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_lbc
+PREHOOK: Output: default@date_serde_orc
+POSTHOOK: query: insert overwrite table date_serde_orc
+ select c1, c2 from date_serde_lbc limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_lbc
+POSTHOOK: Output: default@date_serde_orc
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c1 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c2 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c1 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c2 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+PREHOOK: query: select * from date_serde_orc
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_orc
+#### A masked pattern was here ####
+POSTHOOK: query: select * from date_serde_orc
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_orc
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c1 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c2 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c1 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c2 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+2010-10-20 1064
+PREHOOK: query: select c1, sum(c2) from date_serde_orc group by c1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_serde_orc
+#### A masked pattern was here ####
+POSTHOOK: query: select c1, sum(c2) from date_serde_orc group by c1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_serde_orc
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c1 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c2 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c1 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c2 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+2010-10-20 1064
+PREHOOK: query: drop table date_serde_regex
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@date_serde_regex
+PREHOOK: Output: default@date_serde_regex
+POSTHOOK: query: drop table date_serde_regex
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@date_serde_regex
+POSTHOOK: Output: default@date_serde_regex
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c1 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c2 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c1 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c2 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+PREHOOK: query: drop table date_serde_lb
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@date_serde_lb
+PREHOOK: Output: default@date_serde_lb
+POSTHOOK: query: drop table date_serde_lb
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@date_serde_lb
+POSTHOOK: Output: default@date_serde_lb
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c1 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c2 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c1 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c2 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+PREHOOK: query: drop table date_serde_ls
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@date_serde_ls
+PREHOOK: Output: default@date_serde_ls
+POSTHOOK: query: drop table date_serde_ls
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@date_serde_ls
+POSTHOOK: Output: default@date_serde_ls
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c1 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c2 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c1 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c2 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+PREHOOK: query: drop table date_serde_c
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@date_serde_c
+PREHOOK: Output: default@date_serde_c
+POSTHOOK: query: drop table date_serde_c
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@date_serde_c
+POSTHOOK: Output: default@date_serde_c
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c1 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c2 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c1 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c2 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+PREHOOK: query: drop table date_serde_lbc
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@date_serde_lbc
+PREHOOK: Output: default@date_serde_lbc
+POSTHOOK: query: drop table date_serde_lbc
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@date_serde_lbc
+POSTHOOK: Output: default@date_serde_lbc
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c1 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c2 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c1 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c2 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+PREHOOK: query: drop table date_serde_orc
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@date_serde_orc
+PREHOOK: Output: default@date_serde_orc
+POSTHOOK: query: drop table date_serde_orc
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@date_serde_orc
+POSTHOOK: Output: default@date_serde_orc
+POSTHOOK: Lineage: date_serde_c.c1 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_c.c2 SIMPLE [(date_serde_ls)date_serde_ls.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c1 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_date, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lb.c2 SIMPLE [(date_serde_regex)date_serde_regex.FieldSchema(name:fl_num, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c1 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_lbc.c2 SIMPLE [(date_serde_c)date_serde_c.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c1 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_ls.c2 SIMPLE [(date_serde_lb)date_serde_lb.FieldSchema(name:c2, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c1 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c1, type:date, comment:from deserializer), ]
+POSTHOOK: Lineage: date_serde_orc.c2 SIMPLE [(date_serde_lbc)date_serde_lbc.FieldSchema(name:c2, type:int, comment:from deserializer), ]
Added: hive/trunk/ql/src/test/results/clientpositive/date_udf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/date_udf.q.out?rev=1507713&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/date_udf.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/date_udf.q.out Sat Jul 27 21:20:03 2013
@@ -0,0 +1,259 @@
+PREHOOK: query: drop table date_udf
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table date_udf
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table date_udf_string
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table date_udf_string
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table date_udf_flight
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table date_udf_flight
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table date_udf (d date)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table date_udf (d date)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@date_udf
+PREHOOK: query: create table date_udf_string (d string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table date_udf_string (d string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@date_udf_string
+PREHOOK: query: from src
+ insert overwrite table date_udf
+ select '2011-05-06' limit 1
+ insert overwrite table date_udf_string
+ select '2011-05-06' limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@date_udf
+PREHOOK: Output: default@date_udf_string
+POSTHOOK: query: from src
+ insert overwrite table date_udf
+ select '2011-05-06' limit 1
+ insert overwrite table date_udf_string
+ select '2011-05-06' limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@date_udf
+POSTHOOK: Output: default@date_udf_string
+POSTHOOK: Lineage: date_udf.d EXPRESSION []
+POSTHOOK: Lineage: date_udf_string.d SIMPLE []
+PREHOOK: query: create table date_udf_flight (
+ ORIGIN_CITY_NAME string,
+ DEST_CITY_NAME string,
+ FL_DATE date,
+ ARR_DELAY float,
+ FL_NUM int
+)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table date_udf_flight (
+ ORIGIN_CITY_NAME string,
+ DEST_CITY_NAME string,
+ FL_DATE date,
+ ARR_DELAY float,
+ FL_NUM int
+)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@date_udf_flight
+POSTHOOK: Lineage: date_udf.d EXPRESSION []
+POSTHOOK: Lineage: date_udf_string.d SIMPLE []
+PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/flights_tiny.txt.1' OVERWRITE INTO TABLE date_udf_flight
+PREHOOK: type: LOAD
+PREHOOK: Output: default@date_udf_flight
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/flights_tiny.txt.1' OVERWRITE INTO TABLE date_udf_flight
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@date_udf_flight
+POSTHOOK: Lineage: date_udf.d EXPRESSION []
+POSTHOOK: Lineage: date_udf_string.d SIMPLE []
+PREHOOK: query: -- Test UDFs with date input
+select unix_timestamp(d), year(d), month(d), day(d), dayofmonth(d),
+ weekofyear(d), to_date(d)
+ from date_udf
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_udf
+#### A masked pattern was here ####
+POSTHOOK: query: -- Test UDFs with date input
+select unix_timestamp(d), year(d), month(d), day(d), dayofmonth(d),
+ weekofyear(d), to_date(d)
+ from date_udf
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_udf
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_udf.d EXPRESSION []
+POSTHOOK: Lineage: date_udf_string.d SIMPLE []
+1304665200 2011 5 6 6 18 2011-05-06
+PREHOOK: query: select date_add(d, 5), date_sub(d, 10)
+ from date_udf
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_udf
+#### A masked pattern was here ####
+POSTHOOK: query: select date_add(d, 5), date_sub(d, 10)
+ from date_udf
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_udf
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_udf.d EXPRESSION []
+POSTHOOK: Lineage: date_udf_string.d SIMPLE []
+2011-05-11 2011-04-26
+PREHOOK: query: select datediff(d, d), datediff(d, '2002-03-21'), datediff('2002-03-21', d),
+ datediff(cast ('2002-03-21 00:00:00' as timestamp), d),
+ datediff(d, cast ('2002-03-21 00:00:00' as timestamp))
+ from date_udf
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_udf
+#### A masked pattern was here ####
+POSTHOOK: query: select datediff(d, d), datediff(d, '2002-03-21'), datediff('2002-03-21', d),
+ datediff(cast ('2002-03-21 00:00:00' as timestamp), d),
+ datediff(d, cast ('2002-03-21 00:00:00' as timestamp))
+ from date_udf
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_udf
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_udf.d EXPRESSION []
+POSTHOOK: Lineage: date_udf_string.d SIMPLE []
+0 3333 -3333 -3332 3332
+PREHOOK: query: -- Test UDFs with string input
+select unix_timestamp(d), year(d), month(d), day(d), dayofmonth(d),
+ weekofyear(d), to_date(d)
+ from date_udf_string
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_udf_string
+#### A masked pattern was here ####
+POSTHOOK: query: -- Test UDFs with string input
+select unix_timestamp(d), year(d), month(d), day(d), dayofmonth(d),
+ weekofyear(d), to_date(d)
+ from date_udf_string
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_udf_string
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_udf.d EXPRESSION []
+POSTHOOK: Lineage: date_udf_string.d SIMPLE []
+NULL 2011 5 6 6 18 2011-05-06
+PREHOOK: query: select date_add(d, 5), date_sub(d, 10) from date_udf_string
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_udf_string
+#### A masked pattern was here ####
+POSTHOOK: query: select date_add(d, 5), date_sub(d, 10) from date_udf_string
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_udf_string
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_udf.d EXPRESSION []
+POSTHOOK: Lineage: date_udf_string.d SIMPLE []
+2011-05-11 2011-04-26
+PREHOOK: query: select datediff(d, d), datediff(d, '2002-03-21'), datediff('2002-03-21', d),
+ datediff('2002-03-21 00:00:00', d),
+ datediff(d, '2002-03-21 00:00:00')
+ from date_udf_string
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_udf_string
+#### A masked pattern was here ####
+POSTHOOK: query: select datediff(d, d), datediff(d, '2002-03-21'), datediff('2002-03-21', d),
+ datediff('2002-03-21 00:00:00', d),
+ datediff(d, '2002-03-21 00:00:00')
+ from date_udf_string
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_udf_string
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_udf.d EXPRESSION []
+POSTHOOK: Lineage: date_udf_string.d SIMPLE []
+0 3333 -3333 -3333 3333
+PREHOOK: query: select
+ to_utc_timestamp(date '1970-01-01', 'America/Los_Angeles'),
+ from_utc_timestamp(date '1970-01-01', 'America/Los_Angeles'),
+ to_utc_timestamp(date '2013-06-19', 'America/Los_Angeles'),
+ from_utc_timestamp(date '2013-06-19', 'America/Los_Angeles')
+ from date_udf
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_udf
+#### A masked pattern was here ####
+POSTHOOK: query: select
+ to_utc_timestamp(date '1970-01-01', 'America/Los_Angeles'),
+ from_utc_timestamp(date '1970-01-01', 'America/Los_Angeles'),
+ to_utc_timestamp(date '2013-06-19', 'America/Los_Angeles'),
+ from_utc_timestamp(date '2013-06-19', 'America/Los_Angeles')
+ from date_udf
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_udf
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_udf.d EXPRESSION []
+POSTHOOK: Lineage: date_udf_string.d SIMPLE []
+1970-01-01 08:00:00 1969-12-31 16:00:00 2013-06-19 07:00:00 2013-06-18 17:00:00
+PREHOOK: query: -- should all be true
+select
+ to_utc_timestamp(date '1970-01-01', 'America/Los_Angeles') = to_utc_timestamp(timestamp('1970-01-01 00:00:00'), 'America/Los_Angeles'),
+ from_utc_timestamp(date '1970-01-01', 'America/Los_Angeles') = from_utc_timestamp(timestamp('1970-01-01 00:00:00'), 'America/Los_Angeles'),
+ to_utc_timestamp(date '2013-06-19', 'America/Los_Angeles') = to_utc_timestamp(timestamp('2013-06-19 00:00:00'), 'America/Los_Angeles'),
+ from_utc_timestamp(date '2013-06-19', 'America/Los_Angeles') = from_utc_timestamp(timestamp('2013-06-19 00:00:00'), 'America/Los_Angeles')
+ from date_udf
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_udf
+#### A masked pattern was here ####
+POSTHOOK: query: -- should all be true
+select
+ to_utc_timestamp(date '1970-01-01', 'America/Los_Angeles') = to_utc_timestamp(timestamp('1970-01-01 00:00:00'), 'America/Los_Angeles'),
+ from_utc_timestamp(date '1970-01-01', 'America/Los_Angeles') = from_utc_timestamp(timestamp('1970-01-01 00:00:00'), 'America/Los_Angeles'),
+ to_utc_timestamp(date '2013-06-19', 'America/Los_Angeles') = to_utc_timestamp(timestamp('2013-06-19 00:00:00'), 'America/Los_Angeles'),
+ from_utc_timestamp(date '2013-06-19', 'America/Los_Angeles') = from_utc_timestamp(timestamp('2013-06-19 00:00:00'), 'America/Los_Angeles')
+ from date_udf
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_udf
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_udf.d EXPRESSION []
+POSTHOOK: Lineage: date_udf_string.d SIMPLE []
+true true true true
+PREHOOK: query: -- Aggregation functions (min/max)
+select min(fl_date) from date_udf_flight
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_udf_flight
+#### A masked pattern was here ####
+POSTHOOK: query: -- Aggregation functions (min/max)
+select min(fl_date) from date_udf_flight
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_udf_flight
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_udf.d EXPRESSION []
+POSTHOOK: Lineage: date_udf_string.d SIMPLE []
+2010-10-20
+PREHOOK: query: select max(fl_date) from date_udf_flight
+PREHOOK: type: QUERY
+PREHOOK: Input: default@date_udf_flight
+#### A masked pattern was here ####
+POSTHOOK: query: select max(fl_date) from date_udf_flight
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@date_udf_flight
+#### A masked pattern was here ####
+POSTHOOK: Lineage: date_udf.d EXPRESSION []
+POSTHOOK: Lineage: date_udf_string.d SIMPLE []
+2010-10-31
+PREHOOK: query: drop table date_udf
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@date_udf
+PREHOOK: Output: default@date_udf
+POSTHOOK: query: drop table date_udf
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@date_udf
+POSTHOOK: Output: default@date_udf
+POSTHOOK: Lineage: date_udf.d EXPRESSION []
+POSTHOOK: Lineage: date_udf_string.d SIMPLE []
+PREHOOK: query: drop table date_udf_string
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@date_udf_string
+PREHOOK: Output: default@date_udf_string
+POSTHOOK: query: drop table date_udf_string
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@date_udf_string
+POSTHOOK: Output: default@date_udf_string
+POSTHOOK: Lineage: date_udf.d EXPRESSION []
+POSTHOOK: Lineage: date_udf_string.d SIMPLE []
+PREHOOK: query: drop table date_udf_flight
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@date_udf_flight
+PREHOOK: Output: default@date_udf_flight
+POSTHOOK: query: drop table date_udf_flight
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@date_udf_flight
+POSTHOOK: Output: default@date_udf_flight
+POSTHOOK: Lineage: date_udf.d EXPRESSION []
+POSTHOOK: Lineage: date_udf_string.d SIMPLE []
Added: hive/trunk/ql/src/test/results/clientpositive/partition_date.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/partition_date.q.out?rev=1507713&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/partition_date.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/partition_date.q.out Sat Jul 27 21:20:03 2013
@@ -0,0 +1,392 @@
+PREHOOK: query: drop table partition_date_1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table partition_date_1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table partition_date_1 (key string, value string) partitioned by (dt date, region int)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table partition_date_1 (key string, value string) partitioned by (dt date, region int)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@partition_date_1
+PREHOOK: query: insert overwrite table partition_date_1 partition(dt='2000-01-01', region=1)
+ select * from src limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@partition_date_1@dt=2000-01-01/region=1
+POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2000-01-01', region=1)
+ select * from src limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@partition_date_1@dt=2000-01-01/region=1
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_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_date_1 partition(dt='2000-01-01', region=2)
+ select * from src limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@partition_date_1@dt=2000-01-01/region=2
+POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2000-01-01', region=2)
+ select * from src limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@partition_date_1@dt=2000-01-01/region=2
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_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_date_1 partition(dt='2013-08-08', region=1)
+ select * from src limit 20
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@partition_date_1@dt=2013-08-08/region=1
+POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-08-08', region=1)
+ select * from src limit 20
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@partition_date_1@dt=2013-08-08/region=1
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-08-08', region=10)
+ select * from src limit 11
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@partition_date_1@dt=2013-08-08/region=10
+POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-08-08', region=10)
+ select * from src limit 11
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@partition_date_1@dt=2013-08-08/region=10
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select distinct dt from partition_date_1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
+PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2
+PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
+PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=10
+#### A masked pattern was here ####
+POSTHOOK: query: select distinct dt from partition_date_1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
+POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2
+POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
+POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=10
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+2000-01-01
+2013-08-08
+PREHOOK: query: select *, cast(dt as timestamp) from partition_date_1 where dt = '2000-01-01' and region = 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2
+#### A masked pattern was here ####
+POSTHOOK: query: select *, cast(dt as timestamp) from partition_date_1 where dt = '2000-01-01' and region = 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+238 val_238 2000-01-01 2 1969-12-31 16:00:00
+86 val_86 2000-01-01 2 1969-12-31 16:00:00
+311 val_311 2000-01-01 2 1969-12-31 16:00:00
+27 val_27 2000-01-01 2 1969-12-31 16:00:00
+165 val_165 2000-01-01 2 1969-12-31 16:00:00
+PREHOOK: query: -- 15
+select count(*) from partition_date_1 where dt = date '2000-01-01'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
+PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2
+#### A masked pattern was here ####
+POSTHOOK: query: -- 15
+select count(*) from partition_date_1 where dt = date '2000-01-01'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
+POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+15
+PREHOOK: query: -- 15. Also try with string value in predicate
+select count(*) from partition_date_1 where dt = '2000-01-01'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
+PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2
+#### A masked pattern was here ####
+POSTHOOK: query: -- 15. Also try with string value in predicate
+select count(*) from partition_date_1 where dt = '2000-01-01'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
+POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+15
+PREHOOK: query: -- 5
+select count(*) from partition_date_1 where dt = date '2000-01-01' and region = 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2
+#### A masked pattern was here ####
+POSTHOOK: query: -- 5
+select count(*) from partition_date_1 where dt = date '2000-01-01' and region = 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+5
+PREHOOK: query: -- 11
+select count(*) from partition_date_1 where dt = date '2013-08-08' and region = 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=10
+#### A masked pattern was here ####
+POSTHOOK: query: -- 11
+select count(*) from partition_date_1 where dt = date '2013-08-08' and region = 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=10
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+11
+PREHOOK: query: -- 30
+select count(*) from partition_date_1 where region = 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
+PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 30
+select count(*) from partition_date_1 where region = 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
+POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+30
+PREHOOK: query: -- 0
+select count(*) from partition_date_1 where dt = date '2000-01-01' and region = 3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 0
+select count(*) from partition_date_1 where dt = date '2000-01-01' and region = 3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+0
+PREHOOK: query: -- 0
+select count(*) from partition_date_1 where dt = date '1999-01-01'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 0
+select count(*) from partition_date_1 where dt = date '1999-01-01'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+0
+PREHOOK: query: -- Try other comparison operations
+
+-- 20
+select count(*) from partition_date_1 where dt > date '2000-01-01' and region = 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
+#### A masked pattern was here ####
+POSTHOOK: query: -- Try other comparison operations
+
+-- 20
+select count(*) from partition_date_1 where dt > date '2000-01-01' and region = 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+20
+PREHOOK: query: -- 10
+select count(*) from partition_date_1 where dt < date '2000-01-02' and region = 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 10
+select count(*) from partition_date_1 where dt < date '2000-01-02' and region = 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+10
+PREHOOK: query: -- 20
+select count(*) from partition_date_1 where dt >= date '2000-01-02' and region = 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 20
+select count(*) from partition_date_1 where dt >= date '2000-01-02' and region = 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+20
+PREHOOK: query: -- 10
+select count(*) from partition_date_1 where dt <= date '2000-01-01' and region = 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 10
+select count(*) from partition_date_1 where dt <= date '2000-01-01' and region = 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+10
+PREHOOK: query: -- 20
+select count(*) from partition_date_1 where dt <> date '2000-01-01' and region = 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 20
+select count(*) from partition_date_1 where dt <> date '2000-01-01' and region = 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+20
+PREHOOK: query: drop table partition_date_1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@partition_date_1
+PREHOOK: Output: default@partition_date_1
+POSTHOOK: query: drop table partition_date_1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@partition_date_1
+POSTHOOK: Output: default@partition_date_1
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]