====
---- QUERY
select * from decimal_encodings;
---- RESULTS
0.00,0.00,0.00
255.00,255.00,255.00
65535.00,65535.00,65535.00
9999999.99,9999999.99,9999999.99
0.00,9999999999999999.99,999999999999999999999999999999999999.99
-255.00,-255.00,-255.00
-65535.00,-65535.00,-65535.00
-9999999.99,-9999999.99,-9999999.99
0.00,-9999999999999999.99,-999999999999999999999999999999999999.99
0.00,0.00,0.00
255.00,255.00,255.00
65535.00,65535.00,65535.00
9999999.99,9999999.99,9999999.99
0.00,9999999999999999.99,999999999999999999999999999999999999.99
-255.00,-255.00,-255.00
-65535.00,-65535.00,-65535.00
-9999999.99,-9999999.99,-9999999.99
0.00,-9999999999999999.99,-999999999999999999999999999999999999.99
---- TYPES
DECIMAL,DECIMAL,DECIMAL
====
---- QUERY
select score from decimal_stored_as_int32
---- RESULTS
12.340
24.560
34.123
---- TYPES
DECIMAL
====
---- QUERY
select score from decimal_stored_as_int64
---- RESULTS
12.3400
24.5600
34.1230
---- TYPES
DECIMAL
====
---- QUERY
select * from decimal_padded_fixed_len_byte_array
---- RESULTS
1234,2222,1.2345678900,0.12345678900000000000000000000000000000,12345.78900,1
2345,111,12.3456789000,0.12345678900000000000000000000000000000,3.14100,1
12345,333,123.4567890000,0.12345678900000000000000000000000000000,11.22000,1
12345,333,1234.5678900000,0.12345678900000000000000000000000000000,0.10000,1
132842,333,12345.6789000000,0.12345678900000000000000000000000000000,0.77889,1
---- TYPES
DECIMAL,DECIMAL,DECIMAL,DECIMAL,DECIMAL,DECIMAL
====
---- QUERY
select count(distinct d), avg(d)
from decimal_padded_fixed_len_byte_array2
---- RESULTS
12503,-296330482.059986
---- TYPES
BIGINT,DECIMAL
====
---- QUERY
select d from decimal_padded_fixed_len_byte_array2
order by d
limit 10
---- RESULTS
-999987594
-999877091
-999766588
-999656085
-999545582
-999435079
-999382929
-999324576
-999272426
-999161923
---- TYPES
DECIMAL
====
---- QUERY
select d from decimal_padded_fixed_len_byte_array2
order by d desc
limit 10
---- RESULTS
999889497
999778994
999668491
999557988
999447485
999336982
999226479
996463904
996353401
996242898
---- TYPES
DECIMAL
====