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.

Import repository script would work as documented
answered 28-06-2018 04:38:49 -0400

WOULDNT WORK.. We have exported the repository as below.. which works export -server "//10.10.xxx.xxx:9999" -login denodo_xxx -password xxxxx -singleuser -repository "C:/repository" -property includejars=yes -property includescanners=yes -property in...

Answers: 3

import script

Convert the incoming date in Text format to DateTime using the TO_DATE function
answered 27-06-2018 12:43:41 -0400

Hello, I have a question regarding the conversion of incoming Text format to a Denodo Date format using the TO_DATE function. The field name is <fld_name>. And, a sthe incoming date values are: 5/1/2018 1:41 PM 5/1/2018 12:59 PM 5/1/2018 11:45 ...

Answers: 1

Date Conversion TO_DATE function

Automating status check of Denodo services
answered 27-06-2018 08:24:06 -0400

Hi Team, Reference: Automating status check of Denodo services https://community.denodo.com/kb/view/document/Automating%20status%20check%20of%20Denodo%20services?category=Operation Checking for vql service status. If I have three denodo environments...

Answers: 5
Related to: Automating status check of Denodo services

vql service

How do you subtract two dates to get the duration in days
answered 26-06-2018 13:31:37 -0400

in Oracle we would use select (end_date - start_date) from dual Update - it looks like the getdaysbetween(date1, date2) function may work for me

Answers: 2

Date

Installation
answered 26-06-2018 12:06:48 -0400

I have installed 6.0, 64 bit for windows. I am at the screen where I have to select the packs I want to install. No matter what I select, I get a prompt that says 'Please seclect at least one product to install"

Answers: 1

Does Denodo support Cassandra 3.x?
answered 26-06-2018 08:54:55 -0400

Hi, We are evaluating a few data virtualization solutions and has a strong use case for supporting Cassandra. Does Denodo support Cassandra 3.x? The problem is since Databricks does not support JDBC for Cassandra anymore, is there any other way of ge...

Answers: 1

Cassandra

track failed query
answered 25-06-2018 17:31:49 -0400

A user is hitting Denodo from tableau, He is facing issue with some tableau dashboards. While working with him we found that we can see 'active session with the query hitting from tableau to denodo', but we are unable to track failed query which was hi...

Answers: 3

query

Denodo & SQL Question - Temporary Tables & Updates
answered 25-06-2018 11:58:33 -0400

Hello, I am finding myself creating the majority of my base views by using the create from query function. I have a query I am looking to use to create a base view and in the query I have created temporary tables followed by update statements. The reas...

Answers: 1

Query SQL Temp Tables

Cache query having parameters ROWSTATUS ; EXPIRATIONDATE
answered 25-06-2018 11:20:07 -0400

Hi Team, When I am running the query on denodo view with one parameter which is cached I am seeing the query is created as below, SELECT t0.EMP_NUM, t0.EMPID, t0.OFFICE_NUM, FROM C_NON_EMP4415830103126 t0 WHERE t0.OFFICE_NUM = ? AND t0.ROWSTATUS = ? A...

Answers: 1

Connecting to Hyperion Essbase
answered 25-06-2018 10:25:15 -0400

Getting the follwoing error while connecting to essbase Error accessing Essbase server: Cannot connect to Provider Server.javax.net.ssl.SSLException: Received fatal alert: close_notify

Answers: 1