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.

Multiple input parameters in REST service
answered 07-06-2019 08:32:57 -0400

HI Please let me know how to pass or query multiple inputs for a REST service. Eg. If my REST service has a view with 'Rollnum' in where condition then how shall i fetch the records for the roll numbers "1,,3,6,7" in one go ? Thanks

Answers: 3

input REST multiple Parameters parameter

Connection to oracle 11g to denodo training lab
answered 05-06-2019 08:33:14 -0400

Do i need to download any drivers for oracle 11g. I have downloaded the denodo platform and trying to connect to oracle 11g.Is that the correct way to do it. Getting IO error. do i need to download any VM to do the labs.

Answers: 1

denodo install vdp client 7.0 - size
answered 04-06-2019 12:06:56 -0400

HI, I need to know the size of denodo-install-vdp-client-7.0-win64.zip and denodo-install-vdp-client-7.0-win32.zip and then Unzip. Thanks

Answers: 1

Error: Invalid identifier (too long)
answered 04-06-2019 11:53:41 -0400

Hi team, I was trying to rename a view to a name with more than 100 characters and I got this error: Syntax error: invalid identifier: 'xxxxxxxxxxx' (too long) Is there any character restriction for object name in Denodo? Can I change something, i.e. i...

Answers: 2

Error View Server Configuration Changes

Download of Denodo Training 7.0 QuickStart Virtual Machine fails
answered 04-06-2019 06:19:05 -0400

I have taken up Data Virtualization Developer (Introduction) - On-demand training. As I part of configuration task I am trying to install the virtual machine but I am not able to. Once the zip folder is downloaded from the link provided I try to unzip...

Answers: 1

download vm Denodo Training QuickStart Virtual Machine

Not able to import a view and execute VQL's in VQL shell in Denodo 7.0 express edition
answered 03-06-2019 12:08:23 -0400

Hi Team, Good Day! I was trying to export and import the entire database that I have created within my local to another local machine and it works. I could move my entire DB to another system. But after sometime, I thought of moving some edited view to...

Answers: 1

VQL Import Export

JAVA maxed out and Denodo crashes on local machine
answered 03-06-2019 10:18:02 -0400

Randomly in working daily, Denodo freezes up on local machine. JAVA rises to around 600k Memory (private working set) and there's no more response. Eventually the screen blacks out, but doesn't close. I go into task manager, and kill the JAVA process. ...

Answers: 1

extract server configuration
answered 03-06-2019 09:15:52 -0400

Hi Team, Denodo 5.5 Denodo 6.0 Administration > Server Configuration Tools > Admin Tool Preferences Control Center > Configure > Memory Options Is there any scripted way to get the values configured in these sections. Rather than opening...

Answers: 3

Admin tool memory options Server Configuration Changes

Unable to connect to Hortonworks Hive using Kerberos.
answered 31-05-2019 12:34:58 -0400

Hi Team, We are unable to connect to Hortonworks Hive using Kerberos Authentication. We have installed all jars and using the below connection string. "jdbc:hive2://HOST:PORT/default;principal=**;auth=kerberos" . I am getting the error "Unable to estab...

Answers: 1

Hive kerberos

Case function in Denodo
answered 31-05-2019 07:54:56 -0400

Hi Team, I have a requirement to implement a scenaion similar to the below in Denodo. But I am not sure, how to go about it using denodo case function. It is throwing me some error. Can you please help? IF [varI] =0 then 'Perm' ELSEIF([varI] >0 and ...

Answers: 1
Related to: Oracle SQL to Denodo VQL Quick Reference

Function case function denodo functions CASE