| PREHOOK: query: DROP TABLE IF EXISTS `dec_n0` |
| PREHOOK: type: DROPTABLE |
| POSTHOOK: query: DROP TABLE IF EXISTS `dec_n0` |
| POSTHOOK: type: DROPTABLE |
| PREHOOK: query: CREATE TABLE `dec_n0`(name string, value decimal(8,4)) |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@dec_n0 |
| POSTHOOK: query: CREATE TABLE `dec_n0`(name string, value decimal(8,4)) |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@dec_n0 |
| PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/dec.txt' into TABLE `dec_n0` |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@dec_n0 |
| POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/dec.txt' into TABLE `dec_n0` |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@dec_n0 |
| PREHOOK: query: ANALYZE TABLE `dec_n0` COMPUTE STATISTICS FOR COLUMNS value |
| PREHOOK: type: ANALYZE_TABLE |
| PREHOOK: Input: default@dec_n0 |
| PREHOOK: Output: default@dec_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: ANALYZE TABLE `dec_n0` COMPUTE STATISTICS FOR COLUMNS value |
| POSTHOOK: type: ANALYZE_TABLE |
| POSTHOOK: Input: default@dec_n0 |
| POSTHOOK: Output: default@dec_n0 |
| #### A masked pattern was here #### |
| PREHOOK: query: DESC FORMATTED `dec_n0` value |
| PREHOOK: type: DESCTABLE |
| PREHOOK: Input: default@dec_n0 |
| POSTHOOK: query: DESC FORMATTED `dec_n0` value |
| POSTHOOK: type: DESCTABLE |
| POSTHOOK: Input: default@dec_n0 |
| col_name value |
| data_type decimal(8,4) |
| min -12.25 |
| max 234.79 |
| num_nulls 0 |
| distinct_count 10 |
| avg_col_len |
| max_col_len |
| num_trues |
| num_falses |
| bit_vector HL |
| comment from deserializer |
| COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"value\":\"true\"}} |
| PREHOOK: query: DROP TABLE IF EXISTS avro_dec_n0 |
| PREHOOK: type: DROPTABLE |
| POSTHOOK: query: DROP TABLE IF EXISTS avro_dec_n0 |
| POSTHOOK: type: DROPTABLE |
| PREHOOK: query: CREATE TABLE `avro_dec_n0`( |
| `name` string COMMENT 'from deserializer', |
| `value` decimal(5,2) COMMENT 'from deserializer') |
| COMMENT 'just drop the schema right into the HQL' |
| ROW FORMAT SERDE |
| 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' |
| STORED AS INPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' |
| OUTPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' |
| TBLPROPERTIES ( |
| 'numFiles'='1', |
| 'avro.schema.literal'='{\"namespace\":\"com.howdy\",\"name\":\"some_schema\",\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"},{\"name\":\"value\",\"type\":{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":5,\"scale\":2}}]}' |
| ) |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@avro_dec_n0 |
| POSTHOOK: query: CREATE TABLE `avro_dec_n0`( |
| `name` string COMMENT 'from deserializer', |
| `value` decimal(5,2) COMMENT 'from deserializer') |
| COMMENT 'just drop the schema right into the HQL' |
| ROW FORMAT SERDE |
| 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' |
| STORED AS INPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' |
| OUTPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' |
| TBLPROPERTIES ( |
| 'numFiles'='1', |
| 'avro.schema.literal'='{\"namespace\":\"com.howdy\",\"name\":\"some_schema\",\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"},{\"name\":\"value\",\"type\":{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":5,\"scale\":2}}]}' |
| ) |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@avro_dec_n0 |
| PREHOOK: query: DESC avro_dec_n0 |
| PREHOOK: type: DESCTABLE |
| PREHOOK: Input: default@avro_dec_n0 |
| POSTHOOK: query: DESC avro_dec_n0 |
| POSTHOOK: type: DESCTABLE |
| POSTHOOK: Input: default@avro_dec_n0 |
| name string |
| value decimal(5,2) |
| PREHOOK: query: INSERT OVERWRITE TABLE avro_dec_n0 select name, value from `dec_n0` |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@dec_n0 |
| PREHOOK: Output: default@avro_dec_n0 |
| POSTHOOK: query: INSERT OVERWRITE TABLE avro_dec_n0 select name, value from `dec_n0` |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@dec_n0 |
| POSTHOOK: Output: default@avro_dec_n0 |
| POSTHOOK: Lineage: avro_dec_n0.name SIMPLE [(dec_n0)dec_n0.FieldSchema(name:name, type:string, comment:null), ] |
| POSTHOOK: Lineage: avro_dec_n0.value EXPRESSION [(dec_n0)dec_n0.FieldSchema(name:value, type:decimal(8,4), comment:null), ] |
| PREHOOK: query: SELECT * FROM avro_dec_n0 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@avro_dec_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT * FROM avro_dec_n0 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@avro_dec_n0 |
| #### 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.00 |
| Beck 0.00 |
| Beck 79.90 |
| PREHOOK: query: DROP TABLE IF EXISTS avro_dec1_n0 |
| PREHOOK: type: DROPTABLE |
| POSTHOOK: query: DROP TABLE IF EXISTS avro_dec1_n0 |
| POSTHOOK: type: DROPTABLE |
| PREHOOK: query: CREATE TABLE `avro_dec1_n0`( |
| `name` string COMMENT 'from deserializer', |
| `value` decimal(4,1) COMMENT 'from deserializer') |
| COMMENT 'just drop the schema right into the HQL' |
| ROW FORMAT SERDE |
| 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' |
| STORED AS INPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' |
| OUTPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' |
| TBLPROPERTIES ( |
| 'numFiles'='1', |
| 'avro.schema.literal'='{\"namespace\":\"com.howdy\",\"name\":\"some_schema\",\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"},{\"name\":\"value\",\"type\":{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":4,\"scale\":1}}]}' |
| ) |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@avro_dec1_n0 |
| POSTHOOK: query: CREATE TABLE `avro_dec1_n0`( |
| `name` string COMMENT 'from deserializer', |
| `value` decimal(4,1) COMMENT 'from deserializer') |
| COMMENT 'just drop the schema right into the HQL' |
| ROW FORMAT SERDE |
| 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' |
| STORED AS INPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' |
| OUTPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' |
| TBLPROPERTIES ( |
| 'numFiles'='1', |
| 'avro.schema.literal'='{\"namespace\":\"com.howdy\",\"name\":\"some_schema\",\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"},{\"name\":\"value\",\"type\":{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":4,\"scale\":1}}]}' |
| ) |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@avro_dec1_n0 |
| PREHOOK: query: DESC avro_dec1_n0 |
| PREHOOK: type: DESCTABLE |
| PREHOOK: Input: default@avro_dec1_n0 |
| POSTHOOK: query: DESC avro_dec1_n0 |
| POSTHOOK: type: DESCTABLE |
| POSTHOOK: Input: default@avro_dec1_n0 |
| name string |
| value decimal(4,1) |
| PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/dec.avro' into TABLE avro_dec1_n0 |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@avro_dec1_n0 |
| POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/dec.avro' into TABLE avro_dec1_n0 |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@avro_dec1_n0 |
| PREHOOK: query: select value from avro_dec1_n0 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@avro_dec1_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select value from avro_dec1_n0 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@avro_dec1_n0 |
| #### A masked pattern was here #### |
| 234.8 |
| 77.3 |
| 55.7 |
| 4.3 |
| 6.0 |
| 12.3 |
| 33.3 |
| 19.0 |
| 3.2 |
| 79.9 |
| PREHOOK: query: DROP TABLE `dec_n0` |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@dec_n0 |
| PREHOOK: Output: default@dec_n0 |
| POSTHOOK: query: DROP TABLE `dec_n0` |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@dec_n0 |
| POSTHOOK: Output: default@dec_n0 |
| PREHOOK: query: DROP TABLE avro_dec_n0 |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@avro_dec_n0 |
| PREHOOK: Output: default@avro_dec_n0 |
| POSTHOOK: query: DROP TABLE avro_dec_n0 |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@avro_dec_n0 |
| POSTHOOK: Output: default@avro_dec_n0 |
| PREHOOK: query: DROP TABLE avro_dec1_n0 |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@avro_dec1_n0 |
| PREHOOK: Output: default@avro_dec1_n0 |
| POSTHOOK: query: DROP TABLE avro_dec1_n0 |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@avro_dec1_n0 |
| POSTHOOK: Output: default@avro_dec1_n0 |
