How to select current date in Hive SQL

Question

How do we get the current system date in Hive  In MySQL we have select now    can any one please help me to get the query results  I am very new to Hive  is there a proper documentation for Hive that gives the details information about the pseudo columns  and built-in functions

User · Answer

To fetch only current date excluding time stamp:

in lower versions, looks like hive CURRENT_DATE is not available, hence you can use (it worked for me on Hive 0.14)

select TO_DATE(FROM_UNIXTIME(UNIX_TIMESTAMP()));

In higher versions say hive 2.0, you can use :

select CURRENT_DATE;

User · Answer

Yes    I am using Hue 3 7 0 - The Hadoop UI and to get current date time information we can use below commands in Hive   SELECT from unixtime unix timestamp     -- Selecting Current Time stamp   SELECT CURRENT DATE  -- Selecting Current Date   SELECT CURRENT TIMESTAMP  -- Selecting Current Time stamp    However  in Impala you will find that only below command is working to get date time details   SELECT from unixtime unix timestamp     -- Selecting Current Timestamp     Hope it resolves your query

User · Answer

The functions current date and current timestamp are now available in Hive 1 2 0 and higher  which makes the code a lot cleaner

User · Answer

select from unixtime unix timestamp current date   yyyyMMdd    yyyy-MM-dd      current date - current date    yyyyMMdd - my systems current date format   yyyy-MM-dd - if you wish to change the format to a diff one

User · Answer

To extract the year from current date   SELECT YEAR CURRENT DATE      IBM Netezza   extract year from now      HIVE   SELECT YEAR CURRENT DATE

User · Answer

According to the LanguageManual  you can use unix timestamp   to get the  current time stamp using the default time zone   If you need to convert that to something more human-readable  you can use from unixtime unix timestamp      Hope that helps

[hive] How to select current date in Hive SQL

Examples related to hive

Examples related to hiveql