employees
accept any responsibility.
From: Mich Talebzadeh [mailto:m...@peridale.co.uk <mailto:m...@peridale.co.uk>
]
Sent: 15 January 2016 16:08
To: user@hive.apache.org <mailto:user@hive.apache.org>
Subject: RE: Importing currency figures with currency indicator to Hive from CSV
n or endorsed by Peridale Technology
> Ltd, its subsidiaries or their employees, unless expressly so stated. It is
> the responsibility of the recipient to ensure that this email is virus
> free, therefore neither Peridale Technology Ltd, its subsidiaries nor their
> employees accept
.co.uk]
Sent: 15 January 2016 16:08
To: user@hive.apache.org
Subject: RE: Importing currency figures with currency indicator to Hive from CSV
Hi,
What is the equivalent of Oracle TO_NUMBER function in Hive please?
Thanks
Dr Mich Talebzadeh
LinkedIn
<https://www.linkedin.com/
o ensure that this email is virus free,
therefore neither Peridale Technology Ltd, its subsidiaries nor their employees
accept any responsibility.
From: Mich Talebzadeh [mailto:m...@peridale.co.uk]
Sent: 15 January 2016 15:11
To: user@hive.apache.org
Subject: Importing currency figures with curr
Hi,
How to do convert a column stored as String in Hive into Decimal if possible.
The excel looks like this
Invoice Number
Payment date
Net
VAT
Total
360
10/02/2014
£10,000.00
£2000.00
£12,000.00
And the file (before bzip2) looks like this on imported directory in Linu
