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

Caching not working while joining two tables.
answered 09-05-2017 08:00:40 -0400

Hi, I have created two tables X, Y and enables the cache. With the current configuration. X, Y caching works individually. But when I do a join query with both tables. The cache is not working. Can some one help me on this. EX: select from X trace; -...

Answers: 1

cache cache configuration Cache error

Automatic query rewrite
answered 09-05-2017 05:17:12 -0400

Hi, we're explor enodo as a cache platform for EDW, our EDW is built on redshift and we'd like to replic a similar featur to oracle's aggreg uery rewrite within denodo, are there any docs or examplea on how to do this. Our BI tool is cognos and its mo...

Answers: 1
Related to: Advanced VQL Guide

QueryOptimization Queryrewrite

Listing of users list for a period of time
answered 08-05-2017 11:39:25 -0400

Hi Denodo Team, I want to get the list of users in the particular database for the specific period of time. Eg.. 01st jan to 31st march... I want to get the lis of user which are created for the above mentioend period.. How i can get the details?? ...

Answers: 1

Create sequence of numbers 1 to 10000
answered 08-05-2017 09:00:07 -0400

Hi, How can I create a simple query that simply returns a sequence of numbers 1 to 10000 each number as a record? I'd like to accomplish this without having to connect to a data source (so selecting from dual() if possible) Thanks, Rich

Answers: 1

Denodo jdbc jar usage in Python
answered 08-05-2017 06:20:34 -0400

Hello.. I'm attempting to create a JDBC connection using the Denodo JDBC jar in Python. I'm using the Python JayDeBeApi module establish the connection, however on connect I'm receiving a certificate chaining error. java.security.cert.CertPathValidat...

Answers: 1

Denodo 6.0 JDBC

JSON parameter with OR condition
answered 08-05-2017 06:16:48 -0400

Team, We are creating datasource going into Datasource -> Json and creating datasource connection and creating base view from API 1) We are succesfully able to create Datasource the connection passing below credentials DATA route: HTTP Client HTTP...

Answers: 1

DENODO json JSON

Error when testing a soap service with SOAPUI
answered 04-05-2017 08:09:34 -0400

The following error is recevied when testing the SOAP service. Incidentally the same view was successfully used for a REST service. <soapenv:Fault> <faultcode>soapenv:Server.generalException</faultcode> <faultstring/> <detai...

Answers: 3

web service soap

Debugging A issue in Denodo
answered 04-05-2017 07:22:01 -0400

How do i enable tracing in denodo or debugging in Denodo. Thanks Deepak Mishra

Answers: 1

Debug

Java Heap Size
answered 04-05-2017 00:10:50 -0400

I downloaded the HDFS custom wrapper, and when I try to import it into the VDP, it throws JAVA heap size error. Then from control center when i tried changing the JVM settings from default 1024 to 2048, VDP is not starting, but when i change it back t...

Answers: 1

java HDFSCustomWrapper; S3 Heap

Meta Data Store
answered 03-05-2017 11:15:17 -0400

Can we use Hive/Impala/Hbase or No SQL like Cassandra as Metadata Store for Denodo?

Answers: 2

metadata store nosql