You can translate the question and the replies:

Functions Mapping error

Hey guys, I'm facing again an: [ERROR] Received exception with message 'Unable to find mapping for function 'addmonth'' I know there are function that my db (Hive) doesn't have so we cannot use them from denodo unless we apply them in denodo server instead of pushing them down. But in this case, I know there is an "add_months" function on Hive. Can I specify the mapping to that function somewhere so I can use the addmonth and push it down to hive? Thanks in advance guys! Best, Fabian
user
23-11-2017 13:32:36 -0500

2 Answers

Hi, I tried to execute a view of Hive data source that contains 'addmonth' function and it works fine. I ensured that the "addmonth" function is available in "Delegate scalar functions list" in "Source Configuration" section of Hive data source. When it is delegated to the source, the wrapper automatically converts the function "addmonth" to the "add_months" function that is supported by Hive database. You can have a look at [Data Source Configuration Properties](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/data_source_configuration_properties#data-source-configuration-properties) section in Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
24-11-2017 07:54:54 -0500
Hi again team, I have this list in the "Delegate Scalar Functions" text box (and also have the checkbox checked): abs, acos, addday, addhour, addminute, addmonth, addsecond, addweek, addyear, ascii, asin, atan, case, cast, ceil, coalesce, concat, cos, cot, current_date, degrees, div, exp, firstdayofmonth, firstdayofweek, floor, getday, getdayofweek, getdayofyear, getdaysbetween, gethour, getmillisecond, getminute, getmonth, getsecond, gettimeinmillis, getweek, getyear, instr, lastdayofmonth, lastdayofweek, len, ln, log, lower, ltrim, max, min, mod, mult, nextweekday, now, nullif, position, pow, power, previousweekday, radians, rand, regexp, removeaccents, repeat, replace, round, rtrim, sign, sin, sqrt, substr, substring, subtract, sum, tan, textcat, textconstant, trim, upper I don't know so why I'm getting that function not being delegated.... That's wierd... Is there any other thing I may check that can be preventing me to delegate the function? Thanks again!
user
24-11-2017 08:05:23 -0500
You must sign in to add an answer. If you do not have an account, you can register here