Current Date in Hive

Question

Hi,

Please, can you clarify how to display the current date in Hive?
I tried current_date() and get the following error.

FAILED: SemanticException [Error 10011]: Line 1:36 Invalid function "current_date"

Answer 1

Try this instead:

select from_unixtime(unix_timestamp());

If you have an older version, current_date() won't work.