his email is virus
> free, therefore neither Peridale Technology Ltd, its subsidiaries nor their
> employees accept any responsibility.
>
>
>
> *From:* matshyeq [mailto:matsh...@gmail.com]
> *Sent:* 15 January 2016 10:31
> *To:* user
> *Subject:* Re: Converting date format a
sh...@gmail.com]
Sent: 15 January 2016 10:31
To: user
Subject: Re: Converting date format and excel money format in Hive table
try:
select cast(unix_timestamp('02/10/2014', 'dd/MM/')*1000 as timestamp);
Kind Regards
~Maciek
On 15 January 2016 at 10:15, Mich Taleb
try:
select cast(unix_timestamp('02/10/2014', 'dd/MM/')*1000 as timestamp);
Kind Regards
~Maciek
On 15 January 2016 at 10:15, Mich Talebzadeh wrote:
> Hi,
>
>
>
>
>
> I am importing an excel sheet saved as csv file comma separated and
> compressed with bzip2 into Hive as external table with b
Hi,
I am importing an excel sheet saved as csv file comma separated and compressed
with bzip2 into Hive as external table with bzip2
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
