HPL/SQL is included to Apache Hive since version 2.0
NOW function returns the current date and time (year, month, day, hour, minute, seconds and fractional seconds).
Get the current and date and time:
NOW() -- 2015-11-02 07:59:25.833
Compatibility: PostgreSQL and MySQL.
Version: HPL/SQL 0.3.17