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.

The pod in the denodo-container keeps crashing
answered 29-09-2020 08:46:00 -0400

Hello docker/kubernetes experts, I followed the steps mentioned above and after creating the denodo-service.yaml, I can see that the pod keeps crashing with the status : CrashLoopBackOff. Please let me know if anything is missing that might be causing...

Answers: 1
Related to: Deploying Denodo in Kubernetes

kubernetes

How to remove leading zero's in date time stamp - 08/03/2020 04:05:15 PM
asked 29-09-2020 08:21:37 -0400

Hi Team\ I have format date 08/03/2020 04:05:15 PM want to remove the leading zero only on the date given above . How to do that.. Please help, its very urgent to implement on the job design. 08/03/2020 04:05:15 PM o/p 8/3/2020 04:05:15 PM

Answers: 0

Date time stamp

Perform a join and only keep the first row
answered 29-09-2020 08:09:21 -0400

Perform a join and only keep the first row when the join condition it met

Answers: 1

Flatten view
asked 29-09-2020 06:17:30 -0400

Hi Team, I have created one view from Json data source.In this view there are multiple columns and 4-5 coloumns are itself a collection of array.And Inside these element array there are elements which are itself a collection of array. I want to flatt...

Answers: 0

JSON Data Source FLATTEN

How to remove leading zero's in date time stamp
answered 29-09-2020 05:57:13 -0400

I have below string output using Formatdate function applied 08/03/2017 04:48:34 PM How to remove leading zeros O/p - 8/3/2017 4:46:34 PM Please help

Answers: 1

Date time function

Iterate Api
asked 29-09-2020 05:14:03 -0400

Hello, I have 12 number of pages with my API with limit of 1000 and offset of 1000. Now If I obtain a single page of data it consists of 1000 rows of data and I cannot increase the limit to even 2000 becuase of source that provides only 1k data at a ...

Answers: 0

Pagination #API #Rest_API

Convert rows into columns after flattening in denodo
answered 29-09-2020 02:05:34 -0400

I have created a base view out of an API which returns me some array rcolumns. I then flattened these columns using flattening function in denodo. But I get multiple rows for a single account. My requirement is to convert these rows in corresponding co...

Answers: 1

db2 LUW drivers
answered 29-09-2020 00:11:33 -0400

I need to configure a jdbc connecton to a db2 instance. I have been told that the version of db2 is V 10.5 Fix pack 7 . this look painful as teh denodo site sends me to https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.swg.im.dbclien...

Answers: 3

db2 drivers

Denodo Scheduler: Is it possible to query the denodo scheduler and get a list of jobs, schedules, etc?
asked 28-09-2020 18:20:06 -0400

Is it possible to query the denodo scheduler data? IE: Can we get a list of projects, jobs, and their triggers?

Answers: 0

Denodo 7.0 Scheduler Query Scheduler

RegexExp to extract value between parentheses
answered 28-09-2020 02:55:22 -0400

I am trying to use the following formula to return the value that is between parentheses in a field. For some reason it is just returning the exact same value. I am pretty sure this REGEX is valid. regexp(bv_epic_tpi_inventory_report.hcco, '/(([^)]+)...

Answers: 1

Formula Regex