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 updated version of the Denodo Express 6.0 with new features and fixed issues starting in February 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 6.0 at the Express home page in the Denodo Community

ReST API - cookie
asked 23-02-2018 16:15:38 -0500

We have ReST API which should returns cookie and value . Obviously we can capture the values thru the base view but how do we capture cookie as part of the result. Our idea is capture the Cookie value and use it as interpolation variable for the subseq...

Answers: 0

REST API REST

VDP Connection refused
asked 23-02-2018 15:13:12 -0500

I downloaded the Windows 64bit Denodo Express v6. When I lauch the platform, first the windows it open in is very small, even resizing does not work. Also, when I launch VDP with admin/admin credentials, it says Connection refused. Any insights on how ...

Answers: 0

Ignore HTTP errors during join with other view
answered 23-02-2018 07:44:17 -0500

Some rows in a table when joined with a parametrized view on a REST web service lead to 404 errors. Is there a way to ignore those rows instead of throwing an error and continue with the other rows. Now, the query execution stops (gives error) when o...

Answers: 4

selection queries cannot be delegated to the database using case clause from Hive
answered 23-02-2018 07:23:55 -0500

I have used full join between two tables and added the new column with sample case statement as CASE WHEN A IS NOT NULL THEN B WHEN C IS NOT NULL THEN D ELSE NULL end. If I see the query plan showing warning as selection queries cannot be delegated to ...

Answers: 1

Denodo and Hadoop

Error gathering the statistics of the view: Wrong stats query resultset
answered 23-02-2018 04:46:19 -0500

When I try to gather the statistics for a Base View, I am getting the error: "Error gathering the statistics of the view: Wrong stats query resultset" I tried it going to base view > option> statistics and selected enable statistics and complet...

Answers: 1

Gather Statistics Generate stats

Hadoop installation + Virtualization enabled 64 bit CPU
asked 23-02-2018 00:30:59 -0500

Hi All, I have Windows 7 HP Pavilion dv6 note book, but it didn't support for virtualization (as show in figure there is no any option on BIOS). With this configuration, I can not install Cloudera QuickStart VMs . Due to this issue now I need to c...

Answers: 0

HAdoop HP

Denodo-Query Execution and Filter adding level
asked 22-02-2018 20:03:08 -0500

Hi Team, I need some clarification for my below example. I have a view "A" coming from Oracle DB1 and view "B" coming from Oracle DB2 both views have same columns and almost same data. I brought these two views into Denodo and I did union means A union...

Answers: 0

Java Virtual Machine Launcher
answered 22-02-2018 16:35:31 -0500

Installed Denodo Express, copied the License file to home directory. Getting "Error: Could not create the Java Virtual Machine".I'm assuming there is an bat file somewhere that needs to be updated, but have not had any luck so far.

Answers: 1

JVM settings

Change VDP port
answered 22-02-2018 05:18:30 -0500

Our server is running VDP on a different port 1111 than using 9999. To connect the VDP client from my local machine I have changed the URI: to point to 1111 and changed VDP port mentioned in VDBAdminConfiguration.properties to 1111. It's still not conn...

Answers: 2

Port VDP client

DENODO Express Installation instructions for the MacBook Pro with macOS High Sierra
answered 22-02-2018 03:50:46 -0500

Is there Installation instructions for DENODO Express for the MacBook Pro with macOS High Sierra. I see where it started being supported in February 2018.

Answers: 1