PREHOOK: query: DROP TABLE IF EXISTS dec
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE IF EXISTS dec
POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE dec (
  name string,
  value decimal(8,4))
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dec
POSTHOOK: query: CREATE TABLE dec (
  name string,
  value decimal(8,4))
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dec
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/dec.txt' into TABLE dec
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@dec
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/dec.txt' into TABLE dec
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@dec
PREHOOK: query: ANALYZE TABLE dec COMPUTE STATISTICS FOR COLUMNS value
PREHOOK: type: QUERY
PREHOOK: Input: default@dec
#### A masked pattern was here ####
POSTHOOK: query: ANALYZE TABLE dec COMPUTE STATISTICS FOR COLUMNS value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dec
#### A masked pattern was here ####
PREHOOK: query: DESC FORMATTED dec value
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@dec
POSTHOOK: query: DESC FORMATTED dec value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@dec
# col_name            	data_type           	min                 	max                 	num_nulls           	distinct_count      	avg_col_len         	max_col_len         	num_trues           	num_falses          	comment             
	 	 	 	 	 	 	 	 	 	 
value               	decimal(8,4)        	-12.25              	234.79              	0                   	6                   	                    	                    	                    	                    	from deserializer   
PREHOOK: query: DROP TABLE IF EXISTS avro_dec
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE IF EXISTS avro_dec
POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE avro_dec(
  name string,
  value decimal(5,2))
COMMENT 'just drop the schema right into the HQL'
STORED AS AVRO
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@avro_dec
POSTHOOK: query: CREATE TABLE avro_dec(
  name string,
  value decimal(5,2))
COMMENT 'just drop the schema right into the HQL'
STORED AS AVRO
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@avro_dec
PREHOOK: query: DESC avro_dec
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@avro_dec
POSTHOOK: query: DESC avro_dec
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@avro_dec
name                	string              	                    
value               	decimal(5,2)        	                    
PREHOOK: query: INSERT OVERWRITE TABLE avro_dec SELECT name, value FROM dec
PREHOOK: type: QUERY
PREHOOK: Input: default@dec
PREHOOK: Output: default@avro_dec
POSTHOOK: query: INSERT OVERWRITE TABLE avro_dec SELECT name, value FROM dec
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dec
POSTHOOK: Output: default@avro_dec
POSTHOOK: Lineage: avro_dec.name SIMPLE [(dec)dec.FieldSchema(name:name, type:string, comment:null), ]
POSTHOOK: Lineage: avro_dec.value EXPRESSION [(dec)dec.FieldSchema(name:value, type:decimal(8,4), comment:null), ]
PREHOOK: query: SELECT * FROM avro_dec
PREHOOK: type: QUERY
PREHOOK: Input: default@avro_dec
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM avro_dec
POSTHOOK: type: QUERY
POSTHOOK: Input: default@avro_dec
#### A masked pattern was here ####
Tom	234.79
Beck	77.34
Snow	55.71
Mary	4.33
Cluck	5.96
Tom	-12.25
Mary	33.33
Tom	19
Beck	0
Beck	79.9
PREHOOK: query: DROP TABLE IF EXISTS avro_dec1
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE IF EXISTS avro_dec1
POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE avro_dec1(
  name string,
  value decimal(4,1))
COMMENT 'just drop the schema right into the HQL'
STORED AS AVRO
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@avro_dec1
POSTHOOK: query: CREATE TABLE avro_dec1(
  name string,
  value decimal(4,1))
COMMENT 'just drop the schema right into the HQL'
STORED AS AVRO
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@avro_dec1
PREHOOK: query: DESC avro_dec1
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@avro_dec1
POSTHOOK: query: DESC avro_dec1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@avro_dec1
name                	string              	                    
value               	decimal(4,1)        	                    
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/dec.avro' INTO TABLE avro_dec1
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@avro_dec1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/dec.avro' INTO TABLE avro_dec1
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@avro_dec1
PREHOOK: query: SELECT value FROM avro_dec1
PREHOOK: type: QUERY
PREHOOK: Input: default@avro_dec1
#### A masked pattern was here ####
POSTHOOK: query: SELECT value FROM avro_dec1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@avro_dec1
#### A masked pattern was here ####
234.8
77.3
55.7
4.3
6
12.3
33.3
19
3.2
79.9
PREHOOK: query: DROP TABLE dec
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@dec
PREHOOK: Output: default@dec
POSTHOOK: query: DROP TABLE dec
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@dec
POSTHOOK: Output: default@dec
PREHOOK: query: DROP TABLE avro_dec
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@avro_dec
PREHOOK: Output: default@avro_dec
POSTHOOK: query: DROP TABLE avro_dec
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@avro_dec
POSTHOOK: Output: default@avro_dec
PREHOOK: query: DROP TABLE avro_dec1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@avro_dec1
PREHOOK: Output: default@avro_dec1
POSTHOOK: query: DROP TABLE avro_dec1
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@avro_dec1
POSTHOOK: Output: default@avro_dec1