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)
No comments:
Post a Comment