PREHOOK: query: DESCRIBE FUNCTION to_unix_timestamp PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION to_unix_timestamp POSTHOOK: type: DESCFUNCTION to_unix_timestamp(date[, pattern]) - Returns the UNIX timestamp PREHOOK: query: DESCRIBE FUNCTION EXTENDED to_unix_timestamp PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED to_unix_timestamp POSTHOOK: type: DESCFUNCTION to_unix_timestamp(date[, pattern]) - Returns the UNIX timestamp Converts the specified time to number of seconds since 1970-01-01. PREHOOK: query: create table oneline(key int, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@oneline POSTHOOK: query: create table oneline(key int, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@oneline PREHOOK: query: load data local inpath '../../data/files/things.txt' into table oneline PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@oneline POSTHOOK: query: load data local inpath '../../data/files/things.txt' into table oneline POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@oneline PREHOOK: query: SELECT '2009-03-20 11:30:01', to_unix_timestamp('2009-03-20 11:30:01') FROM oneline PREHOOK: type: QUERY PREHOOK: Input: default@oneline #### A masked pattern was here #### POSTHOOK: query: SELECT '2009-03-20 11:30:01', to_unix_timestamp('2009-03-20 11:30:01') FROM oneline POSTHOOK: type: QUERY POSTHOOK: Input: default@oneline #### A masked pattern was here #### 2009-03-20 11:30:01 1237573801 PREHOOK: query: SELECT '2009-03-20', to_unix_timestamp('2009-03-20', 'yyyy-MM-dd') FROM oneline PREHOOK: type: QUERY PREHOOK: Input: default@oneline #### A masked pattern was here #### POSTHOOK: query: SELECT '2009-03-20', to_unix_timestamp('2009-03-20', 'yyyy-MM-dd') FROM oneline POSTHOOK: type: QUERY POSTHOOK: Input: default@oneline #### A masked pattern was here #### 2009-03-20 1237532400 PREHOOK: query: SELECT '2009 Mar 20 11:30:01 am', to_unix_timestamp('2009 Mar 20 11:30:01 am', 'yyyy MMM dd h:mm:ss a') FROM oneline PREHOOK: type: QUERY PREHOOK: Input: default@oneline #### A masked pattern was here #### POSTHOOK: query: SELECT '2009 Mar 20 11:30:01 am', to_unix_timestamp('2009 Mar 20 11:30:01 am', 'yyyy MMM dd h:mm:ss a') FROM oneline POSTHOOK: type: QUERY POSTHOOK: Input: default@oneline #### A masked pattern was here #### 2009 Mar 20 11:30:01 am 1237573801 PREHOOK: query: SELECT 'random_string', to_unix_timestamp('random_string') FROM oneline PREHOOK: type: QUERY PREHOOK: Input: default@oneline #### A masked pattern was here #### POSTHOOK: query: SELECT 'random_string', to_unix_timestamp('random_string') FROM oneline POSTHOOK: type: QUERY POSTHOOK: Input: default@oneline #### A masked pattern was here #### random_string NULL PREHOOK: query: -- PPD explain select * from (select * from src) a where unix_timestamp(a.key) > 10 PREHOOK: type: QUERY POSTHOOK: query: -- PPD explain select * from (select * from src) a where unix_timestamp(a.key) > 10 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: src Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (unix_timestamp(_col0) > 10) (type: boolean) Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col1 (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 9 Data size: 1803 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: explain select * from (select * from src) a where to_unix_timestamp(a.key) > 10 PREHOOK: type: QUERY POSTHOOK: query: explain select * from (select * from src) a where to_unix_timestamp(a.key) > 10 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: src Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (to_unix_timestamp(key) > 10) (type: boolean) Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 9 Data size: 1803 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