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.

joining multiple base view error via custom wrapper parquet file in S3.
answered 25-06-2020 02:32:21 -0400

Hi Team, I am getting below error while creating the derived view from joining multiple base view. Accessing the AWS S3 bucket data source from custom wrapper parquet file in S3. [CUSTOM WRAPPER] [ERROR] Received exception with message 'Error accessi...

Answers: 2

S3 parquet file DENODO AWS S3 derived view custom wrapper

Data Lineage metadata extraction and its graphical representation
answered 25-06-2020 02:30:40 -0400

I understand denodo provide certain predefined views to expose metadata. Couple of those views expose data lineage information. But do you expect the consuming application to build the graphical representation themselves or do you also provide some sup...

Answers: 1

Metadata views data lineage

Unable to connect to hive
answered 25-06-2020 01:37:05 -0400

I have downloaded the jdbc driver for hive. I am using cloudera distribution. I downloaded the driver and put it under /opt/denodo/denodo-platform-7.0/lib-external/jdbc-drivers/hive-1.1.0-cloudera this path. It is still showing error: Unable to estab...

Answers: 1

How to solve QUERY_TIMEOUT
answered 24-06-2020 16:51:48 -0400

How can I solve the QUERY_TIMEOUT after 900 seconds. My connection is: Driver class: oracle.jdbc.OracleDriver Database URI: jdbc:oracle:thin:@10.187.18.24:1521/DOKO As explained in Developer guide, I tried: jdbc:oracle:thin:@10.187.18.24:1521/DOKO?que...

Answers: 8

QUERY_TIMEOUT

HOw to connect denodo VDP from a java program
answered 23-06-2020 09:34:12 -0400

i want to connect to denodo that is installed on remote server. i want to connect it from my local system using Java Program. How can i do that?

Answers: 1

trying to connect denodo using odbc and getting error
answered 23-06-2020 08:56:24 -0400

I did the same mentioned in the earlier question, but i am getting below error: InterfaceError: (‘IM002’, ‘[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)’)

Answers: 1

Where does the metadata of Diagnostic & Monitoring Tool stored ?
answered 23-06-2020 06:57:44 -0400

Where does the metadata of Diagnostic & Monitoring Tool stored in Denodo Platform (vdp) ? Is it stored in the same apache derby database in which Denodo by default stores its own metadata ? And can we configure an external database to enable Diagno...

Answers: 1

Denodo Diagnostic & Monitoring Tool

Restriction User From Creating More View
answered 23-06-2020 06:35:39 -0400

I would like to know is there any possible way to restriction a user (newly created or existing one) when creation views. Example: a user " trainer" who have create, read, write privileges. but need to restriction the user from creating more than 5 view.

Answers: 1

assign privilages Create User Create Base View LIMIT

Step: Run the query - Query execution does not complete
answered 23-06-2020 06:26:44 -0400

Hi I am following the guide to run the query for SELECT * FROM same_store_sales_by_year. But I see that the query keeps on running and does not complete while the result of the step was to show that the query executes in 15 seconds.

Answers: 2

aws free-trial

Test Drive : ds_impala_historical_data connection not working
answered 23-06-2020 06:23:10 -0400

The data source in test drive "ds_impala_historicaldata" when click on test connection does not seem to succeed. The connection status shows "Testing JDBC connection" for long time and does not end.

Answers: 2

Impala AWS free-trial