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
Thanks Stephen! I shall check this . My requirement is controlling the formatting in session level using some properties set. Looks like, there's no such as of now . Would this be a good feature in hive cli?
If many people think so, then I can file a feature request.

Sent from Mailbox for iPad

On Tue, Aug 13, 2013 at 8:11 PM, Stephen Sprague <[EMAIL PROTECTED]>
wrote:

> 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