Q&A

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

Role, User and VCS management options are disabled in Denodo express 7.0
answered 29-05-2019 17:53:50 -0400

Downloaded and installed Denodo express 7.0. Logged in with default admin user. I am able to connect to cloud source and create views. But user management, Role management and VCS management options are disabled. Why so?

Answers: 1

Create User Role and User Management