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.

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

Passing a tableau Parameter from Tableau to a parameterised Denodo Derived view
answered 31-05-2019 06:35:42 -0400

Hi, I have created a denodo derived view which has a parameter and filter added on that. The paraemetr passes the Customer ID. When i run and test in Denodo, it works fine. I change the parameter default value everytime and it filters the data for that...

Answers: 1

Parameterize

Denodo testing tool for denodo 7
answered 31-05-2019 04:38:43 -0400

Hi, We have been using Denodo 6 currently and will be moving to denodo 7 soon. We want to do some automation testing for our comonly checked test cases and encountered this tool with denodo called Denodo testing tool. I haven't seen any documentatio...

Answers: 1

Denodo Testing Tool Testing

training for developers 'DEN70EDUD01 Data Virtualization Developer (Introduction) - On-demand' Problem with download zip files at each exercise
answered 31-05-2019 03:33:47 -0400

Hi, I previously installed a VM to do the tutorial. I would like to use this VM to do the courses on demand without having to install the virtual machine you are proposing. the problem is that when I try to do the download, in the various exercises, it...

Answers: 1

Denodo 7 imported data from Denodo 6: caveats?
answered 30-05-2019 12:47:58 -0400

Hello, I was testing an import from a virtual database in Denodo 6 to Denodo 7. Without changes, I noticed that date fields got marked "deprecated". I checked the documentation and read that now there will be multiple date and time datatypes. How ...

Answers: 3

License does not allow more requests.- Error message
answered 30-05-2019 00:54:47 -0400

This week we have run into an intermittent problem. We get locked out from our Denodo session, with this error: "Error while creating base view License does not allow more requests. The number of requests being processed is too high" It then clears...

Answers: 1