Hive query manipulation for non-business days (weekends & holidays) : I've a query regarding some tweaking my Hive query in the requirement defined below; couldn't get my head around on this.

Case: The data gets generated only on business days i.e., weekdays & non-holidays dates. This data I load in Hive. The source & target, both are HDFS.

Stringent process: The data should be replicated for every day. So, for Saturday & Sunday, I'll copy the same data of Friday. Same is the case for public holidays. 

Current process: As of now I'm executing it manually to load weekends' data.

Requirement: I need to automate this in the query itself.

Any suggestions?

