Q&A

Query to AWS Athena
answered 02-06-2020 08:04:38 -0400

Do the Denodo query optimizations (aggregation pushdown etc) works with AWS Athena?

Answers: 1

AWS S3 Athena

Errors with ODBC client connection from SQL Server Polybase
answered 02-06-2020 03:49:04 -0400

Hi-- My use-case requires me to establish a Polybase connection from SQL Server using ODBC driver. I have successfuly followed instructions on: https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-odbc-generic?view=sq...

Answers: 4

ODBC

Error removing JAR: Error loading User(XXXXXX)
answered 01-06-2020 09:41:49 -0400

Hi, I used the custom policy code provided in samples and added a user check and query contains check. Now i cannot delete the jar from jar management and get errors. Error removing JAR: Error loading User(XXXXXX) What is the solution for this? Than...

Answers: 4

custom policy Denodo 6.0

Incremental cache implementation in denodo
answered 01-06-2020 04:23:27 -0400

Hi Team, Our source is a custom java API using custom java wrapper, we have made couple of views in denodo. These views are cache'd everyday using scheduler jobs. After vdb cache job ran, we have set of vdb scheduler jobs which will export the cached d...

Answers: 1

Incremental Cache

Implementation process
answered 01-06-2020 03:58:14 -0400

All, Could someone please help me get an idea of what the implementation process is like when buying Denodo? Are there a lot of professional services fees required? Thanks.

Answers: 1

implementation onboarding professional services

Text (timestamp) to date
answered 01-06-2020 03:55:21 -0400

Hi. My view has a field with timestamp. Although, the field type is "text". I really only want to get a date from the field, but I don't know how. Here is an example of the text field: 2019-12-21T13:15:49.000-0600 2019-10-02T15:01:43.000-0500 I need ...

Answers: 2

Date Conversion Timezone conversion Dates Date

Create new date field from a timestamp
answered 01-06-2020 03:45:27 -0400

Hi. I have two views in Denodo (in different datebases). I want to join the two on date (and another ID). However, the views do not have date, they only store timestamp. I want to get just the date from the timestamp in both views and join them. Here ...

Answers: 2

Date timestamp

Mircrosoft Ajax Date Format
answered 29-05-2020 05:38:18 -0400

Hello, I have a Json Data source configured to get data from external application. I am seeing the data . But there are 2 cols, Updated At and Created At. values in those columns are coming in the format /Date(1589932800000)/ I tried creating a new f...

Answers: 3

JSON Data Source

Metadata from source system
answered 27-05-2020 14:34:47 -0400

How will be the metadata be brought in to the Denodo from source system? Esp the semantic information.

Answers: 1

Run Scheduler Job Based on Value from a Query
answered 27-05-2020 08:21:52 -0400

Hello, Is it possible to allow a Denodo Scheduler job to start only when the value returned by a query indicates it is ok for the job to start? The scenario is as follows: We want to cache a Denodo view. However, before we can start the cache job, we...

Answers: 1

Conditional Job Run Scheduler