Q&A

I have imported views however it's not visible in the main home screen I saw that when I went to "Administration >> sync with VDP" I was able to see those views however when clicked on them I got "Internal error while executing operation!"
answered 13-05-2022 09:02:22 -0400

I have imported views however it's not visible in the main home screen I saw that when I went to "Administration >> sync with VDP" I was able to see those views however when clicked on them I got "Internal error while executing operation!"

Answers: 1

Data Catalog

Imported views not visible in Denodo Catalog
answered 13-05-2022 08:57:38 -0400

I have imported 195 views from .zip in data catalog module however I am not able to view them in data catalogue

Answers: 1

Denodo data catalog

Denodo & AWS DMS
answered 12-05-2022 09:27:56 -0400

Hello: Can I use AWS DMS to replicate data from Denodo to S3 bucket or into Snowflake ??? Any help is greatly appreciated. Thanks

Answers: 2

AWS

How to multiply rows based on some numbers
answered 12-05-2022 06:45:28 -0400

Hello! I'm new to SQL world and Denodo community as well. What I'm trying to do is to multiply rows by month gap as below. I've been looking for this for hours.. Result 1 | User | Account | Product | Column D | Start Month | End Month | | XXX | Pau...

Answers: 3

Moving Denodo Cache Database
answered 12-05-2022 05:40:56 -0400

Can we move Denodo Cache Database to another server without interrupting Denodo's operations?

Answers: 1

Cache

Convert a number to an INTERVAL DAY TO SECOND
answered 11-05-2022 08:19:48 -0400

Hello, Is there any possibility to achieve in Denodo something similar to NUMTODSINTERVAL Oracle function? select NUMTODSINTERVAL(0.6, 'DAY') from dual; Thank you in advance!

Answers: 1

Date time function

Migrating tags to higher environments
answered 10-05-2022 11:34:31 -0400

How can we just explicitly migrate only tags to higher environments?

Answers: 1

Migrate Tags

Check if Value in Array
answered 10-05-2022 08:27:46 -0400

Hi, I have to check if a string is a substring of a longer one. Trivially this would lead to INSTR which doesn't work in this particular case as some of the strings to look for are substrings of others (eg. 'abc', 'abcde', ...). The long string is deli...

Answers: 1

Array

(Additional Question) Is it possible to CUD (Insert/Update/Delete) in denodo query editor ?
answered 09-05-2022 12:18:08 -0400

Hi, You've answered like this https://community.denodo.com/answers/question/details?questionId=9064u000000wkIHAAY&title=Is+it+possible+to+CUD+%28Insert%2FUpdate%2FDelete%29+in+denodo+query+editor+%3F I'd tested CUD in Impala with Kudu Table. but...

Answers: 1

Impala

Connection reset by peer - From log
answered 06-05-2022 12:23:30 -0400

Here we are having 1 functional account of519143, and part of onecdp_dev vdb, whenever we were trying to connect with VDP admin tool or web services, we were getting 1 error, and from the logs we extracted the error, can anyone help on this to understa...

Answers: 1

Connection reset