You can translate the question and the replies:

Query not getting delegated to hive

Hi, 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.
user
23-05-2019 14:48:01 -0400

1 Answer

Hi, For a list of the scalar functions currently delegated to Hive, you can take a look at the “Delegate scalar function list” in the Source Configuration tab of the data source. Current date() or get quarter() are not currently in the list. The recommended solution to maintain query delegation is to use an alternative syntax using delegated functions that are in the list. You could also write a custom function which implements the delegation. For more information on how to do this, take a look at https://community.denodo.com/docs/html/browse/7.0/vdp/developer/developing_extensions/developing_custom_functions/creating_custom_functions_with_annotations#developing-custom-functions-that-can-be-delegated-to-a-database If you have a denodo support user and you would like the delegation to be considered as an evolution in a future release, you can also open a support case in the Denodo Support Site (http://support.denodo.com) with an enhancement request so that it can be evaluated by the Denodo team. Hope this helps!
Denodo Team
28-05-2019 20:20:33 -0400
You must sign in to add an answer. If you do not have an account, you can register here