Q&A

Denodo Data Catalog: Having Clause
answered 07-05-2020 11:51:01 -0400

Hi, Even though Denodo 7 provides HAVING clause for filtering conditions on the results returned by a query using the GROUP BY clause, this functionality is not available in the Data Catalog that diminishes the value of the queries. Any attempts to add...

Answers: 2
Related to: Oracle SQL to Denodo VQL Quick Reference

Group By Having Clause Data Catalog Denodo Data Catalog. Version 7.0

How to connect to Denodo VDP using Oracle SQL Developer?
answered 07-05-2020 00:37:41 -0400

Is it possible to connect to Denodo VDP 7.0 using Oracle SQL Developer client using Denodo JDBC Driver?

Answers: 1

JDBC

Denodo Data Catalog.v.7.0: Request for Having Clause
answered 06-05-2020 17:55:30 -0400

Denodo Data Catalog. Version 7.0 According to https://community.denodo.com/docs/html/browse/7.0/vdp/vql/queries_select_statement/having_clause/having_clause the Denodo 7 provides HAVING clause for filtering conditions on the results returned by a query...

Answers: 1

Having clause Data Catalog Denodo Data Catalog. Version 7.0 Group By

Error while connecting to Azure data lake storage GEN2
answered 06-05-2020 09:16:34 -0400

Hello Team, I am trying to create Datasource based on Azure data lake storage GEN2. Till i save all the configuration, it goes fine. When I try creating base view, it throws below error: There was an error while creating this base view: Error while e...

Answers: 7

OpenOffice Data Source Classeur ODS SXC
answered 06-05-2020 08:01:30 -0400

Hello, Can DENODO connect to a DataSource of OpenOffice likeCalc File with extension ODS or SXC ? tnx

Answers: 1

OpenOffice Classeur ODS DataSource

how to pass the query params to denodo as json HTTP client.
answered 06-05-2020 07:23:33 -0400

i have a requirement to connect the json HTTP client to denodo . the url looks like this: https://<servername>/excer/yhn?$format=json&filters=alud:%2210/1/2019%22 something like above.. please help me on how to execute the same in denodo. ...

Answers: 1

Delete flag option at exporter section Denodo scheduler
answered 06-05-2020 05:45:55 -0400

Hi , please I want to ask about the delete flag option at exporter section at Denodo scheduler ..as when I enable it , all rows deleted even the exporeted rows ? also I want to ask if there is option to delete the rows (which i extract it ) from source...

Answers: 2

Exporter section Job scheduler

Change Management
answered 06-05-2020 05:23:10 -0400

Does anyone have a change process mapped out which they can share. For example what steps do you follow if there is a change in the source system table / file. i.e. attribute added, attribute changed, attributed deleted etc.

Answers: 1

fail to export data from jdbc source to hhive
answered 06-05-2020 00:48:44 -0400

I try to export data from mysql into hive using denodo scheduler and I create the 2 tables same structure but when I execute the job error appears "Group0#JDBCExporter0: Document 1: Method not supported" ..any help why this happen ? full error 1929530...

Answers: 4

Job scheduler Denodo and Hive

Unable to login to server from client
answered 05-05-2020 07:25:55 -0400

Unable to login to denodo server from Denodo Client. Getting the Java Exception as below. Could you please assist on this asap ? "Initialization Error.Connection Error Construction, Implementing(Algorithm, Default Provider Sun JSSE, Class sun.securi...

Answers: 3

Java NoSuchAlgorithmException