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

Hive connectivity issue
answered 02-05-2017 18:51:27 -0400

Hi, The issue i am facing when i pointed to the following driver "hive-jdbc-0.7.1.jar" is "Unable to establish connection: Insufficient resources to execute operation". How to resolve this? Thanks in advance

Answers: 3

Limit inside Denodo common table expression
answered 02-05-2017 09:49:05 -0400

Is it possible to limit VQL query output inside common table expressions? I mean something like that: "DenodoTable" hh order by "holding" desc **--LIMIT 10** ) select * from cte If uncomment "LIMIT 10', above VQL gives "Syntax error: Exception par...

Answers: 1

Top N CTE Limit

Custom Logging for JAVA procedures
answered 02-05-2017 08:46:05 -0400

We have a Java Stored Procedures that refers to other java classes. We want to have logging framework which will log to file during execution. Currently, I am using org.apache.commons.logging.Log; org.apache.commons.logging.LogFactory; private static ...

Answers: 1

logging

Connecting pop3 server
answered 02-05-2017 05:41:48 -0400

Hi Team, I am trying to connect pop3 server for getting mail details but not sure how i can create the pop3 data source. I have tried 'Aracne' data source but while creating base view i am geting "Unable to connect to aracne server" Please let me kn...

Answers: 1

Scheduling Jobs in Denodo using BMC Contol-M (without using the Denodo Scheduler)
answered 02-05-2017 02:05:54 -0400

I am using Version 6.0 (update 12192016) on RedHat Linux. I need to use Control-M with Denodo - to run jobs in Denodo to populate the Cache engine tables. Can I use ODBC to connect from Control-M to to Denodo to run VQL scripts to run Base/Derived Vi...

Answers: 2

Denodo Scheduler 6.0 wrapper contol-M

Access Cognos TM1 from Denodo
answered 28-04-2017 07:28:02 -0400

HI We wanted to Access Cognos TM1 from Denodo.INstalled the denodo O data wrapper in denodo What all details required to make successful connection to TM1 but not sure on options to select while creating a Datasource .Any document or link supporting it

Answers: 1

Denodo TM1

Case statements not giving expected results in Denodo
answered 28-04-2017 06:58:55 -0400

When I execute the below logic in TOAD in the SELECT statement, I get proper expected result but when I put the same logic in Denodo View for one of the output columns, the result set doesn't match with what Toad is returning: ((((trim(tr_tran_short_d...

Answers: 1

CASE

Issue with CONTEXT date conversion with call from a REST Webservice
answered 28-04-2017 06:30:57 -0400

I am getting the following error when I execute a the following query from a REST Web Service to a view in Denodo: SELECT_NAVIGATIONAL <fields> FROM <denodo derived view> WHERE (1=1 and (Rcvd_Date BETWEEN DATE '0001-01-01' AND DATE '9999-12...

Answers: 1

Date Conversion dateformat

custom wrapper
answered 28-04-2017 04:12:47 -0400

Why have you written a custom datasource wrapper for fetching data from salesforce.com when you are using soap only internally in it and we know that denodo supports creation of soap datasource?

Answers: 3

custom wrapper

Connector to Spark SQL
answered 26-04-2017 11:50:25 -0400

Hi Team, We are looking for Connector for Spark SQL. when i go through the same question, i see one answer that we need to create the baseview from query instead import baseview. Also config change in hive datasource. These answers are when the versio...

Answers: 1

Spark-sql connection