Q&A

You must sign in to ask a question. If you do not have an account, you can register here

Error saving view: Syntax Error: Exception parsing query near '*'
answered 08-02-2022 04:04:27 -0500

Hello, I am working through the lab LAB Create an Aggregation View (DEN80EDU12D08LAB01). When I get to step 5 Specify a where condition to filter the data using those parameters: to_localdate('yyyy-MM-dd''T''HH:mm:ss', bv_sales_all.saledate) between s...

Answers: 1

Syntax error

Denodo service timeout issue or slow response.
answered 08-02-2022 02:32:03 -0500

Can we compress a large content coming out as a response. Because we are facing timeout issue. Would request you to provide some assistance.

Answers: 1

#salesforce #performance #optimization #timeoutissue

JSON Data source optional parameter for GET request
answered 08-02-2022 02:27:23 -0500

How do we have an optional paramter defined for JSON datasource GET URL? like for mandatory paramter we can add @{paramter} part of URL.

Answers: 1

ODBC with OAuth2
answered 08-02-2022 01:48:34 -0500

Hi, We want to configure an ODBC with OAuth2 on Windows, with an OAuth Server which exposes the grant type Authorization Code. In the ODBC configuration > Advanced Options > Page 3 > OAuth 2.0 settings > Extra parameters, we set : grant_...

Answers: 1

Denodo 8 ODBC oauth2

Is it possible to track when a view was dropped?? or by who?
answered 07-02-2022 08:01:37 -0500

Hi Denodo team, Is it possible to track when a view was dropped?? or by who? I know we can see when was created or modified and by who but for drop objects?? is there a log or something for that? Also when a promotion is deployed in other environments...

Answers: 1

automate status check in linux
answered 07-02-2022 07:23:19 -0500

how to - Automating status check of Denodo services - in linux environment

Answers: 1
Related to: Automating status check of Denodo services

Getting py4j.protocol.Py4JJavaError: An error occurred while calling o65.jdbc. : java.sql.SQLException: Unsupported type TIMESTAMP_WITH_TIMEZONE
answered 07-02-2022 07:08:58 -0500

I am making JDBC connection to Denodo database using pyspark. The table that i am connecting to contains "TIMESTAMP_WITH_TIMEZONE" datatype for 2 columns. Since spark provides builtin jdbc connection to a handful of dbs only of which denodo is not a pa...

Answers: 1

JDBC Spark Spark-sql connection

Problem with Amazon Athena Cache
answered 04-02-2022 07:00:37 -0500

Hello, We have Denodo VDP 8.0 running in a Linux server. We add Amazon Athena Cache and we have a problem when try to store results in cache. The logs registered: FATAL YYYY-MM-DDTHH:MI:SS.FFF com.denodo.vdb.engine.thread.ReusableThread [] - runWork ...

Answers: 1

Cache Error AWS S3 Athena athena Athena AWS athena Cache

Denodo express with presto compute
answered 04-02-2022 05:13:38 -0500

Hi Denodo team, How can I update my express edition to include latest Denodo offering that includes embeded presto compute?

Answers: 1

How to pass Variable from report to derived view
answered 03-02-2022 06:54:25 -0500

I need to pass a parameter from report (e.g. power BI,BO) to derived view. how do you achieve this?

Answers: 1

#parameters