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 April 2018.

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

WHERE Clause in query
answered 10-01-2018 14:12:41 -0500

I have created dervied view's using Baseview views and query also has an where clause at the end on one the Base view. When I run the new derived view the where condition is executed at the end. I dont see this helping peformance. please let me know, I...

Answers: 1

query plan Sql performance WHERE CONDITIONS

Performance Bench Marks
answered 10-01-2018 09:27:29 -0500

I'm currently seeing performance issues when we run quiries extracting data from tables with multimilliion records. The data movement is slow and cpu consumption is quite high during the query execution. As a first step, I would like to compare it to t...

Answers: 1

performance Bulk Data Load Sql performance

REGEXP_LIKE function in a Scheduler query
answered 09-01-2018 08:35:06 -0500

Hello, I am trying to create a job in Scheduler, by putting a REGEXPLIKE function in the sql. The query which works in Oracle is: SELECT FROM mytable WHERE REGEXPLIKE (referer,'^https?://[a-z6.]{0,9}.?google[a-z]{0,11}.[a-z]','i')* But this quer...

Answers: 2

REGEXP_LIKE

Virtual Data Marts
answered 09-01-2018 07:35:44 -0500

Can you give an idea on how virtual data marts can be implemented from Denodo? 1.For existing physical data marts. 2.For developing from scratch within denodo.

Answers: 1

connection error: Software caused connection abort: recv failed
answered 09-01-2018 06:19:09 -0500

Hi, I installed Denodo on my linux (CentOS) VM and started it. Then I tried to connect to it via VDP Admin on my host machine and I’m getting the following error: connection error: Software caused connection abort: recv failed VDP-Admin Log: ...

Answers: 1

bad ELF interpreter + SSH Crash
answered 09-01-2018 02:57:31 -0500

Hey, I'm trying to install denodo on a Linux VM via an SSH-Connection. But when I execute the install-command the following happens: [root@sandbox denodo-install-6.0]# ./installer_cli.sh install ./installer_cli.sh: /opt/denodo_install/denodo-inst...

Answers: 2

Cached View Names on Database
answered 08-01-2018 06:13:24 -0500

Hi, In Denodo , when we cache a view to RDBMS the name of the table which is created does not reflect the name of the view but istead is some random combination of characters and numbers. For example Denodo Cached View in VDP = dv_sls Denodo C...

Answers: 1

VDP Date format and REST Service output date format is not matching
answered 08-01-2018 05:53:52 -0500

Hi Team, I seeing different issues here. Please help to fix out. I have one date column in oracle DB and getting data as below Requirement Request Date 11/27/2017 10:59:37 PM 11/27/2017 10:59:37 PM 11/27/2017 10:59:37 PM I brought into Denodo and whil...

Answers: 1

GetQuarter function
answered 05-01-2018 06:52:30 -0500

select ctry_cd, sum(setlmt_amt) from dpd.issr_qtr where getquarter(prch_dt) = 1 group by ctry_cd The above query does not delegate the getquarter function to the database. So Denodo is retrieving several million records on to the denodo server and doi...

Answers: 2

GetQuarter

Start the Denodo job with dependencies using Shell script
answered 04-01-2018 19:26:47 -0500

Hi, Can you please assist me to invoke the Denodo Job with dependecies option using shell schipt. I can see only below options and don't see start-with-dependecies option sh test_schedulerclient.sh -start load_dv_added_current_frozen_vw -h sjgdvappd...

Answers: 1

shell Denodo scheduler admin Denodo Scheduler 6.0