Hive SQL automatically round off

Viewed 18

I am doing a multiplicate 3 columns and it seems like automatically rounding of 6 decimal places. The type of my column is decimal(38, 10). [enter image description here][1] [1]: https://i.stack.imgur.com/h5DLW.png

How can i show full 10 decimal places as result? Please help me, thank you very much.

0 Answers
Related