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.

find rows for all views
answered 14-11-2018 07:43:24 -0500

Hi Team, Denodo 5.5 Is this possible to achieve ? For a given view get number of rows for it and all it component views. This means as- Final View - FV1 - 1000 rows Derived View - DV1 - 5000 rows Derived View - DV2 - 7000 rows Base View - BV1 - 800...

Answers: 1

rows

Query to get full cache & rowcount
answered 13-11-2018 13:08:45 -0500

What is the VQL query to run a full cache on all the existing base views? Is there any system view to get row count of all the base views in the database.

Answers: 3

Setting up access to Google Big Query.
answered 13-11-2018 09:17:28 -0500

Using Denodo 7.0, I'm trying to setup a connection to Google Big Query. I have worked my way through the documentation, but when I'm attempting to use the OAuth 2.0 Credentials Wizard, there is something I'm missing. I don't fully understand what I'm s...

Answers: 1

LDAP Baseview creation Error
answered 13-11-2018 07:48:18 -0500

Hi, I have created a LDAP datasource with the server URL(ldap://<Server Name>:389), User id and Password. When I test the connection it says 'Connection tested successfully' But when I try to create Base view I am getting the error 'Unable to co...

Answers: 1

LDAP

Denodo username and name of user with LDAP authentication
answered 13-11-2018 03:47:33 -0500

We are utilizing 7.0.20181011 with LDAP authentication. We are looking to improve our capability to monitor access permissions. We utilize the CATALOG PERMISSIONS() stored procedure but it shows only username (e.g. smithj), not the name of the user (e....

Answers: 1

#LDAP

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