Latest Activity

code

Incremental Refresh of Summary View

I have a senario where I want to refresh the content of Summary view incrementally. How best I can achieve this by using Denodo Scheduler or other means? In the arcticle, it is mentioned that for CACHE, you have this variable which tracks out when was ...

code

Scheduler report

Hi, How to get the scheduler report details in VDP. Have configured jdbc datasource but still unable to find the exact history

code

Assign property groups to view with vql

How assign property group to views or interfaces with vql.

Related to: How To Use Property Groups in the Data Catalog

code

Delegate geospatial function

Hi Experts, How can I delegate the ST_INTERSECTS geospatial function to my snowflake datasource? In the Source configuration, I see analytic, scalar and other types of functions. How do I delegate a geospatial fumction to Snowflake? Thanks much in ad...

code

Facing error 'Multiple DISTINCT aggregates are not supported at this time.'

While executing the below query i am facing the error 'Multiple DISTINCT aggregates are not supported at this time.' query : SELECT COUNT(DISTINCT (((EXTRACT(YEAR FROM C1))))) COL_1, COUNT(DISTINCT (((EXTRACT(YEAR FROM C2))))) COL_2 FROM TableName

code

Scheduler: Authentication error: The username or password is incorrect

Please assist. When I try to execute a job via schedule the below error appears. I have checked the admin user name password is correct. Caused by: com.denodo.vdb.vdbinterface.common.connection.VDBConnectionException: authentication error: The userna...

code

Denodo 8.0 VQL Stored procedures

Hi , I have created a VQL stored procedure in Denodo 8.0 to insert data into a table via simple loop but my last record is getting inserted twice.I tried below command which works in PL/SQL but it is not working and giving error - Exception parsing qu...

code

SELECT with ALL fields from a ODATA2 view fails. SELECT with HALF of all of the fields will ran fine.

A VQL SELECT with the +/- 50 fields of the odata2 api fails. If we slipt the fields in half and created two vql select statements, they both ran fine. The following is the error we get which provides no valuable information. Finished with error: Erro...

code

JDBC data source for MS Access

Since the ODBC data source is being deprecated, how would I connect to an Access database using JDBC?

code

Limit concurrent queries

Hi Team When multiple queries are hitting denodo from a user, our server wll become inaccessible.I have created a restriction for that specific account when concurrent queries reaches 10. From 11th query onwards,it will be in queued state.But still, o...