Q&A

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

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Base View from query
answered 31-01-2019 05:42:13 -0500

Hi Team, Denodo 5.5 How to create a Base View from Query on stored procedure 'element_metadata()' Please tell. I also intend to use interpolation variables. Thanks.

Answers: 2

Query Stored Procedure

the issue with one data source
answered 31-01-2019 02:46:27 -0500

I have 10 differnt tables in various schemas on same datasource but these tables are isolated how i am suppose to get 10 columns from 10 tables in one output .

Answers: 1

support VSAM files on an ZOS in IAM format
answered 30-01-2019 01:25:53 -0500

Hi do you support VSAM files on an ZOS in IAM format? Thanks

Answers: 1

IDs from java.util.TimeZone.getAvailableIDs
answered 28-01-2019 11:50:14 -0500

Can someone post the available IDs from java.util.TimeZone.getAvailableIDs?

Answers: 1
Related to: Localization of RESTful web services

timezone

VQL support for CROSS APPLY
answered 25-01-2019 06:42:55 -0500

I've looked for mention of VQL support for the cross apply join type, didn't find any. This is a powerful function for handling many query cases where it would be very challenging or impossible to do without it. Is it supported in VQL? If not, is it on...

Answers: 1
Related to: Best Practices for Migrating SQL queries to Denodo VQL

Integrating JUnit with Denodo Testing Tool
answered 25-01-2019 06:28:45 -0500

Hi Team, While i am trying to integrate Denodo Testing Tool with JUnit, i could not find TestRunner class at path "com.denodo.connect.testing.TestRunner" It would really great if you can elaborate as to how we can integrate Denodo Testing Tool with J...

Answers: 1

DenodoTestingTool

NEST() aggregation function ERROR when (Snowflake) source configuration has "Delegate aggregate functions list" checkbox is "unchecked"
answered 24-01-2019 14:33:34 -0500

Dear Denodo Support Team, I am encountering below error while delegating the aggregate functions setting is unchecked. Error: Finished with error: Error executing query. Total time 0.117 seconds. QUERY [VIRTUAL] [ERROR] QUERY [JDBC WRAPPER] ...

Answers: 1

Denodo 6.0 Delegate nesting delegation data aggregation

Connect to data source
answered 24-01-2019 13:00:05 -0500

Hi, i would like to connect denodo to my local sql server 2014. I tried to set up for new data source but it fail to connect. Please help.

Answers: 1

database Data Source

BulkLoad Issue on CacheDB
answered 24-01-2019 08:05:57 -0500

Hi Team I have environment where we are having 300millions records it took us 10hrs to load on the cache DB(3years data) with proper query, I want to schedule another job with 1 day older records to be cached which i am expeting only updated records,...

Answers: 1

Incremental mode last_modified_date > '@LASTCACHEREFRESH'
answered 24-01-2019 06:39:31 -0500

What is the date format of the variable LASTCACHEREFRESH My data has a column last_updated with a data type as "text" and value like "2019-01-22 11:00" but using the condition last_updated > @LASTCACHEREFRESH and the cache does not get loaded. I ha...

Answers: 1

LASTCACHEREFRESH