question Re: in hive casting of decimal to double is returning the exponential form rather than the non scientific form in Support Questions

question Re: in hive casting of decimal to double is returning the exponential form rather than the non scientific form in Support Questions https://community.cloudera.com/t5/Support-Questions/in-hive-casting-of-decimal-to-double-is-returning-the/m-p/209234#M171190 Hi Team, You can cast as decimal and solve the issue as shown below. ROUND(CAST(1.750646377E7 AS DECIMAL(38,10)),2); Thanks & regards, Kamleshkumar Gujarathi Fri, 09 Feb 2018 05:03:57 GMT Big 2018-02-09T05:03:57Z