Q&A

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

No privilege to create database/users?
answered 02-06-2020 09:26:00 -0400

Hi, I am trying to create a new database with my user "admin" (default user), and a new user to assign different privileges, but I receive the message "Error accessing the metadata while loading/storing objects" Bear in mind i have a test licence DT...

Answers: 1

Administration Tool

Caching
answered 02-06-2020 08:20:28 -0400

Hi, I have partial caching enabled, and configuration is set on external database and allowed writing on the database. Also I exposed the view as a REST service. When I access the RET service it creates the table in the cache database but does not cach...

Answers: 1

Partial Caching

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