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.

Cached Denodo view is slower than uncached view while fetching data from the tableau.
answered 28-12-2017 13:45:38 -0500

Hi, I have two views in Denodo. One is cached and another one is not cached. Both are having almost 3 crores records and 36 columns. In this scenario, when I fetch records in denodo such as find distinct cloumn in each table, I see it is taking almost...

Answers: 1

slow query

Connect Denodo view from python code
answered 28-12-2017 07:21:55 -0500

Hi Team, I am trying to access a Denodo derieved view from my python code. Which library do I need to import in my code? Could you also provide any sample snippet for the same?

Answers: 1

Denodo error when creating/updating view.
answered 28-12-2017 04:49:22 -0500

Hello guys. I faced with issue when trying to delete/update some derived view (and its base view/table/wrapper), the following logs are from denodo: 14460953 [RMI(30959)-10.111.111.222-4929] FATAL 2017-10-18T08:36:24.281 com.denodo.vdb.interpreter.ex...

Answers: 6

denodo

Error while creating Base View (incorrect expression)
answered 28-12-2017 03:55:34 -0500

Hi: When attempting to create a base view from a Delimited File, there is an error displayed for the regular expression ^. However this expression is used in the example. Can you please help me? I attach an image with the error https://imgur.com/a/s9Rc8

Answers: 1

Delimited Files delimited_files tuple

CONFIGURE SERVICES & install Impala drivers in Linux server
answered 27-12-2017 16:17:43 -0500

Hi Team, Kindly provide us the steps involed to perform the below activity. 1.How to CONFIGURE SERVICES in linux server. 2.How to install Impala drivers in linux server:

Answers: 1

Changing/updating the values of wrapper during migration
answered 27-12-2017 04:04:58 -0500

Hi , I have a base views in multiple schemas of a datasource. Below is a example of wrapper CREATE WRAPPER JDBC <view_name> FOLDER = ‘/base views/’ DATASOURCENAME=db_name SCHEMANAME=’XYZ’ OUTPUTSCHEMA ( However, while changing the environment...

Answers: 3

Stored procedure returning data only with "call" statement and not with "select"
answered 26-12-2017 07:24:00 -0500

I have created a stored procedure which returns an Array. It is not performing any DML operations and is only retrieving data, parsing it and giving back an array. However, I can only view the data using "call" statement. The "select" statement is retu...

Answers: 5

Stored Procedures

Denodo platform for other service
answered 26-12-2017 07:16:14 -0500

I was reading through denodo platform for various services like AWS and Azure . Are there any other services or ways to implement Denodo platform ??

Answers: 1

STORED PROCEDURES NOT DISPLAYED IN TREE DATA SOURCE
answered 26-12-2017 07:03:05 -0500

Hi: I'm attempting to execute the LAB03 however stored Procedures are not displayed in the data tree source. Can you please let me know why are not displayed? If something is missing? I attach the image where procedures are correctly created in MYSQL b...

Answers: 1

Stored Procedures

Unable to read Unicode character columns in views
answered 22-12-2017 07:21:58 -0500

we built some base views off RMS sql files. three columns have elements that are formatted “ObjectValueTypUnicode” datatype. the columns do not appear in the output on a SELECT * base view build. Just not there while every other field is populated and ...

Answers: 1

unicode