Q&A

ReST API Dynamic end point
answered 09-09-2020 14:04:46 -0400

I need to execute the First Endpoint and get the results Using the results of the First URL (ID) need to execute another call to get the corresponding data. First Call example https://company.data.com/api/metaproperties/ ID ABC CDE EFG Second Call e...

Answers: 2

REST API REST

Insert a field in a SQLServer with DEFAULT value
answered 09-09-2020 08:29:04 -0400

Hi, How i insert a field in a SQLServer with DEFAULT as the value in the timestamp in write back? I need insert in Sqlserver table a field like that: catalogo_id = 'CATALOGO_ID' :'java.sql.Blob' (OPT) (sourcetypesize='8', sourcetypeid='-2', sourcetyp...

Answers: 1

BLOB

ERROR: 666 : Memory quota too low for aggregation
answered 09-09-2020 08:09:10 -0400

ERROR: 666 : Memory quota too low for aggregation i am getting this error while running the view, all the memory setting are correct as per the denodo guideline. Please suggest

Answers: 1

memory low

parameterized query in Data Catalog
answered 09-09-2020 07:45:18 -0400

Can we have parameterized query in data catalog ? Basically when a user logs in and try to access data or export data from a derived view, they will be given option to enter value for few off the fields within the view as a filter ? but not like where...

Answers: 1

#Query #data catalog

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