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
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
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
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
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
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
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
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
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
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