PREHOOK: query: DROP TABLE parquet_types_staging PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE parquet_types_staging POSTHOOK: type: DROPTABLE PREHOOK: query: DROP TABLE parquet_types PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE parquet_types POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE parquet_types_staging ( cint int, ctinyint tinyint, csmallint smallint, cfloat float, cdouble double, cstring1 string, t timestamp, cchar char(5), cvarchar varchar(10) ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@parquet_types_staging POSTHOOK: query: CREATE TABLE parquet_types_staging ( cint int, ctinyint tinyint, csmallint smallint, cfloat float, cdouble double, cstring1 string, t timestamp, cchar char(5), cvarchar varchar(10) ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@parquet_types_staging PREHOOK: query: CREATE TABLE parquet_types ( cint int, ctinyint tinyint, csmallint smallint, cfloat float, cdouble double, cstring1 string, t timestamp, cchar char(5), cvarchar varchar(10) ) STORED AS PARQUET PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@parquet_types POSTHOOK: query: CREATE TABLE parquet_types ( cint int, ctinyint tinyint, csmallint smallint, cfloat float, cdouble double, cstring1 string, t timestamp, cchar char(5), cvarchar varchar(10) ) STORED AS PARQUET POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@parquet_types PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/parquet_types.txt' OVERWRITE INTO TABLE parquet_types_staging PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@parquet_types_staging POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/parquet_types.txt' OVERWRITE INTO TABLE parquet_types_staging POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@parquet_types_staging PREHOOK: query: INSERT OVERWRITE TABLE parquet_types SELECT * FROM parquet_types_staging PREHOOK: type: QUERY PREHOOK: Input: default@parquet_types_staging PREHOOK: Output: default@parquet_types POSTHOOK: query: INSERT OVERWRITE TABLE parquet_types SELECT * FROM parquet_types_staging POSTHOOK: type: QUERY POSTHOOK: Input: default@parquet_types_staging POSTHOOK: Output: default@parquet_types POSTHOOK: Lineage: parquet_types.cchar SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:cchar, type:char(5), comment:null), ] POSTHOOK: Lineage: parquet_types.cdouble SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:cdouble, type:double, comment:null), ] POSTHOOK: Lineage: parquet_types.cfloat SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:cfloat, type:float, comment:null), ] POSTHOOK: Lineage: parquet_types.cint SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:cint, type:int, comment:null), ] POSTHOOK: Lineage: parquet_types.csmallint SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:csmallint, type:smallint, comment:null), ] POSTHOOK: Lineage: parquet_types.cstring1 SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:cstring1, type:string, comment:null), ] POSTHOOK: Lineage: parquet_types.ctinyint SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:ctinyint, type:tinyint, comment:null), ] POSTHOOK: Lineage: parquet_types.cvarchar SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:cvarchar, type:varchar(10), comment:null), ] POSTHOOK: Lineage: parquet_types.t SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:t, type:timestamp, comment:null), ] PREHOOK: query: SELECT * FROM parquet_types PREHOOK: type: QUERY PREHOOK: Input: default@parquet_types #### A masked pattern was here #### POSTHOOK: query: SELECT * FROM parquet_types POSTHOOK: type: QUERY POSTHOOK: Input: default@parquet_types #### A masked pattern was here #### 100 1 1 1.0 0.0 abc 2011-01-01 01:01:01.111111111 a a 101 2 2 1.1 0.3 def 2012-02-02 02:02:02.222222222 ab ab 102 3 3 1.2 0.6 ghi 2013-03-03 03:03:03.333333333 abc abc 103 1 4 1.3 0.9 jkl 2014-04-04 04:04:04.444444444 abcd abcd 104 2 5 1.4 1.2 mno 2015-05-05 05:05:05.555555555 abcde abcde 105 3 1 1.0 1.5 pqr 2016-06-06 06:06:06.666666666 abcde abcdef 106 1 2 1.1 1.8 stu 2017-07-07 07:07:07.777777777 abcde abcdefg 107 2 3 1.2 2.1 vwx 2018-08-08 08:08:08.888888888 bcdef abcdefgh 108 3 4 1.3 2.4 yza 2019-09-09 09:09:09.999999999 cdefg abcdefghij 109 1 5 1.4 2.7 bcd 2020-10-10 10:10:10.101010101 klmno abcdedef 110 2 1 1.0 3.0 efg 2021-11-11 11:11:11.111111111 pqrst abcdede 111 3 2 1.1 3.3 hij 2022-12-12 12:12:12.121212121 nopqr abcded 112 1 3 1.2 3.6 klm 2023-01-02 13:13:13.131313131 opqrs abcdd 113 2 4 1.3 3.9 nop 2024-02-02 14:14:14.141414141 pqrst abc 114 3 5 1.4 4.2 qrs 2025-03-03 15:15:15.151515151 qrstu b 115 1 1 1.0 4.5 tuv 2026-04-04 16:16:16.161616161 rstuv abcded 116 2 2 1.1 4.8 wxy 2027-05-05 17:17:17.171717171 stuvw abcded 117 3 3 1.2 5.1 zab 2028-06-06 18:18:18.181818181 tuvwx abcded 118 1 4 1.3 5.4 cde 2029-07-07 19:19:19.191919191 uvwzy abcdede 119 2 5 1.4 5.7 fgh 2030-08-08 20:20:20.202020202 vwxyz abcdede 120 3 1 1.0 6.0 ijk 2031-09-09 21:21:21.212121212 wxyza abcde PREHOOK: query: SELECT ctinyint, MAX(cint), MIN(csmallint), COUNT(cstring1), AVG(cfloat), STDDEV_POP(cdouble) FROM parquet_types GROUP BY ctinyint ORDER BY ctinyint PREHOOK: type: QUERY PREHOOK: Input: default@parquet_types #### A masked pattern was here #### POSTHOOK: query: SELECT ctinyint, MAX(cint), MIN(csmallint), COUNT(cstring1), AVG(cfloat), STDDEV_POP(cdouble) FROM parquet_types GROUP BY ctinyint ORDER BY ctinyint POSTHOOK: type: QUERY POSTHOOK: Input: default@parquet_types #### A masked pattern was here #### 1 118 1 7 1.1857142789023263 1.8000000000000003 2 119 1 7 1.2142857142857142 1.8 3 120 1 7 1.171428578240531 1.7999999999999996