Tuesday, 16 August 2022

Hive: get extended help about a function usage

Syntax

DESCRIBE FUNCTION EXTENDED {function_name};

Example

DESCRIBE FUNCTION EXTENDED year;

Above statement print the usage of year function.

hive> DESCRIBE FUNCTION EXTENDED year;
OK
year(date) - Returns the year of date
date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'.
Example:
   > SELECT year('2009-07-30') FROM src LIMIT 1;
  2009
Time taken: 0.011 seconds, Fetched: 5 row(s)

 

Previous                                                    Next                                                    Home

No comments:

Post a Comment