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

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

Different Execution Plans
answered 03-05-2017 08:53:36 -0400

Hi, I have a derived view expecting to run 2 base views parallely and do a join operation in denedo server with the base view results from source server. Even the execution plan in the derived view shows me the same but actual plan is different. On so...

Answers: 1

Execution plans

GROUP BY and String Aggregate functions
answered 03-05-2017 03:18:14 -0400

I've made a View in Denodo VDP which is a UNION of two other "SELECT" views. Now I want to pivot some of the data in this new view; I use following query; ELECT primitivumnummer AS primitivumnummer, CASE WHEN ( hasname = 'txtNap' ) T...

Answers: 1

Aggregate