How can I display decimal value based on precision and scale in hive? for example,
I have a input value 1234 and want to display it as 12.34 if my input precision and scale is (4,2) I tried this using cast but it didn’t work ,it is giving null , see below.
hive (default)> select cast(‘1234’ as decimal(4,2));
Time taken: 2.673 seconds, Fetched: 1 row(s)