| PREHOOK: query: drop table tstz1_n1 |
| PREHOOK: type: DROPTABLE |
| POSTHOOK: query: drop table tstz1_n1 |
| POSTHOOK: type: DROPTABLE |
| PREHOOK: query: create table tstz1_n1(t timestamp with local time zone) |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@tstz1_n1 |
| POSTHOOK: query: create table tstz1_n1(t timestamp with local time zone) |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@tstz1_n1 |
| PREHOOK: query: insert overwrite table tstz1_n1 select cast('2016-01-03 12:26:34 America/Los_Angeles' as timestamp with local time zone) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| PREHOOK: Output: default@tstz1_n1 |
| POSTHOOK: query: insert overwrite table tstz1_n1 select cast('2016-01-03 12:26:34 America/Los_Angeles' as timestamp with local time zone) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| POSTHOOK: Output: default@tstz1_n1 |
| POSTHOOK: Lineage: tstz1_n1.t SIMPLE [] |
| PREHOOK: query: select cast(t as timestamp) from tstz1_n1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@tstz1_n1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select cast(t as timestamp) from tstz1_n1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@tstz1_n1 |
| #### A masked pattern was here #### |
| 2016-01-03 12:26:34 |
| PREHOOK: query: select cast(to_epoch_milli(t) as timestamp) from tstz1_n1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@tstz1_n1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select cast(to_epoch_milli(t) as timestamp) from tstz1_n1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@tstz1_n1 |
| #### A masked pattern was here #### |
| 2016-01-03 20:26:34 |
| PREHOOK: query: select cast(t as timestamp) from tstz1_n1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@tstz1_n1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select cast(t as timestamp) from tstz1_n1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@tstz1_n1 |
| #### A masked pattern was here #### |
| 2016-01-03 20:26:34 |
| PREHOOK: query: select cast(to_epoch_milli(t) as timestamp) from tstz1_n1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@tstz1_n1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select cast(to_epoch_milli(t) as timestamp) from tstz1_n1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@tstz1_n1 |
| #### A masked pattern was here #### |
| 2016-01-03 20:26:34 |