Latest Activity

code

combine data from multiple sources with overlapping elements

Hello everyone, I'm currently working on a project where I need to combine data from multiple sources with overlapping elements. My goal is to create a common list by cross-referencing these data sources. I plan to use Denodo for this project. Howev...

code

Query failing due to resource limit reached or DB2 error

Howdy, We have a user who is performing a query sleection on a virtualized view. The customer has tried two different approaches to complete the query. One, with DATA MOVEMENT ENABLED. And another with DATA MOVEMENT DISABLED. enabled with DATA_MOVEM...

code

Replaceing a view while copying previous work

Hi when you need to change a View from one type to another, for example Selection to Join View, you are forced to create a new View that replace the old one. At the same time you whant to copy all work that is done in the Output section of the first Vi...

code

getting error when running query in hive

getting error when running query in hive : Finished with error: Error executing query. Total time 47.467 seconds. DV_PROFILE_END_RSLT_TBL_AGGREGATE [VIRTUAL] [ERROR] DV_PROFILE_END_RSLT_TBL_AGGREGATE [JDBC WRAPPER] [ERROR] DV_PROFILE_END_RSLT_TBL_AGG...

code

Unable to identify resources.log file header

I connected CloudWatch to resources.log file but unable to see header and identify columns. What are they supposed to be in order? Log file location: denodo-monitor/logs/<Denodo server name>-resources.log

log
code

POST REST Query Using Data from Derived View

I have an query that is a POST that has several variables in the POST Body. I would like to get data from another Derived View and use the values from it to loop through the records and perform as many calls to the REST endpoint as there are records re...

code

Denodo Express - Denodo Web Studio not opening

Hello, I installed Denodo Express on my Mac by following the instructions on https://community.denodo.com/tutorials/browse/basics/1install_index. From the Denodo platform control center, I managed to start the Virtual DataPort Server, but when I try...

code

desc datasource meta info

Hello , I am trying to get the metadata information using desc datasource command. While I am running desc datasource jdbc "source_name" in VQL Shell, we could see the full output. Whereas if we are creating view using the same command and using the...

code

How Can I implement SSO in Power BI or Tableau to connect to Denodo?

We want our users to connect to Denodo in applications like PowerBI, Tableau, Qlik, DBeaver using SSO so that they don't need to provide their credentials everytime while connecting to the views in Denodo. Any suggestions or inputs on how to implement...

code

rownum to reset the generated sequence after a certain number

We need to generate a sequence and then reset the counter after 100. We are able to use rownum function to generate the sequence but it doesn't reset after a certain number. How can we achieve this?