Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Numbers display in Hive CLI


Copy link to this message
-
Re: Numbers display in Hive CLI
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 <[EMAIL PROTECTED]> 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
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB