question Re: hive unix_timestamp() returns allways one in Archives of Support Questions (Read Only)

hive unix_timestamp() returns allways one

AlinaGHERMAN — Fri, 16 Sep 2022 09:19:47 GMT

Hello,

I need to compare a date with today date so I want to use the function unix_timestamp().

However this function returns one (1970-01-01 00:00:01).

Note:

- The servers date is correctly setted up.

- I use an AWS infrastructure

What else should I check in order to make this function work?

thank you!

UkrZilla — Wed, 21 Jan 2015 10:02:29 GMT

Hi, Alina

You should use the following:

select unix_timestamp(now())

Thanks

AlinaGHERMAN — Wed, 21 Jan 2015 10:18:16 GMT

With the given sintax I get:

error while compiling statement: failed: semanticexception [error 10011]: line 1:22 invalid function 'now'

My query:

select unix_timestamp(now()) from test_kpi_data;

Thank you!

UkrZilla — Wed, 21 Jan 2015 10:26:44 GMT

I guess you mean Impala.

Impala:

select unix_timestamp()

result: 1

Hive:

select unix_timestamp()

result: 1421835925