Home / Q&A / All Questions

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 April 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

Converting flat structure table to 3 level hierarchy json object
answered 28-03-2017 11:52:19 -0400

Hi Team, We have a requirement to convert denormalized table structure as a source and we want to provide 3 level hierarchy json object what would be the best approach using Denodo?

Answers: 5

changing the name of multiple views at once
answered 28-03-2017 11:45:44 -0400

I have created 20 base views. how can i change their name by prefixing them with "bv_" without editing each base view individually ? Thank You. erol aivas

Answers: 3

view name

How to query with query arguments
answered 28-03-2017 08:51:23 -0400

I am trying to follow the idea with the splunk, which consists of 2 views, in Denodo, one is actually creating the job with the sid, and the other is querying the results. I am failing with the combination of both, since a query of the form (refering t...

Answers: 1

splunk arguments

Issue with limit on the query using JDBC driver vs denodo
answered 27-03-2017 09:06:13 -0400

There is an issue with putting limits on the query through the JDBC version. using select * from <table> limit 200 does not work. It is like the JDBC doesn't parse the limit constraint to the VQL.

Answers: 1

JDBC Query limit

Choosing the fields returned in stored procedure call CATALOG_VDP_METADATA_VIEWS
answered 27-03-2017 08:51:18 -0400

Is there a way to limit the fields returned in the Stored Procedure call CALL CATALOG_VDP_METADATA_VIEWS . For example, I only need the following fields from this call: DATABASE_NAME: name of the database that the view of the field belongs to. VIEW_NA...

Answers: 1

meta data Stored Procedures

List of possible or default log categories
answered 27-03-2017 07:41:03 -0400

How do I determine the list of the possible log categories that can be passed to the logcontroller stored procedure? for example: call logcontroller('com.denodo.vdp.requests','error'); I know of: com.denodo.vdp.requests Regards, Mike

Answers: 1

logging

Downloading issue
answered 27-03-2017 07:16:17 -0400

Hi Team, I am trying to download the Express edition 6.0 but it fails every time in between. Could you help me here.

Answers: 1

DENODO

Denodo's doesn't listen on the proper ethernet interface
answered 24-03-2017 08:40:30 -0400

Hello, It seems that my new denodo installation listen on the various ports only on localhost, I've tried to follow the explanations on the RMI configuration article (https://community.denodo.com/kb/view/document/RMI%20host%20configuration?category=Op...

Answers: 3

Doesn't seems to work on azure
answered 24-03-2017 08:36:00 -0400

Seems that it doesn't work on azure I can see my server listening to the ports, all is configured well (including ports / firewall) telnet to port 9999 on localhost work well but not from outside to the public ip. tcp6 0 0 :::9997 ...

Answers: 1
Related to: Installation steps on a cloud environment

cloud vm azure

Web access shows "The page you requested was not found."
answered 24-03-2017 08:31:04 -0400

After trying for several days to install your software on an headless machine on azure where the application refuse to listen to the public ports I've left azure and moved to google cloud. I've downloaded your tar.gz, unpacked it and ran installer_cli...

Answers: 1

cloud