| PREHOOK: query: CREATE EXTERNAL TABLE hbase_avro_table( |
| `key` string COMMENT '', |
| `data_frv4` struct<`id`:string, `dischargedate`:struct<`value`:timestamp>>) |
| ROW FORMAT SERDE |
| 'org.apache.hadoop.hive.hbase.HBaseSerDe' |
| STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' |
| WITH SERDEPROPERTIES ( |
| 'serialization.format'='1', |
| 'hbase.columns.mapping' = ':key,data:frV4', |
| 'data.frV4.serialization.type'='avro', |
| #### A masked pattern was here #### |
| ) |
| TBLPROPERTIES ( |
| 'hbase.table.name' = 'HiveAvroTable', |
| 'hbase.struct.autogenerate'='true') |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@hbase_avro_table |
| POSTHOOK: query: CREATE EXTERNAL TABLE hbase_avro_table( |
| `key` string COMMENT '', |
| `data_frv4` struct<`id`:string, `dischargedate`:struct<`value`:timestamp>>) |
| ROW FORMAT SERDE |
| 'org.apache.hadoop.hive.hbase.HBaseSerDe' |
| STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' |
| WITH SERDEPROPERTIES ( |
| 'serialization.format'='1', |
| 'hbase.columns.mapping' = ':key,data:frV4', |
| 'data.frV4.serialization.type'='avro', |
| #### A masked pattern was here #### |
| ) |
| TBLPROPERTIES ( |
| 'hbase.table.name' = 'HiveAvroTable', |
| 'hbase.struct.autogenerate'='true') |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@hbase_avro_table |
| PREHOOK: query: select data_frV4.dischargedate.value from hbase_avro_table |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@hbase_avro_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: select data_frV4.dischargedate.value from hbase_avro_table |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@hbase_avro_table |
| #### A masked pattern was here #### |
| 2022-07-05 00:00:00 |
