We always assume that the strength of Hive comes from its ability to use a
very close ensemble to ANSI SQL enabling queries to be done with a smooth
learning curve,
Additionally we like to assume that Hive strength is about Schema on Read.
However, after having some discussion on it, we still n
Thanks very helpful.
Regards,
Dr Mich Talebzadeh
LinkedIn
https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
Sybase ASE 15 Gold Medal Award 2008
A Winning Strategy: Running the most Critical Financial Data on ASE 15
http://login.sybase.com/files/Pro
Try:
REGEXP_REPLACE(net,'[^\\d\\.]','');
Thank you,
Kind Regards
~Maciek
On 15 January 2016 at 17:33, Mich Talebzadeh wrote:
> OK this is a convoluted way of doing it using SUBSTR and REGEXP_REPLACE
> UDF to get rid of ‘?’ and commas in the curremcy imported from CSV file
>
>
>
>
>
>
>
> 0: jdb
I think 'translate' might be useful in this scenario
example:
select translate(t2.net,'?','$') from t2;
On Fri, Jan 15, 2016 at 5:05 AM, Mich Talebzadeh
wrote:
> Thanks that solved data conversion.
>
>
>
> How does one replace ?10,000.00 with £10,000.00 ?
>
>
>
> Dr Mich Talebzadeh
>
>
>
> Lin
See this:
http://stackoverflow.com/questions/23082763/need-to-add-auto-increment-column-in-a-table-using-hive
On Sat, Jan 16, 2016 at 11:52 AM, Ashok Kumar wrote:
> Hi,
>
> Is there an equivalent to Microsoft IDENTITY column in Hive please.
>
> Thanks and regards
>
--
Want to work at Handy? C
Hi,
Is there an equivalent to Microsoft IDENTITY column in Hive please.
Thanks and regards
