Q&A

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

LISTAGG QUERY SAMPLE
answered 27-02-2020 07:23:54 -0500

Hi, please provide a query sample example to show the function listagg. Currently i am not able to produce syntactically correct query even though i follow the syntax. Also please do not provide the listagg function link in ur community as i already...

Answers: 1

listagg

Scheduling job to load data for all the month-end dates in the caching database.
answered 26-02-2020 07:47:06 -0500

Hi, We have created multiple final views with mandatory parameter 'as_of_dt' for each view. Now, we want to schedule job to load all month end data in cache.( all month end dates for future and past- not any single month end date ) I was planning to ...

Answers: 1

Denodo 7.0 Denodo Scheduler 7.0