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 April 2018.

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

datediff year
answered 31-05-2017 08:46:39 -0400

What is the translation of datediff(Year,date1,date2)?

Answers: 1
Related to: Microsoft SQL Server SQL to Denodo VQL Quick Reference

Creating a Denodo derived view with correlated subquery
answered 31-05-2017 07:34:02 -0400

We are using Denodo 6.0 and trying to create a Denodo derived view which has a corrleated subquery. SELECT T1.TRNS_ID, T2.BLD_TS FROM bv_CMSN_TRNS T1 INNER JOIN bv_CMSN_STAT T2 ON T1.EDI_TRNS_ID = T2.EDI_TRNS_ID WHERE T2.BLD_TS = (SELECT MAX(BLD_TS) F...

Answers: 1

trace-on to debug
answered 29-05-2017 08:47:57 -0400

We rarely face below issue and Its kind of Internal Server Error. ‘Error retrieving data from ‘Path’. HTTP error code: 500.’ I want to debug this issue and find the cause of this . Why request-response does not work sometimes. Please help me to resol...

Answers: 1

Debug

Use Denodo to write back to tables of the data source (i.e a RDBMS database like Oracle, SQL Server)
answered 29-05-2017 08:27:24 -0400

How do I use Denodo to write back to tables of the data source (i.e a RDBMS database like Oracle, SQL Server). Is the option set on the data source or the base view of the data source? And how is it done?

Answers: 1

update JDBC Data-Source

Express password help or reset
answered 29-05-2017 07:37:46 -0400

Just intalled and trying to use Express, but it doesn't like my portal login. And there isn't a "forgot password" link. Any ideas on how to get it reset? Thanks, Bob

Answers: 1

Denodo Java 8 JDBC-ODBC bridge road map
answered 29-05-2017 03:48:20 -0400

We are attempting to upgrade our Denodo to the latest version (v60 update 20170515). This version supports Java 8 which helps us with some new data source connectors, however due to the jdbc-odbc bridge not supported in Java 8, we will be unable to use...

Answers: 3

ODBC JDBC jdbc java8 DataSource

How to specify json structure when we publish a flat view as rest web service
answered 25-05-2017 15:06:02 -0400

I have flattern structure like below in one of the views: Person Table ID| Name We want to publish this as a restbased webservice with json output and out put should be like below: {"Persons":[{" ID":"1","name":"abc1"},{"ID":"2","name":"abc2"}]} Note:...

Answers: 6

Connectivity to S3 with data in parquet format
answered 25-05-2017 13:21:37 -0400

Hi, Would like to know if Denodo can connect to the S3 object store and retrieve content stored in the parquet format via a regular SQL query. Thanks. John

Answers: 1

S3

Calling a Stored Procedure within another Stored Procedure
answered 25-05-2017 04:43:19 -0400

I want to know if I can call a Stored Procedure from another Stored Procedure. For example I want to Generate the Statistics for all Derived Views in a particular VDP database. The "GENERATE_STATS" stored procedure uses the View name as a parameter The...

Answers: 1

VQL Stored Procedures

AWS Athena connection from denodo
answered 24-05-2017 21:08:48 -0400

Hi, I am trying to connect to AWS Athena from Denodo. Has anyone here done this? If yes, please advise. Thanks.

Answers: 3