Q&A BY TAG 'Function'

You must sign in to ask a question. If you do not have an account, you can register here

how can I call a custom function created in Oracle DB from denodo
answered 31-12-2019 15:57:53 -0500

Hi , i have created a Pl/SQL function in underlying oracle database which set the context based on passed input user parameter. i want to call this function from denodo VQL. i imported this function in denodo by creating base view on it and then trie...

Answers: 1

Function Custom Functions

Format_date is not working for me to display 'yyyymm' patern
answered 26-07-2019 02:08:46 -0400

Hi Team, As per the customer requirement, I have to display only 'yyyymm' of a date field and I gave the expression as below in denodo: formatdate('yyyymm', dim_day.day_dt) But it gaves only the year, month displays as 00. For eg: 201800, 201900. I...

Answers: 2

Date Conversion Function TO_DATE function

Filtering by max date
answered 25-07-2019 06:20:21 -0400

I am trying to filter a transformation by only pulling in the rows that have the latest effective date. I've tried using the max function, but have been unable to get the results I'm looking for. Running on version 6.0.

Answers: 1

Function

Date Temporary Table
answered 14-06-2019 12:16:20 -0400

Hello All, I am trying to create a temporary table with two years worth of dates. Is this possible in VQL? I looked through the documentation and it doesn't look like we can call any looping functions. Similar procedure in MS SQL: https://stackoverf...

Answers: 1

Function Temp Tables

Case function in Denodo
answered 31-05-2019 07:54:56 -0400

Hi Team, I have a requirement to implement a scenaion similar to the below in Denodo. But I am not sure, how to go about it using denodo case function. It is throwing me some error. Can you please help? IF [varI] =0 then 'Perm' ELSEIF([varI] >0 and ...

Answers: 1
Related to: Oracle SQL to Denodo VQL Quick Reference

Function case function denodo functions CASE

Query not getting delegated to hive
answered 28-05-2019 20:20:33 -0400

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...

Answers: 1

Function Query Delegate

I want to substract numeric column from a date column and i'm using addday() fucntion
answered 12-11-2018 07:41:59 -0500

Hi, I want to substract numeric column from a date column and i'm using addday() fucntion as below- addday(xxbi_oe_order_lines_all_v.promise_date, mult (xxbi_oe_order_lines_all_v.delivery_lead_time,-1)) where 'xxbi_oe_order_lines_all_v.promise_date' ...

Answers: 1

Function

Interpolation of function and variable.
answered 26-09-2018 08:27:23 -0400

I have a connection to an Oracle database. In the connection we set up several Driver Properties including the user name which the database uses to pull only the rows the user executing the query has access to (row security). That property is set up l...

Answers: 1

Function Interpolation Variables oracle

Functions Mapping error
answered 24-11-2017 08:05:23 -0500

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 ...

Answers: 2

Extra Functions Function

Denodo functions that are not delegated to source
answered 09-08-2017 09:09:45 -0400

Hi team! Is there a list of those functions/queries/process that are not pushed down to the source? I mean like sub selects, truncates, casts, etc. We need a detailed list of that stuff in order to optimize our views. Thanks in advance! EDIT: The s...

Answers: 1

Function Delegate