https://community.cloudera.com/t5/Archives-of-Support-Questions/Business-Days-in-Hive/m-p/154289#M20634 <P><A rel="user" href="https://community.cloudera.com/users/1473/colorsoflife.html" nodeid="1473">@Mamta Chawla</A></P><P>you need to come up with your own logic based on <A href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions" target="_blank">https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions</A></P><P>look at datediff function and then just figure out whether it's a business day, you can also write your own UDF. <A href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-CreatingCustomUDFs" target="_blank">https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-CreatingCustomUDFs</A></P> Wed, 24 Feb 2016 00:32:07 GMT aervits 2016-02-24T00:32:07Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Business-Days-in-Hive/m-p/154288#M20633 <P>Hi,</P><P>I want to calculate no. of business days between two dates using hive queries. How can I do it??</P><P>Thanks</P><P>Mamta</P> Wed, 24 Feb 2016 00:28:40 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Business-Days-in-Hive/m-p/154288#M20633 colorsoflife 2016-02-24T00:28:40Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Business-Days-in-Hive/m-p/154289#M20634 <P><A rel="user" href="https://community.cloudera.com/users/1473/colorsoflife.html" nodeid="1473">@Mamta Chawla</A></P><P>you need to come up with your own logic based on <A href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions" target="_blank">https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions</A></P><P>look at datediff function and then just figure out whether it's a business day, you can also write your own UDF. <A href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-CreatingCustomUDFs" target="_blank">https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-CreatingCustomUDFs</A></P> Wed, 24 Feb 2016 00:32:07 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Business-Days-in-Hive/m-p/154289#M20634 aervits 2016-02-24T00:32:07Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Business-Days-in-Hive/m-p/154290#M20635 <P><A rel="user" href="https://community.cloudera.com/users/1473/colorsoflife.html" nodeid="1473">@Mamta Chawla</A></P><P>See this <A href="https://www.pythian.com/blog/calculating-business-days-in-hiveql/" target="_blank">https://www.pythian.com/blog/calculating-business-days-in-hiveql/</A></P> Wed, 24 Feb 2016 00:50:46 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Business-Days-in-Hive/m-p/154290#M20635 nsabharwal 2016-02-24T00:50:46Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Business-Days-in-Hive/m-p/154291#M20636 <P>More information <A href="https://github.com/pythian/hive-udfs">https://github.com/pythian/hive-udfs</A></P> Wed, 24 Feb 2016 00:51:36 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Business-Days-in-Hive/m-p/154291#M20636 nsabharwal 2016-02-24T00:51:36Z