PREHOOK: query: -- Test timestamp functions in vectorized mode to verify they run correctly end-to-end. CREATE TABLE alltypesorc_string(ctimestamp1 timestamp, stimestamp1 string) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@alltypesorc_string POSTHOOK: query: -- Test timestamp functions in vectorized mode to verify they run correctly end-to-end. CREATE TABLE alltypesorc_string(ctimestamp1 timestamp, stimestamp1 string) STORED AS ORC POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@alltypesorc_string PREHOOK: query: INSERT OVERWRITE TABLE alltypesorc_string SELECT to_utc_timestamp(ctimestamp1, 'America/Los_Angeles'), CAST(to_utc_timestamp(ctimestamp1, 'America/Los_Angeles') AS STRING) FROM alltypesorc LIMIT 40 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc PREHOOK: Output: default@alltypesorc_string POSTHOOK: query: INSERT OVERWRITE TABLE alltypesorc_string SELECT to_utc_timestamp(ctimestamp1, 'America/Los_Angeles'), CAST(to_utc_timestamp(ctimestamp1, 'America/Los_Angeles') AS STRING) FROM alltypesorc LIMIT 40 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc POSTHOOK: Output: default@alltypesorc_string POSTHOOK: Lineage: alltypesorc_string.ctimestamp1 EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ] POSTHOOK: Lineage: alltypesorc_string.stimestamp1 EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ] PREHOOK: query: CREATE TABLE alltypesorc_wrong(stimestamp1 string) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@alltypesorc_wrong POSTHOOK: query: CREATE TABLE alltypesorc_wrong(stimestamp1 string) STORED AS ORC POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@alltypesorc_wrong PREHOOK: query: INSERT INTO TABLE alltypesorc_wrong SELECT 'abcd' FROM alltypesorc LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc PREHOOK: Output: default@alltypesorc_wrong POSTHOOK: query: INSERT INTO TABLE alltypesorc_wrong SELECT 'abcd' FROM alltypesorc LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc POSTHOOK: Output: default@alltypesorc_wrong POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE [] PREHOOK: query: INSERT INTO TABLE alltypesorc_wrong SELECT '2000:01:01 00-00-00' FROM alltypesorc LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc PREHOOK: Output: default@alltypesorc_wrong POSTHOOK: query: INSERT INTO TABLE alltypesorc_wrong SELECT '2000:01:01 00-00-00' FROM alltypesorc LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc POSTHOOK: Output: default@alltypesorc_wrong POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE [] PREHOOK: query: INSERT INTO TABLE alltypesorc_wrong SELECT '0000-00-00 99:99:99' FROM alltypesorc LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc PREHOOK: Output: default@alltypesorc_wrong POSTHOOK: query: INSERT INTO TABLE alltypesorc_wrong SELECT '0000-00-00 99:99:99' FROM alltypesorc LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc POSTHOOK: Output: default@alltypesorc_wrong POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE [] PREHOOK: query: EXPLAIN SELECT to_unix_timestamp(ctimestamp1) AS c1, year(ctimestamp1), month(ctimestamp1), day(ctimestamp1), dayofmonth(ctimestamp1), weekofyear(ctimestamp1), hour(ctimestamp1), minute(ctimestamp1), second(ctimestamp1) FROM alltypesorc_string ORDER BY c1 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT to_unix_timestamp(ctimestamp1) AS c1, year(ctimestamp1), month(ctimestamp1), day(ctimestamp1), dayofmonth(ctimestamp1), weekofyear(ctimestamp1), hour(ctimestamp1), minute(ctimestamp1), second(ctimestamp1) FROM alltypesorc_string ORDER BY c1 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesorc_string Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: to_unix_timestamp(ctimestamp1) (type: bigint), year(ctimestamp1) (type: int), month(ctimestamp1) (type: int), day(ctimestamp1) (type: int), dayofmonth(ctimestamp1) (type: int), weekofyear(ctimestamp1) (type: int), hour(ctimestamp1) (type: int), minute(ctimestamp1) (type: int), second(ctimestamp1) (type: int) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8 Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: bigint) sort order: + Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type: int) Execution mode: vectorized Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: bigint), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: int), VALUE._col3 (type: int), VALUE._col4 (type: int), VALUE._col5 (type: int), VALUE._col6 (type: int), VALUE._col7 (type: int) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8 Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: ListSink PREHOOK: query: SELECT to_unix_timestamp(ctimestamp1) AS c1, year(ctimestamp1), month(ctimestamp1), day(ctimestamp1), dayofmonth(ctimestamp1), weekofyear(ctimestamp1), hour(ctimestamp1), minute(ctimestamp1), second(ctimestamp1) FROM alltypesorc_string ORDER BY c1 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc_string #### A masked pattern was here #### POSTHOOK: query: SELECT to_unix_timestamp(ctimestamp1) AS c1, year(ctimestamp1), month(ctimestamp1), day(ctimestamp1), dayofmonth(ctimestamp1), weekofyear(ctimestamp1), hour(ctimestamp1), minute(ctimestamp1), second(ctimestamp1) FROM alltypesorc_string ORDER BY c1 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc_string #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL NULL 28784 1969 12 31 31 1 23 59 44 28784 1969 12 31 31 1 23 59 44 28784 1969 12 31 31 1 23 59 44 28784 1969 12 31 31 1 23 59 44 28785 1969 12 31 31 1 23 59 45 28786 1969 12 31 31 1 23 59 46 28787 1969 12 31 31 1 23 59 47 28788 1969 12 31 31 1 23 59 48 28789 1969 12 31 31 1 23 59 49 28789 1969 12 31 31 1 23 59 49 28790 1969 12 31 31 1 23 59 50 28792 1969 12 31 31 1 23 59 52 28792 1969 12 31 31 1 23 59 52 28792 1969 12 31 31 1 23 59 52 28792 1969 12 31 31 1 23 59 52 28795 1969 12 31 31 1 23 59 55 28795 1969 12 31 31 1 23 59 55 28795 1969 12 31 31 1 23 59 55 28798 1969 12 31 31 1 23 59 58 28798 1969 12 31 31 1 23 59 58 28800 1970 1 1 1 1 0 0 0 28800 1970 1 1 1 1 0 0 0 28802 1970 1 1 1 1 0 0 2 28803 1970 1 1 1 1 0 0 3 28804 1970 1 1 1 1 0 0 4 28804 1970 1 1 1 1 0 0 4 28805 1970 1 1 1 1 0 0 5 28805 1970 1 1 1 1 0 0 5 28806 1970 1 1 1 1 0 0 6 28807 1970 1 1 1 1 0 0 7 28807 1970 1 1 1 1 0 0 7 28807 1970 1 1 1 1 0 0 7 28808 1970 1 1 1 1 0 0 8 28808 1970 1 1 1 1 0 0 8 28809 1970 1 1 1 1 0 0 9 28811 1970 1 1 1 1 0 0 11 28813 1970 1 1 1 1 0 0 13 28814 1970 1 1 1 1 0 0 14 28815 1970 1 1 1 1 0 0 15 PREHOOK: query: EXPLAIN SELECT to_unix_timestamp(stimestamp1) AS c1, year(stimestamp1), month(stimestamp1), day(stimestamp1), dayofmonth(stimestamp1), weekofyear(stimestamp1), hour(stimestamp1), minute(stimestamp1), second(stimestamp1) FROM alltypesorc_string ORDER BY c1 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT to_unix_timestamp(stimestamp1) AS c1, year(stimestamp1), month(stimestamp1), day(stimestamp1), dayofmonth(stimestamp1), weekofyear(stimestamp1), hour(stimestamp1), minute(stimestamp1), second(stimestamp1) FROM alltypesorc_string ORDER BY c1 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesorc_string Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: to_unix_timestamp(stimestamp1) (type: bigint), year(stimestamp1) (type: int), month(stimestamp1) (type: int), day(stimestamp1) (type: int), dayofmonth(stimestamp1) (type: int), weekofyear(stimestamp1) (type: int), hour(stimestamp1) (type: int), minute(stimestamp1) (type: int), second(stimestamp1) (type: int) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8 Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: bigint) sort order: + Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type: int) Execution mode: vectorized Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: bigint), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: int), VALUE._col3 (type: int), VALUE._col4 (type: int), VALUE._col5 (type: int), VALUE._col6 (type: int), VALUE._col7 (type: int) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8 Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: ListSink PREHOOK: query: SELECT to_unix_timestamp(stimestamp1) AS c1, year(stimestamp1), month(stimestamp1), day(stimestamp1), dayofmonth(stimestamp1), weekofyear(stimestamp1), hour(stimestamp1), minute(stimestamp1), second(stimestamp1) FROM alltypesorc_string ORDER BY c1 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc_string #### A masked pattern was here #### POSTHOOK: query: SELECT to_unix_timestamp(stimestamp1) AS c1, year(stimestamp1), month(stimestamp1), day(stimestamp1), dayofmonth(stimestamp1), weekofyear(stimestamp1), hour(stimestamp1), minute(stimestamp1), second(stimestamp1) FROM alltypesorc_string ORDER BY c1 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc_string #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL NULL 28784 1969 12 31 31 1 23 59 44 28784 1969 12 31 31 1 23 59 44 28784 1969 12 31 31 1 23 59 44 28784 1969 12 31 31 1 23 59 44 28785 1969 12 31 31 1 23 59 45 28786 1969 12 31 31 1 23 59 46 28787 1969 12 31 31 1 23 59 47 28788 1969 12 31 31 1 23 59 48 28789 1969 12 31 31 1 23 59 49 28789 1969 12 31 31 1 23 59 49 28790 1969 12 31 31 1 23 59 50 28792 1969 12 31 31 1 23 59 52 28792 1969 12 31 31 1 23 59 52 28792 1969 12 31 31 1 23 59 52 28792 1969 12 31 31 1 23 59 52 28795 1969 12 31 31 1 23 59 55 28795 1969 12 31 31 1 23 59 55 28795 1969 12 31 31 1 23 59 55 28798 1969 12 31 31 1 23 59 58 28798 1969 12 31 31 1 23 59 58 28800 1970 1 1 1 1 0 0 0 28800 1970 1 1 1 1 0 0 0 28802 1970 1 1 1 1 0 0 2 28803 1970 1 1 1 1 0 0 3 28804 1970 1 1 1 1 0 0 4 28804 1970 1 1 1 1 0 0 4 28805 1970 1 1 1 1 0 0 5 28805 1970 1 1 1 1 0 0 5 28806 1970 1 1 1 1 0 0 6 28807 1970 1 1 1 1 0 0 7 28807 1970 1 1 1 1 0 0 7 28807 1970 1 1 1 1 0 0 7 28808 1970 1 1 1 1 0 0 8 28808 1970 1 1 1 1 0 0 8 28809 1970 1 1 1 1 0 0 9 28811 1970 1 1 1 1 0 0 11 28813 1970 1 1 1 1 0 0 13 28814 1970 1 1 1 1 0 0 14 28815 1970 1 1 1 1 0 0 15 PREHOOK: query: EXPLAIN SELECT to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1) AS c1, year(ctimestamp1) = year(stimestamp1), month(ctimestamp1) = month(stimestamp1), day(ctimestamp1) = day(stimestamp1), dayofmonth(ctimestamp1) = dayofmonth(stimestamp1), weekofyear(ctimestamp1) = weekofyear(stimestamp1), hour(ctimestamp1) = hour(stimestamp1), minute(ctimestamp1) = minute(stimestamp1), second(ctimestamp1) = second(stimestamp1) FROM alltypesorc_string ORDER BY c1 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1) AS c1, year(ctimestamp1) = year(stimestamp1), month(ctimestamp1) = month(stimestamp1), day(ctimestamp1) = day(stimestamp1), dayofmonth(ctimestamp1) = dayofmonth(stimestamp1), weekofyear(ctimestamp1) = weekofyear(stimestamp1), hour(ctimestamp1) = hour(stimestamp1), minute(ctimestamp1) = minute(stimestamp1), second(ctimestamp1) = second(stimestamp1) FROM alltypesorc_string ORDER BY c1 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesorc_string Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1)) (type: boolean), (year(ctimestamp1) = year(stimestamp1)) (type: boolean), (month(ctimestamp1) = month(stimestamp1)) (type: boolean), (day(ctimestamp1) = day(stimestamp1)) (type: boolean), (dayofmonth(ctimestamp1) = dayofmonth(stimestamp1)) (type: boolean), (weekofyear(ctimestamp1) = weekofyear(stimestamp1)) (type: boolean), (hour(ctimestamp1) = hour(stimestamp1)) (type: boolean), (minute(ctimestamp1) = minute(stimestamp1)) (type: boolean), (second(ctimestamp1) = second(stimestamp1)) (type: boolean) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8 Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: boolean) sort order: + Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: boolean), _col2 (type: boolean), _col3 (type: boolean), _col4 (type: boolean), _col5 (type: boolean), _col6 (type: boolean), _col7 (type: boolean), _col8 (type: boolean) Execution mode: vectorized Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: boolean), VALUE._col0 (type: boolean), VALUE._col1 (type: boolean), VALUE._col2 (type: boolean), VALUE._col3 (type: boolean), VALUE._col4 (type: boolean), VALUE._col5 (type: boolean), VALUE._col6 (type: boolean), VALUE._col7 (type: boolean) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8 Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: ListSink PREHOOK: query: -- Should all be true or NULL SELECT to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1) AS c1, year(ctimestamp1) = year(stimestamp1), month(ctimestamp1) = month(stimestamp1), day(ctimestamp1) = day(stimestamp1), dayofmonth(ctimestamp1) = dayofmonth(stimestamp1), weekofyear(ctimestamp1) = weekofyear(stimestamp1), hour(ctimestamp1) = hour(stimestamp1), minute(ctimestamp1) = minute(stimestamp1), second(ctimestamp1) = second(stimestamp1) FROM alltypesorc_string ORDER BY c1 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc_string #### A masked pattern was here #### POSTHOOK: query: -- Should all be true or NULL SELECT to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1) AS c1, year(ctimestamp1) = year(stimestamp1), month(ctimestamp1) = month(stimestamp1), day(ctimestamp1) = day(stimestamp1), dayofmonth(ctimestamp1) = dayofmonth(stimestamp1), weekofyear(ctimestamp1) = weekofyear(stimestamp1), hour(ctimestamp1) = hour(stimestamp1), minute(ctimestamp1) = minute(stimestamp1), second(ctimestamp1) = second(stimestamp1) FROM alltypesorc_string ORDER BY c1 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc_string #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL NULL true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true true PREHOOK: query: -- Wrong format. Should all be NULL. EXPLAIN SELECT to_unix_timestamp(stimestamp1) AS c1, year(stimestamp1), month(stimestamp1), day(stimestamp1), dayofmonth(stimestamp1), weekofyear(stimestamp1), hour(stimestamp1), minute(stimestamp1), second(stimestamp1) FROM alltypesorc_wrong ORDER BY c1 PREHOOK: type: QUERY POSTHOOK: query: -- Wrong format. Should all be NULL. EXPLAIN SELECT to_unix_timestamp(stimestamp1) AS c1, year(stimestamp1), month(stimestamp1), day(stimestamp1), dayofmonth(stimestamp1), weekofyear(stimestamp1), hour(stimestamp1), minute(stimestamp1), second(stimestamp1) FROM alltypesorc_wrong ORDER BY c1 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: alltypesorc_wrong Statistics: Num rows: 1 Data size: 103 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: to_unix_timestamp(stimestamp1) (type: bigint), year(stimestamp1) (type: int), month(stimestamp1) (type: int), day(stimestamp1) (type: int), dayofmonth(stimestamp1) (type: int), weekofyear(stimestamp1) (type: int), hour(stimestamp1) (type: int), minute(stimestamp1) (type: int), second(stimestamp1) (type: int) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8 Statistics: Num rows: 1 Data size: 103 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: bigint) sort order: + Statistics: Num rows: 1 Data size: 103 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type: int) Execution mode: vectorized Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: bigint), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: int), VALUE._col3 (type: int), VALUE._col4 (type: int), VALUE._col5 (type: int), VALUE._col6 (type: int), VALUE._col7 (type: int) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8 Statistics: Num rows: 1 Data size: 103 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 1 Data size: 103 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: ListSink PREHOOK: query: SELECT to_unix_timestamp(stimestamp1) AS c1, year(stimestamp1), month(stimestamp1), day(stimestamp1), dayofmonth(stimestamp1), weekofyear(stimestamp1), hour(stimestamp1), minute(stimestamp1), second(stimestamp1) FROM alltypesorc_wrong ORDER BY c1 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc_wrong #### A masked pattern was here #### POSTHOOK: query: SELECT to_unix_timestamp(stimestamp1) AS c1, year(stimestamp1), month(stimestamp1), day(stimestamp1), dayofmonth(stimestamp1), weekofyear(stimestamp1), hour(stimestamp1), minute(stimestamp1), second(stimestamp1) FROM alltypesorc_wrong ORDER BY c1 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc_wrong #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL