We are working with HQL and facing problems in getting numbers in a certain format.We want to accomplish the following:
input: 0.000000098812output: 9.88E-8
We don't want any digits after the first three significant digits.Can someone please help us out?
You can use Regexp_extract and extract only the required digits.
refer to this link for more details regards to regexp_extract in hive.
Let us know if you have any issues..!!