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.

java.lang.NoClassDefFoundError while trying to connect to hive
answered 03-03-2020 07:37:34 -0500

hello, i have a problem concerning connecting to hive database. i have denodo virtual dataPort version 7 and the quickstart cloudera vm with cloudera version 1.1 .0 but everytime i try to test the connection the following error appears Unable to es...

Answers: 1

Hive Access Denodo Express Hive Issue AWS HIVE JDBI Connection URI

Error while connecting to Git
answered 03-03-2020 07:34:30 -0500

How to upload image/screenshot here in this question?

Answers: 1

Invalid Query because of Oracle REGEXP_LIKE pattern
answered 03-03-2020 04:40:24 -0500

Hi, I am trying to create a base view from query with below sql syntax. However it is failiing with invalid query so i came to know that it is because of '<(1\d{3}(.\d+)?)+>'). Now i tried escaping { and } with '\' but still no success. i am ...

Answers: 1

Invalid query in create base view from query

Elastic queries timeout when aggregating timestamps
answered 02-03-2020 07:57:21 -0500

We are having issues with a Elastic queries hanging and eventually timing out when aggregating or formatting on a timestamp column. Here's our issue. We've created a Data Source using the Elastic JDBC connector. Our Base View is as follows: SELECT t0...

Answers: 1

elastic

denodo_platform
answered 02-03-2020 02:09:59 -0500

Hi there On a windows server, when the server starts up is it possible to make Virtual DataPort startup automatically as administrator. Please let me know

Answers: 1

Virtual DataPort

Error while testing the SSL connection using Keystore
answered 28-02-2020 07:56:46 -0500

Hi, I am trying to test and HTTPS request throught SSL certificate. I tried generating a certificate following below link https://community.denodo.com/docs/html/browse/6.0/platform/installation/postinstallation_tasks/enable_ssl_connections_in_the_deno...

Answers: 1

Text to Date field conversion
answered 27-02-2020 21:31:33 -0500

Hi Team, Using Denodo 7.0 version. I have date field in format 'MM/dd/yyyy' in my source which is in text datatype. I need to project the same in same format('MM/dd/yyyy') but in date datatype. When i use CAST, to_date ,to_localdate ....., format is ...

Answers: 1

Date Conversion Date

Unable to create TFS environment
answered 27-02-2020 13:55:51 -0500

I'm trying to integrate denodo with TFS in version 6.0. Whenever i try to create environment I'm getting this error: Error creating environment: error creating environment: Unexpected URL format: 'http://team/tfs/****/folder/environments/development.p...

Answers: 1

TFS

Context clause wiped out by VDP....
answered 27-02-2020 07:29:05 -0500

I created a new derived view from a base view and provided the context for 'queryTimeout' setting e.g. SELECT ... FROM ... CONTEXT ('queryTimeout' = '9000000') However, VDP keeps replacing it with SELECT ... FROM ... CONTEXT ('formatted' = 'yes') ...

Answers: 1

Denodo7 hibernate jar not found
answered 27-02-2020 07:25:11 -0500

As per Denodo documentation Hibernate jar is available under /dist folder in the installation directory. But we couldn't found the folder /dist in our Denodo7 installation directory. Requesting your support on this issue

Answers: 1

Hibernate Denodo Jar