| PREHOOK: query: CREATE TABLE timestamp_formats ( |
| c1 string, |
| c1_ts timestamp, |
| c2 string, |
| c2_ts timestamp, |
| c3 string, |
| c3_ts timestamp |
| ) |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@timestamp_formats |
| POSTHOOK: query: CREATE TABLE timestamp_formats ( |
| c1 string, |
| c1_ts timestamp, |
| c2 string, |
| c2_ts timestamp, |
| c3 string, |
| c3_ts timestamp |
| ) |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@timestamp_formats |
| PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/ts_formats.txt' overwrite into table timestamp_formats |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@timestamp_formats |
| POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/ts_formats.txt' overwrite into table timestamp_formats |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@timestamp_formats |
| PREHOOK: query: SELECT * FROM timestamp_formats |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@timestamp_formats |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT * FROM timestamp_formats |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@timestamp_formats |
| #### A masked pattern was here #### |
| 2011-01-01 01:01:01.111111111 2011-01-01 01:01:01.111111111 2011-01-01T01:01:01.111111111 2011-01-01 01:01:01.111111111 2011-01-01T01:01:01 2011-01-01 01:01:01 |
| 2012-02-02 02:02:02.222222222 2012-02-02 02:02:02.222222222 2012-02-02T02:02:02.222222222 2012-02-02 02:02:02.222222222 2012-02-02T02:02:02 2012-02-02 02:02:02 |
| 2013-03-03 03:03:03.333333333 2013-03-03 03:03:03.333333333 2013-03-03T03:03:03.333333333 2013-03-03 03:03:03.333333333 2013-03-03T03:03:03 2013-03-03 03:03:03 |
| 2014-04-04 04:04:04.444444444 2014-04-04 04:04:04.444444444 2014-04-04T04:04:04.444444444 2014-04-04 04:04:04.444444444 2014-04-04T04:04:04 2014-04-04 04:04:04 |
| 2015-05-05 05:05:05.555555555 2015-05-05 05:05:05.555555555 2015-05-05T05:05:05.555555555 2015-05-05 05:05:05.555555555 2015-05-05T05:05:05 2015-05-05 05:05:05 |
| 2016-06-06 06:06:06.666666666 2016-06-06 06:06:06.666666666 2016-06-06T06:06:06.666666666 2016-06-06 06:06:06.666666666 2016-06-06T06:06:06 2016-06-06 06:06:06 |
| 2017-07-07 07:07:07.777777777 2017-07-07 07:07:07.777777777 2017-07-07T07:07:07.777777777 2017-07-07 07:07:07.777777777 2017-07-07T07:07:07 2017-07-07 07:07:07 |
| 2018-08-08 08:08:08.888888888 2018-08-08 08:08:08.888888888 2018-08-08T08:08:08.888888888 2018-08-08 08:08:08.888888888 2018-08-08T08:08:08 2018-08-08 08:08:08 |
| 2019-09-09 09:09:09.999999999 2019-09-09 09:09:09.999999999 2019-09-09T09:09:09.999999999 2019-09-09 09:09:09.999999999 2019-09-09T09:09:09 2019-09-09 09:09:09 |
| 2020-10-10 10:10:10.101010101 2020-10-10 10:10:10.101010101 2020-10-10T10:10:10.101010101 2020-10-10 10:10:10.101010101 2020-10-10T10:10:10 2020-10-10 10:10:10 |
| 2021-11-11 11:11:11.111111111 2021-11-11 11:11:11.111111111 2021-11-11T11:11:11.111111111 2021-11-11 11:11:11.111111111 2021-11-11T11:11:11 2021-11-11 11:11:11 |
| 2022-12-12 12:12:12.121212121 2022-12-12 12:12:12.121212121 2022-12-12T12:12:12.121212121 2022-12-12 12:12:12.121212121 2022-12-12T12:12:12 2022-12-12 12:12:12 |
| 2023-01-02 13:13:13.131313131 2023-01-02 13:13:13.131313131 2023-01-02T13:13:13.131313131 2023-01-02 13:13:13.131313131 2023-01-02T13:13:13 2023-01-02 13:13:13 |
| 2024-02-02 14:14:14.141414141 2024-02-02 14:14:14.141414141 2024-02-02T14:14:14.141414141 2024-02-02 14:14:14.141414141 2024-02-02T14:14:14 2024-02-02 14:14:14 |
| 2025-03-03 15:15:15.151515151 2025-03-03 15:15:15.151515151 2025-03-03T15:15:15.151515151 2025-03-03 15:15:15.151515151 2025-03-03T15:15:15 2025-03-03 15:15:15 |
| 2026-04-04 16:16:16.161616161 2026-04-04 16:16:16.161616161 2026-04-04T16:16:16.161616161 2026-04-04 16:16:16.161616161 2026-04-04T16:16:16 2026-04-04 16:16:16 |
| 2027-05-05 17:17:17.171717171 2027-05-05 17:17:17.171717171 2027-05-05T17:17:17.171717171 2027-05-05 17:17:17.171717171 2027-05-05T17:17:17 2027-05-05 17:17:17 |
| 2028-06-06 18:18:18.181818181 2028-06-06 18:18:18.181818181 2028-06-06T18:18:18.181818181 2028-06-06 18:18:18.181818181 2028-06-06T18:18:18 2028-06-06 18:18:18 |
| 2029-07-07 19:19:19.191919191 2029-07-07 19:19:19.191919191 2029-07-07T19:19:19.191919191 2029-07-07 19:19:19.191919191 2029-07-07T19:19:19 2029-07-07 19:19:19 |
| 2030-08-08 20:20:20.202020202 2030-08-08 20:20:20.202020202 2030-08-08T20:20:20.202020202 2030-08-08 20:20:20.202020202 2030-08-08T20:20:20 2030-08-08 20:20:20 |
| 2031-09-09 21:21:21.212121212 2031-09-09 21:21:21.212121212 2031-09-09T21:21:21.212121212 2031-09-09 21:21:21.212121212 2031-09-09T21:21:21 2031-09-09 21:21:21 |
| PREHOOK: query: ALTER TABLE timestamp_formats SET SERDEPROPERTIES ("timestamp.formats"="yyyy-MM-dd'T'HH:mm:ss") |
| PREHOOK: type: ALTERTABLE_SERDEPROPERTIES |
| PREHOOK: Input: default@timestamp_formats |
| PREHOOK: Output: default@timestamp_formats |
| POSTHOOK: query: ALTER TABLE timestamp_formats SET SERDEPROPERTIES ("timestamp.formats"="yyyy-MM-dd'T'HH:mm:ss") |
| POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES |
| POSTHOOK: Input: default@timestamp_formats |
| POSTHOOK: Output: default@timestamp_formats |
| PREHOOK: query: SELECT * FROM timestamp_formats |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@timestamp_formats |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT * FROM timestamp_formats |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@timestamp_formats |
| #### A masked pattern was here #### |
| 2011-01-01 01:01:01.111111111 2011-01-01 01:01:01.111111111 2011-01-01T01:01:01.111111111 2011-01-01 01:01:01.111111111 2011-01-01T01:01:01 2011-01-01 01:01:01 |
| 2012-02-02 02:02:02.222222222 2012-02-02 02:02:02.222222222 2012-02-02T02:02:02.222222222 2012-02-02 02:02:02.222222222 2012-02-02T02:02:02 2012-02-02 02:02:02 |
| 2013-03-03 03:03:03.333333333 2013-03-03 03:03:03.333333333 2013-03-03T03:03:03.333333333 2013-03-03 03:03:03.333333333 2013-03-03T03:03:03 2013-03-03 03:03:03 |
| 2014-04-04 04:04:04.444444444 2014-04-04 04:04:04.444444444 2014-04-04T04:04:04.444444444 2014-04-04 04:04:04.444444444 2014-04-04T04:04:04 2014-04-04 04:04:04 |
| 2015-05-05 05:05:05.555555555 2015-05-05 05:05:05.555555555 2015-05-05T05:05:05.555555555 2015-05-05 05:05:05.555555555 2015-05-05T05:05:05 2015-05-05 05:05:05 |
| 2016-06-06 06:06:06.666666666 2016-06-06 06:06:06.666666666 2016-06-06T06:06:06.666666666 2016-06-06 06:06:06.666666666 2016-06-06T06:06:06 2016-06-06 06:06:06 |
| 2017-07-07 07:07:07.777777777 2017-07-07 07:07:07.777777777 2017-07-07T07:07:07.777777777 2017-07-07 07:07:07.777777777 2017-07-07T07:07:07 2017-07-07 07:07:07 |
| 2018-08-08 08:08:08.888888888 2018-08-08 08:08:08.888888888 2018-08-08T08:08:08.888888888 2018-08-08 08:08:08.888888888 2018-08-08T08:08:08 2018-08-08 08:08:08 |
| 2019-09-09 09:09:09.999999999 2019-09-09 09:09:09.999999999 2019-09-09T09:09:09.999999999 2019-09-09 09:09:09.999999999 2019-09-09T09:09:09 2019-09-09 09:09:09 |
| 2020-10-10 10:10:10.101010101 2020-10-10 10:10:10.101010101 2020-10-10T10:10:10.101010101 2020-10-10 10:10:10.101010101 2020-10-10T10:10:10 2020-10-10 10:10:10 |
| 2021-11-11 11:11:11.111111111 2021-11-11 11:11:11.111111111 2021-11-11T11:11:11.111111111 2021-11-11 11:11:11.111111111 2021-11-11T11:11:11 2021-11-11 11:11:11 |
| 2022-12-12 12:12:12.121212121 2022-12-12 12:12:12.121212121 2022-12-12T12:12:12.121212121 2022-12-12 12:12:12.121212121 2022-12-12T12:12:12 2022-12-12 12:12:12 |
| 2023-01-02 13:13:13.131313131 2023-01-02 13:13:13.131313131 2023-01-02T13:13:13.131313131 2023-01-02 13:13:13.131313131 2023-01-02T13:13:13 2023-01-02 13:13:13 |
| 2024-02-02 14:14:14.141414141 2024-02-02 14:14:14.141414141 2024-02-02T14:14:14.141414141 2024-02-02 14:14:14.141414141 2024-02-02T14:14:14 2024-02-02 14:14:14 |
| 2025-03-03 15:15:15.151515151 2025-03-03 15:15:15.151515151 2025-03-03T15:15:15.151515151 2025-03-03 15:15:15.151515151 2025-03-03T15:15:15 2025-03-03 15:15:15 |
| 2026-04-04 16:16:16.161616161 2026-04-04 16:16:16.161616161 2026-04-04T16:16:16.161616161 2026-04-04 16:16:16.161616161 2026-04-04T16:16:16 2026-04-04 16:16:16 |
| 2027-05-05 17:17:17.171717171 2027-05-05 17:17:17.171717171 2027-05-05T17:17:17.171717171 2027-05-05 17:17:17.171717171 2027-05-05T17:17:17 2027-05-05 17:17:17 |
| 2028-06-06 18:18:18.181818181 2028-06-06 18:18:18.181818181 2028-06-06T18:18:18.181818181 2028-06-06 18:18:18.181818181 2028-06-06T18:18:18 2028-06-06 18:18:18 |
| 2029-07-07 19:19:19.191919191 2029-07-07 19:19:19.191919191 2029-07-07T19:19:19.191919191 2029-07-07 19:19:19.191919191 2029-07-07T19:19:19 2029-07-07 19:19:19 |
| 2030-08-08 20:20:20.202020202 2030-08-08 20:20:20.202020202 2030-08-08T20:20:20.202020202 2030-08-08 20:20:20.202020202 2030-08-08T20:20:20 2030-08-08 20:20:20 |
| 2031-09-09 21:21:21.212121212 2031-09-09 21:21:21.212121212 2031-09-09T21:21:21.212121212 2031-09-09 21:21:21.212121212 2031-09-09T21:21:21 2031-09-09 21:21:21 |
| PREHOOK: query: ALTER TABLE timestamp_formats SET SERDEPROPERTIES ("timestamp.formats"="yyyy-MM-dd'T'HH:mm:ss,yyyy-MM-dd'T'HH:mm:ss.SSSSSSSSS") |
| PREHOOK: type: ALTERTABLE_SERDEPROPERTIES |
| PREHOOK: Input: default@timestamp_formats |
| PREHOOK: Output: default@timestamp_formats |
| POSTHOOK: query: ALTER TABLE timestamp_formats SET SERDEPROPERTIES ("timestamp.formats"="yyyy-MM-dd'T'HH:mm:ss,yyyy-MM-dd'T'HH:mm:ss.SSSSSSSSS") |
| POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES |
| POSTHOOK: Input: default@timestamp_formats |
| POSTHOOK: Output: default@timestamp_formats |
| PREHOOK: query: SELECT * FROM timestamp_formats |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@timestamp_formats |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT * FROM timestamp_formats |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@timestamp_formats |
| #### A masked pattern was here #### |
| 2011-01-01 01:01:01.111111111 2011-01-01 01:01:01.111111111 2011-01-01T01:01:01.111111111 2011-01-01 01:01:01.111 2011-01-01T01:01:01 2011-01-01 01:01:01 |
| 2012-02-02 02:02:02.222222222 2012-02-02 02:02:02.222222222 2012-02-02T02:02:02.222222222 2012-02-02 02:02:02.222 2012-02-02T02:02:02 2012-02-02 02:02:02 |
| 2013-03-03 03:03:03.333333333 2013-03-03 03:03:03.333333333 2013-03-03T03:03:03.333333333 2013-03-03 03:03:03.333 2013-03-03T03:03:03 2013-03-03 03:03:03 |
| 2014-04-04 04:04:04.444444444 2014-04-04 04:04:04.444444444 2014-04-04T04:04:04.444444444 2014-04-04 04:04:04.444 2014-04-04T04:04:04 2014-04-04 04:04:04 |
| 2015-05-05 05:05:05.555555555 2015-05-05 05:05:05.555555555 2015-05-05T05:05:05.555555555 2015-05-05 05:05:05.555 2015-05-05T05:05:05 2015-05-05 05:05:05 |
| 2016-06-06 06:06:06.666666666 2016-06-06 06:06:06.666666666 2016-06-06T06:06:06.666666666 2016-06-06 06:06:06.666 2016-06-06T06:06:06 2016-06-06 06:06:06 |
| 2017-07-07 07:07:07.777777777 2017-07-07 07:07:07.777777777 2017-07-07T07:07:07.777777777 2017-07-07 07:07:07.777 2017-07-07T07:07:07 2017-07-07 07:07:07 |
| 2018-08-08 08:08:08.888888888 2018-08-08 08:08:08.888888888 2018-08-08T08:08:08.888888888 2018-08-08 08:08:08.888 2018-08-08T08:08:08 2018-08-08 08:08:08 |
| 2019-09-09 09:09:09.999999999 2019-09-09 09:09:09.999999999 2019-09-09T09:09:09.999999999 2019-09-09 09:09:09.999 2019-09-09T09:09:09 2019-09-09 09:09:09 |
| 2020-10-10 10:10:10.101010101 2020-10-10 10:10:10.101010101 2020-10-10T10:10:10.101010101 2020-10-10 10:10:10.101 2020-10-10T10:10:10 2020-10-10 10:10:10 |
| 2021-11-11 11:11:11.111111111 2021-11-11 11:11:11.111111111 2021-11-11T11:11:11.111111111 2021-11-11 11:11:11.111 2021-11-11T11:11:11 2021-11-11 11:11:11 |
| 2022-12-12 12:12:12.121212121 2022-12-12 12:12:12.121212121 2022-12-12T12:12:12.121212121 2022-12-12 12:12:12.121 2022-12-12T12:12:12 2022-12-12 12:12:12 |
| 2023-01-02 13:13:13.131313131 2023-01-02 13:13:13.131313131 2023-01-02T13:13:13.131313131 2023-01-02 13:13:13.131 2023-01-02T13:13:13 2023-01-02 13:13:13 |
| 2024-02-02 14:14:14.141414141 2024-02-02 14:14:14.141414141 2024-02-02T14:14:14.141414141 2024-02-02 14:14:14.141 2024-02-02T14:14:14 2024-02-02 14:14:14 |
| 2025-03-03 15:15:15.151515151 2025-03-03 15:15:15.151515151 2025-03-03T15:15:15.151515151 2025-03-03 15:15:15.151 2025-03-03T15:15:15 2025-03-03 15:15:15 |
| 2026-04-04 16:16:16.161616161 2026-04-04 16:16:16.161616161 2026-04-04T16:16:16.161616161 2026-04-04 16:16:16.161 2026-04-04T16:16:16 2026-04-04 16:16:16 |
| 2027-05-05 17:17:17.171717171 2027-05-05 17:17:17.171717171 2027-05-05T17:17:17.171717171 2027-05-05 17:17:17.171 2027-05-05T17:17:17 2027-05-05 17:17:17 |
| 2028-06-06 18:18:18.181818181 2028-06-06 18:18:18.181818181 2028-06-06T18:18:18.181818181 2028-06-06 18:18:18.181 2028-06-06T18:18:18 2028-06-06 18:18:18 |
| 2029-07-07 19:19:19.191919191 2029-07-07 19:19:19.191919191 2029-07-07T19:19:19.191919191 2029-07-07 19:19:19.191 2029-07-07T19:19:19 2029-07-07 19:19:19 |
| 2030-08-08 20:20:20.202020202 2030-08-08 20:20:20.202020202 2030-08-08T20:20:20.202020202 2030-08-08 20:20:20.202 2030-08-08T20:20:20 2030-08-08 20:20:20 |
| 2031-09-09 21:21:21.212121212 2031-09-09 21:21:21.212121212 2031-09-09T21:21:21.212121212 2031-09-09 21:21:21.212 2031-09-09T21:21:21 2031-09-09 21:21:21 |
| PREHOOK: query: DROP TABLE timestamp_formats |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@timestamp_formats |
| PREHOOK: Output: default@timestamp_formats |
| POSTHOOK: query: DROP TABLE timestamp_formats |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@timestamp_formats |
| POSTHOOK: Output: default@timestamp_formats |
