well... a good 'ol search (let's not use the word google) of "hive udf" we find this:
https://cwiki.apache.org/Hive/languagemanual-udf.html#LanguageManualUDF-StringFunctionsand there's a reference to a function called format_number(). or did you really want the *hive CLI* to format the number? if that's the case then no there is no option for that in the hive client. On Mon, Aug 12, 2013 at 11:30 PM, pandees waran <pande...@gmail.com> wrote: > HI, > > I see the SUM(double_column) displays the result in scientific notation in > the hive cli. Is there any way to customize the number display in hive CLI? > > -- > Thanks, > Pandeeswaran > Hi, > I am seeing the double values are displayed as scientifi not >