Home / Q&A / All Questions

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.

How to create 2 different environments in one Denodo Platform installed?
answered 12-11-2018 19:48:32 -0500

Currently, I have a virtual database named "xyz" in Denodo 7.0. As per my project's requirement - I would like to replicate the same virtual database with a new name "xyz_staging" as I have only ONE Denodo platform installed. And, I would like to renam...

Answers: 1

Denodo 7.0 Environments

I want to substract numeric column from a date column and i'm using addday() fucntion
answered 12-11-2018 07:41:59 -0500

Hi, I want to substract numeric column from a date column and i'm using addday() fucntion as below- addday(xxbi_oe_order_lines_all_v.promise_date, mult (xxbi_oe_order_lines_all_v.delivery_lead_time,-1)) where 'xxbi_oe_order_lines_all_v.promise_date' ...

Answers: 1

Function

Ltpa token
answered 12-11-2018 07:35:05 -0500

Hi, i have to call a web service with ltpa token authentication, is possibile to do this with denodo? thanks.

Answers: 1

ltpa token

Join condition failing for text datatype in Denodo
answered 12-11-2018 04:55:22 -0500

Hi Team, Since Date function or datatype got deprecated in Denodo 7.0 I used some formatting in a coulumn in view name called A and got the desired value : "WED NOV 07 00:00:00 EST 2018" as required using, regexp(replace(cast(formatdate('EE MMM dd HH:...

Answers: 1

Denodo + Spark SQL
answered 12-11-2018 04:38:38 -0500

I had created spark conenction in denodo. Datbase Adapter: Spark SQL 1.6 Driver Class : org.apache.hive.jdbc.HiveDriver Database URI : jdbc:hive2://xyx.abc.com:10000 But while running queries;still the job is running on mapreduce. In yarn for the job...

Answers: 4

Spark-sql connection

unable to create VDPCache job in scheduler
answered 09-11-2018 13:29:47 -0500

Hello, I'm trying to create a VDPCache Extract job from scheduler in Denodo 7.0. I'm able to create a Datasource sucessfully, when I try to create a VDPCache job, I'm selecting a baseview from dropdown sucessfully and when I try to save the job it thr...

Answers: 1

Denodo 7.0 Denodo Scheduler 7.0 VDPCache

Connecting to Tableau, Connection Guide no longer exists
answered 08-11-2018 09:08:12 -0500

Hi, I am trying to setup a connection to denodo within my tableau v 10.5 . Seems like the documentation on how to do this is gone. https://community.denodo.com/kb/view/document/Connecting%20Tableau%20Desktop%20to%20Denodo?category=Northbound+Connecti...

Answers: 2

DENODO Tableau

In my Derived view there is one field message. it's return value in XML. How do I get some field from there?
answered 08-11-2018 06:32:44 -0500

In my message field I got ><ns2:ResponseDateTime>2018-09-20T14:10:26.607-04:00</ns2:ResponseDateTime>><ServiceName>test</ServiceName><ServiceRequestDateTime>2018-09-20T14:10:26.508-04:00</ServiceRequestDateTime&gt...

Answers: 3

VDP XML DENODO

two query in same session.
answered 08-11-2018 06:27:59 -0500

How to run 2 or more queries in same VQL session, getting two result set.?

Answers: 1

to_date function given a week_of_year and year -> influence day selection?
answered 08-11-2018 05:58:27 -0500

Hello, getmonth(to_date('yyyyww', *date)) a wrong month 201831 -> gives 7 but it should be 8, The beginning of this week is in month 7 and the end in 8. How can this be influenced, i.e. by defining the 'first day' it should be converted to?

Answers: 1