ql/src/test/results/clientpositive/llap/decimal_5.q.out

PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_5_n0
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_5_n0
POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE DECIMAL_5_n0(key decimal(10,5), value int)
ROW FORMAT DELIMITED
   FIELDS TERMINATED BY ' '
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@DECIMAL_5_n0
POSTHOOK: query: CREATE TABLE DECIMAL_5_n0(key decimal(10,5), value int)
ROW FORMAT DELIMITED
   FIELDS TERMINATED BY ' '
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@DECIMAL_5_n0
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_5_n0
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@decimal_5_n0
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_5_n0
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@decimal_5_n0
PREHOOK: query: SELECT key FROM DECIMAL_5_n0 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_5_n0
#### A masked pattern was here ####
POSTHOOK: query: SELECT key FROM DECIMAL_5_n0 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_5_n0
#### A masked pattern was here ####
-4400.00000
-1255.49000
-1.12200
-1.12000
-1.12000
-0.33300
-0.33000
-0.30000
0.00000
0.00000
0.00000
0.01000
0.02000
0.10000
0.20000
0.30000
0.33000
0.33300
1.00000
1.00000
1.00000
1.12000
1.12200
2.00000
2.00000
3.14000
3.14000
3.14000
3.14000
10.00000
20.00000
100.00000
124.00000
125.20000
200.00000
NULL
NULL
NULL
PREHOOK: query: SELECT DISTINCT key FROM DECIMAL_5_n0 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_5_n0
#### A masked pattern was here ####
POSTHOOK: query: SELECT DISTINCT key FROM DECIMAL_5_n0 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_5_n0
#### A masked pattern was here ####
-4400.00000
-1255.49000
-1.12200
-1.12000
-0.33300
-0.33000
-0.30000
0.00000
0.01000
0.02000
0.10000
0.20000
0.30000
0.33000
0.33300
1.00000
1.12000
1.12200
2.00000
3.14000
10.00000
20.00000
100.00000
124.00000
125.20000
200.00000
NULL
PREHOOK: query: SELECT cast(key as decimal) FROM DECIMAL_5_n0
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_5_n0
#### A masked pattern was here ####
POSTHOOK: query: SELECT cast(key as decimal) FROM DECIMAL_5_n0
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_5_n0
#### A masked pattern was here ####
-4400
NULL
0
0
100
10
1
0
0
200
20
2
0
0
0
0
0
0
0
0
0
1
2
3
-1
-1
-1
1
1
124
125
-1255
3
3
3
1
NULL
NULL
PREHOOK: query: SELECT cast(key as decimal(6,3)) FROM DECIMAL_5_n0
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_5_n0
#### A masked pattern was here ####
POSTHOOK: query: SELECT cast(key as decimal(6,3)) FROM DECIMAL_5_n0
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_5_n0
#### A masked pattern was here ####
NULL
NULL
0.000
0.000
100.000
10.000
1.000
0.100
0.010
200.000
20.000
2.000
0.000
0.200
0.020
0.300
0.330
0.333
-0.300
-0.330
-0.333
1.000
2.000
3.140
-1.120
-1.120
-1.122
1.120
1.122
124.000
125.200
NULL
3.140
3.140
3.140
1.000
NULL
NULL
PREHOOK: query: DROP TABLE DECIMAL_5_n0
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@decimal_5_n0
PREHOOK: Output: default@decimal_5_n0
POSTHOOK: query: DROP TABLE DECIMAL_5_n0
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@decimal_5_n0
POSTHOOK: Output: default@decimal_5_n0