Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Business Days in Hive

Solved Go to solution
Highlighted

Business Days in Hive

Hi,

I want to calculate no. of business days between two dates using hive queries. How can I do it??

Thanks

Mamta

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Business Days in Hive

3 REPLIES 3
Highlighted

Re: Business Days in Hive

Mentor

@Mamta Chawla

you need to come up with your own logic based on https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions

look at datediff function and then just figure out whether it's a business day, you can also write your own UDF. https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-CreatingCustom...

Highlighted

Re: Business Days in Hive

Highlighted

Re: Business Days in Hive

Don't have an account?
Coming from Hortonworks? Activate your account here