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 November 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.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Stopping queries through VQL shell
answered 06-04-2018 08:33:09 -0400

I wanted to see if there was a kill command we could run via VQL shell to stop all queries. We are looking to integrate a way to stop all running queries with a script before a release is done.

Answers: 1

Is it possible to query only the data in the Cache of a derived view?
answered 06-04-2018 08:15:25 -0400

Hello - very new to Denodo and running into a questions I am looking for help with. Esentially, I have created an ODBC connection between our denodo databases and Alteryx. I am querying data from a denodo table, but I am only interested in returning da...

Answers: 1

Driver ODBC Alteryx Cache

SUBSTR not working on Union View
answered 05-04-2018 08:24:43 -0400

Hi Team I have a 3 Views say A(BaseView),B(BaseView),C(Union View- Union of A and B Base Views). So when I am trying to put a SUBSTRING Function in one of the column in C Union view its not able to put so any idea why its not making me to use. Regard...

Answers: 1

View Parameters disable
answered 05-04-2018 08:21:54 -0400

Hi! Im trying to do the DEN60EDU118 LAB01. In some point it ask us to use view parametes botton. When im trying to do it, the botton is disable it says: "This feature is not allloed by the licence"! I use de lincense provide by the express instalatio...

Answers: 3

Parameter View

ES 6 support on Denodo
answered 05-04-2018 08:07:54 -0400

Hi, We have a hosted Elasticsearch cluster and we want to consume data and use with other sources using Denodo - is this possible to do via Denodo Express v6 or indeed any version? Best Rgds,

Answers: 1

ES6

to_date function from denodo cannot be delegated to HIVE
answered 04-04-2018 11:11:09 -0400

Hi, I am getting warning as to_date cannot be delegated while trying to find the difference between two dates in denodo with source as HIVE The logic I have used in denodo as: getdaysbetween(to_date('yyyy-MM-dd', table1.start_dt), to_date('yyyy-MM-dd...

Answers: 2

Denodo and Hive

PC Hardware Requirements to run Denodo
answered 04-04-2018 09:21:45 -0400

I've combed through the website but there is no mentioned on the minimum PC requirements to install and run Denodo Client. Could you please advice?

Answers: 3

PC Hardware Requirements

Suppport For Cassandra
answered 04-04-2018 09:03:01 -0400

Hello, I downloaded Denodo Express v6.0 - It states in the documentation that it supports Cassandra - is there any documentation to show the steps to create a new data source for Cassandra? does it use datastax? Best Rgds,

Answers: 1

Cassandra

How to know if a particular denodo Job has completed its action?
answered 04-04-2018 08:16:26 -0400

In my Java application, I am using the APIs provided by Denodo like denodo-configurations, denodo-scheduler-api-jar, denodo-scheduler-client, to access the Scheduler Manager factory classes. I below peice of code returns me only the following job stat...

Answers: 1

java code

Denodo connectivity to COSMOD DB
answered 03-04-2018 08:43:21 -0400

Can Denodo VDP(6.0/7.0) connect to COSMOS DB in Azure? Appreciate if somebody can share any implementation details or alternative, if that is not possible out of the box

Answers: 1

Connectivity