Q&A

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

Denodo MongoDB Base Base View Creation
answered 10-09-2020 04:11:25 -0400

HI Team, I'm trying to create base view from a mongodb datasource using Connection String(host:port/database) and Collection fields as wrapper parameter values but I'm facing the error "There was an error while creating this base view: Error while exec...

Answers: 9

mongodb

Store logs in csv format S3
answered 10-09-2020 04:03:05 -0400

Hello, I have set up the log4j.xml file to store the VDP-queries log to S3 location. I can see that the files stored are in an unreadable format. Can you please let me know if I can store them in csv format? I have followed the below link to set it up...

Answers: 1

AWS S3 query logs logging log4j2.xml

Denodo consuming Impala array datatype
answered 10-09-2020 03:13:47 -0400

We are trying to connect to a Impala table through Denodo. We are able to connect to Impala and see the underlying table. However when we create a base view, the "array" field in underlying Impala table is coming as "text" field. For example below "tes...

Answers: 3

Impala

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