Latest Activity

code

Using a select statment when implementing a interface

Hi everyone. I need to create an interface with dynamic values on the interface definition. I will give an example to show what I mean: Normally an interface is created this way: CREATE OR REPLACE INTERFACE VIEW i_inventory_50 ( productpartnumber_0:...

code

VQL stored procedure-error cursor

Hi, I am trying to create this stored procedure: ( nomeview IN VARCHAR) AS ( // Procedure variables v_name VARCHAR; database_name VARCHAR; Interface_name VARCHAR; CURSOR interfaces IS 'SELECT view_name FROM VIEW_DEPENDENCIES() WHERE view_database_name...

code

Error "no such object in table" in denodo scheduler

Hi We are getting below error for all cache jobs which was running without any errors in scheduler. select * from view_name CONTEXT('cache_preload'='true', 'cache_wait_for_load'='true', 'cache_return_query_results'='false', 'cache_invalidate'='all_row...

code

Amazon Athena Adapter is not present in Database Adapter dropdown for creating a datasource

Hi I am trying to create a datasource for connecting with Athena from denodo.All the required jar files are present in denodo server.But unfortunately, am not able to see athena adapter in dropdown.All of my teammates are able to see this adapter. Ho...

code

VQL stored procedure/role changes

Hello Denodo, I'm having trouble creating a VQL stored procedure for user and role changes. Is it possible to do this, and if so, how can I achieve it? Thank you.

code

How to use double as datatype

Hi, I'm currently working on a Impala query where I want to calculate the sum of a field in a table, and I need to cast it as a double. However, I'm encountering an error, and I could use some assistance. SELECT SUM(CAST(fieldname AS double)) FROM ta...

code

Configuration of Kerberos for the Scheduler

Configuration of Kerberos for the Scheduler is missing in the current document

Related to: Kerberos configuration and troubleshooting

code

Restart service

There is a os patching in server. Which services and in which order services need to stop. how to know that services are stopped.

code

View Schema from Restful api - unexpected response

I have created a derived view and want to get the view schema through the VDP Restful API. However, I believe that the response does not show the expected field types. Below is an example of some fields types in Denodo design studio and the correspondi...

code

Finished with error: java.lang.OutOfMemoryError: GC overhead limit exceeded

Hi We have cached a view fetching more than 4million data.We are getting the below error when we are retrieving all rows in the view. Finished with error: java.lang.OutOfMemoryError: GC overhead limit exceeded Why it is throwing the above error eve...