You can translate the question and the replies:

Function LASTDAYOFMONTH not delegated to Teradata

Hallo Denodo Team, Investigating the reasons why a query is not delegated to the Teradata data source, we have read this explanation: The function 'lastdayofmonth' cannot be delegated to this database Teradata has a corresponding function, namely LAST_DAY Why, in your opinion, the delegation does not happen? Is there a way to circumvent this (and similar) behaviour? Thank you kindly Alberto lastdayofmonth = addmonth(addday(current_date(), -1*extract(day from current_date())),1)
delegation delegate lastdayofmonth teradata
user
17-01-2019 05:46:21 -0500
code

2 Answers

I confirm that rewriting the function ( lastdayofmonth ) in terms of "supported (mapped) functions", the delegation does occur
user
21-01-2019 08:54:31 -0500
Hi, For a list of the scalar functions currently delegated to Teradata, you can take a look at the "Delegate scalar function list" in the Source Configuration tab of the data source. LAST_DAY is 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 (as you have done in your answer). 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 user with support access 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
22-01-2019 06:26:53 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here