hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gunt...@apache.org
Subject [3/7] hive git commit: HIVE-15873: Remove Windows-specific code (Gunther Hagleitner, reviewed by Ashtuosh Chauhan)
Date Sat, 11 Feb 2017 20:59:48 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/38ad7792/ql/src/test/results/clientpositive/partition_timestamp2_win.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/partition_timestamp2_win.q.out b/ql/src/test/results/clientpositive/partition_timestamp2_win.q.out
deleted file mode 100755
index f39db1f..0000000
--- a/ql/src/test/results/clientpositive/partition_timestamp2_win.q.out
+++ /dev/null
@@ -1,399 +0,0 @@
-PREHOOK: query: -- Windows-specific due to space character being escaped in Hive paths on
Windows.
--- INCLUDE_OS_WINDOWS
-drop table partition_timestamp2_1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: -- Windows-specific due to space character being escaped in Hive paths on
Windows.
--- INCLUDE_OS_WINDOWS
-drop table partition_timestamp2_1
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table partition_timestamp2_1 (key string, value string) partitioned
by (dt timestamp, region int)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@partition_timestamp2_1
-POSTHOOK: query: create table partition_timestamp2_1 (key string, value string) partitioned
by (dt timestamp, region int)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@partition_timestamp2_1
-PREHOOK: query: -- test timestamp literal syntax
-from (select * from src tablesample (1 rows)) x
-insert overwrite table partition_timestamp2_1 partition(dt=timestamp '2000-01-01 00:00:00',
region=1) select *
-insert overwrite table partition_timestamp2_1 partition(dt=timestamp '2000-01-01 01:00:00',
region=1) select *
-insert overwrite table partition_timestamp2_1 partition(dt=timestamp '1999-01-01 00:00:00',
region=2) select *
-insert overwrite table partition_timestamp2_1 partition(dt=timestamp '1999-01-01 01:00:00',
region=2) select *
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-PREHOOK: Output: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-PREHOOK: Output: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-PREHOOK: Output: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-POSTHOOK: query: -- test timestamp literal syntax
-from (select * from src tablesample (1 rows)) x
-insert overwrite table partition_timestamp2_1 partition(dt=timestamp '2000-01-01 00:00:00',
region=1) select *
-insert overwrite table partition_timestamp2_1 partition(dt=timestamp '2000-01-01 01:00:00',
region=1) select *
-insert overwrite table partition_timestamp2_1 partition(dt=timestamp '1999-01-01 00:00:00',
region=2) select *
-insert overwrite table partition_timestamp2_1 partition(dt=timestamp '1999-01-01 01:00:00',
region=2) select *
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-POSTHOOK: Output: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-POSTHOOK: Output: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-POSTHOOK: Output: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-POSTHOOK: Lineage: partition_timestamp2_1 PARTITION(dt=1999-01-01 00:00:00.0,region=2).key
SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_timestamp2_1 PARTITION(dt=1999-01-01 00:00:00.0,region=2).value
SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_timestamp2_1 PARTITION(dt=1999-01-01 01:00:00.0,region=2).key
SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_timestamp2_1 PARTITION(dt=1999-01-01 01:00:00.0,region=2).value
SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_timestamp2_1 PARTITION(dt=2000-01-01 00:00:00.0,region=1).key
SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_timestamp2_1 PARTITION(dt=2000-01-01 00:00:00.0,region=1).value
SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_timestamp2_1 PARTITION(dt=2000-01-01 01:00:00.0,region=1).key
SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_timestamp2_1 PARTITION(dt=2000-01-01 01:00:00.0,region=1).value
SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select distinct dt from partition_timestamp2_1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp2_1
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: select distinct dt from partition_timestamp2_1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-1999-01-01 00:00:00
-1999-01-01 01:00:00
-2000-01-01 00:00:00
-2000-01-01 01:00:00
-PREHOOK: query: select * from partition_timestamp2_1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp2_1
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: select * from partition_timestamp2_1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-238	val_238	1999-01-01 00:00:00	2
-238	val_238	1999-01-01 01:00:00	2
-238	val_238	2000-01-01 00:00:00	1
-238	val_238	2000-01-01 01:00:00	1
-PREHOOK: query: -- insert overwrite
-insert overwrite table partition_timestamp2_1 partition(dt=timestamp '2000-01-01 00:00:00',
region=1)
-  select 'changed_key', 'changed_value' from src tablesample (2 rows)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-POSTHOOK: query: -- insert overwrite
-insert overwrite table partition_timestamp2_1 partition(dt=timestamp '2000-01-01 00:00:00',
region=1)
-  select 'changed_key', 'changed_value' from src tablesample (2 rows)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-POSTHOOK: Lineage: partition_timestamp2_1 PARTITION(dt=2000-01-01 00:00:00.0,region=1).key
SIMPLE []
-POSTHOOK: Lineage: partition_timestamp2_1 PARTITION(dt=2000-01-01 00:00:00.0,region=1).value
SIMPLE []
-PREHOOK: query: select * from partition_timestamp2_1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp2_1
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: select * from partition_timestamp2_1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-238	val_238	1999-01-01 00:00:00	2
-238	val_238	1999-01-01 01:00:00	2
-changed_key	changed_value	2000-01-01 00:00:00	1
-changed_key	changed_value	2000-01-01 00:00:00	1
-238	val_238	2000-01-01 01:00:00	1
-PREHOOK: query: -- truncate
-truncate table partition_timestamp2_1 partition(dt=timestamp '2000-01-01 00:00:00', region=1)
-PREHOOK: type: TRUNCATETABLE
-PREHOOK: Output: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-POSTHOOK: query: -- truncate
-truncate table partition_timestamp2_1 partition(dt=timestamp '2000-01-01 00:00:00', region=1)
-POSTHOOK: type: TRUNCATETABLE
-POSTHOOK: Output: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-PREHOOK: query: select distinct dt from partition_timestamp2_1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp2_1
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: select distinct dt from partition_timestamp2_1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-1999-01-01 00:00:00
-1999-01-01 01:00:00
-2000-01-01 00:00:00
-2000-01-01 01:00:00
-PREHOOK: query: select * from partition_timestamp2_1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp2_1
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: select * from partition_timestamp2_1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-238	val_238	1999-01-01 00:00:00	2
-238	val_238	1999-01-01 01:00:00	2
-238	val_238	2000-01-01 01:00:00	1
-PREHOOK: query: -- alter table add partition
-alter table partition_timestamp2_1 add partition (dt=timestamp '1980-01-02 00:00:00', region=3)
-PREHOOK: type: ALTERTABLE_ADDPARTS
-PREHOOK: Output: default@partition_timestamp2_1
-POSTHOOK: query: -- alter table add partition
-alter table partition_timestamp2_1 add partition (dt=timestamp '1980-01-02 00:00:00', region=3)
-POSTHOOK: type: ALTERTABLE_ADDPARTS
-POSTHOOK: Output: default@partition_timestamp2_1
-POSTHOOK: Output: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-PREHOOK: query: select distinct dt from partition_timestamp2_1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp2_1
-PREHOOK: Input: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: select distinct dt from partition_timestamp2_1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-1980-01-02 00:00:00
-1999-01-01 00:00:00
-1999-01-01 01:00:00
-2000-01-01 00:00:00
-2000-01-01 01:00:00
-PREHOOK: query: select * from partition_timestamp2_1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp2_1
-PREHOOK: Input: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: select * from partition_timestamp2_1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-238	val_238	1999-01-01 00:00:00	2
-238	val_238	1999-01-01 01:00:00	2
-238	val_238	2000-01-01 01:00:00	1
-PREHOOK: query: -- alter table drop
-alter table partition_timestamp2_1 drop partition (dt=timestamp '1999-01-01 01:00:00', region=2)
-PREHOOK: type: ALTERTABLE_DROPPARTS
-PREHOOK: Input: default@partition_timestamp2_1
-PREHOOK: Output: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-POSTHOOK: query: -- alter table drop
-alter table partition_timestamp2_1 drop partition (dt=timestamp '1999-01-01 01:00:00', region=2)
-POSTHOOK: type: ALTERTABLE_DROPPARTS
-POSTHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: Output: default@partition_timestamp2_1@dt=1999-01-01%2001%3A00%3A00.0/region=2
-PREHOOK: query: select distinct dt from partition_timestamp2_1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp2_1
-PREHOOK: Input: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: select distinct dt from partition_timestamp2_1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-1980-01-02 00:00:00
-1999-01-01 00:00:00
-2000-01-01 00:00:00
-2000-01-01 01:00:00
-PREHOOK: query: select * from partition_timestamp2_1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp2_1
-PREHOOK: Input: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: select * from partition_timestamp2_1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-238	val_238	1999-01-01 00:00:00	2
-238	val_238	2000-01-01 01:00:00	1
-PREHOOK: query: -- alter table set serde
-alter table partition_timestamp2_1 partition(dt=timestamp '1980-01-02 00:00:00', region=3)
-  set serde 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
-PREHOOK: type: ALTERPARTITION_SERIALIZER
-PREHOOK: Input: default@partition_timestamp2_1
-PREHOOK: Output: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-POSTHOOK: query: -- alter table set serde
-alter table partition_timestamp2_1 partition(dt=timestamp '1980-01-02 00:00:00', region=3)
-  set serde 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
-POSTHOOK: type: ALTERPARTITION_SERIALIZER
-POSTHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-POSTHOOK: Output: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-PREHOOK: query: -- alter table set fileformat
-alter table partition_timestamp2_1 partition(dt=timestamp '1980-01-02 00:00:00', region=3)
-  set fileformat rcfile
-PREHOOK: type: ALTERPARTITION_FILEFORMAT
-PREHOOK: Input: default@partition_timestamp2_1
-PREHOOK: Output: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-POSTHOOK: query: -- alter table set fileformat
-alter table partition_timestamp2_1 partition(dt=timestamp '1980-01-02 00:00:00', region=3)
-  set fileformat rcfile
-POSTHOOK: type: ALTERPARTITION_FILEFORMAT
-POSTHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-POSTHOOK: Output: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-PREHOOK: query: describe extended partition_timestamp2_1  partition(dt=timestamp '1980-01-02
00:00:00', region=3)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: query: describe extended partition_timestamp2_1  partition(dt=timestamp '1980-01-02
00:00:00', region=3)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@partition_timestamp2_1
-key                 	string              	                    
-value               	string              	                    
-dt                  	timestamp           	                    
-region              	int                 	                    
-	 	 
-# Partition Information	 	 
-# col_name            	data_type           	comment             
-	 	 
-dt                  	timestamp           	                    
-region              	int                 	                    
-	 	 
-#### A masked pattern was here ####
-PREHOOK: query: insert overwrite table partition_timestamp2_1 partition(dt=timestamp '1980-01-02
00:00:00', region=3)
-  select * from src tablesample (2 rows)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-POSTHOOK: query: insert overwrite table partition_timestamp2_1 partition(dt=timestamp '1980-01-02
00:00:00', region=3)
-  select * from src tablesample (2 rows)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-POSTHOOK: Lineage: partition_timestamp2_1 PARTITION(dt=1980-01-02 00:00:00.0,region=3).key
SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_timestamp2_1 PARTITION(dt=1980-01-02 00:00:00.0,region=3).value
SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from partition_timestamp2_1 order by key,value,dt,region
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp2_1
-PREHOOK: Input: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-PREHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-PREHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: select * from partition_timestamp2_1 order by key,value,dt,region
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1999-01-01%2000%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2000%3A00%3A00.0/region=1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-238	val_238	1980-01-02 00:00:00	3
-238	val_238	1999-01-01 00:00:00	2
-238	val_238	2000-01-01 01:00:00	1
-86	val_86	1980-01-02 00:00:00	3
-PREHOOK: query: -- alter table set location
-alter table partition_timestamp2_1 partition(dt=timestamp '1980-01-02 00:00:00', region=3)
-#### A masked pattern was here ####
-PREHOOK: type: ALTERPARTITION_LOCATION
-PREHOOK: Input: default@partition_timestamp2_1
-PREHOOK: Output: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-#### A masked pattern was here ####
-POSTHOOK: query: -- alter table set location
-alter table partition_timestamp2_1 partition(dt=timestamp '1980-01-02 00:00:00', region=3)
-#### A masked pattern was here ####
-POSTHOOK: type: ALTERPARTITION_LOCATION
-POSTHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-POSTHOOK: Output: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-#### A masked pattern was here ####
-PREHOOK: query: describe extended partition_timestamp2_1 partition(dt=timestamp '1980-01-02
00:00:00', region=3)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: query: describe extended partition_timestamp2_1 partition(dt=timestamp '1980-01-02
00:00:00', region=3)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@partition_timestamp2_1
-key                 	string              	                    
-value               	string              	                    
-dt                  	timestamp           	                    
-region              	int                 	                    
-	 	 
-# Partition Information	 	 
-# col_name            	data_type           	comment             
-	 	 
-dt                  	timestamp           	                    
-region              	int                 	                    
-	 	 
-#### A masked pattern was here ####
-PREHOOK: query: -- alter table touch
-alter table partition_timestamp2_1 touch partition(dt=timestamp '1980-01-02 00:00:00', region=3)
-PREHOOK: type: ALTERTABLE_TOUCH
-PREHOOK: Input: default@partition_timestamp2_1
-PREHOOK: Output: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-POSTHOOK: query: -- alter table touch
-alter table partition_timestamp2_1 touch partition(dt=timestamp '1980-01-02 00:00:00', region=3)
-POSTHOOK: type: ALTERTABLE_TOUCH
-POSTHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: Input: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-POSTHOOK: Output: default@partition_timestamp2_1@dt=1980-01-02%2000%3A00%3A00.0/region=3
-PREHOOK: query: drop table partition_timestamp2_1
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@partition_timestamp2_1
-PREHOOK: Output: default@partition_timestamp2_1
-POSTHOOK: query: drop table partition_timestamp2_1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@partition_timestamp2_1
-POSTHOOK: Output: default@partition_timestamp2_1

http://git-wip-us.apache.org/repos/asf/hive/blob/38ad7792/ql/src/test/results/clientpositive/partition_timestamp_win.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/partition_timestamp_win.q.out b/ql/src/test/results/clientpositive/partition_timestamp_win.q.out
deleted file mode 100755
index bbb9773..0000000
--- a/ql/src/test/results/clientpositive/partition_timestamp_win.q.out
+++ /dev/null
@@ -1,316 +0,0 @@
-PREHOOK: query: -- Windows-specific test due to space character being escaped in Hive paths
on Windows.
--- INCLUDE_OS_WINDOWS
-drop table partition_timestamp_1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: -- Windows-specific test due to space character being escaped in Hive paths
on Windows.
--- INCLUDE_OS_WINDOWS
-drop table partition_timestamp_1
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table partition_timestamp_1 (key string, value string) partitioned
by (dt timestamp, region string)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@partition_timestamp_1
-POSTHOOK: query: create table partition_timestamp_1 (key string, value string) partitioned
by (dt timestamp, region string)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@partition_timestamp_1
-PREHOOK: query: insert overwrite table partition_timestamp_1 partition(dt='2000-01-01 01:00:00',
region= '1')
-  select * from src tablesample (10 rows)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@partition_timestamp_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-POSTHOOK: query: insert overwrite table partition_timestamp_1 partition(dt='2000-01-01 01:00:00',
region= '1')
-  select * from src tablesample (10 rows)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@partition_timestamp_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-POSTHOOK: Lineage: partition_timestamp_1 PARTITION(dt=2000-01-01 01:00:00.0,region=1).key
SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_timestamp_1 PARTITION(dt=2000-01-01 01:00:00.0,region=1).value
SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: insert overwrite table partition_timestamp_1 partition(dt='2000-01-01 02:00:00',
region= '2')
-  select * from src tablesample (5 rows)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@partition_timestamp_1@dt=2000-01-01%2002%3A00%3A00.0/region=2
-POSTHOOK: query: insert overwrite table partition_timestamp_1 partition(dt='2000-01-01 02:00:00',
region= '2')
-  select * from src tablesample (5 rows)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@partition_timestamp_1@dt=2000-01-01%2002%3A00%3A00.0/region=2
-POSTHOOK: Lineage: partition_timestamp_1 PARTITION(dt=2000-01-01 02:00:00.0,region=2).key
SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_timestamp_1 PARTITION(dt=2000-01-01 02:00:00.0,region=2).value
SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: insert overwrite table partition_timestamp_1 partition(dt='2001-01-01 01:00:00',
region= '2020-20-20')
-  select * from src tablesample (5 rows)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@partition_timestamp_1@dt=2001-01-01%2001%3A00%3A00.0/region=2020-20-20
-POSTHOOK: query: insert overwrite table partition_timestamp_1 partition(dt='2001-01-01 01:00:00',
region= '2020-20-20')
-  select * from src tablesample (5 rows)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@partition_timestamp_1@dt=2001-01-01%2001%3A00%3A00.0/region=2020-20-20
-POSTHOOK: Lineage: partition_timestamp_1 PARTITION(dt=2001-01-01 01:00:00.0,region=2020-20-20).key
SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_timestamp_1 PARTITION(dt=2001-01-01 01:00:00.0,region=2020-20-20).value
SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: insert overwrite table partition_timestamp_1 partition(dt='2001-01-01 02:00:00',
region= '1')
-  select * from src tablesample (20 rows)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@partition_timestamp_1@dt=2001-01-01%2002%3A00%3A00.0/region=1
-POSTHOOK: query: insert overwrite table partition_timestamp_1 partition(dt='2001-01-01 02:00:00',
region= '1')
-  select * from src tablesample (20 rows)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@partition_timestamp_1@dt=2001-01-01%2002%3A00%3A00.0/region=1
-POSTHOOK: Lineage: partition_timestamp_1 PARTITION(dt=2001-01-01 02:00:00.0,region=1).key
SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_timestamp_1 PARTITION(dt=2001-01-01 02:00:00.0,region=1).value
SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: insert overwrite table partition_timestamp_1 partition(dt='2001-01-01 03:00:00',
region= '10')
-  select * from src tablesample (11 rows)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@partition_timestamp_1@dt=2001-01-01%2003%3A00%3A00.0/region=10
-POSTHOOK: query: insert overwrite table partition_timestamp_1 partition(dt='2001-01-01 03:00:00',
region= '10')
-  select * from src tablesample (11 rows)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@partition_timestamp_1@dt=2001-01-01%2003%3A00%3A00.0/region=10
-POSTHOOK: Lineage: partition_timestamp_1 PARTITION(dt=2001-01-01 03:00:00.0,region=10).key
SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: partition_timestamp_1 PARTITION(dt=2001-01-01 03:00:00.0,region=10).value
SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select distinct dt from partition_timestamp_1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-PREHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-PREHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2002%3A00%3A00.0/region=2
-PREHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2001%3A00%3A00.0/region=2020-20-20
-PREHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2002%3A00%3A00.0/region=1
-PREHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2003%3A00%3A00.0/region=10
-#### A masked pattern was here ####
-POSTHOOK: query: select distinct dt from partition_timestamp_1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2002%3A00%3A00.0/region=2
-POSTHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2001%3A00%3A00.0/region=2020-20-20
-POSTHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2002%3A00%3A00.0/region=1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2003%3A00%3A00.0/region=10
-#### A masked pattern was here ####
-2000-01-01 01:00:00
-2000-01-01 02:00:00
-2001-01-01 01:00:00
-2001-01-01 02:00:00
-2001-01-01 03:00:00
-PREHOOK: query: select * from partition_timestamp_1 where dt = '2000-01-01 01:00:00' and
region = '2' order by key,value
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-#### A masked pattern was here ####
-POSTHOOK: query: select * from partition_timestamp_1 where dt = '2000-01-01 01:00:00' and
region = '2' order by key,value
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-#### A masked pattern was here ####
-PREHOOK: query: -- 10
-select count(*) from partition_timestamp_1 where dt = timestamp '2000-01-01 01:00:00'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-PREHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: -- 10
-select count(*) from partition_timestamp_1 where dt = timestamp '2000-01-01 01:00:00'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-10
-PREHOOK: query: -- 10.  Also try with string value in predicate
-select count(*) from partition_timestamp_1 where dt = '2000-01-01 01:00:00'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-PREHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: -- 10.  Also try with string value in predicate
-select count(*) from partition_timestamp_1 where dt = '2000-01-01 01:00:00'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-10
-PREHOOK: query: -- 5
-select count(*) from partition_timestamp_1 where dt = timestamp '2000-01-01 02:00:00' and
region = '2'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-PREHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2002%3A00%3A00.0/region=2
-#### A masked pattern was here ####
-POSTHOOK: query: -- 5
-select count(*) from partition_timestamp_1 where dt = timestamp '2000-01-01 02:00:00' and
region = '2'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2002%3A00%3A00.0/region=2
-#### A masked pattern was here ####
-5
-PREHOOK: query: -- 11
-select count(*) from partition_timestamp_1 where dt = timestamp '2001-01-01 03:00:00' and
region = '10'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-PREHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2003%3A00%3A00.0/region=10
-#### A masked pattern was here ####
-POSTHOOK: query: -- 11
-select count(*) from partition_timestamp_1 where dt = timestamp '2001-01-01 03:00:00' and
region = '10'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2003%3A00%3A00.0/region=10
-#### A masked pattern was here ####
-11
-PREHOOK: query: -- 30
-select count(*) from partition_timestamp_1 where region = '1'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-PREHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-PREHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2002%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: -- 30
-select count(*) from partition_timestamp_1 where region = '1'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2002%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-30
-PREHOOK: query: -- 0
-select count(*) from partition_timestamp_1 where dt = timestamp '2000-01-01 01:00:00' and
region = '3'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-#### A masked pattern was here ####
-POSTHOOK: query: -- 0
-select count(*) from partition_timestamp_1 where dt = timestamp '2000-01-01 01:00:00' and
region = '3'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-#### A masked pattern was here ####
-0
-PREHOOK: query: -- 0
-select count(*) from partition_timestamp_1 where dt = timestamp '1999-01-01 01:00:00'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-#### A masked pattern was here ####
-POSTHOOK: query: -- 0
-select count(*) from partition_timestamp_1 where dt = timestamp '1999-01-01 01:00:00'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-#### A masked pattern was here ####
-0
-PREHOOK: query: -- Try other comparison operations
-
--- 20
-select count(*) from partition_timestamp_1 where dt > timestamp '2000-01-01 01:00:00'
and region = '1'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-PREHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2002%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: -- Try other comparison operations
-
--- 20
-select count(*) from partition_timestamp_1 where dt > timestamp '2000-01-01 01:00:00'
and region = '1'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2002%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-20
-PREHOOK: query: -- 10
-select count(*) from partition_timestamp_1 where dt < timestamp '2000-01-02 01:00:00'
and region = '1'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-PREHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: -- 10
-select count(*) from partition_timestamp_1 where dt < timestamp '2000-01-02 01:00:00'
and region = '1'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-10
-PREHOOK: query: -- 20
-select count(*) from partition_timestamp_1 where dt >= timestamp '2000-01-02 01:00:00'
and region = '1'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-PREHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2002%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: -- 20
-select count(*) from partition_timestamp_1 where dt >= timestamp '2000-01-02 01:00:00'
and region = '1'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2002%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-20
-PREHOOK: query: -- 10
-select count(*) from partition_timestamp_1 where dt <= timestamp '2000-01-01 01:00:00'
and region = '1'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-PREHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: -- 10
-select count(*) from partition_timestamp_1 where dt <= timestamp '2000-01-01 01:00:00'
and region = '1'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-10
-PREHOOK: query: -- 20
-select count(*) from partition_timestamp_1 where dt <> timestamp '2000-01-01 01:00:00'
and region = '1'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-PREHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2002%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: -- 20
-select count(*) from partition_timestamp_1 where dt <> timestamp '2000-01-01 01:00:00'
and region = '1'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2002%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-20
-PREHOOK: query: -- 10
-select count(*) from partition_timestamp_1 where dt between timestamp '1999-12-30 12:00:00'
and timestamp '2000-01-03 12:00:00' and region = '1'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-PREHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-POSTHOOK: query: -- 10
-select count(*) from partition_timestamp_1 where dt between timestamp '1999-12-30 12:00:00'
and timestamp '2000-01-03 12:00:00' and region = '1'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2000-01-01%2001%3A00%3A00.0/region=1
-#### A masked pattern was here ####
-10
-PREHOOK: query: -- Try a string key with timestamp-like strings
-
--- 5
-select count(*) from partition_timestamp_1 where region = '2020-20-20'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-PREHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2001%3A00%3A00.0/region=2020-20-20
-#### A masked pattern was here ####
-POSTHOOK: query: -- Try a string key with timestamp-like strings
-
--- 5
-select count(*) from partition_timestamp_1 where region = '2020-20-20'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2001%3A00%3A00.0/region=2020-20-20
-#### A masked pattern was here ####
-5
-PREHOOK: query: -- 5
-select count(*) from partition_timestamp_1 where region > '2010-01-01'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@partition_timestamp_1
-PREHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2001%3A00%3A00.0/region=2020-20-20
-#### A masked pattern was here ####
-POSTHOOK: query: -- 5
-select count(*) from partition_timestamp_1 where region > '2010-01-01'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@partition_timestamp_1
-POSTHOOK: Input: default@partition_timestamp_1@dt=2001-01-01%2001%3A00%3A00.0/region=2020-20-20
-#### A masked pattern was here ####
-5
-PREHOOK: query: drop table partition_timestamp_1
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@partition_timestamp_1
-PREHOOK: Output: default@partition_timestamp_1
-POSTHOOK: query: drop table partition_timestamp_1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@partition_timestamp_1
-POSTHOOK: Output: default@partition_timestamp_1

http://git-wip-us.apache.org/repos/asf/hive/blob/38ad7792/ql/src/test/results/clientpositive/scriptfile1_win.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/scriptfile1_win.q.out b/ql/src/test/results/clientpositive/scriptfile1_win.q.out
deleted file mode 100644
index 0c9c546..0000000
--- a/ql/src/test/results/clientpositive/scriptfile1_win.q.out
+++ /dev/null
@@ -1,55 +0,0 @@
-PREHOOK: query: -- INCLUDE_OS_WINDOWS
-
-CREATE TABLE dest1(key INT, value STRING)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@dest1
-POSTHOOK: query: -- INCLUDE_OS_WINDOWS
-
-CREATE TABLE dest1(key INT, value STRING)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@dest1
-PREHOOK: query: FROM (
-  FROM src
-  SELECT TRANSFORM(src.key, src.value)
-         USING 'testgrep_win.bat' AS (tkey, tvalue)
-  CLUSTER BY tkey
-) tmap
-INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@dest1
-POSTHOOK: query: FROM (
-  FROM src
-  SELECT TRANSFORM(src.key, src.value)
-         USING 'testgrep_win.bat' AS (tkey, tvalue)
-  CLUSTER BY tkey
-) tmap
-INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@dest1
-POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default),
(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default),
(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@dest1
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@dest1
-#### A masked pattern was here ####
-NULL	NULL
-NULL	NULL
-10	val_10
-100	val_100
-100	val_100
-103	val_103
-103	val_103
-104	val_104
-104	val_104
-105	val_105
-310	val_310
-NULL	NULL
-NULL	NULL


Mime
View raw message