Latest Activity

code

Column not found

Hello, I am extracting data from other view and using statement like below select field1 as column1 , field2, field3 from viewEx; but I am getting error column1 not found can you please help

code

How do you modify the sql sentence?

I see no option to edit the sql query once it is created. Must you recreate the view to add/remove/edit columns?

Related to: Using the Create Base View From Query Option

code

Teradata equivalent functions

Hi, I have teradata queries as NVL (<fieldname>, 0) Decode (<fieldname>) what is theequivalent functions in denodo for NVL and DECODE?

code

trying to configuring denodo monitoring in my machine

Hi Team, I am trying to configuring denodo monitor in my machine by using given link. https://community.denodo.com/docs/html/browse/7.0/vdp/administration/monitoring_the_virtual_dataport_server/denodo_monitor/configuring_the_denodo_monitor While exec...

code

setting java home

Hi Team, When I was installing Denodo 8 Express on my windows system I found that JAVA HOME must be set to install it. So, I set my JAVA HOME to be: C:\Program Files\Java\jdk-21\bin Than, Denodo 8 Express installed and I was able to use it. Next, I c...

code

VQL stored procedure

Hi Denodo, can you please give me an example of how you execute a dynamic query in a vql stroed procedure. We are automating our grants and need to execute grant statement dynamically depending upon the grants in the source database. thank you.

code

Return Data for the past months

Hi I'd like to query the teradata query in denodo VQL, however I cant able to get the syntax right. SELECT ADDMONTH(ADDMONTH(CURRENT_DATE, -12), (EXTRACT(MONTH FROM ADDDAY(<field_name> , -12 ) -6 ))) Any pointers would be appreciated. Thank you.

code

Unable to Create "Denodo Training" database when Following Tutorial

Hello, I followed the Connecting and Combining Tutorial (DEN80EDU00VID02). But after I import the VQL files, the denodo training database does not appear in the virtual dataport administration Tool. Is there anyway, I can work around this or resolve this?

code

Denodo Scheduler Cache update jobs are failing due to [GROUPBY] [ERROR]

Below is the error message logged in the VDP. Is this due to lack of swap space?? what does Too many open files mean??? 14913679 [Access(1369)-22-05.00-ent_davita.dv_spr_rsltsorgnsmantbtc_log_cwow_cache] ERROR 2018-06-28T20:32:02.634 com.denodo.vdb.en...

code

Denodo equivalent in Teradata Addmonth(DATE)

Hi I have a teradata query where i have select joining_date from table_name where joining_date between case when (joining_date,0) > 6 then addmonth(trunc(addmonth(DATE,0),'yyyy') here in the above query DATE is not a name of column name from tab...