| ==== |
| ---- 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 |
| ==== |