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
