Q&A

How to convert a date and time to another format?
answered 09-09-2020 05:51:13 -0400

Hi! I would like to know how to convert a column with a date format such as dd/MM/YYYY 12:00:00 a.m to a format where only shows "dd/MM/YYYY". I have used the function FORMATDATE('dd/MM/YYYY, datecolumn) and although it gives me the format that I want ...

Answers: 1

Timezone conversion Dates Questionable

vql shell command to VCS commit and VCS push?
answered 08-09-2020 04:42:42 -0400

Hi team, I understand we have VCS vql shell command for pull (DVCSPULL DBELEMENTS database_name), do we have the same for VCS commit and VCS push operation?

Answers: 1

vql shell VCS push VCS commit

Revision Type Description
answered 07-09-2020 09:01:54 -0400

Hi Team, We have fetch the details of of the solution manager for athe database of denodo. In that we have found that the in Revision. The Revision type is give as 1,3 etc. As Revision type are mentioned in the solution manager are like "Create" etc. ...

Answers: 1

SolutionManager

Different execution plans at design studio
answered 07-09-2020 08:31:31 -0400

Hi, please I want to ask how to get multiple (alternative) execution or query plans at design studio at version 8?

Answers: 1

design studio Execution plans Denodo Query Exceqution Plan

Denodo write back in SQL Server table
answered 07-09-2020 04:08:54 -0400

Hi, When i try to insert rows in sqlserver table with vqlshell in a table with field (NOT NULL) :TIMESTAMP i receive a 'Error executing view. Received exception with message 'Cannot insert an explicit value into a timestamp column. Use INSERT with a c...

Answers: 1

Row_Number() against Derived view
answered 04-09-2020 19:55:24 -0400

I have a final view which has been derived from two different data sources MySQL and Postgres. I have cached the derived view. and underlying cache DB is postgres. it supports the row_number function When I execute the 'row_number()' function in the ...

Answers: 1

anaytical_function row_number

Enable 2FA for Denodo
answered 04-09-2020 18:09:03 -0400

Can we enable 2 factor authentication for login to Denodo Data Catalog and VDP Admin tool ? If not both then either of them ?

Answers: 1

#2FA

json_object_agg
answered 04-09-2020 08:21:05 -0400

What is the equivalent for postgres function json_object_agg(name, value) function in Denodo ?

Answers: 1

json_object_agg JSON

Get the host name in VQL
answered 04-09-2020 08:10:06 -0400

Hi, I have a load balanced infrastructure, and would like to get the name of the node which is answering to my query. Something like select hostname() from dual Is it possible directly in VQL?

Answers: 1

Email notification on scheduled job failure
answered 04-09-2020 06:14:19 -0400

How to setup notification for any job failure scheduled via Denodo Scheduler ?

Answers: 1

#Scheduler #Email #Notification