Business Days in Hive

[#1]

Hi,

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

Thanks

Mamta

[#2]

@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...

[#3 · Accepted solution]

@Mamta Chawla

See this https://www.pythian.com/blog/calculating-business-days-in-hiveql/

[#4]

More information https://github.com/pythian/hive-udfs