hive unix_timestamp() returns allways one

[#1]

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!

[#2]

Hi, Alina

You should use the following:

select unix_timestamp(now())

Thanks

[#3]

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!

[#4 · Accepted solution]

I guess you mean Impala.

Impala:

select unix_timestamp()

result: 1

Hive:

select unix_timestamp()

result: 1421835925