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

Does Denodo accept this Delimiter ?
answered 26-04-2017 07:32:41 -0400

The column delimiter is |~ Is that a product limitation ? -- Lokesh

Answers: 1

Date conversion not working as expected
answered 26-04-2017 07:09:36 -0400

I have a NUMERIC source column which is in format “YYYYMMDD”. I am using TO_DATE function to convert into date. However the dates are not converted accurately using the function. The dates I have in the source column are 20170421 while the output of TO...

Answers: 1

TO_DATE function

Is there a query to see role-to-role assignments?
answered 25-04-2017 14:38:34 -0400

Using Denodo 6.0, is there a query or service which can provide a list of roles and any roles granted to them? Obviously, the "Role Management" window has what I want ... and I want it in a way that external audit automation can pick it up. I have rev...

Answers: 1

roles Role and User Management

McAfee exclusions for Denodo
answered 25-04-2017 09:38:13 -0400

We have the McAfee Anti-virus software installed on our Denodo server and we are noticing very slow performance while loading the cache. Are they any McAfee exclusions that we need to consider to improve performance

Answers: 1

Denodo intstallation and Unintsallation on Linux Server
answered 25-04-2017 09:33:20 -0400

Hi Team, Can you please guide me for below queries : I have installed denodo on Linux server but somehow I forgot the steps . 1) How to unistall denodo from Linux Server 2) After downloading installer file , I know we need to execute below command ...

Answers: 1

installation

Can branch pruning remove unwanted joins during query execution from same source
answered 24-04-2017 17:32:43 -0400

We are using Denodo 6.0 and are trying to see if branch pruning works for the following condition: We have 2 base views bv1 and bv2 build on the same source. We have defined an assicoation between these 2 views. bv1 is Principal and bv2 is Dependent. O...

Answers: 1

Branch Pruning

Teradata as Cache Database and Configuring Monitoring Tool for Teradata
answered 24-04-2017 16:56:47 -0400

Teradata as cache Database: Does Denodo supports Teradata as caching database ? If yes then is it works as other RDBMS system does ? I wanted to confirm if I setup Teradata as cache database, element delegation such as function, subquery, etc, should w...

Answers: 2

cache cache configuration Denodo Monitor teradata monitoring tool monitor

Connecting with Hive database in Cloudera distribution in VDP Denodo
answered 24-04-2017 16:23:15 -0400

Hi, I am trying to connect to Hive database in cloudera distribution with denodo installed on my local machine. I have database in hive and unable to configure the data source properties in VDP as it is asking for Credentials. Please provide me the ...

Answers: 3

cloudera Hive

VDP hangs, unable to create base view
answered 24-04-2017 12:01:59 -0400

During the creation of Base View the VDP system hangs. The DS is a delimited file with 1000+ columns. -- Lokesh

Answers: 1

lastIndexOf Functions
answered 24-04-2017 08:45:56 -0400

Is there a function like lastIndexOf? https://www.tutorialspoint.com/java/java_string_lastindexof.htm Or any workaround?

Answers: 1

LastIndexOf