Re: Numbers display in Hive CLI

2013-08-13 Thread pandees waran
Sure , let me explore hive beeline client  — Sent from Mailbox for iPad On Tue, Aug 13, 2013 at 11:24 PM, Stephen Sprague wrote: > Yeah. I would think i'd be a useful feature to have in the client - but > probably not the Hive CLI client. The Hive client seems pretty bare bones > and my guess it

Re: Numbers display in Hive CLI

2013-08-13 Thread Stephen Sprague
Yeah. I would think i'd be a useful feature to have in the client - but probably not the Hive CLI client. The Hive client seems pretty bare bones and my guess it'll probably stay that way. The Beeline client, however, looks to be where these kinds of bells and whistles probably could/should be ad

Re: Numbers display in Hive CLI

2013-08-13 Thread pandees waran
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

Re: Numbers display in Hive CLI

2013-08-13 Thread Stephen Sprague
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

Numbers display in Hive CLI

2013-08-12 Thread pandees waran
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