Sunday 27 November 2022

Hive: weekofyear: Return week number of the date

Signature

weekofyear(string date)
hive> SELECT weekofyear('2021-01-05');
OK
_c0
1
Time taken: 0.04 seconds, Fetched: 1 row(s)
hive> SELECT weekofyear('2021-01-12');
OK
_c0
2
Time taken: 0.045 seconds, Fetched: 1 row(s)

 

Previous                                                    Next                                                    Home

No comments:

Post a Comment