Q&A

Filtering Left Outer Joins with Automatic Simplification of Queries enabled causing execution plan to be complex
answered 10-09-2020 08:38:26 -0400

My development team is seeing strange behaviour with Denodo execution plans when using left outer joins and filters. We have a query that has multiple left joins to get data from a lookup table. When we execute the query, it takes approximately 20 se...

Answers: 1

Filter left join Query Simplification

Invalidate Cache
answered 10-09-2020 07:58:04 -0400

I had Full cache enabled for 3 views, they were scheduled to run everyday. But because of the large quantity of data, the temporary cache tables became too large and the jobs started failing citing lack of space as the reason. So I invalidated cache f...

Answers: 1

create a base view from Dremio data source, different sourcetypeid value for the same column of this base view
answered 10-09-2020 06:18:47 -0400

Hi Team, we are connection dremio data source to create base view, we found for the decimal column in source, such as decimal (10,0), deciaml (6,0), the sourcetypeid show different value in waprrer and table difinition, see below generated vql from dre...

Answers: 1

sourcetypeid value Dremio source

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