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

Changes made at scheduler level
answered 13-07-2018 14:11:37 -0400

Hi Team, Schedule of one of our prod job got chagned and we are trying to find out who / what / when and how ? Can you guide us how to trace above information or which log to scan for ? Thanks

Answers: 1

DBeaver, SQLserver. java.sql.SQLException: Invalid mapping to BYTE
answered 13-07-2018 11:22:35 -0400

I'm trying to access data from SQLserver via Denodo (I think version 6), using latest Dbeaver (on Win7). I'm not an adminstrator so have no visibility of Denodo setup etc. nor the database itself. I'm getting warnings when viewing data from views of ...

Answers: 2

BYTE DBeaver SQLserver.

Delegate operation minus to the source
answered 13-07-2018 09:59:35 -0400

Hello I have two views derived from the same source, I do a minus operation between them and the operation is not delegated to the source. Can this operation be delegated to the source? I'm using denode 7.0

Answers: 1

Truncate and Drop Data Movement tables from Cache database
answered 13-07-2018 04:37:13 -0400

Hello, How do I remove (Truncate then Drop) the Data Movement tables that have been created in the Cache database? These tables were created - in my example, MySQL - when I had clicked on the Data Movenment option in the Derived View Execution Plan. I...

Answers: 1

data movement tables Cache

Connecting to Twitter
answered 13-07-2018 04:17:04 -0400

Hi Team, Am wondering can we connect/get twitter data using denodo platform. Is there any reference document? Am working on some usecases to connect to any social media website using denodo. FYI,am using a licensed version of denodo. Thanks in advan...

Answers: 1

#HTTP #Post #Rest_API #webservice

RMI HOST setting error
answered 13-07-2018 03:24:22 -0400

HI Team While peroforming RMI Setting on LInux server I did below stpes . Intsalled Denodo 7.0 using below commands cd denodo-install-7.0/ chmod +x installer_cli.sh ./installer_cli.sh install Then I have Edited the file <DENODO_HOME>/...

Answers: 1

installation

Unable to establish connection: CLIENT_PLUGIN_AUTH is required
answered 12-07-2018 17:39:35 -0400

while connecting to MYSQL,when we test the connection it is givving following error- 'Unable to establish connection: CLIENT_PLUGIN_AUTH is required' What needs to be done to resolve thos issue.

Answers: 1

How to convert Julian date YYYYJJJ into YYYYMMDD
answered 12-07-2018 13:01:54 -0400

Hi I'm looking for a way to convert Julian date to yyyyMMdd format in Denodo. I couldn't find any reference to Julian date in Help. Appreciate your fast response. Thanks, Sathish Manthani

Answers: 2

#date #conversion #formatdate

Getting error Finished with error: Error deleting content for database <db_name> :Unknown column 'rowStatus' in 'where clause'
answered 12-07-2018 08:44:12 -0400

Hi, When I call the CALL CLEAN_CACHE_DATABASE stored procedure for a partiular database, I am getting the following error: Finished with error: Error deleting content for database &lt;db_name&gt; :Unknown column 'rowStatus' in 'where clause' I had Ca...

Answers: 1

CALL CLEAN_CACHE_DATABASE

data fabric
answered 12-07-2018 08:34:39 -0400

I want to explore and want to know how data fabric available in Denodo 7 is going to help users. We are relying mostly on snowflake as data source to fetch large amount of data, and hundreds of views are created on top of this source and other source s...

Answers: 1

data fabric