We have a report view that is run monthly and is critical from the end user perspective. This view is cached on a regular schedule.
When we run the view in vdp and it does not have any functions like current date() or get quarter(), I see that the query directly goes to hive in explain plan and it works fine.
But when we introduce any date related function in the vql of the view and run it, it changes the execution plan and takes more time. The code tables used have alternate wrappers defined which goes to hive but with the function in the vql it starts to go to db2 for some part and then hive.
Is there a fix for this, I can create the support ticket if needed.