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 2016/10/21 13:51:59 UTC
[1/3] hive git commit: HIVE-14913 : addendum patch
Repository: hive
Updated Branches:
refs/heads/master f2efa6a2b -> 6cca9911b
http://git-wip-us.apache.org/repos/asf/hive/blob/6cca9911/ql/src/test/results/clientpositive/llap/orc_ppd_basic.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/orc_ppd_basic.q.out b/ql/src/test/results/clientpositive/llap/orc_ppd_basic.q.out
index f50d28b..8eb6e35 100644
--- a/ql/src/test/results/clientpositive/llap/orc_ppd_basic.q.out
+++ b/ql/src/test/results/clientpositive/llap/orc_ppd_basic.q.out
@@ -221,11 +221,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 16711
- HDFS_BYTES_WRITTEN: 104
- HDFS_READ_OPS: 5
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -245,11 +240,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
RECORDS_OUT_0: 1
@@ -260,11 +250,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 638
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 4
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -287,11 +272,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 102
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -312,11 +292,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 102
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -338,11 +313,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 102
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -364,11 +334,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -390,11 +355,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 102
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -415,11 +375,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 102
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -441,11 +396,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 104
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -467,11 +417,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 102
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -493,11 +438,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 104
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -519,11 +459,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -545,11 +480,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 102
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -571,11 +501,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 103
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -598,11 +523,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
RECORDS_OUT_0: 1
@@ -612,11 +532,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
RECORDS_OUT_0: 1
@@ -626,11 +541,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -651,11 +561,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -682,11 +587,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
RECORDS_OUT_0: 1
@@ -697,11 +597,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 4402
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 4
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -725,11 +620,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -750,11 +640,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -776,11 +661,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
RECORDS_OUT_0: 1
@@ -791,11 +671,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 104
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -817,11 +692,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -843,11 +713,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -868,11 +733,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -893,11 +753,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -919,11 +774,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 102
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -945,11 +795,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 102
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -971,11 +816,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 102
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -997,11 +837,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 102
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -1023,11 +858,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -1049,11 +879,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -1076,11 +901,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -1101,11 +921,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -1126,11 +941,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -1152,11 +962,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -1178,11 +983,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -1204,11 +1004,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -1230,11 +1025,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -1256,11 +1046,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 5215
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 4
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -1284,11 +1069,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -1309,11 +1089,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -1334,11 +1109,6 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd
#### A masked pattern was here ####
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 101
- HDFS_READ_OPS: 2
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 2
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
@@ -1363,45 +1133,41 @@ PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
PREHOOK: Output: database:default
PREHOOK: Output: default@tmp_orcppd
-Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 1571
- HDFS_READ_OPS: 3
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 3
-Stage-1 HIVE COUNTERS:
- CREATED_FILES: 1
- DESERIALIZE_ERRORS: 0
- RECORDS_IN_Map_1: 24
- RECORDS_OUT_1_default.tmp_orcppd: 20
- RECORDS_OUT_INTERMEDIATE_Map_1: 20
-Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 105700
- CACHE_MISS_BYTES: 0
- METADATA_CACHE_HIT: 2
- NUM_DECODED_BATCHES: 1
- NUM_VECTOR_BATCHES: 5
- ROWS_EMITTED: 5000
- SELECTED_ROWGROUPS: 3
+POSTHOOK: query: create temporary table tmp_orcppd
+ stored as orc
+ as select ctinyint, csmallint, cint , cbigint, cfloat, cdouble,
+ cstring1, cstring2, ctimestamp1, ctimestamp2
+ from alltypesorc limit 20
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@tmp_orcppd
PREHOOK: query: insert into table tmp_orcppd
values(null, null, null, null, null,
null, null, null, null, null)
PREHOOK: type: QUERY
PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@tmp_orcppd
-Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 30
- HDFS_BYTES_WRITTEN: 724
- HDFS_READ_OPS: 4
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 3
-Stage-1 HIVE COUNTERS:
- CREATED_FILES: 1
- DESERIALIZE_ERRORS: 0
- RECORDS_IN_Map_1: 1
- RECORDS_OUT_1_default.tmp_orcppd: 1
+POSTHOOK: query: insert into table tmp_orcppd
+ values(null, null, null, null, null,
+ null, null, null, null, null)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__1
+POSTHOOK: Output: default@tmp_orcppd
+POSTHOOK: Lineage: tmp_orcppd.cbigint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
+POSTHOOK: Lineage: tmp_orcppd.cdouble EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
+POSTHOOK: Lineage: tmp_orcppd.cfloat EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
+POSTHOOK: Lineage: tmp_orcppd.cint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: tmp_orcppd.csmallint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: tmp_orcppd.cstring1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
+POSTHOOK: Lineage: tmp_orcppd.cstring2 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col8, type:string, comment:), ]
+POSTHOOK: Lineage: tmp_orcppd.ctimestamp1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col9, type:string, comment:), ]
+POSTHOOK: Lineage: tmp_orcppd.ctimestamp2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
+POSTHOOK: Lineage: tmp_orcppd.ctinyint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: drop table if exists tbl_orcppd_1_1
PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table if exists tbl_orcppd_1_1
+POSTHOOK: type: DROPTABLE
PREHOOK: query: create table tbl_orcppd_1_1 as
select count(*) from tmp_orcppd
where ctimestamp1> current_timestamp() and
@@ -1412,19 +1178,25 @@ PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@tmp_orcppd
PREHOOK: Output: database:default
PREHOOK: Output: default@tbl_orcppd_1_1
-Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 80
- HDFS_READ_OPS: 3
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 3
-Stage-1 HIVE COUNTERS:
- CREATED_FILES: 1
- RECORDS_OUT_1_default.tbl_orcppd_1_1: 1
+POSTHOOK: query: create table tbl_orcppd_1_1 as
+ select count(*) from tmp_orcppd
+ where ctimestamp1> current_timestamp() and
+ ctimestamp2 > current_timestamp() and
+ cstring1 like 'a*' and
+ cstring2 like 'a*'
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@tmp_orcppd
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@tbl_orcppd_1_1
+POSTHOOK: Lineage: tbl_orcppd_1_1._c0 EXPRESSION [(tmp_orcppd)tmp_orcppd.null, ]
PREHOOK: query: drop table if exists tmp_orcppd
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@tmp_orcppd
PREHOOK: Output: default@tmp_orcppd
+POSTHOOK: query: drop table if exists tmp_orcppd
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@tmp_orcppd
+POSTHOOK: Output: default@tmp_orcppd
PREHOOK: query: create temporary table tmp_orcppd
stored as orc
as select ctimestamp1, ctimestamp2
@@ -1433,44 +1205,30 @@ PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
PREHOOK: Output: database:default
PREHOOK: Output: default@tmp_orcppd
-Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 491
- HDFS_READ_OPS: 3
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 3
-Stage-1 HIVE COUNTERS:
- CREATED_FILES: 1
- DESERIALIZE_ERRORS: 0
- RECORDS_IN_Map_1: 14
- RECORDS_OUT_1_default.tmp_orcppd: 10
- RECORDS_OUT_INTERMEDIATE_Map_1: 10
-Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 30589
- CACHE_MISS_BYTES: 0
- METADATA_CACHE_HIT: 3
- NUM_DECODED_BATCHES: 1
- NUM_VECTOR_BATCHES: 5
- ROWS_EMITTED: 5000
- SELECTED_ROWGROUPS: 3
+POSTHOOK: query: create temporary table tmp_orcppd
+ stored as orc
+ as select ctimestamp1, ctimestamp2
+ from alltypesorc limit 10
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@tmp_orcppd
PREHOOK: query: insert into table tmp_orcppd
values(null, null)
PREHOOK: type: QUERY
PREHOOK: Input: default@values__tmp__table__2
PREHOOK: Output: default@tmp_orcppd
-Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 6
- HDFS_BYTES_WRITTEN: 317
- HDFS_READ_OPS: 4
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 3
-Stage-1 HIVE COUNTERS:
- CREATED_FILES: 1
- DESERIALIZE_ERRORS: 0
- RECORDS_IN_Map_1: 1
- RECORDS_OUT_1_default.tmp_orcppd: 1
+POSTHOOK: query: insert into table tmp_orcppd
+ values(null, null)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__2
+POSTHOOK: Output: default@tmp_orcppd
+POSTHOOK: Lineage: tmp_orcppd.ctimestamp1 EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: tmp_orcppd.ctimestamp2 EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
PREHOOK: query: drop table if exists tbl_orcppd_2_1
PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table if exists tbl_orcppd_2_1
+POSTHOOK: type: DROPTABLE
PREHOOK: query: create table tbl_orcppd_2_1 as
select count(*) from tmp_orcppd
where ctimestamp1 in (cast('2065-08-13 19:03:52' as timestamp), cast('2071-01-16 20:21:17' as timestamp), current_timestamp())
@@ -1478,19 +1236,22 @@ PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@tmp_orcppd
PREHOOK: Output: database:default
PREHOOK: Output: default@tbl_orcppd_2_1
-Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 0
- HDFS_BYTES_WRITTEN: 80
- HDFS_READ_OPS: 3
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 3
-Stage-1 HIVE COUNTERS:
- CREATED_FILES: 1
- RECORDS_OUT_1_default.tbl_orcppd_2_1: 1
+POSTHOOK: query: create table tbl_orcppd_2_1 as
+ select count(*) from tmp_orcppd
+ where ctimestamp1 in (cast('2065-08-13 19:03:52' as timestamp), cast('2071-01-16 20:21:17' as timestamp), current_timestamp())
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@tmp_orcppd
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@tbl_orcppd_2_1
+POSTHOOK: Lineage: tbl_orcppd_2_1._c0 EXPRESSION [(tmp_orcppd)tmp_orcppd.null, ]
PREHOOK: query: drop table if exists tmp_orcppd
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@tmp_orcppd
PREHOOK: Output: default@tmp_orcppd
+POSTHOOK: query: drop table if exists tmp_orcppd
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@tmp_orcppd
+POSTHOOK: Output: default@tmp_orcppd
PREHOOK: query: create temporary table tmp_orcppd
stored as orc
as select ts, da
@@ -1499,46 +1260,30 @@ PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@orc_ppd_staging
PREHOOK: Output: database:default
PREHOOK: Output: default@tmp_orcppd
-Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 846
- HDFS_BYTES_WRITTEN: 2979
- HDFS_READ_OPS: 9
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 3
-Stage-1 HIVE COUNTERS:
- CREATED_FILES: 1
- DESERIALIZE_ERRORS: 0
- RECORDS_IN_Map_1: 2100
- RECORDS_OUT_1_default.tmp_orcppd: 2100
-Stage-1 LLAP IO COUNTERS:
- ALLOCATED_BYTES: 786432
- ALLOCATED_USED_BYTES: 38
- CACHE_HIT_BYTES: 2587
- CACHE_MISS_BYTES: 32
- METADATA_CACHE_HIT: 3
- METADATA_CACHE_MISS: 3
- NUM_DECODED_BATCHES: 5
- NUM_VECTOR_BATCHES: 5
- ROWS_EMITTED: 2100
- SELECTED_ROWGROUPS: 5
+POSTHOOK: query: create temporary table tmp_orcppd
+ stored as orc
+ as select ts, da
+ from orc_ppd_staging
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@orc_ppd_staging
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@tmp_orcppd
PREHOOK: query: insert into table tmp_orcppd
values(null, null)
PREHOOK: type: QUERY
PREHOOK: Input: default@values__tmp__table__3
PREHOOK: Output: default@tmp_orcppd
-Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 6
- HDFS_BYTES_WRITTEN: 315
- HDFS_READ_OPS: 4
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 3
-Stage-1 HIVE COUNTERS:
- CREATED_FILES: 1
- DESERIALIZE_ERRORS: 0
- RECORDS_IN_Map_1: 1
- RECORDS_OUT_1_default.tmp_orcppd: 1
+POSTHOOK: query: insert into table tmp_orcppd
+ values(null, null)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__3
+POSTHOOK: Output: default@tmp_orcppd
+POSTHOOK: Lineage: tmp_orcppd.da EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: tmp_orcppd.ts EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
PREHOOK: query: drop table if exists tbl_orcppd_3_1
PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table if exists tbl_orcppd_3_1
+POSTHOOK: type: DROPTABLE
PREHOOK: query: create table tbl_orcppd_3_1 as
select count(*) from tmp_orcppd
group by ts, da
@@ -1548,29 +1293,13 @@ PREHOOK: Input: default@alltypesorc
PREHOOK: Input: default@tmp_orcppd
PREHOOK: Output: database:default
PREHOOK: Output: default@tbl_orcppd_3_1
-Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 5623
- HDFS_BYTES_WRITTEN: 48
- HDFS_READ_OPS: 5
- HDFS_LARGE_READ_OPS: 0
- HDFS_WRITE_OPS: 1
-Stage-1 HIVE COUNTERS:
- DESERIALIZE_ERRORS: 0
- RECORDS_IN_Map_1: 2100
- RECORDS_IN_Map_4: 14
- RECORDS_OUT_1_default.tbl_orcppd_3_1: 0
- RECORDS_OUT_INTERMEDIATE_Map_1: 254
- RECORDS_OUT_INTERMEDIATE_Map_4: 10
- RECORDS_OUT_INTERMEDIATE_Reducer_2: 254
- RECORDS_OUT_INTERMEDIATE_Reducer_5: 9
-Stage-1 LLAP IO COUNTERS:
- ALLOCATED_BYTES: 786432
- ALLOCATED_USED_BYTES: 6361
- CACHE_HIT_BYTES: 16353
- CACHE_MISS_BYTES: 2590
- METADATA_CACHE_HIT: 3
- METADATA_CACHE_MISS: 2
- NUM_DECODED_BATCHES: 3
- NUM_VECTOR_BATCHES: 13
- ROWS_EMITTED: 12100
- SELECTED_ROWGROUPS: 4
+POSTHOOK: query: create table tbl_orcppd_3_1 as
+ select count(*) from tmp_orcppd
+ group by ts, da
+ having ts in (select ctimestamp1 from alltypesorc limit 10)
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Input: default@tmp_orcppd
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@tbl_orcppd_3_1
+POSTHOOK: Lineage: tbl_orcppd_3_1._c0 EXPRESSION [(tmp_orcppd)tmp_orcppd.null, ]
[3/3] hive git commit: HIVE-14913 : addendum patch
Posted by ha...@apache.org.
HIVE-14913 : addendum patch
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/6cca9911
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/6cca9911
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/6cca9911
Branch: refs/heads/master
Commit: 6cca9911bde22dbe9dfacbfa188dd7a56062f202
Parents: f2efa6a
Author: Ashutosh Chauhan <ha...@apache.org>
Authored: Fri Oct 21 06:51:44 2016 -0700
Committer: Ashutosh Chauhan <ha...@apache.org>
Committed: Fri Oct 21 06:51:44 2016 -0700
----------------------------------------------------------------------
.../test/queries/clientpositive/orc_ppd_basic.q | 6 +
.../clientpositive/current_date_timestamp.q.out | 376 --
.../llap/current_date_timestamp.q.out | 4780 ++++++++++++++++++
.../clientpositive/llap/orc_ppd_basic.q.out | 467 +-
4 files changed, 4884 insertions(+), 745 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/6cca9911/ql/src/test/queries/clientpositive/orc_ppd_basic.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/orc_ppd_basic.q b/ql/src/test/queries/clientpositive/orc_ppd_basic.q
index c3ba24a..41134a0 100644
--- a/ql/src/test/queries/clientpositive/orc_ppd_basic.q
+++ b/ql/src/test/queries/clientpositive/orc_ppd_basic.q
@@ -191,6 +191,12 @@ set hive.optimize.index.filter=true;
select count(*) from orc_ppd where f=74.72;
+RESET;
+set hive.compute.query.using.stats=false;
+set hive.mapred.mode=nonstrict;
+SET hive.fetch.task.conversion=none;
+SET hive.optimize.index.filter=true;
+SET hive.cbo.enable=false;
create temporary table tmp_orcppd
stored as orc
as select ctinyint, csmallint, cint , cbigint, cfloat, cdouble,
http://git-wip-us.apache.org/repos/asf/hive/blob/6cca9911/ql/src/test/results/clientpositive/current_date_timestamp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/current_date_timestamp.q.out b/ql/src/test/results/clientpositive/current_date_timestamp.q.out
deleted file mode 100644
index 93e5104..0000000
--- a/ql/src/test/results/clientpositive/current_date_timestamp.q.out
+++ /dev/null
@@ -1,376 +0,0 @@
-PREHOOK: query: select current_timestamp = current_timestamp(), current_date = current_date() from src limit 5
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-POSTHOOK: query: select current_timestamp = current_timestamp(), current_date = current_date() from src limit 5
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-#### A masked pattern was here ####
-true true
-true true
-true true
-true true
-true true
-PREHOOK: query: --ensure that timestamp is same for all the rows while using current_timestamp() query should return single row
-select count(*) from (select current_timestamp() from alltypesorc union select current_timestamp() from src limit 5 ) subq
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesorc
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-POSTHOOK: query: --ensure that timestamp is same for all the rows while using current_timestamp() query should return single row
-select count(*) from (select current_timestamp() from alltypesorc union select current_timestamp() from src limit 5 ) subq
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesorc
-POSTHOOK: Input: default@src
-#### A masked pattern was here ####
-1
-PREHOOK: query: select count(*) from (select current_timestamp() from alltypesorc
- union
- select current_timestamp() from src
- limit 5 ) subqr
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesorc
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-POSTHOOK: query: select count(*) from (select current_timestamp() from alltypesorc
- union
- select current_timestamp() from src
- limit 5 ) subqr
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesorc
-POSTHOOK: Input: default@src
-#### A masked pattern was here ####
-1
-PREHOOK: query: --current_timestamp() should appear as expression
-explain extended select current_timestamp() from alltypesorc
-PREHOOK: type: QUERY
-POSTHOOK: query: --current_timestamp() should appear as expression
-explain extended select current_timestamp() from alltypesorc
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-0 is a root stage
-
-STAGE PLANS:
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- TableScan
- alias: alltypesorc
- Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: COMPLETE
- GatherStats: false
- Select Operator
- expressions: 2012-01-01 01:02:03.0 (type: timestamp)
- outputColumnNames: _col0
- Statistics: Num rows: 12288 Data size: 491520 Basic stats: COMPLETE Column stats: COMPLETE
- ListSink
-
-PREHOOK: query: --current_timestamp() + insert
-create temporary table tmp_runtimeconstant(
- ts1 timestamp,
- ts2 timestamp,
- dt date,
- s string,
- v varchar(50),
- c char(50)
- )
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@tmp_runtimeconstant
-POSTHOOK: query: --current_timestamp() + insert
-create temporary table tmp_runtimeconstant(
- ts1 timestamp,
- ts2 timestamp,
- dt date,
- s string,
- v varchar(50),
- c char(50)
- )
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@tmp_runtimeconstant
-PREHOOK: query: insert into table tmp_runtimeconstant
- select current_timestamp(),
- cast(current_timestamp() as timestamp),
- cast(current_timestamp() as date),
- cast(current_timestamp() as string),
- cast(current_timestamp() as varchar(50)),
- cast(current_timestamp() as char(50))
- from alltypesorc limit 5
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesorc
-PREHOOK: Output: default@tmp_runtimeconstant
-POSTHOOK: query: insert into table tmp_runtimeconstant
- select current_timestamp(),
- cast(current_timestamp() as timestamp),
- cast(current_timestamp() as date),
- cast(current_timestamp() as string),
- cast(current_timestamp() as varchar(50)),
- cast(current_timestamp() as char(50))
- from alltypesorc limit 5
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesorc
-POSTHOOK: Output: default@tmp_runtimeconstant
-POSTHOOK: Lineage: tmp_runtimeconstant.c SIMPLE []
-POSTHOOK: Lineage: tmp_runtimeconstant.dt SIMPLE []
-POSTHOOK: Lineage: tmp_runtimeconstant.s SIMPLE []
-POSTHOOK: Lineage: tmp_runtimeconstant.ts1 SIMPLE []
-POSTHOOK: Lineage: tmp_runtimeconstant.ts2 SIMPLE []
-POSTHOOK: Lineage: tmp_runtimeconstant.v SIMPLE []
-PREHOOK: query: select ts1 = ts2,
- to_date(ts2) = dt,
- s = v,
- v = c
-from tmp_runtimeconstant
-PREHOOK: type: QUERY
-PREHOOK: Input: default@tmp_runtimeconstant
-#### A masked pattern was here ####
-POSTHOOK: query: select ts1 = ts2,
- to_date(ts2) = dt,
- s = v,
- v = c
-from tmp_runtimeconstant
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@tmp_runtimeconstant
-#### A masked pattern was here ####
-true true true true
-true true true true
-true true true true
-true true true true
-true true true true
-PREHOOK: query: --current_date() + insert
-drop table if exists tmp_runtimeconstant
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@tmp_runtimeconstant
-PREHOOK: Output: default@tmp_runtimeconstant
-POSTHOOK: query: --current_date() + insert
-drop table if exists tmp_runtimeconstant
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@tmp_runtimeconstant
-POSTHOOK: Output: default@tmp_runtimeconstant
-PREHOOK: query: create temporary table tmp_runtimeconstant(d date, t timestamp)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@tmp_runtimeconstant
-POSTHOOK: query: create temporary table tmp_runtimeconstant(d date, t timestamp)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@tmp_runtimeconstant
-PREHOOK: query: insert into table tmp_runtimeconstant
- select current_date(), current_timestamp() from alltypesorc limit 5
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesorc
-PREHOOK: Output: default@tmp_runtimeconstant
-POSTHOOK: query: insert into table tmp_runtimeconstant
- select current_date(), current_timestamp() from alltypesorc limit 5
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesorc
-POSTHOOK: Output: default@tmp_runtimeconstant
-POSTHOOK: Lineage: tmp_runtimeconstant.d SIMPLE []
-POSTHOOK: Lineage: tmp_runtimeconstant.t SIMPLE []
-PREHOOK: query: select to_date(t)=d from tmp_runtimeconstant
-PREHOOK: type: QUERY
-PREHOOK: Input: default@tmp_runtimeconstant
-#### A masked pattern was here ####
-POSTHOOK: query: select to_date(t)=d from tmp_runtimeconstant
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@tmp_runtimeconstant
-#### A masked pattern was here ####
-true
-true
-true
-true
-true
-PREHOOK: query: --current_timestamp() + current_date() + where
-drop table if exists tmp_runtimeconstant
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@tmp_runtimeconstant
-PREHOOK: Output: default@tmp_runtimeconstant
-POSTHOOK: query: --current_timestamp() + current_date() + where
-drop table if exists tmp_runtimeconstant
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@tmp_runtimeconstant
-POSTHOOK: Output: default@tmp_runtimeconstant
-PREHOOK: query: create temporary table tmp_runtimeconstant(t timestamp, d date)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@tmp_runtimeconstant
-POSTHOOK: query: create temporary table tmp_runtimeconstant(t timestamp, d date)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@tmp_runtimeconstant
-PREHOOK: query: insert into table tmp_runtimeconstant
- select current_timestamp(), current_date() from alltypesorc limit 5
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesorc
-PREHOOK: Output: default@tmp_runtimeconstant
-POSTHOOK: query: insert into table tmp_runtimeconstant
- select current_timestamp(), current_date() from alltypesorc limit 5
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesorc
-POSTHOOK: Output: default@tmp_runtimeconstant
-POSTHOOK: Lineage: tmp_runtimeconstant.d SIMPLE []
-POSTHOOK: Lineage: tmp_runtimeconstant.t SIMPLE []
-PREHOOK: query: select count(*) from tmp_runtimeconstant
- where current_timestamp() >= t
- and current_date <> d
-PREHOOK: type: QUERY
-PREHOOK: Input: default@tmp_runtimeconstant
-#### A masked pattern was here ####
-POSTHOOK: query: select count(*) from tmp_runtimeconstant
- where current_timestamp() >= t
- and current_date <> d
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@tmp_runtimeconstant
-#### A masked pattern was here ####
-0
-PREHOOK: query: --current_timestamp() as argument for unix_timestamp(), hour(), minute(), second()
-select unix_timestamp(current_timestamp()),
- hour(current_timestamp()),
- minute(current_timestamp()),
- second(current_timestamp())
- from alltypesorc limit 5
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesorc
-#### A masked pattern was here ####
-POSTHOOK: query: --current_timestamp() as argument for unix_timestamp(), hour(), minute(), second()
-select unix_timestamp(current_timestamp()),
- hour(current_timestamp()),
- minute(current_timestamp()),
- second(current_timestamp())
- from alltypesorc limit 5
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesorc
-#### A masked pattern was here ####
-1325408523 1 2 3
-1325408523 1 2 3
-1325408523 1 2 3
-1325408523 1 2 3
-1325408523 1 2 3
-PREHOOK: query: --current_timestamp() as argument for various date udfs
-select to_date(current_timestamp()),
- year(current_timestamp()),
- month(current_timestamp()),
- day(current_timestamp()),
- weekofyear(current_timestamp()),
- datediff(current_timestamp(),current_timestamp),
- to_date(date_add(current_timestamp(), 31)),
- to_date(date_sub(current_timestamp(), 31)),
- last_day(current_timestamp()),
- next_day(current_timestamp(),'FRIDAY')
- from alltypesorc limit 5
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesorc
-#### A masked pattern was here ####
-POSTHOOK: query: --current_timestamp() as argument for various date udfs
-select to_date(current_timestamp()),
- year(current_timestamp()),
- month(current_timestamp()),
- day(current_timestamp()),
- weekofyear(current_timestamp()),
- datediff(current_timestamp(),current_timestamp),
- to_date(date_add(current_timestamp(), 31)),
- to_date(date_sub(current_timestamp(), 31)),
- last_day(current_timestamp()),
- next_day(current_timestamp(),'FRIDAY')
- from alltypesorc limit 5
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesorc
-#### A masked pattern was here ####
-2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
-2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
-2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
-2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
-2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
-PREHOOK: query: --current_date() as argument for various date udfs
-select to_date(current_date()),
- year(current_date()),
- month(current_date()),
- day(current_date()),
- weekofyear(current_date()),
- datediff(current_date(),current_date),
- to_date(date_add(current_date(), 31)),
- to_date(date_sub(current_date(), 31)),
- last_day(current_date()),
- next_day(current_date(),'FRIDAY')
- from alltypesorc limit 5
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesorc
-#### A masked pattern was here ####
-POSTHOOK: query: --current_date() as argument for various date udfs
-select to_date(current_date()),
- year(current_date()),
- month(current_date()),
- day(current_date()),
- weekofyear(current_date()),
- datediff(current_date(),current_date),
- to_date(date_add(current_date(), 31)),
- to_date(date_sub(current_date(), 31)),
- last_day(current_date()),
- next_day(current_date(),'FRIDAY')
- from alltypesorc limit 5
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesorc
-#### A masked pattern was here ####
-2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
-2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
-2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
-2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
-2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
-PREHOOK: query: select current_timestamp() - current_timestamp(),
- current_timestamp() - current_date(),
- current_date() - current_timestamp(),
- current_date() - current_date()
- from alltypesorc limit 1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesorc
-#### A masked pattern was here ####
-POSTHOOK: query: select current_timestamp() - current_timestamp(),
- current_timestamp() - current_date(),
- current_date() - current_timestamp(),
- current_date() - current_date()
- from alltypesorc limit 1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesorc
-#### A masked pattern was here ####
-0 00:00:00.000000000 0 01:02:03.000000000 -0 01:02:03.000000000 0 00:00:00.000000000
-PREHOOK: query: select ctimestamp1 - current_date(),
- ctimestamp1- ctimestamp2,
- current_date() - current_date(),
- current_date() - ctimestamp2
-from alltypesorc
-where ctimestamp1 is not null
- and ctimestamp2 is not null
- limit 5
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesorc
-#### A masked pattern was here ####
-POSTHOOK: query: select ctimestamp1 - current_date(),
- ctimestamp1- ctimestamp2,
- current_date() - current_date(),
- current_date() - ctimestamp2
-from alltypesorc
-where ctimestamp1 is not null
- and ctimestamp2 is not null
- limit 5
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesorc
-#### A masked pattern was here ####
--15340 08:00:12.326000000 -0 00:00:21.201000000 0 00:00:00.000000000 15340 07:59:51.125000000
--15340 08:00:03.213000000 -0 00:00:04.759000000 0 00:00:00.000000000 15340 07:59:58.454000000
--15340 08:00:14.813000000 -0 00:00:21.774000000 0 00:00:00.000000000 15340 07:59:53.039000000
--15340 08:00:08.566000000 -0 00:00:21.918000000 0 00:00:00.000000000 15340 07:59:46.648000000
--15340 07:59:44.993000000 -0 00:00:00.141000000 0 00:00:00.000000000 15340 07:59:44.852000000
-PREHOOK: query: select current_date, current_timestamp from src limit 5
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-POSTHOOK: query: select current_date, current_timestamp from src limit 5
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-#### A masked pattern was here ####
-2012-01-01 2012-01-01 01:02:03
-2012-01-01 2012-01-01 01:02:03
-2012-01-01 2012-01-01 01:02:03
-2012-01-01 2012-01-01 01:02:03
-2012-01-01 2012-01-01 01:02:03
[2/3] hive git commit: HIVE-14913 : addendum patch
Posted by ha...@apache.org.
http://git-wip-us.apache.org/repos/asf/hive/blob/6cca9911/ql/src/test/results/clientpositive/llap/current_date_timestamp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/current_date_timestamp.q.out b/ql/src/test/results/clientpositive/llap/current_date_timestamp.q.out
new file mode 100644
index 0000000..27e0896
--- /dev/null
+++ b/ql/src/test/results/clientpositive/llap/current_date_timestamp.q.out
@@ -0,0 +1,4780 @@
+PREHOOK: query: select current_timestamp = current_timestamp(), current_date = current_date() from src limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select current_timestamp = current_timestamp(), current_date = current_date() from src limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+true true
+true true
+true true
+true true
+true true
+PREHOOK: query: --ensure that timestamp is same for all the rows while using current_timestamp() query should return single row
+select count(*) from (select current_timestamp() from alltypesorc union select current_timestamp() from src limit 5 ) subq
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: --ensure that timestamp is same for all the rows while using current_timestamp() query should return single row
+select count(*) from (select current_timestamp() from alltypesorc union select current_timestamp() from src limit 5 ) subq
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+1
+PREHOOK: query: select count(*) from (select current_timestamp() from alltypesorc
+ union
+ select current_timestamp() from src
+ limit 5 ) subqr
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from (select current_timestamp() from alltypesorc
+ union
+ select current_timestamp() from src
+ limit 5 ) subqr
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+1
+PREHOOK: query: --current_timestamp() should appear as expression
+explain extended select current_timestamp() from alltypesorc
+PREHOOK: type: QUERY
+POSTHOOK: query: --current_timestamp() should appear as expression
+explain extended select current_timestamp() from alltypesorc
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ TableScan
+ alias: alltypesorc
+ GatherStats: false
+ Select Operator
+ expressions: 2012-01-01 01:02:03.0 (type: timestamp)
+ outputColumnNames: _col0
+ ListSink
+
+PREHOOK: query: --current_timestamp() + insert
+create temporary table tmp_runtimeconstant(
+ ts1 timestamp,
+ ts2 timestamp,
+ dt date,
+ s string,
+ v varchar(50),
+ c char(50)
+ )
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: query: --current_timestamp() + insert
+create temporary table tmp_runtimeconstant(
+ ts1 timestamp,
+ ts2 timestamp,
+ dt date,
+ s string,
+ v varchar(50),
+ c char(50)
+ )
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@tmp_runtimeconstant
+PREHOOK: query: insert into table tmp_runtimeconstant
+ select current_timestamp(),
+ cast(current_timestamp() as timestamp),
+ cast(current_timestamp() as date),
+ cast(current_timestamp() as string),
+ cast(current_timestamp() as varchar(50)),
+ cast(current_timestamp() as char(50))
+ from alltypesorc limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: query: insert into table tmp_runtimeconstant
+ select current_timestamp(),
+ cast(current_timestamp() as timestamp),
+ cast(current_timestamp() as date),
+ cast(current_timestamp() as string),
+ cast(current_timestamp() as varchar(50)),
+ cast(current_timestamp() as char(50))
+ from alltypesorc limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: Lineage: tmp_runtimeconstant.c SIMPLE []
+POSTHOOK: Lineage: tmp_runtimeconstant.dt SIMPLE []
+POSTHOOK: Lineage: tmp_runtimeconstant.s SIMPLE []
+POSTHOOK: Lineage: tmp_runtimeconstant.ts1 SIMPLE []
+POSTHOOK: Lineage: tmp_runtimeconstant.ts2 SIMPLE []
+POSTHOOK: Lineage: tmp_runtimeconstant.v SIMPLE []
+PREHOOK: query: select ts1 = ts2,
+ to_date(ts2) = dt,
+ s = v,
+ v = c
+from tmp_runtimeconstant
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tmp_runtimeconstant
+#### A masked pattern was here ####
+POSTHOOK: query: select ts1 = ts2,
+ to_date(ts2) = dt,
+ s = v,
+ v = c
+from tmp_runtimeconstant
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tmp_runtimeconstant
+#### A masked pattern was here ####
+true true true true
+true true true true
+true true true true
+true true true true
+true true true true
+PREHOOK: query: --current_date() + insert
+drop table if exists tmp_runtimeconstant
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@tmp_runtimeconstant
+PREHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: query: --current_date() + insert
+drop table if exists tmp_runtimeconstant
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@tmp_runtimeconstant
+POSTHOOK: Output: default@tmp_runtimeconstant
+PREHOOK: query: create temporary table tmp_runtimeconstant(d date, t timestamp)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: query: create temporary table tmp_runtimeconstant(d date, t timestamp)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@tmp_runtimeconstant
+PREHOOK: query: insert into table tmp_runtimeconstant
+ select current_date(), current_timestamp() from alltypesorc limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: query: insert into table tmp_runtimeconstant
+ select current_date(), current_timestamp() from alltypesorc limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: Lineage: tmp_runtimeconstant.d SIMPLE []
+POSTHOOK: Lineage: tmp_runtimeconstant.t SIMPLE []
+PREHOOK: query: select to_date(t)=d from tmp_runtimeconstant
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tmp_runtimeconstant
+#### A masked pattern was here ####
+POSTHOOK: query: select to_date(t)=d from tmp_runtimeconstant
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tmp_runtimeconstant
+#### A masked pattern was here ####
+true
+true
+true
+true
+true
+PREHOOK: query: --current_timestamp() + current_date() + where
+drop table if exists tmp_runtimeconstant
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@tmp_runtimeconstant
+PREHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: query: --current_timestamp() + current_date() + where
+drop table if exists tmp_runtimeconstant
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@tmp_runtimeconstant
+POSTHOOK: Output: default@tmp_runtimeconstant
+PREHOOK: query: create temporary table tmp_runtimeconstant(t timestamp, d date)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: query: create temporary table tmp_runtimeconstant(t timestamp, d date)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@tmp_runtimeconstant
+PREHOOK: query: insert into table tmp_runtimeconstant
+ select current_timestamp(), current_date() from alltypesorc limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: query: insert into table tmp_runtimeconstant
+ select current_timestamp(), current_date() from alltypesorc limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: Lineage: tmp_runtimeconstant.d SIMPLE []
+POSTHOOK: Lineage: tmp_runtimeconstant.t SIMPLE []
+PREHOOK: query: select count(*) from tmp_runtimeconstant
+ where current_timestamp() >= t
+ and current_date <> d
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tmp_runtimeconstant
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from tmp_runtimeconstant
+ where current_timestamp() >= t
+ and current_date <> d
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tmp_runtimeconstant
+#### A masked pattern was here ####
+0
+PREHOOK: query: --current_timestamp() as argument for unix_timestamp(), hour(), minute(), second()
+select unix_timestamp(current_timestamp()),
+ hour(current_timestamp()),
+ minute(current_timestamp()),
+ second(current_timestamp())
+ from alltypesorc limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: --current_timestamp() as argument for unix_timestamp(), hour(), minute(), second()
+select unix_timestamp(current_timestamp()),
+ hour(current_timestamp()),
+ minute(current_timestamp()),
+ second(current_timestamp())
+ from alltypesorc limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+1325408523 1 2 3
+1325408523 1 2 3
+1325408523 1 2 3
+1325408523 1 2 3
+1325408523 1 2 3
+PREHOOK: query: --current_timestamp() as argument for various date udfs
+select to_date(current_timestamp()),
+ year(current_timestamp()),
+ month(current_timestamp()),
+ day(current_timestamp()),
+ weekofyear(current_timestamp()),
+ datediff(current_timestamp(),current_timestamp),
+ to_date(date_add(current_timestamp(), 31)),
+ to_date(date_sub(current_timestamp(), 31)),
+ last_day(current_timestamp()),
+ next_day(current_timestamp(),'FRIDAY')
+ from alltypesorc limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: --current_timestamp() as argument for various date udfs
+select to_date(current_timestamp()),
+ year(current_timestamp()),
+ month(current_timestamp()),
+ day(current_timestamp()),
+ weekofyear(current_timestamp()),
+ datediff(current_timestamp(),current_timestamp),
+ to_date(date_add(current_timestamp(), 31)),
+ to_date(date_sub(current_timestamp(), 31)),
+ last_day(current_timestamp()),
+ next_day(current_timestamp(),'FRIDAY')
+ from alltypesorc limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+PREHOOK: query: --current_date() as argument for various date udfs
+select to_date(current_date()),
+ year(current_date()),
+ month(current_date()),
+ day(current_date()),
+ weekofyear(current_date()),
+ datediff(current_date(),current_date),
+ to_date(date_add(current_date(), 31)),
+ to_date(date_sub(current_date(), 31)),
+ last_day(current_date()),
+ next_day(current_date(),'FRIDAY')
+ from alltypesorc limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: --current_date() as argument for various date udfs
+select to_date(current_date()),
+ year(current_date()),
+ month(current_date()),
+ day(current_date()),
+ weekofyear(current_date()),
+ datediff(current_date(),current_date),
+ to_date(date_add(current_date(), 31)),
+ to_date(date_sub(current_date(), 31)),
+ last_day(current_date()),
+ next_day(current_date(),'FRIDAY')
+ from alltypesorc limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+PREHOOK: query: select current_timestamp() - current_timestamp(),
+ current_timestamp() - current_date(),
+ current_date() - current_timestamp(),
+ current_date() - current_date()
+ from alltypesorc limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select current_timestamp() - current_timestamp(),
+ current_timestamp() - current_date(),
+ current_date() - current_timestamp(),
+ current_date() - current_date()
+ from alltypesorc limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+0 00:00:00.000000000 0 01:02:03.000000000 -0 01:02:03.000000000 0 00:00:00.000000000
+PREHOOK: query: select ctimestamp1 - current_date(),
+ ctimestamp1- ctimestamp2,
+ current_date() - current_date(),
+ current_date() - ctimestamp2
+from alltypesorc
+where ctimestamp1 is not null
+ and ctimestamp2 is not null
+ limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select ctimestamp1 - current_date(),
+ ctimestamp1- ctimestamp2,
+ current_date() - current_date(),
+ current_date() - ctimestamp2
+from alltypesorc
+where ctimestamp1 is not null
+ and ctimestamp2 is not null
+ limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+-15340 08:00:12.326000000 -0 00:00:21.201000000 0 00:00:00.000000000 15340 07:59:51.125000000
+-15340 08:00:03.213000000 -0 00:00:04.759000000 0 00:00:00.000000000 15340 07:59:58.454000000
+-15340 08:00:14.813000000 -0 00:00:21.774000000 0 00:00:00.000000000 15340 07:59:53.039000000
+-15340 08:00:08.566000000 -0 00:00:21.918000000 0 00:00:00.000000000 15340 07:59:46.648000000
+-15340 07:59:44.993000000 -0 00:00:00.141000000 0 00:00:00.000000000 15340 07:59:44.852000000
+PREHOOK: query: select current_date, current_timestamp from src limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select current_date, current_timestamp from src limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+2012-01-01 2012-01-01 01:02:03
+2012-01-01 2012-01-01 01:02:03
+2012-01-01 2012-01-01 01:02:03
+2012-01-01 2012-01-01 01:02:03
+2012-01-01 2012-01-01 01:02:03
+PREHOOK: query: select `[kv]+.+` from srcpart order by key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+#### A masked pattern was here ####
+POSTHOOK: query: select `[kv]+.+` from srcpart order by key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+#### A masked pattern was here ####
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+10 val_10
+10 val_10
+10 val_10
+10 val_10
+100 val_100
+100 val_100
+100 val_100
+100 val_100
+100 val_100
+100 val_100
+100 val_100
+100 val_100
+103 val_103
+103 val_103
+103 val_103
+103 val_103
+103 val_103
+103 val_103
+103 val_103
+103 val_103
+104 val_104
+104 val_104
+104 val_104
+104 val_104
+104 val_104
+104 val_104
+104 val_104
+104 val_104
+105 val_105
+105 val_105
+105 val_105
+105 val_105
+11 val_11
+11 val_11
+11 val_11
+11 val_11
+111 val_111
+111 val_111
+111 val_111
+111 val_111
+113 val_113
+113 val_113
+113 val_113
+113 val_113
+113 val_113
+113 val_113
+113 val_113
+113 val_113
+114 val_114
+114 val_114
+114 val_114
+114 val_114
+116 val_116
+116 val_116
+116 val_116
+116 val_116
+118 val_118
+118 val_118
+118 val_118
+118 val_118
+118 val_118
+118 val_118
+118 val_118
+118 val_118
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+12 val_12
+12 val_12
+12 val_12
+12 val_12
+12 val_12
+12 val_12
+12 val_12
+12 val_12
+120 val_120
+120 val_120
+120 val_120
+120 val_120
+120 val_120
+120 val_120
+120 val_120
+120 val_120
+125 val_125
+125 val_125
+125 val_125
+125 val_125
+125 val_125
+125 val_125
+125 val_125
+125 val_125
+126 val_126
+126 val_126
+126 val_126
+126 val_126
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+129 val_129
+129 val_129
+129 val_129
+129 val_129
+129 val_129
+129 val_129
+129 val_129
+129 val_129
+131 val_131
+131 val_131
+131 val_131
+131 val_131
+133 val_133
+133 val_133
+133 val_133
+133 val_133
+134 val_134
+134 val_134
+134 val_134
+134 val_134
+134 val_134
+134 val_134
+134 val_134
+134 val_134
+136 val_136
+136 val_136
+136 val_136
+136 val_136
+137 val_137
+137 val_137
+137 val_137
+137 val_137
+137 val_137
+137 val_137
+137 val_137
+137 val_137
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+143 val_143
+143 val_143
+143 val_143
+143 val_143
+145 val_145
+145 val_145
+145 val_145
+145 val_145
+146 val_146
+146 val_146
+146 val_146
+146 val_146
+146 val_146
+146 val_146
+146 val_146
+146 val_146
+149 val_149
+149 val_149
+149 val_149
+149 val_149
+149 val_149
+149 val_149
+149 val_149
+149 val_149
+15 val_15
+15 val_15
+15 val_15
+15 val_15
+15 val_15
+15 val_15
+15 val_15
+15 val_15
+150 val_150
+150 val_150
+150 val_150
+150 val_150
+152 val_152
+152 val_152
+152 val_152
+152 val_152
+152 val_152
+152 val_152
+152 val_152
+152 val_152
+153 val_153
+153 val_153
+153 val_153
+153 val_153
+155 val_155
+155 val_155
+155 val_155
+155 val_155
+156 val_156
+156 val_156
+156 val_156
+156 val_156
+157 val_157
+157 val_157
+157 val_157
+157 val_157
+158 val_158
+158 val_158
+158 val_158
+158 val_158
+160 val_160
+160 val_160
+160 val_160
+160 val_160
+162 val_162
+162 val_162
+162 val_162
+162 val_162
+163 val_163
+163 val_163
+163 val_163
+163 val_163
+164 val_164
+164 val_164
+164 val_164
+164 val_164
+164 val_164
+164 val_164
+164 val_164
+164 val_164
+165 val_165
+165 val_165
+165 val_165
+165 val_165
+165 val_165
+165 val_165
+165 val_165
+165 val_165
+166 val_166
+166 val_166
+166 val_166
+166 val_166
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+168 val_168
+168 val_168
+168 val_168
+168 val_168
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+17 val_17
+17 val_17
+17 val_17
+17 val_17
+170 val_170
+170 val_170
+170 val_170
+170 val_170
+172 val_172
+172 val_172
+172 val_172
+172 val_172
+172 val_172
+172 val_172
+172 val_172
+172 val_172
+174 val_174
+174 val_174
+174 val_174
+174 val_174
+174 val_174
+174 val_174
+174 val_174
+174 val_174
+175 val_175
+175 val_175
+175 val_175
+175 val_175
+175 val_175
+175 val_175
+175 val_175
+175 val_175
+176 val_176
+176 val_176
+176 val_176
+176 val_176
+176 val_176
+176 val_176
+176 val_176
+176 val_176
+177 val_177
+177 val_177
+177 val_177
+177 val_177
+178 val_178
+178 val_178
+178 val_178
+178 val_178
+179 val_179
+179 val_179
+179 val_179
+179 val_179
+179 val_179
+179 val_179
+179 val_179
+179 val_179
+18 val_18
+18 val_18
+18 val_18
+18 val_18
+18 val_18
+18 val_18
+18 val_18
+18 val_18
+180 val_180
+180 val_180
+180 val_180
+180 val_180
+181 val_181
+181 val_181
+181 val_181
+181 val_181
+183 val_183
+183 val_183
+183 val_183
+183 val_183
+186 val_186
+186 val_186
+186 val_186
+186 val_186
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+189 val_189
+189 val_189
+189 val_189
+189 val_189
+19 val_19
+19 val_19
+19 val_19
+19 val_19
+190 val_190
+190 val_190
+190 val_190
+190 val_190
+191 val_191
+191 val_191
+191 val_191
+191 val_191
+191 val_191
+191 val_191
+191 val_191
+191 val_191
+192 val_192
+192 val_192
+192 val_192
+192 val_192
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+194 val_194
+194 val_194
+194 val_194
+194 val_194
+195 val_195
+195 val_195
+195 val_195
+195 val_195
+195 val_195
+195 val_195
+195 val_195
+195 val_195
+196 val_196
+196 val_196
+196 val_196
+196 val_196
+197 val_197
+197 val_197
+197 val_197
+197 val_197
+197 val_197
+197 val_197
+197 val_197
+197 val_197
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+2 val_2
+2 val_2
+2 val_2
+2 val_2
+20 val_20
+20 val_20
+20 val_20
+20 val_20
+200 val_200
+200 val_200
+200 val_200
+200 val_200
+200 val_200
+200 val_200
+200 val_200
+200 val_200
+201 val_201
+201 val_201
+201 val_201
+201 val_201
+202 val_202
+202 val_202
+202 val_202
+202 val_202
+203 val_203
+203 val_203
+203 val_203
+203 val_203
+203 val_203
+203 val_203
+203 val_203
+203 val_203
+205 val_205
+205 val_205
+205 val_205
+205 val_205
+205 val_205
+205 val_205
+205 val_205
+205 val_205
+207 val_207
+207 val_207
+207 val_207
+207 val_207
+207 val_207
+207 val_207
+207 val_207
+207 val_207
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+209 val_209
+209 val_209
+209 val_209
+209 val_209
+209 val_209
+209 val_209
+209 val_209
+209 val_209
+213 val_213
+213 val_213
+213 val_213
+213 val_213
+213 val_213
+213 val_213
+213 val_213
+213 val_213
+214 val_214
+214 val_214
+214 val_214
+214 val_214
+216 val_216
+216 val_216
+216 val_216
+216 val_216
+216 val_216
+216 val_216
+216 val_216
+216 val_216
+217 val_217
+217 val_217
+217 val_217
+217 val_217
+217 val_217
+217 val_217
+217 val_217
+217 val_217
+218 val_218
+218 val_218
+218 val_218
+218 val_218
+219 val_219
+219 val_219
+219 val_219
+219 val_219
+219 val_219
+219 val_219
+219 val_219
+219 val_219
+221 val_221
+221 val_221
+221 val_221
+221 val_221
+221 val_221
+221 val_221
+221 val_221
+221 val_221
+222 val_222
+222 val_222
+222 val_222
+222 val_222
+223 val_223
+223 val_223
+223 val_223
+223 val_223
+223 val_223
+223 val_223
+223 val_223
+223 val_223
+224 val_224
+224 val_224
+224 val_224
+224 val_224
+224 val_224
+224 val_224
+224 val_224
+224 val_224
+226 val_226
+226 val_226
+226 val_226
+226 val_226
+228 val_228
+228 val_228
+228 val_228
+228 val_228
+229 val_229
+229 val_229
+229 val_229
+229 val_229
+229 val_229
+229 val_229
+229 val_229
+229 val_229
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+233 val_233
+233 val_233
+233 val_233
+233 val_233
+233 val_233
+233 val_233
+233 val_233
+233 val_233
+235 val_235
+235 val_235
+235 val_235
+235 val_235
+237 val_237
+237 val_237
+237 val_237
+237 val_237
+237 val_237
+237 val_237
+237 val_237
+237 val_237
+238 val_238
+238 val_238
+238 val_238
+238 val_238
+238 val_238
+238 val_238
+238 val_238
+238 val_238
+239 val_239
+239 val_239
+239 val_239
+239 val_239
+239 val_239
+239 val_239
+239 val_239
+239 val_239
+24 val_24
+24 val_24
+24 val_24
+24 val_24
+24 val_24
+24 val_24
+24 val_24
+24 val_24
+241 val_241
+241 val_241
+241 val_241
+241 val_241
+242 val_242
+242 val_242
+242 val_242
+242 val_242
+242 val_242
+242 val_242
+242 val_242
+242 val_242
+244 val_244
+244 val_244
+244 val_244
+244 val_244
+247 val_247
+247 val_247
+247 val_247
+247 val_247
+248 val_248
+248 val_248
+248 val_248
+248 val_248
+249 val_249
+249 val_249
+249 val_249
+249 val_249
+252 val_252
+252 val_252
+252 val_252
+252 val_252
+255 val_255
+255 val_255
+255 val_255
+255 val_255
+255 val_255
+255 val_255
+255 val_255
+255 val_255
+256 val_256
+256 val_256
+256 val_256
+256 val_256
+256 val_256
+256 val_256
+256 val_256
+256 val_256
+257 val_257
+257 val_257
+257 val_257
+257 val_257
+258 val_258
+258 val_258
+258 val_258
+258 val_258
+26 val_26
+26 val_26
+26 val_26
+26 val_26
+26 val_26
+26 val_26
+26 val_26
+26 val_26
+260 val_260
+260 val_260
+260 val_260
+260 val_260
+262 val_262
+262 val_262
+262 val_262
+262 val_262
+263 val_263
+263 val_263
+263 val_263
+263 val_263
+265 val_265
+265 val_265
+265 val_265
+265 val_265
+265 val_265
+265 val_265
+265 val_265
+265 val_265
+266 val_266
+266 val_266
+266 val_266
+266 val_266
+27 val_27
+27 val_27
+27 val_27
+27 val_27
+272 val_272
+272 val_272
+272 val_272
+272 val_272
+272 val_272
+272 val_272
+272 val_272
+272 val_272
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+274 val_274
+274 val_274
+274 val_274
+274 val_274
+275 val_275
+275 val_275
+275 val_275
+275 val_275
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+278 val_278
+278 val_278
+278 val_278
+278 val_278
+278 val_278
+278 val_278
+278 val_278
+278 val_278
+28 val_28
+28 val_28
+28 val_28
+28 val_28
+280 val_280
+280 val_280
+280 val_280
+280 val_280
+280 val_280
+280 val_280
+280 val_280
+280 val_280
+281 val_281
+281 val_281
+281 val_281
+281 val_281
+281 val_281
+281 val_281
+281 val_281
+281 val_281
+282 val_282
+282 val_282
+282 val_282
+282 val_282
+282 val_282
+282 val_282
+282 val_282
+282 val_282
+283 val_283
+283 val_283
+283 val_283
+283 val_283
+284 val_284
+284 val_284
+284 val_284
+284 val_284
+285 val_285
+285 val_285
+285 val_285
+285 val_285
+286 val_286
+286 val_286
+286 val_286
+286 val_286
+287 val_287
+287 val_287
+287 val_287
+287 val_287
+288 val_288
+288 val_288
+288 val_288
+288 val_288
+288 val_288
+288 val_288
+288 val_288
+288 val_288
+289 val_289
+289 val_289
+289 val_289
+289 val_289
+291 val_291
+291 val_291
+291 val_291
+291 val_291
+292 val_292
+292 val_292
+292 val_292
+292 val_292
+296 val_296
+296 val_296
+296 val_296
+296 val_296
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+30 val_30
+30 val_30
+30 val_30
+30 val_30
+302 val_302
+302 val_302
+302 val_302
+302 val_302
+305 val_305
+305 val_305
+305 val_305
+305 val_305
+306 val_306
+306 val_306
+306 val_306
+306 val_306
+307 val_307
+307 val_307
+307 val_307
+307 val_307
+307 val_307
+307 val_307
+307 val_307
+307 val_307
+308 val_308
+308 val_308
+308 val_308
+308 val_308
+309 val_309
+309 val_309
+309 val_309
+309 val_309
+309 val_309
+309 val_309
+309 val_309
+309 val_309
+310 val_310
+310 val_310
+310 val_310
+310 val_310
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+315 val_315
+315 val_315
+315 val_315
+315 val_315
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+317 val_317
+317 val_317
+317 val_317
+317 val_317
+317 val_317
+317 val_317
+317 val_317
+317 val_317
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+321 val_321
+321 val_321
+321 val_321
+321 val_321
+321 val_321
+321 val_321
+321 val_321
+321 val_321
+322 val_322
+322 val_322
+322 val_322
+322 val_322
+322 val_322
+322 val_322
+322 val_322
+322 val_322
+323 val_323
+323 val_323
+323 val_323
+323 val_323
+325 val_325
+325 val_325
+325 val_325
+325 val_325
+325 val_325
+325 val_325
+325 val_325
+325 val_325
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+33 val_33
+33 val_33
+33 val_33
+33 val_33
+331 val_331
+331 val_331
+331 val_331
+331 val_331
+331 val_331
+331 val_331
+331 val_331
+331 val_331
+332 val_332
+332 val_332
+332 val_332
+332 val_332
+333 val_333
+333 val_333
+333 val_333
+333 val_333
+333 val_333
+333 val_333
+333 val_333
+333 val_333
+335 val_335
+335 val_335
+335 val_335
+335 val_335
+336 val_336
+336 val_336
+336 val_336
+336 val_336
+338 val_338
+338 val_338
+338 val_338
+338 val_338
+339 val_339
+339 val_339
+339 val_339
+339 val_339
+34 val_34
+34 val_34
+34 val_34
+34 val_34
+341 val_341
+341 val_341
+341 val_341
+341 val_341
+342 val_342
+342 val_342
+342 val_342
+342 val_342
+342 val_342
+342 val_342
+342 val_342
+342 val_342
+344 val_344
+344 val_344
+344 val_344
+344 val_344
+344 val_344
+344 val_344
+344 val_344
+344 val_344
+345 val_345
+345 val_345
+345 val_345
+345 val_345
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+351 val_351
+351 val_351
+351 val_351
+351 val_351
+353 val_353
+353 val_353
+353 val_353
+353 val_353
+353 val_353
+353 val_353
+353 val_353
+353 val_353
+356 val_356
+356 val_356
+356 val_356
+356 val_356
+360 val_360
+360 val_360
+360 val_360
+360 val_360
+362 val_362
+362 val_362
+362 val_362
+362 val_362
+364 val_364
+364 val_364
+364 val_364
+364 val_364
+365 val_365
+365 val_365
+365 val_365
+365 val_365
+366 val_366
+366 val_366
+366 val_366
+366 val_366
+367 val_367
+367 val_367
+367 val_367
+367 val_367
+367 val_367
+367 val_367
+367 val_367
+367 val_367
+368 val_368
+368 val_368
+368 val_368
+368 val_368
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+37 val_37
+37 val_37
+37 val_37
+37 val_37
+37 val_37
+37 val_37
+37 val_37
+37 val_37
+373 val_373
+373 val_373
+373 val_373
+373 val_373
+374 val_374
+374 val_374
+374 val_374
+374 val_374
+375 val_375
+375 val_375
+375 val_375
+375 val_375
+377 val_377
+377 val_377
+377 val_377
+377 val_377
+378 val_378
+378 val_378
+378 val_378
+378 val_378
+379 val_379
+379 val_379
+379 val_379
+379 val_379
+382 val_382
+382 val_382
+382 val_382
+382 val_382
+382 val_382
+382 val_382
+382 val_382
+382 val_382
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+386 val_386
+386 val_386
+386 val_386
+386 val_386
+389 val_389
+389 val_389
+389 val_389
+389 val_389
+392 val_392
+392 val_392
+392 val_392
+392 val_392
+393 val_393
+393 val_393
+393 val_393
+393 val_393
+394 val_394
+394 val_394
+394 val_394
+394 val_394
+395 val_395
+395 val_395
+395 val_395
+395 val_395
+395 val_395
+395 val_395
+395 val_395
+395 val_395
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+397 val_397
+397 val_397
+397 val_397
+397 val_397
+397 val_397
+397 val_397
+397 val_397
+397 val_397
+399 val_399
+399 val_399
+399 val_399
+399 val_399
+399 val_399
+399 val_399
+399 val_399
+399 val_399
+4 val_4
+4 val_4
+4 val_4
+4 val_4
+400 val_400
+400 val_400
+400 val_400
+400 val_400
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+402 val_402
+402 val_402
+402 val_402
+402 val_402
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+404 val_404
+404 val_404
+404 val_404
+404 val_404
+404 val_404
+404 val_404
+404 val_404
+404 val_404
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+407 val_407
+407 val_407
+407 val_407
+407 val_407
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+41 val_41
+41 val_41
+41 val_41
+41 val_41
+411 val_411
+411 val_411
+411 val_411
+411 val_411
+413 val_413
+413 val_413
+413 val_413
+413 val_413
+413 val_413
+413 val_413
+413 val_413
+413 val_413
+414 val_414
+414 val_414
+414 val_414
+414 val_414
+414 val_414
+414 val_414
+414 val_414
+414 val_414
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+418 val_418
+418 val_418
+418 val_418
+418 val_418
+419 val_419
+419 val_419
+419 val_419
+419 val_419
+42 val_42
+42 val_42
+42 val_42
+42 val_42
+42 val_42
+42 val_42
+42 val_42
+42 val_42
+421 val_421
+421 val_421
+421 val_421
+421 val_421
+424 val_424
+424 val_424
+424 val_424
+424 val_424
+424 val_424
+424 val_424
+424 val_424
+424 val_424
+427 val_427
+427 val_427
+427 val_427
+427 val_427
+429 val_429
+429 val_429
+429 val_429
+429 val_429
+429 val_429
+429 val_429
+429 val_429
+429 val_429
+43 val_43
+43 val_43
+43 val_43
+43 val_43
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+432 val_432
+432 val_432
+432 val_432
+432 val_432
+435 val_435
+435 val_435
+435 val_435
+435 val_435
+436 val_436
+436 val_436
+436 val_436
+436 val_436
+437 val_437
+437 val_437
+437 val_437
+437 val_437
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+439 val_439
+439 val_439
+439 val_439
+439 val_439
+439 val_439
+439 val_439
+439 val_439
+439 val_439
+44 val_44
+44 val_44
+44 val_44
+44 val_44
+443 val_443
+443 val_443
+443 val_443
+443 val_443
+444 val_444
+444 val_444
+444 val_444
+444 val_444
+446 val_446
+446 val_446
+446 val_446
+446 val_446
+448 val_448
+448 val_448
+448 val_448
+448 val_448
+449 val_449
+449 val_449
+449 val_449
+449 val_449
+452 val_452
+452 val_452
+452 val_452
+452 val_452
+453 val_453
+453 val_453
+453 val_453
+453 val_453
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+455 val_455
+455 val_455
+455 val_455
+455 val_455
+457 val_457
+457 val_457
+457 val_457
+457 val_457
+458 val_458
+458 val_458
+458 val_458
+458 val_458
+458 val_458
+458 val_458
+458 val_458
+458 val_458
+459 val_459
+459 val_459
+459 val_459
+459 val_459
+459 val_459
+459 val_459
+459 val_459
+459 val_459
+460 val_460
+460 val_460
+460 val_460
+460 val_460
+462 val_462
+462 val_462
+462 val_462
+462 val_462
+462 val_462
+462 val_462
+462 val_462
+462 val_462
+463 val_463
+463 val_463
+463 val_463
+463 val_463
+463 val_463
+463 val_463
+463 val_463
+463 val_463
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+467 val_467
+467 val_467
+467 val_467
+467 val_467
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+47 val_47
+47 val_47
+47 val_47
+47 val_47
+470 val_470
+470 val_470
+470 val_470
+470 val_470
+472 val_472
+472 val_472
+472 val_472
+472 val_472
+475 val_475
+475 val_475
+475 val_475
+475 val_475
+477 val_477
+477 val_477
+477 val_477
+477 val_477
+478 val_478
+478 val_478
+478 val_478
+478 val_478
+478 val_478
+478 val_478
+478 val_478
+478 val_478
+479 val_479
+479 val_479
+479 val_479
+479 val_479
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+481 val_481
+481 val_481
+481 val_481
+481 val_481
+482 val_482
+482 val_482
+482 val_482
+482 val_482
+483 val_483
+483 val_483
+483 val_483
+483 val_483
+484 val_484
+484 val_484
+484 val_484
+484 val_484
+485 val_485
+485 val_485
+485 val_485
+485 val_485
+487 val_487
+487 val_487
+487 val_487
+487 val_487
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+490 val_490
+490 val_490
+490 val_490
+490 val_490
+491 val_491
+491 val_491
+491 val_491
+491 val_491
+492 val_492
+492 val_492
+492 val_492
+492 val_492
+492 val_492
+492 val_492
+492 val_492
+492 val_492
+493 val_493
+493 val_493
+493 val_493
+493 val_493
+494 val_494
+494 val_494
+494 val_494
+494 val_494
+495 val_495
+495 val_495
+495 val_495
+495 val_495
+496 val_496
+496 val_496
+496 val_496
+496 val_496
+497 val_497
+497 val_497
+497 val_497
+497 val_497
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+51 val_51
+51 val_51
+51 val_51
+51 val_51
+51 val_51
+51 val_51
+51 val_51
+51 val_51
+53 val_53
+53 val_53
+53 val_53
+53 val_53
+54 val_54
+54 val_54
+54 val_54
+54 val_54
+57 val_57
+57 val_57
+57 val_57
+57 val_57
+58 val_58
+58 val_58
+58 val_58
+58 val_58
+58 val_58
+58 val_58
+58 val_58
+58 val_58
+64 val_64
+64 val_64
+64 val_64
+64 val_64
+65 val_65
+65 val_65
+65 val_65
+65 val_65
+66 val_66
+66 val_66
+66 val_66
+66 val_66
+67 val_67
+67 val_67
+67 val_67
+67 val_67
+67 val_67
+67 val_67
+67 val_67
+67 val_67
+69 val_69
+69 val_69
+69 val_69
+69 val_69
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+72 val_72
+72 val_72
+72 val_72
+72 val_72
+72 val_72
+72 val_72
+72 val_72
+72 val_72
+74 val_74
+74 val_74
+74 val_74
+74 val_74
+76 val_76
+76 val_76
+76 val_76
+76 val_76
+76 val_76
+76 val_76
+76 val_76
+76 val_76
+77 val_77
+77 val_77
+77 val_77
+77 val_77
+78 val_78
+78 val_78
+78 val_78
+78 val_78
+8 val_8
+8 val_8
+8 val_8
+8 val_8
+80 val_80
+80 val_80
+80 val_80
+80 val_80
+82 val_82
+82 val_82
+82 val_82
+82 val_82
+83 val_83
+83 val_83
+83 val_83
+83 val_83
+83 val_83
+83 val_83
+83 val_83
+83 val_83
+84 val_84
+84 val_84
+84 val_84
+84 val_84
+84 val_84
+84 val_84
+84 val_84
+84 val_84
+85 val_85
+85 val_85
+85 val_85
+85 val_85
+86 val_86
+86 val_86
+86 val_86
+86 val_86
+87 val_87
+87 val_87
+87 val_87
+87 val_87
+9 val_9
+9 val_9
+9 val_9
+9 val_9
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+92 val_92
+92 val_92
+92 val_92
+92 val_92
+95 val_95
+95 val_95
+95 val_95
+95 val_95
+95 val_95
+95 val_95
+95 val_95
+95 val_95
+96 val_96
+96 val_96
+96 val_96
+96 val_96
+97 val_97
+97 val_97
+97 val_97
+97 val_97
+97 val_97
+97 val_97
+97 val_97
+97 val_97
+98 val_98
+98 val_98
+98 val_98
+98 val_98
+98 val_98
+98 val_98
+98 val_98
+98 val_98
+PREHOOK: query: select current_timestamp = current_timestamp(), current_date = current_date() from src limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select current_timestamp = current_timestamp(), current_date = current_date() from src limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+true true
+true true
+true true
+true true
+true true
+PREHOOK: query: --ensure that timestamp is same for all the rows while using current_timestamp() query should return single row
+select count(*) from (select current_timestamp() from alltypesorc union select current_timestamp() from src limit 5 ) subq
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: --ensure that timestamp is same for all the rows while using current_timestamp() query should return single row
+select count(*) from (select current_timestamp() from alltypesorc union select current_timestamp() from src limit 5 ) subq
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+1
+PREHOOK: query: select count(*) from (select current_timestamp() from alltypesorc
+ union
+ select current_timestamp() from src
+ limit 5 ) subqr
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from (select current_timestamp() from alltypesorc
+ union
+ select current_timestamp() from src
+ limit 5 ) subqr
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+1
+PREHOOK: query: --current_timestamp() should appear as expression
+explain extended select current_timestamp() from alltypesorc
+PREHOOK: type: QUERY
+POSTHOOK: query: --current_timestamp() should appear as expression
+explain extended select current_timestamp() from alltypesorc
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ TableScan
+ alias: alltypesorc
+ GatherStats: false
+ Select Operator
+ expressions: 2012-01-01 01:02:03.0 (type: timestamp)
+ outputColumnNames: _col0
+ ListSink
+
+PREHOOK: query: --current_timestamp() + insert
+create temporary table tmp_runtimeconstant(
+ ts1 timestamp,
+ ts2 timestamp,
+ dt date,
+ s string,
+ v varchar(50),
+ c char(50)
+ )
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: query: --current_timestamp() + insert
+create temporary table tmp_runtimeconstant(
+ ts1 timestamp,
+ ts2 timestamp,
+ dt date,
+ s string,
+ v varchar(50),
+ c char(50)
+ )
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@tmp_runtimeconstant
+PREHOOK: query: insert into table tmp_runtimeconstant
+ select current_timestamp(),
+ cast(current_timestamp() as timestamp),
+ cast(current_timestamp() as date),
+ cast(current_timestamp() as string),
+ cast(current_timestamp() as varchar(50)),
+ cast(current_timestamp() as char(50))
+ from alltypesorc limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: query: insert into table tmp_runtimeconstant
+ select current_timestamp(),
+ cast(current_timestamp() as timestamp),
+ cast(current_timestamp() as date),
+ cast(current_timestamp() as string),
+ cast(current_timestamp() as varchar(50)),
+ cast(current_timestamp() as char(50))
+ from alltypesorc limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: Lineage: tmp_runtimeconstant.c SIMPLE []
+POSTHOOK: Lineage: tmp_runtimeconstant.dt SIMPLE []
+POSTHOOK: Lineage: tmp_runtimeconstant.s SIMPLE []
+POSTHOOK: Lineage: tmp_runtimeconstant.ts1 SIMPLE []
+POSTHOOK: Lineage: tmp_runtimeconstant.ts2 SIMPLE []
+POSTHOOK: Lineage: tmp_runtimeconstant.v SIMPLE []
+PREHOOK: query: select ts1 = ts2,
+ to_date(ts2) = dt,
+ s = v,
+ v = c
+from tmp_runtimeconstant
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tmp_runtimeconstant
+#### A masked pattern was here ####
+POSTHOOK: query: select ts1 = ts2,
+ to_date(ts2) = dt,
+ s = v,
+ v = c
+from tmp_runtimeconstant
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tmp_runtimeconstant
+#### A masked pattern was here ####
+true true true true
+true true true true
+true true true true
+true true true true
+true true true true
+PREHOOK: query: --current_date() + insert
+drop table if exists tmp_runtimeconstant
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@tmp_runtimeconstant
+PREHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: query: --current_date() + insert
+drop table if exists tmp_runtimeconstant
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@tmp_runtimeconstant
+POSTHOOK: Output: default@tmp_runtimeconstant
+PREHOOK: query: create temporary table tmp_runtimeconstant(d date, t timestamp)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: query: create temporary table tmp_runtimeconstant(d date, t timestamp)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@tmp_runtimeconstant
+PREHOOK: query: insert into table tmp_runtimeconstant
+ select current_date(), current_timestamp() from alltypesorc limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: query: insert into table tmp_runtimeconstant
+ select current_date(), current_timestamp() from alltypesorc limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: Lineage: tmp_runtimeconstant.d SIMPLE []
+POSTHOOK: Lineage: tmp_runtimeconstant.t SIMPLE []
+PREHOOK: query: select to_date(t)=d from tmp_runtimeconstant
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tmp_runtimeconstant
+#### A masked pattern was here ####
+POSTHOOK: query: select to_date(t)=d from tmp_runtimeconstant
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tmp_runtimeconstant
+#### A masked pattern was here ####
+true
+true
+true
+true
+true
+PREHOOK: query: --current_timestamp() + current_date() + where
+drop table if exists tmp_runtimeconstant
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@tmp_runtimeconstant
+PREHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: query: --current_timestamp() + current_date() + where
+drop table if exists tmp_runtimeconstant
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@tmp_runtimeconstant
+POSTHOOK: Output: default@tmp_runtimeconstant
+PREHOOK: query: create temporary table tmp_runtimeconstant(t timestamp, d date)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: query: create temporary table tmp_runtimeconstant(t timestamp, d date)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@tmp_runtimeconstant
+PREHOOK: query: insert into table tmp_runtimeconstant
+ select current_timestamp(), current_date() from alltypesorc limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: query: insert into table tmp_runtimeconstant
+ select current_timestamp(), current_date() from alltypesorc limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@tmp_runtimeconstant
+POSTHOOK: Lineage: tmp_runtimeconstant.d SIMPLE []
+POSTHOOK: Lineage: tmp_runtimeconstant.t SIMPLE []
+PREHOOK: query: select count(*) from tmp_runtimeconstant
+ where current_timestamp() >= t
+ and current_date <> d
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tmp_runtimeconstant
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from tmp_runtimeconstant
+ where current_timestamp() >= t
+ and current_date <> d
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tmp_runtimeconstant
+#### A masked pattern was here ####
+0
+PREHOOK: query: --current_timestamp() as argument for unix_timestamp(), hour(), minute(), second()
+select unix_timestamp(current_timestamp()),
+ hour(current_timestamp()),
+ minute(current_timestamp()),
+ second(current_timestamp())
+ from alltypesorc limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: --current_timestamp() as argument for unix_timestamp(), hour(), minute(), second()
+select unix_timestamp(current_timestamp()),
+ hour(current_timestamp()),
+ minute(current_timestamp()),
+ second(current_timestamp())
+ from alltypesorc limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+1325408523 1 2 3
+1325408523 1 2 3
+1325408523 1 2 3
+1325408523 1 2 3
+1325408523 1 2 3
+PREHOOK: query: --current_timestamp() as argument for various date udfs
+select to_date(current_timestamp()),
+ year(current_timestamp()),
+ month(current_timestamp()),
+ day(current_timestamp()),
+ weekofyear(current_timestamp()),
+ datediff(current_timestamp(),current_timestamp),
+ to_date(date_add(current_timestamp(), 31)),
+ to_date(date_sub(current_timestamp(), 31)),
+ last_day(current_timestamp()),
+ next_day(current_timestamp(),'FRIDAY')
+ from alltypesorc limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: --current_timestamp() as argument for various date udfs
+select to_date(current_timestamp()),
+ year(current_timestamp()),
+ month(current_timestamp()),
+ day(current_timestamp()),
+ weekofyear(current_timestamp()),
+ datediff(current_timestamp(),current_timestamp),
+ to_date(date_add(current_timestamp(), 31)),
+ to_date(date_sub(current_timestamp(), 31)),
+ last_day(current_timestamp()),
+ next_day(current_timestamp(),'FRIDAY')
+ from alltypesorc limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+PREHOOK: query: --current_date() as argument for various date udfs
+select to_date(current_date()),
+ year(current_date()),
+ month(current_date()),
+ day(current_date()),
+ weekofyear(current_date()),
+ datediff(current_date(),current_date),
+ to_date(date_add(current_date(), 31)),
+ to_date(date_sub(current_date(), 31)),
+ last_day(current_date()),
+ next_day(current_date(),'FRIDAY')
+ from alltypesorc limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: --current_date() as argument for various date udfs
+select to_date(current_date()),
+ year(current_date()),
+ month(current_date()),
+ day(current_date()),
+ weekofyear(current_date()),
+ datediff(current_date(),current_date),
+ to_date(date_add(current_date(), 31)),
+ to_date(date_sub(current_date(), 31)),
+ last_day(current_date()),
+ next_day(current_date(),'FRIDAY')
+ from alltypesorc limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06
+PREHOOK: query: select current_timestamp() - current_timestamp(),
+ current_timestamp() - current_date(),
+ current_date() - current_timestamp(),
+ current_date() - current_date()
+ from alltypesorc limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select current_timestamp() - current_timestamp(),
+ current_timestamp() - current_date(),
+ current_date() - current_timestamp(),
+ current_date() - current_date()
+ from alltypesorc limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+0 00:00:00.000000000 0 01:02:03.000000000 -0 01:02:03.000000000 0 00:00:00.000000000
+PREHOOK: query: select ctimestamp1 - current_date(),
+ ctimestamp1- ctimestamp2,
+ current_date() - current_date(),
+ current_date() - ctimestamp2
+from alltypesorc
+where ctimestamp1 is not null
+ and ctimestamp2 is not null
+ limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select ctimestamp1 - current_date(),
+ ctimestamp1- ctimestamp2,
+ current_date() - current_date(),
+ current_date() - ctimestamp2
+from alltypesorc
+where ctimestamp1 is not null
+ and ctimestamp2 is not null
+ limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+-15340 08:00:12.326000000 -0 00:00:21.201000000 0 00:00:00.000000000 15340 07:59:51.125000000
+-15340 08:00:03.213000000 -0 00:00:04.759000000 0 00:00:00.000000000 15340 07:59:58.454000000
+-15340 08:00:14.813000000 -0 00:00:21.774000000 0 00:00:00.000000000 15340 07:59:53.039000000
+-15340 08:00:08.566000000 -0 00:00:21.918000000 0 00:00:00.000000000 15340 07:59:46.648000000
+-15340 07:59:44.993000000 -0 00:00:00.141000000 0 00:00:00.000000000 15340 07:59:44.852000000
+PREHOOK: query: select current_date, current_timestamp from src limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select current_date, current_timestamp from src limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+2012-01-01 2012-01-01 01:02:03
+2012-01-01 2012-01-01 01:02:03
+2012-01-01 2012-01-01 01:02:03
+2012-01-01 2012-01-01 01:02:03
+2012-01-01 2012-01-01 01:02:03
+PREHOOK: query: select `[kv]+.+` from srcpart order by key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+#### A masked pattern was here ####
+POSTHOOK: query: select `[kv]+.+` from srcpart order by key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+#### A masked pattern was here ####
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+10 val_10
+10 val_10
+10 val_10
+10 val_10
+100 val_100
+100 val_100
+100 val_100
+100 val_100
+100 val_100
+100 val_100
+100 val_100
+100 val_100
+103 val_103
+103 val_103
+103 val_103
+103 val_103
+103 val_103
+103 val_103
+103 val_103
+103 val_103
+104 val_104
+104 val_104
+104 val_104
+104 val_104
+104 val_104
+104 val_104
+104 val_104
+104 val_104
+105 val_105
+105 val_105
+105 val_105
+105 val_105
+11 val_11
+11 val_11
+11 val_11
+11 val_11
+111 val_111
+111 val_111
+111 val_111
+111 val_111
+113 val_113
+113 val_113
+113 val_113
+113 val_113
+113 val_113
+113 val_113
+113 val_113
+113 val_113
+114 val_114
+114 val_114
+114 val_114
+114 val_114
+116 val_116
+116 val_116
+116 val_116
+116 val_116
+118 val_118
+118 val_118
+118 val_118
+118 val_118
+118 val_118
+118 val_118
+118 val_118
+118 val_118
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+12 val_12
+12 val_12
+12 val_12
+12 val_12
+12 val_12
+12 val_12
+12 val_12
+12 val_12
+120 val_120
+120 val_120
+120 val_120
+120 val_120
+120 val_120
+120 val_120
+120 val_120
+120 val_120
+125 val_125
+125 val_125
+125 val_125
+125 val_125
+125 val_125
+125 val_125
+125 val_125
+125 val_125
+126 val_126
+126 val_126
+126 val_126
+126 val_126
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+129 val_129
+129 val_129
+129 val_129
+129 val_129
+129 val_129
+129 val_129
+129 val_129
+129 val_129
+131 val_131
+131 val_131
+131 val_131
+131 val_131
+133 val_133
+133 val_133
+133 val_133
+133 val_133
+134 val_134
+134 val_134
+134 val_134
+134 val_134
+134 val_134
+134 val_134
+134 val_134
+134 val_134
+136 val_136
+136 val_136
+136 val_136
+136 val_136
+137 val_137
+137 val_137
+137 val_137
+137 val_137
+137 val_137
+137 val_137
+137 val_137
+137 val_137
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+143 val_143
+143 val_143
+143 val_143
+143 val_143
+145 val_145
+145 val_145
+145 val_145
+145 val_145
+146 val_146
+146 val_146
+146 val_146
+146 val_146
+146 val_146
+146 val_146
+146 val_146
+146 val_146
+149 val_149
+149 val_149
+149 val_149
+149 val_149
+149 val_149
+149 val_149
+149 val_149
+149 val_149
+15 val_15
+15 val_15
+15 val_15
+15 val_15
+15 val_15
+15 val_15
+15 val_15
+15 val_15
+150 val_150
+150 val_150
+150 val_150
+150 val_150
+152 val_152
+152 val_152
+152 val_152
+152 val_152
+152 val_152
+152 val_152
+152 val_152
+152 val_152
+153 val_153
+153 val_153
+153 val_153
+153 val_153
+155 val_155
+155 val_155
+155 val_155
+155 val_155
+156 val_156
+156 val_156
+156 val_156
+156 val_156
+157 val_157
+157 val_157
+157 val_157
+157 val_157
+158 val_158
+158 val_158
+158 val_158
+158 val_158
+160 val_160
+160 val_160
+160 val_160
+160 val_160
+162 val_162
+162 val_162
+162 val_162
+162 val_162
+163 val_163
+163 val_163
+163 val_163
+163 val_163
+164 val_164
+164 val_164
+164 val_164
+164 val_164
+164 val_164
+164 val_164
+164 val_164
+164 val_164
+165 val_165
+165 val_165
+165 val_165
+165 val_165
+165 val_165
+165 val_165
+165 val_165
+165 val_165
+166 val_166
+166 val_166
+166 val_166
+166 val_166
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+168 val_168
+168 val_168
+168 val_168
+168 val_168
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+17 val_17
+17 val_17
+17 val_17
+17 val_17
+170 val_170
+170 val_170
+170 val_170
+170 val_170
+172 val_172
+172 val_172
+172 val_172
+172 val_172
+172 val_172
+172 val_172
+172 val_172
+172 val_172
+174 val_174
+174 val_174
+174 val_174
+174 val_174
+174 val_174
+174 val_174
+174 val_174
+174 val_174
+175 val_175
+175 val_175
+175 val_175
+175 val_175
+175 val_175
+175 val_175
+175 val_175
+175 val_175
+176 val_176
+176 val_176
+176 val_176
+176 val_176
+176 val_176
+176 val_176
+176 val_176
+176 val_176
+177 val_177
+177 val_177
+177 val_177
+177 val_177
+178 val_178
+178 val_178
+178 val_178
+178 val_178
+179 val_179
+179 val_179
+179 val_179
+179 val_179
+179 val_179
+179 val_179
+179 val_179
+179 val_179
+18 val_18
+18 val_18
+18 val_18
+18 val_18
+18 val_18
+18 val_18
+18 val_18
+18 val_18
+180 val_180
+180 val_180
+180 val_180
+180 val_180
+181 val_181
+181 val_181
+181 val_181
+181 val_181
+183 val_183
+183 val_183
+183 val_183
+183 val_183
+186 val_186
+186 val_186
+186 val_186
+186 val_186
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+189 val_189
+189 val_189
+189 val_189
+189 val_189
+19 val_19
+19 val_19
+19 val_19
+19 val_19
+190 val_190
+190 val_190
+190 val_190
+190 val_190
+191 val_191
+191 val_191
+191 val_191
+191 val_191
+191 val_191
+191 val_191
+191 val_191
+191 val_191
+192 val_192
+192 val_192
+192 val_192
+192 val_192
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+194 val_194
+194 val_194
+194 val_194
+194 val_194
+195 val_195
+195 val_195
+195 val_195
+195 val_195
+195 val_195
+195 val_195
+195 val_195
+195 val_195
+196 val_196
+196 val_196
+196 val_196
+196 val_196
+197 val_197
+197 val_197
+197 val_197
+197 val_197
+197 val_197
+197 val_197
+197 val_197
+197 val_197
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+2 val_2
+2 val_2
+2 val_2
+2 val_2
+20 val_20
+20 val_20
+20 val_20
+20 val_20
+200 val_200
+200 val_200
+200 val_200
+200 val_200
+200 val_200
+200 val_200
+200 val_200
+200 val_200
+201 val_201
+201 val_201
+201 val_201
+201 val_201
+202 val_202
+202 val_202
+202 val_202
+202 val_202
+203 val_203
+203 val_203
+203 val_203
+203 val_203
+203 val_203
+203 val_203
+203 val_203
+203 val_203
+205 val_205
+205 val_205
+205 val_205
+205 val_205
+205 val_205
+205 val_205
+205 val_205
+205 val_205
+207 val_207
+207 val_207
+207 val_207
+207 val_207
+207 val_207
+207 val_207
+207 val_207
+207 val_207
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+209 val_209
+209 val_209
+209 val_209
+209 val_209
+209 val_209
+209 val_209
+209 val_209
+209 val_209
+213 val_213
+213 val_213
+213 val_213
+213 val_213
+213 val_213
+213 val_213
+213 val_213
+213 val_213
+214 val_214
+214 val_214
+214 val_214
+214 val_214
+216 val_216
+216 val_216
+216 val_216
+216 val_216
+216 val_216
+216 val_216
+216 val_216
+216 val_216
+217 val_217
+217 val_217
+217 val_217
+217 val_217
+217 val_217
+217 val_217
+217 val_217
+217 val_217
+218 val_218
+218 val_218
+218 val_218
+218 val_218
+219 val_219
+219 val_219
+219 val_219
+219 val_219
+219 val_219
+219 val_219
+219 val_219
+219 val_219
+221 val_221
+221 val_221
+221 val_221
+221 val_221
+221 val_221
+221 val_221
+221 val_221
+221 val_221
+222 val_222
+222 val_222
+222 val_222
+222 val_222
+223 val_223
+223 val_223
+223 val_223
+223 val_223
+223 val_223
+223 val_223
+223 val_223
+223 val_223
+224 val_224
+224 val_224
+224 val_224
+224 val_224
+224 val_224
+224 val_224
+224 val_224
+224 val_224
+226 val_226
+226 val_226
+226 val_226
+226 val_226
+228 val_228
+228 val_228
+228 val_228
+228 val_228
+229 val_229
+229 val_229
+229 val_229
+229 val_229
+229 val_229
+229 val_229
+229 val_229
+229 val_229
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+233 val_233
+233 val_233
+233 val_233
+233 val_233
+233 val_233
+233 val_233
+233 val_233
+233 val_233
+235 val_235
+235 val_235
+235 val_235
+235 val_235
+237 val_237
+237 val_237
+237 val_237
+237 val_237
+237 val_237
+237 val_237
+237 val_237
+237 val_237
+238 val_238
+238 val_238
+238 val_238
+238 val_238
+238 val_238
+238 val_238
+238 val_238
+238 val_238
+239 val_239
+239 val_239
+239 val_239
+239 val_239
+239 val_239
+239 val_239
+239 val_239
+239 val_239
+24 val_24
+24 val_24
+24 val_24
+24 val_24
+24 val_24
+24 val_24
+24 val_24
+24 val_24
+241 val_241
+241 val_241
+241 val_241
+241 val_241
+242 val_242
+242 val_242
+242 val_242
+242 val_242
+242 val_242
+242 val_242
+242 val_242
+242 val_242
+244 val_244
+244 val_244
+244 val_244
+244 val_244
+247 val_247
+247 val_247
+247 val_247
+247 val_247
+248 val_248
+248 val_248
+248 val_248
+248 val_248
+249 val_249
+249 val_249
+249 val_249
+249 val_249
+252 val_252
+252 val_252
+252 val_252
+252 val_252
+255 val_255
+255 val_255
+255 val_255
+255 val_255
+255 val_255
+255 val_255
+255 val_255
+255 val_255
+256 val_256
+256 val_256
+256 val_256
+256 val_256
+256 val_256
+256 val_256
+256 val_256
+256 val_256
+257 val_257
+257 val_257
+257 val_257
+257 val_257
+258 val_258
+258 val_258
+258 val_258
+258 val_258
+26 val_26
+26 val_26
+26 val_26
+26 val_26
+26 val_26
+26 val_26
+26 val_26
+26 val_26
+260 val_260
+260 val_260
+260 val_260
+260 val_260
+262 val_262
+262 val_262
+262 val_262
+262 val_262
+263 val_263
+263 val_263
+263 val_263
+263 val_263
+265 val_265
+265 val_265
+265 val_265
+265 val_265
+265 val_265
+265 val_265
+265 val_265
+265 val_265
+266 val_266
+266 val_266
+266 val_266
+266 val_266
+27 val_27
+27 val_27
+27 val_27
+27 val_27
+272 val_272
+272 val_272
+272 val_272
+272 val_272
+272 val_272
+272 val_272
+272 val_272
+272 val_272
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+274 val_274
+274 val_274
+274 val_274
+274 val_274
+275 val_275
+275 val_275
+275 val_275
+275 val_275
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+278 val_278
+278 val_278
+278 val_278
+278 val_278
+278 val_278
+278 val_278
+278 val_278
+278 val_278
+28 val_28
+28 val_28
+28 val_28
+28 val_28
+280 val_280
+280 val_280
+280 val_280
+280 val_280
+280 val_280
+280 val_280
+280 val_280
+280 val_280
+281 val_281
+281 val_281
+281 val_281
+281 val_281
+281 val_281
+281 val_281
+281 val_281
+281 val_281
+282 val_282
+282 val_282
+282 val_282
+282 val_282
+282 val_282
+282 val_282
+282 val_282
+282 val_282
+283 val_283
+283 val_283
+283 val_283
+283 val_283
+284 val_284
+284 val_284
+284 val_284
+284 val_284
+285 val_285
+285 val_285
+285 val_285
+285 val_285
+286 val_286
+286 val_286
+286 val_286
+286 val_286
+287 val_287
+287 val_287
+287 val_287
+287 val_287
+288 val_288
+288 val_288
+288 val_288
+288 val_288
+288 val_288
+288 val_288
+288 val_288
+288 val_288
+289 val_289
+289 val_289
+289 val_289
+289 val_289
+291 val_291
+291 val_291
+291 val_291
+291 val_291
+292 val_292
+292 val_292
+292 val_292
+292 val_292
+296 val_296
+296 val_296
+296 val_296
+296 val_296
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+30 val_30
+30 val_30
+30 val_30
+30 val_30
+302 val_302
+302 val_302
+302 val_302
+302 val_302
+305 val_305
+305 val_305
+305 val_305
+305 val_305
+306 val_306
+306 val_306
+306 val_306
+306 val_306
+307 val_307
+307 val_307
+307 val_307
+307 val_307
+307 val_307
+307 val_307
+307 val_307
+307 val_307
+308 val_308
+308 val_308
+308 val_308
+308 val_308
+309 val_309
+309 val_309
+309 val_309
+309 val_309
+309 val_309
+309 val_309
+309 val_309
+309 val_309
+310 val_310
+310 val_310
+310 val_310
+310 val_310
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+315 val_315
+315 val_315
+315 val_315
+315 val_315
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+317 val_317
+317 val_317
+317 val_317
+317 val_317
+317 val_317
+317 val_317
+317 val_317
+317 val_317
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+321 val_321
+321 val_321
+321 val_321
+321 val_321
+321 val_321
+321 val_321
+321 val_321
+321 val_321
+322 val_322
+322 val_322
+322 val_322
+322 val_322
+322 val_322
+322 val_322
+322 val_322
+322 val_322
+323 val_323
+323 val_323
+323 val_323
+323 val_323
+325 val_325
+325 val_325
+325 val_325
+325 val_325
+325 val_325
+325 val_325
+325 val_325
+325 val_325
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+33 val_33
+33 val_33
+33 val_33
+33 val_33
+331 val_331
+331 val_331
+331 val_331
+331 val_331
+331 val_331
+331 val_331
+331 val_331
+331 val_331
+332 val_332
+332 val_332
+332 val_332
+332 val_332
+333 val_333
+333 val_333
+333 val_333
+333 val_333
+333 val_333
+333 val_333
+333 val_333
+333 val_333
+335 val_335
+335 val_335
+335 val_335
+335 val_335
+336 val_336
+336 val_336
+336 val_336
+336 val_336
+338 val_338
+338 val_338
+338 val_338
+338 val_338
+339 val_339
+339 val_339
+339 val_339
+339 val_339
+34 val_34
+34 val_34
+34 val_34
+34 val_34
+341 val_341
+341 val_341
+341 val_341
+341 val_341
+342 val_342
+342 val_342
+342 val_342
+342 val_342
+342 val_342
+342 val_342
+342 val_342
+342 val_342
+344 val_344
+344 val_344
+344 val_344
+344 val_344
+344 val_344
+344 val_344
+344 val_344
+344 val_344
+345 val_345
+345 val_345
+345 val_345
+345 val_345
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+351 val_351
+351 val_351
+351 val_351
+351 val_351
+353 val_353
+353 val_353
+353 val_353
+353 val_353
+353 val_353
+353 val_353
+353 val_353
+353 val_353
+356 val_356
+356 val_356
+356 val_356
+356 val_356
+360 val_360
+360 val_360
+360 val_360
+360 val_360
+362 val_362
+362 val_362
+362 val_362
+362 val_362
+364 val_364
+364 val_364
+364 val_364
+364 val_364
+365 val_365
+365 val_365
+365 val_365
+365 val_365
+366 val_366
+366 val_366
+366 val_366
+366 val_366
+367 val_367
+367 val_367
+367 val_367
+367 val_367
+367 val_367
+367 val_367
+367 val_367
+367 val_367
+368 val_368
+368 val_368
+368 val_368
+368 val_368
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+37 val_37
+37 val_37
+37 val_37
+37 val_37
+37 val_37
+37 val_37
+37 val_37
+37 val_37
+373 val_373
+373 val_373
+373 val_373
+373 val_373
+374 val_374
+374 val_374
+374 val_374
+374 val_374
+375 val_375
+375 val_375
+375 val_375
+375 val_375
+377 val_377
+377 val_377
+377 val_377
+377 val_377
+378 val_378
+378 val_378
+378 val_378
+378 val_378
+379 val_379
+379 val_379
+379 val_379
+379 val_379
+382 val_382
+382 val_382
+382 val_382
+382 val_382
+382 val_382
+382 val_382
+382 val_382
+382 val_382
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+386 val_386
+386 val_386
+386 val_386
+386 val_386
+389 val_389
+389 val_389
+389 val_389
+389 val_389
+392 val_392
+392 val_392
+392 val_392
+392 val_392
+393 val_393
+393 val_393
+393 val_393
+393 val_393
+394 val_394
+394 val_394
+394 val_394
+394 val_394
+395 val_395
+395 val_395
+395 val_395
+395 val_395
+395 val_395
+395 val_395
+395 val_395
+395 val_395
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+397 val_397
+397 val_397
+397 val_397
+397 val_397
+397 val_397
+397 val_397
+397 val_397
+397 val_397
+399 val_399
+399 val_399
+399 val_399
+399 val_399
+399 val_399
+399 val_399
+399 val_399
+399 val_399
+4 val_4
+4 val_4
+4 val_4
+4 val_4
+400 val_400
+400 val_400
+400 val_400
+400 val_400
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+402 val_402
+402 val_402
+402 val_402
+402 val_402
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+404 val_404
+404 val_404
+404 val_404
+404 val_404
+404 val_404
+404 val_404
+404 val_404
+404 val_404
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+407 val_407
+407 val_407
+407 val_407
+407 val_407
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+41 val_41
+41 val_41
+41 val_41
+41 val_41
+411 val_411
+411 val_411
+411 val_411
+411 val_411
+413 val_413
+413 val_413
+413 val_413
+413 val_413
+413 val_413
+413 val_413
+413 val_413
+413 val_413
+414 val_414
+414 val_414
+414 val_414
+414 val_414
+414 val_414
+414 val_414
+414 val_414
+414 val_414
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+418 val_418
+418 val_418
+418 val_418
+418 val_418
+419 val_419
+419 val_419
+419 val_419
+419 val_419
+42 val_42
+42 val_42
+42 val_42
+42 val_42
+42 val_42
+42 val_42
+42 val_42
+42 val_42
+421 val_421
+421 val_421
+421 val_421
+421 val_421
+424 val_424
+424 val_424
+424 val_424
+424 val_424
+424 val_424
+424 val_424
+424 val_424
+424 val_424
+427 val_427
+427 val_427
+427 val_427
+427 val_427
+429 val_429
+429 val_429
+429 val_429
+429 val_429
+429 val_429
+429 val_429
+429 val_429
+429 val_429
+43 val_43
+43 val_43
+43 val_43
+43 val_43
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+432 val_432
+432 val_432
+432 val_432
+432 val_432
+435 val_435
+435 val_435
+435 val_435
+435 val_435
+436 val_436
+436 val_436
+436 val_436
+436 val_436
+437 val_437
+437 val_437
+437 val_437
+437 val_437
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+439 val_439
+439 val_439
+439 val_439
+439 val_439
+439 val_439
+439 val_439
+439 val_439
+439 val_439
+44 val_44
+44 val_44
+44 val_44
+44 val_44
+443 val_443
+443 val_443
+443 val_443
+443 val_443
+444 val_444
+444 val_444
+444 val_444
+444 val_444
+446 val_446
+446 val_446
+446 val_446
+446 val_446
+448 val_448
+448 val_448
+448 val_448
+448 val_448
+449 val_449
+449 val_449
+449 val_449
+449 val_449
+452 val_452
+452 val_452
+452 val_452
+452 val_452
+453 val_453
+453 val_453
+453 val_453
+453 val_453
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+455 val_455
+455 val_455
+455 val_455
+455 val_455
+457 val_457
+457 val_457
+457 val_457
+457 val_457
+458 val_458
+458 val_458
+458 val_458
+458 val_458
+458 val_458
+458 val_458
+458 val_458
+458 val_458
+459 val_459
+459 val_459
+459 val_459
+459 val_459
+459 val_459
+459 val_459
+459 val_459
+459 val_459
+460 val_460
+460 val_460
+460 val_460
+460 val_460
+462 val_462
+462 val_462
+462 val_462
+462 val_462
+462 val_462
+462 val_462
+462 val_462
+462 val_462
+463 val_463
+463 val_463
+463 val_463
+463 val_463
+463 val_463
+463 val_463
+463 val_463
+463 val_463
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+467 val_467
+467 val_467
+467 val_467
+467 val_467
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+47 val_47
+47 val_47
+47 val_47
+47 val_47
+470 val_470
+470 val_470
+470 val_470
+470 val_470
+472 val_472
+472 val_472
+472 val_472
+472 val_472
+475 val_475
+475 val_475
+475 val_475
+475 val_475
+477 val_477
+477 val_477
+477 val_477
+477 val_477
+478 val_478
+478 val_478
+478 val_478
+478 val_478
+478 val_478
+478 val_478
+478 val_478
+478 val_478
+479 val_479
+479 val_479
+479 val_479
+479 val_479
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+481 val_481
+481 val_481
+481 val_481
+481 val_481
+482 val_482
+482 val_482
+482 val_482
+482 val_482
+483 val_483
+483 val_483
+483 val_483
+483 val_483
+484 val_484
+484 val_484
+484 val_484
+484 val_484
+485 val_485
+485 val_485
+485 val_485
+485 val_485
+487 val_487
+487 val_487
+487 val_487
+487 val_487
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+490 val_490
+490 val_490
+490 val_490
+490 val_490
+491 val_491
+491 val_491
+491 val_491
+491 val_491
+492 val_492
+492 val_492
+492 val_492
+492 val_492
+492 val_492
+492 val_492
+492 val_492
+492 val_492
+493 val_493
+493 val_493
+493 val_493
+493 val_493
+494 val_494
+494 val_494
+494 val_494
+494 val_494
+495 val_495
+495 val_495
+495 val_495
+495 val_495
+496 val_496
+496 val_496
+496 val_496
+496 val_496
+497 val_497
+497 val_497
+497 val_497
+497 val_497
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+51 val_51
+51 val_51
+51 val_51
+51 val_51
+51 val_51
+51 val_51
+51 val_51
+51 val_51
+53 val_53
+53 val_53
+53 val_53
+53 val_53
+54 val_54
+54 val_54
+54 val_54
+54 val_54
+57 val_57
+57 val_57
+57 val_57
+57 val_57
+58 val_58
+58 val_58
+58 val_58
+58 val_58
+58 val_58
+58 val_58
+58 val_58
+58 val_58
+64 val_64
+64 val_64
+64 val_64
+64 val_64
+65 val_65
+65 val_65
+65 val_65
+65 val_65
+66 val_66
+66 val_66
+66 val_66
+66 val_66
+67 val_67
+67 val_67
+67 val_67
+67 val_67
+67 val_67
+67 val_67
+67 val_67
+67 val_67
+69 val_69
+69 val_69
+69 val_69
+69 val_69
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+72 val_72
+72 val_72
+72 val_72
+72 val_72
+72 val_72
+72 val_72
+72 val_72
+72 val_72
+74 val_74
+74 val_74
+74 val_74
+74 val_74
+76 val_76
+76 val_76
+76 val_76
+76 val_76
+76 val_76
+76 val_76
+76 val_76
+76 val_76
+77 val_77
+77 val_77
+77 val_77
+77 val_77
+78 val_78
+78 val_78
+78 val_78
+78 val_78
+8 val_8
+8 val_8
+8 val_8
+8 val_8
+80 val_80
+80 val_80
+80 val_80
+80 val_80
+82 val_82
+82 val_82
+82 val_82
+82 val_82
+83 val_83
+83 val_83
+83 val_83
+83 val_83
+83 val_83
+83 val_83
+83 val_83
+83 val_83
+84 val_84
+84 val_84
+84 val_84
+84 val_84
+84 val_84
+84 val_84
+84 val_84
+84 val_84
+85 val_85
+85 val_85
+85 val_85
+85 val_85
+86 val_86
+86 val_86
+86 val_86
+86 val_86
+87 val_87
+87 val_87
+87 val_87
+87 val_87
+9 val_9
+9 val_9
+9 val_9
+9 val_9
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+92 val_92
+92 val_92
+92 val_92
+92 val_92
+95 val_95
+95 val_95
+95 val_95
+95 val_95
+95 val_95
+95 val_95
+95 val_95
+95 val_95
+96 val_96
+96 val_96
+96 val_96
+96 val_96
+97 val_97
+97 val_97
+97 val_97
+97 val_97
+97 val_97
+97 val_97
+97 val_97
+97 val_97
+98 val_98
+98 val_98
+98 val_98
+98 val_98
+98 val_98
+98 val_98
+98 val_98
+98 val_98