| PREHOOK: query: drop table if exists decimal_1_1 |
| PREHOOK: type: DROPTABLE |
| POSTHOOK: query: drop table if exists decimal_1_1 |
| POSTHOOK: type: DROPTABLE |
| PREHOOK: query: create table decimal_1_1 (d decimal(1,1)) |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@decimal_1_1 |
| POSTHOOK: query: create table decimal_1_1 (d decimal(1,1)) |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@decimal_1_1 |
| PREHOOK: query: load data local inpath '../../data/files/decimal_1_1.txt' into table decimal_1_1 |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@decimal_1_1 |
| POSTHOOK: query: load data local inpath '../../data/files/decimal_1_1.txt' into table decimal_1_1 |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@decimal_1_1 |
| PREHOOK: query: select * from decimal_1_1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@decimal_1_1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from decimal_1_1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@decimal_1_1 |
| #### A masked pattern was here #### |
| 0.0 |
| 0.0 |
| 0.0 |
| 0.1 |
| 0.2 |
| 0.9 |
| 0.9 |
| NULL |
| 0.3 |
| NULL |
| NULL |
| 0.0 |
| 0.0 |
| NULL |
| 0.0 |
| 0.0 |
| 0.0 |
| 0.0 |
| -0.1 |
| -0.2 |
| -0.9 |
| -0.9 |
| NULL |
| -0.3 |
| NULL |
| NULL |
| 0.0 |
| 0.0 |
| NULL |
| 0.0 |
| PREHOOK: query: select d from decimal_1_1 order by d desc |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@decimal_1_1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select d from decimal_1_1 order by d desc |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@decimal_1_1 |
| #### A masked pattern was here #### |
| 0.9 |
| 0.9 |
| 0.3 |
| 0.2 |
| 0.1 |
| 0.0 |
| 0.0 |
| 0.0 |
| 0.0 |
| 0.0 |
| 0.0 |
| 0.0 |
| 0.0 |
| 0.0 |
| 0.0 |
| 0.0 |
| 0.0 |
| -0.1 |
| -0.2 |
| -0.3 |
| -0.9 |
| -0.9 |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| PREHOOK: query: drop table decimal_1_1 |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@decimal_1_1 |
| PREHOOK: Output: default@decimal_1_1 |
| POSTHOOK: query: drop table decimal_1_1 |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@decimal_1_1 |
| POSTHOOK: Output: default@decimal_1_1 |