Q&A

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

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