I suppose your query is against HIVE, you can take advantage of round() built-in UDF function.
--Bala G. On Tue, Aug 26, 2014 at 11:24 AM, upd r <updbigd...@gmail.com> wrote: > Hi, > > Can someone please tell me if there is a way to alter the precision digits > for a double/float data type to 2 or 3. > Eg: 232879.7979879 to 232879.79 > > Thanks, > UPD >