| PREHOOK: query: CREATE TABLE staging(t tinyint, |
| si smallint, |
| i int, |
| b bigint, |
| f float, |
| d double, |
| bo boolean, |
| s string, |
| ts timestamp, |
| dec decimal(4,2), |
| bin binary) |
| ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' |
| STORED AS TEXTFILE |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@staging |
| POSTHOOK: query: CREATE TABLE staging(t tinyint, |
| si smallint, |
| i int, |
| b bigint, |
| f float, |
| d double, |
| bo boolean, |
| s string, |
| ts timestamp, |
| dec decimal(4,2), |
| bin binary) |
| ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' |
| STORED AS TEXTFILE |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@staging |
| PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/over1k' OVERWRITE INTO TABLE staging |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@staging |
| POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/over1k' OVERWRITE INTO TABLE staging |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@staging |
| PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/over1k' INTO TABLE staging |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@staging |
| POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/over1k' INTO TABLE staging |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@staging |
| PREHOOK: query: CREATE TABLE orc_ppd_staging(t tinyint, |
| si smallint, |
| i int, |
| b bigint, |
| f float, |
| d double, |
| bo boolean, |
| s string, |
| c char(50), |
| v varchar(50), |
| da date, |
| ts timestamp, |
| dec decimal(4,2), |
| bin binary) |
| STORED AS ORC tblproperties("orc.row.index.stride" = "1000", "orc.bloom.filter.columns"="*") |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@orc_ppd_staging |
| POSTHOOK: query: CREATE TABLE orc_ppd_staging(t tinyint, |
| si smallint, |
| i int, |
| b bigint, |
| f float, |
| d double, |
| bo boolean, |
| s string, |
| c char(50), |
| v varchar(50), |
| da date, |
| ts timestamp, |
| dec decimal(4,2), |
| bin binary) |
| STORED AS ORC tblproperties("orc.row.index.stride" = "1000", "orc.bloom.filter.columns"="*") |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@orc_ppd_staging |
| PREHOOK: query: insert overwrite table orc_ppd_staging select t, si, i, b, f, d, bo, s, cast(s as char(50)), cast(s as varchar(50)), cast(ts as date), ts, dec, bin from staging order by t, s |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@staging |
| PREHOOK: Output: default@orc_ppd_staging |
| POSTHOOK: query: insert overwrite table orc_ppd_staging select t, si, i, b, f, d, bo, s, cast(s as char(50)), cast(s as varchar(50)), cast(ts as date), ts, dec, bin from staging order by t, s |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@staging |
| POSTHOOK: Output: default@orc_ppd_staging |
| POSTHOOK: Lineage: orc_ppd_staging.b SIMPLE [(staging)staging.FieldSchema(name:b, type:bigint, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd_staging.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd_staging.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd_staging.c EXPRESSION [(staging)staging.FieldSchema(name:s, type:string, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd_staging.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd_staging.da EXPRESSION [(staging)staging.FieldSchema(name:ts, type:timestamp, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd_staging.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ] |
| POSTHOOK: Lineage: orc_ppd_staging.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd_staging.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd_staging.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd_staging.si SIMPLE [(staging)staging.FieldSchema(name:si, type:smallint, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd_staging.t SIMPLE [(staging)staging.FieldSchema(name:t, type:tinyint, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd_staging.ts SIMPLE [(staging)staging.FieldSchema(name:ts, type:timestamp, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd_staging.v EXPRESSION [(staging)staging.FieldSchema(name:s, type:string, comment:null), ] |
| PREHOOK: query: -- just to introduce a gap in min/max range for bloom filters. The dataset has contiguous values |
| -- which makes it hard to test bloom filters |
| insert into orc_ppd_staging select -10,-321,-65680,-4294967430,-97.94,-13.07,true,"aaa","aaa","aaa","1990-03-11","1990-03-11 10:11:58.703308",-71.54,"aaa" from staging limit 1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@staging |
| PREHOOK: Output: default@orc_ppd_staging |
| POSTHOOK: query: -- just to introduce a gap in min/max range for bloom filters. The dataset has contiguous values |
| -- which makes it hard to test bloom filters |
| insert into orc_ppd_staging select -10,-321,-65680,-4294967430,-97.94,-13.07,true,"aaa","aaa","aaa","1990-03-11","1990-03-11 10:11:58.703308",-71.54,"aaa" from staging limit 1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@staging |
| POSTHOOK: Output: default@orc_ppd_staging |
| POSTHOOK: Lineage: orc_ppd_staging.b EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.bin EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.bo SIMPLE [] |
| POSTHOOK: Lineage: orc_ppd_staging.c EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.d EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.da EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.dec EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.f EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.i EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.s SIMPLE [] |
| POSTHOOK: Lineage: orc_ppd_staging.si EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.t EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.ts EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.v EXPRESSION [] |
| PREHOOK: query: insert into orc_ppd_staging select 127,331,65690,4294967440,107.94,23.07,true,"zzz","zzz","zzz","2023-03-11","2023-03-11 10:11:58.703308",71.54,"zzz" from staging limit 1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@staging |
| PREHOOK: Output: default@orc_ppd_staging |
| POSTHOOK: query: insert into orc_ppd_staging select 127,331,65690,4294967440,107.94,23.07,true,"zzz","zzz","zzz","2023-03-11","2023-03-11 10:11:58.703308",71.54,"zzz" from staging limit 1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@staging |
| POSTHOOK: Output: default@orc_ppd_staging |
| POSTHOOK: Lineage: orc_ppd_staging.b SIMPLE [] |
| POSTHOOK: Lineage: orc_ppd_staging.bin EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.bo SIMPLE [] |
| POSTHOOK: Lineage: orc_ppd_staging.c EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.d EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.da EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.dec SIMPLE [] |
| POSTHOOK: Lineage: orc_ppd_staging.f EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.i SIMPLE [] |
| POSTHOOK: Lineage: orc_ppd_staging.s SIMPLE [] |
| POSTHOOK: Lineage: orc_ppd_staging.si EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.t EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.ts EXPRESSION [] |
| POSTHOOK: Lineage: orc_ppd_staging.v EXPRESSION [] |
| PREHOOK: query: CREATE TABLE orc_ppd(t tinyint, |
| si smallint, |
| i int, |
| b bigint, |
| f float, |
| d double, |
| bo boolean, |
| s string, |
| c char(50), |
| v varchar(50), |
| da date, |
| ts timestamp, |
| dec decimal(4,2), |
| bin binary) |
| STORED AS ORC tblproperties("orc.row.index.stride" = "1000", "orc.bloom.filter.columns"="*") |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@orc_ppd |
| POSTHOOK: query: CREATE TABLE orc_ppd(t tinyint, |
| si smallint, |
| i int, |
| b bigint, |
| f float, |
| d double, |
| bo boolean, |
| s string, |
| c char(50), |
| v varchar(50), |
| da date, |
| ts timestamp, |
| dec decimal(4,2), |
| bin binary) |
| STORED AS ORC tblproperties("orc.row.index.stride" = "1000", "orc.bloom.filter.columns"="*") |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@orc_ppd |
| PREHOOK: query: insert overwrite table orc_ppd select t, si, i, b, f, d, bo, s, cast(s as char(50)), cast(s as varchar(50)), cast(ts as date), ts, dec, bin from orc_ppd_staging order by t, s |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd_staging |
| PREHOOK: Output: default@orc_ppd |
| POSTHOOK: query: insert overwrite table orc_ppd select t, si, i, b, f, d, bo, s, cast(s as char(50)), cast(s as varchar(50)), cast(ts as date), ts, dec, bin from orc_ppd_staging order by t, s |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@orc_ppd_staging |
| POSTHOOK: Output: default@orc_ppd |
| POSTHOOK: Lineage: orc_ppd.b SIMPLE [(orc_ppd_staging)orc_ppd_staging.FieldSchema(name:b, type:bigint, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd.bin SIMPLE [(orc_ppd_staging)orc_ppd_staging.FieldSchema(name:bin, type:binary, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd.bo SIMPLE [(orc_ppd_staging)orc_ppd_staging.FieldSchema(name:bo, type:boolean, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd.c EXPRESSION [(orc_ppd_staging)orc_ppd_staging.FieldSchema(name:s, type:string, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd.d SIMPLE [(orc_ppd_staging)orc_ppd_staging.FieldSchema(name:d, type:double, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd.da EXPRESSION [(orc_ppd_staging)orc_ppd_staging.FieldSchema(name:ts, type:timestamp, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd.dec SIMPLE [(orc_ppd_staging)orc_ppd_staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ] |
| POSTHOOK: Lineage: orc_ppd.f SIMPLE [(orc_ppd_staging)orc_ppd_staging.FieldSchema(name:f, type:float, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd.i SIMPLE [(orc_ppd_staging)orc_ppd_staging.FieldSchema(name:i, type:int, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd.s SIMPLE [(orc_ppd_staging)orc_ppd_staging.FieldSchema(name:s, type:string, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd.si SIMPLE [(orc_ppd_staging)orc_ppd_staging.FieldSchema(name:si, type:smallint, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd.t SIMPLE [(orc_ppd_staging)orc_ppd_staging.FieldSchema(name:t, type:tinyint, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd.ts SIMPLE [(orc_ppd_staging)orc_ppd_staging.FieldSchema(name:ts, type:timestamp, comment:null), ] |
| POSTHOOK: Lineage: orc_ppd.v EXPRESSION [(orc_ppd_staging)orc_ppd_staging.FieldSchema(name:s, type:string, comment:null), ] |
| PREHOOK: query: -- Row group statistics for column t: |
| -- Entry 0: count: 994 hasNull: true min: -10 max: 54 sum: 26014 positions: 0,0,0,0,0,0,0 |
| -- Entry 1: count: 1000 hasNull: false min: 54 max: 118 sum: 86812 positions: 0,2,124,0,0,116,11 |
| -- Entry 2: count: 100 hasNull: false min: 118 max: 127 sum: 12151 positions: 0,4,119,0,0,244,19 |
| |
| -- INPUT_RECORDS: 0 (no row groups) |
| select count(*) from orc_ppd where t > 127 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 17046 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 6 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| ALLOCATED_BYTES: 524288 |
| ALLOCATED_USED_BYTES: 269 |
| CACHE_MISS_BYTES: 249 |
| METADATA_CACHE_MISS: 2 |
| NUM_DECODED_BATCHES: 3 |
| NUM_VECTOR_BATCHES: 3 |
| ROWS_EMITTED: 2100 |
| SELECTED_ROWGROUPS: 3 |
| 0 |
| PREHOOK: query: -- INPUT_RECORDS: 0 (no row groups) |
| select count(*) from orc_ppd where t > 127 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 0 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 2 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| RECORDS_OUT_0: 1 |
| 0 |
| PREHOOK: query: -- INPUT_RECORDS: 1000 (1 row group) |
| select count(*) from orc_ppd where t = 55 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 0 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 2 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| CACHE_HIT_BYTES: 249 |
| CACHE_MISS_BYTES: 0 |
| METADATA_CACHE_HIT: 2 |
| NUM_DECODED_BATCHES: 3 |
| NUM_VECTOR_BATCHES: 3 |
| ROWS_EMITTED: 2100 |
| SELECTED_ROWGROUPS: 3 |
| 8 |
| PREHOOK: query: -- INPUT_RECORDS: 1000 (1 row group) |
| select count(*) from orc_ppd where t = 55 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 0 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 2 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 1000 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| CACHE_HIT_BYTES: 249 |
| CACHE_MISS_BYTES: 0 |
| METADATA_CACHE_HIT: 2 |
| NUM_DECODED_BATCHES: 1 |
| NUM_VECTOR_BATCHES: 1 |
| ROWS_EMITTED: 1000 |
| SELECTED_ROWGROUPS: 1 |
| 8 |
| PREHOOK: query: -- INPUT_RECORDS: 2000 (2 row groups) |
| select count(*) from orc_ppd where t = 54 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 0 |
| HDFS_BYTES_WRITTEN: 102 |
| HDFS_READ_OPS: 2 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| CACHE_HIT_BYTES: 249 |
| CACHE_MISS_BYTES: 0 |
| METADATA_CACHE_HIT: 2 |
| NUM_DECODED_BATCHES: 3 |
| NUM_VECTOR_BATCHES: 3 |
| ROWS_EMITTED: 2100 |
| SELECTED_ROWGROUPS: 3 |
| 18 |
| PREHOOK: query: -- INPUT_RECORDS: 2000 (2 row groups) |
| select count(*) from orc_ppd where t = 54 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 0 |
| HDFS_BYTES_WRITTEN: 102 |
| HDFS_READ_OPS: 2 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2000 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| CACHE_HIT_BYTES: 249 |
| CACHE_MISS_BYTES: 0 |
| METADATA_CACHE_HIT: 2 |
| NUM_DECODED_BATCHES: 2 |
| NUM_VECTOR_BATCHES: 2 |
| ROWS_EMITTED: 2000 |
| SELECTED_ROWGROUPS: 2 |
| 18 |
| PREHOOK: query: alter table orc_ppd change column t t smallint |
| PREHOOK: type: ALTERTABLE_RENAMECOL |
| PREHOOK: Input: default@orc_ppd |
| PREHOOK: Output: default@orc_ppd |
| PREHOOK: query: -- INPUT_RECORDS: 0 (no row groups) |
| select count(*) from orc_ppd where t > 127 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 16936 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 0 |
| PREHOOK: query: -- INPUT_RECORDS: 0 (no row groups) |
| select count(*) from orc_ppd where t > 127 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 0 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 2 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| RECORDS_OUT_0: 1 |
| 0 |
| PREHOOK: query: -- INPUT_RECORDS: 1000 (1 row group) |
| select count(*) from orc_ppd where t = 55 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 16936 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 8 |
| PREHOOK: query: -- INPUT_RECORDS: 1000 (1 row group) |
| select count(*) from orc_ppd where t = 55 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 17909 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 1000 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 8 |
| PREHOOK: query: -- INPUT_RECORDS: 2000 (2 row groups) |
| select count(*) from orc_ppd where t = 54 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 16936 |
| HDFS_BYTES_WRITTEN: 102 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 18 |
| PREHOOK: query: -- INPUT_RECORDS: 2000 (2 row groups) |
| select count(*) from orc_ppd where t = 54 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 17909 |
| HDFS_BYTES_WRITTEN: 102 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2000 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 18 |
| PREHOOK: query: alter table orc_ppd change column t t int |
| PREHOOK: type: ALTERTABLE_RENAMECOL |
| PREHOOK: Input: default@orc_ppd |
| PREHOOK: Output: default@orc_ppd |
| PREHOOK: query: -- INPUT_RECORDS: 0 (no row groups) |
| select count(*) from orc_ppd where t > 127 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 16936 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 0 |
| PREHOOK: query: -- INPUT_RECORDS: 0 (no row groups) |
| select count(*) from orc_ppd where t > 127 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 0 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 2 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| RECORDS_OUT_0: 1 |
| 0 |
| PREHOOK: query: -- INPUT_RECORDS: 1000 (1 row group) |
| select count(*) from orc_ppd where t = 55 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 16936 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 8 |
| PREHOOK: query: -- INPUT_RECORDS: 1000 (1 row group) |
| select count(*) from orc_ppd where t = 55 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 17909 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 1000 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 8 |
| PREHOOK: query: -- INPUT_RECORDS: 2000 (2 row groups) |
| select count(*) from orc_ppd where t = 54 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 16936 |
| HDFS_BYTES_WRITTEN: 102 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 18 |
| PREHOOK: query: -- INPUT_RECORDS: 2000 (2 row groups) |
| select count(*) from orc_ppd where t = 54 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 17909 |
| HDFS_BYTES_WRITTEN: 102 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2000 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 18 |
| PREHOOK: query: alter table orc_ppd change column t t bigint |
| PREHOOK: type: ALTERTABLE_RENAMECOL |
| PREHOOK: Input: default@orc_ppd |
| PREHOOK: Output: default@orc_ppd |
| PREHOOK: query: -- INPUT_RECORDS: 0 (no row groups) |
| select count(*) from orc_ppd where t > 127 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 16936 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 0 |
| PREHOOK: query: -- INPUT_RECORDS: 0 (no row groups) |
| select count(*) from orc_ppd where t > 127 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 0 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 2 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| RECORDS_OUT_0: 1 |
| 0 |
| PREHOOK: query: -- INPUT_RECORDS: 1000 (1 row group) |
| select count(*) from orc_ppd where t = 55 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 16936 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 8 |
| PREHOOK: query: -- INPUT_RECORDS: 1000 (1 row group) |
| select count(*) from orc_ppd where t = 55 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 17909 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 1000 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 8 |
| PREHOOK: query: -- INPUT_RECORDS: 2000 (2 row groups) |
| select count(*) from orc_ppd where t = 54 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 16936 |
| HDFS_BYTES_WRITTEN: 102 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 18 |
| PREHOOK: query: -- INPUT_RECORDS: 2000 (2 row groups) |
| select count(*) from orc_ppd where t = 54 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 17909 |
| HDFS_BYTES_WRITTEN: 102 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2000 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 18 |
| PREHOOK: query: alter table orc_ppd change column t t string |
| PREHOOK: type: ALTERTABLE_RENAMECOL |
| PREHOOK: Input: default@orc_ppd |
| PREHOOK: Output: default@orc_ppd |
| PREHOOK: query: -- INPUT_RECORDS: 0 (no row groups) |
| select count(*) from orc_ppd where t > '127' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 16936 |
| HDFS_BYTES_WRITTEN: 104 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 1566 |
| PREHOOK: query: -- INPUT_RECORDS: 0 (no row groups) |
| select count(*) from orc_ppd where t > '127' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 17909 |
| HDFS_BYTES_WRITTEN: 104 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 1566 |
| PREHOOK: query: -- INPUT_RECORDS: 1000 (1 row group) |
| select count(*) from orc_ppd where t = '55' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 16936 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 8 |
| PREHOOK: query: -- INPUT_RECORDS: 1000 (1 row group) |
| select count(*) from orc_ppd where t = '55' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 17909 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 8 |
| PREHOOK: query: -- INPUT_RECORDS: 2000 (2 row groups) |
| select count(*) from orc_ppd where t = '54' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 16936 |
| HDFS_BYTES_WRITTEN: 102 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 18 |
| PREHOOK: query: -- INPUT_RECORDS: 2000 (2 row groups) |
| select count(*) from orc_ppd where t = '54' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 17909 |
| HDFS_BYTES_WRITTEN: 102 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 18 |
| PREHOOK: query: -- float tests |
| select count(*) from orc_ppd where f = 74.72 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 5215 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| ALLOCATED_BYTES: 262144 |
| ALLOCATED_USED_BYTES: 8400 |
| CACHE_HIT_BYTES: 0 |
| CACHE_MISS_BYTES: 4809 |
| METADATA_CACHE_HIT: 1 |
| METADATA_CACHE_MISS: 1 |
| NUM_DECODED_BATCHES: 3 |
| NUM_VECTOR_BATCHES: 3 |
| ROWS_EMITTED: 2100 |
| SELECTED_ROWGROUPS: 3 |
| 2 |
| PREHOOK: query: select count(*) from orc_ppd where f = 74.72 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 0 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 2 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| CACHE_HIT_BYTES: 4809 |
| CACHE_MISS_BYTES: 0 |
| METADATA_CACHE_HIT: 2 |
| NUM_DECODED_BATCHES: 3 |
| NUM_VECTOR_BATCHES: 3 |
| ROWS_EMITTED: 2100 |
| SELECTED_ROWGROUPS: 3 |
| 2 |
| PREHOOK: query: alter table orc_ppd change column f f double |
| PREHOOK: type: ALTERTABLE_RENAMECOL |
| PREHOOK: Input: default@orc_ppd |
| PREHOOK: Output: default@orc_ppd |
| PREHOOK: query: select count(*) from orc_ppd where f = 74.72 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 21496 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 2 |
| PREHOOK: query: select count(*) from orc_ppd where f = 74.72 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 23556 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 2 |
| PREHOOK: query: alter table orc_ppd change column f f string |
| PREHOOK: type: ALTERTABLE_RENAMECOL |
| PREHOOK: Input: default@orc_ppd |
| PREHOOK: Output: default@orc_ppd |
| PREHOOK: query: select count(*) from orc_ppd where f = '74.72' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 21496 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 2 |
| PREHOOK: query: select count(*) from orc_ppd where f = '74.72' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 23556 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 2 |
| PREHOOK: query: -- string tests |
| select count(*) from orc_ppd where s = 'bob davidson' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 4402 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| ALLOCATED_BYTES: 786432 |
| ALLOCATED_USED_BYTES: 11299 |
| CACHE_HIT_BYTES: 0 |
| CACHE_MISS_BYTES: 3980 |
| METADATA_CACHE_HIT: 1 |
| METADATA_CACHE_MISS: 1 |
| NUM_DECODED_BATCHES: 3 |
| NUM_VECTOR_BATCHES: 3 |
| ROWS_EMITTED: 2100 |
| SELECTED_ROWGROUPS: 3 |
| 6 |
| PREHOOK: query: select count(*) from orc_ppd where s = 'bob davidson' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 0 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 2 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| CACHE_HIT_BYTES: 3980 |
| CACHE_MISS_BYTES: 0 |
| METADATA_CACHE_HIT: 2 |
| NUM_DECODED_BATCHES: 3 |
| NUM_VECTOR_BATCHES: 3 |
| ROWS_EMITTED: 2100 |
| SELECTED_ROWGROUPS: 3 |
| 6 |
| PREHOOK: query: alter table orc_ppd change column s s char(50) |
| PREHOOK: type: ALTERTABLE_RENAMECOL |
| PREHOOK: Input: default@orc_ppd |
| PREHOOK: Output: default@orc_ppd |
| PREHOOK: query: select count(*) from orc_ppd where s = 'bob davidson' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 20667 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 6 |
| PREHOOK: query: select count(*) from orc_ppd where s = 'bob davidson' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 22574 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 6 |
| PREHOOK: query: alter table orc_ppd change column s s varchar(50) |
| PREHOOK: type: ALTERTABLE_RENAMECOL |
| PREHOOK: Input: default@orc_ppd |
| PREHOOK: Output: default@orc_ppd |
| PREHOOK: query: select count(*) from orc_ppd where s = 'bob davidson' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 20667 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 6 |
| PREHOOK: query: select count(*) from orc_ppd where s = 'bob davidson' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 22574 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 6 |
| PREHOOK: query: alter table orc_ppd change column s s char(50) |
| PREHOOK: type: ALTERTABLE_RENAMECOL |
| PREHOOK: Input: default@orc_ppd |
| PREHOOK: Output: default@orc_ppd |
| PREHOOK: query: select count(*) from orc_ppd where s = 'bob davidson' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 20667 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 6 |
| PREHOOK: query: select count(*) from orc_ppd where s = 'bob davidson' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 22574 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 6 |
| PREHOOK: query: alter table orc_ppd change column s s string |
| PREHOOK: type: ALTERTABLE_RENAMECOL |
| PREHOOK: Input: default@orc_ppd |
| PREHOOK: Output: default@orc_ppd |
| PREHOOK: query: select count(*) from orc_ppd where s = 'bob davidson' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 0 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 2 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| CACHE_HIT_BYTES: 3980 |
| CACHE_MISS_BYTES: 0 |
| METADATA_CACHE_HIT: 2 |
| NUM_DECODED_BATCHES: 3 |
| NUM_VECTOR_BATCHES: 3 |
| ROWS_EMITTED: 2100 |
| SELECTED_ROWGROUPS: 3 |
| 6 |
| PREHOOK: query: select count(*) from orc_ppd where s = 'bob davidson' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 0 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 2 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| CACHE_HIT_BYTES: 3980 |
| CACHE_MISS_BYTES: 0 |
| METADATA_CACHE_HIT: 2 |
| NUM_DECODED_BATCHES: 3 |
| NUM_VECTOR_BATCHES: 3 |
| ROWS_EMITTED: 2100 |
| SELECTED_ROWGROUPS: 3 |
| 6 |
| PREHOOK: query: alter table orc_ppd add columns (boo boolean) |
| PREHOOK: type: ALTERTABLE_ADDCOLS |
| PREHOOK: Input: default@orc_ppd |
| PREHOOK: Output: default@orc_ppd |
| PREHOOK: query: -- ppd on newly added column |
| select count(*) from orc_ppd where si = 442 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 18785 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 4 |
| PREHOOK: query: select count(*) from orc_ppd where si = 442 or boo is not null or boo = false |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 18785 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 4 |
| PREHOOK: query: select count(*) from orc_ppd where si = 442 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 20256 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 1000 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 4 |
| PREHOOK: query: select count(*) from orc_ppd where si = 442 or boo is not null or boo = false |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_ppd |
| #### A masked pattern was here #### |
| Stage-1 FILE SYSTEM COUNTERS: |
| HDFS_BYTES_READ: 20256 |
| HDFS_BYTES_WRITTEN: 101 |
| HDFS_READ_OPS: 4 |
| HDFS_LARGE_READ_OPS: 0 |
| HDFS_WRITE_OPS: 2 |
| Stage-1 HIVE COUNTERS: |
| CREATED_FILES: 1 |
| DESERIALIZE_ERRORS: 0 |
| RECORDS_IN_Map_1: 2100 |
| RECORDS_OUT_0: 1 |
| RECORDS_OUT_INTERMEDIATE_Map_1: 1 |
| Stage-1 LLAP IO COUNTERS: |
| METADATA_CACHE_HIT: 1 |
| 4 |