Q&A

Can the Built-In XSLT Transformations capabilities be used to generate highly formatted, dynamic query, PDF documents?
answered 25-02-2021 07:27:11 -0500

We need to generate formatted documents from data in our SQL database including images. A parameterized query is used to access the data set for each document to be created. Can the Denodo built-in XSLT transformations capabilities be sued for this pur...

Answers: 1

PDF XSLT

Order of records getting changed
answered 25-02-2021 05:01:54 -0500

Hi Team, I have teradata storedprocedures which has update statment when i execute the restAPI by updating a record then the order of rows are getting changed example: before updation: ROW1 ROW2 ROW3 ROW4 After updation: ROW3 ROW1 ROW4 ROW2 etc like a...

Answers: 1

Query memory Usage: need to find a better alternative to handle large queries
answered 25-02-2021 01:51:35 -0500

Hi, Settings of memory usage: Maximum query size: 200 MB swapping status: ON Max size in memory of each node: 50 MB Max size of blocks stored: 200 KB There is a view which is using more than the specified memory. We don't want to increase the memory ...

Answers: 1

Setting CONTEXT ('formatted' = 'yes') as default?
answered 24-02-2021 07:44:43 -0500

Is there a way I can have the system, by defult, add "CONTEXT ('formatted' = 'yes')" to the end of a derived view when I use the VQL Shell to create views, instead of having to write it out at the end of every script?

Answers: 1

VQL vql shell context formatting

Filter in Association
answered 24-02-2021 07:30:09 -0500

We are using denodo 8, for Rest webservice we are using associations. Below is the exam URL: <URL> Question we have is, how can we use filter on associations used here bv_empl_class_abstraction_vw_role and bv_address_employee_abstraction_vw_...

Answers: 3

Denodo unable to fetch all the records for an entity which contains different Schemas file extensions for the parquet files from S3
answered 24-02-2021 06:15:56 -0500

Hello, I tried to create a base with file pattern (.) for the parquet file entity/table in s3 region. Then, when i excute the count query to fetch all the recodrs in the entity.I could able to get the below mentioned error. Finished with error: Error ...

Answers: 3

custom S3 HDFSCustomWrapper; S3 DENODO AWS S3 Create Base View

Condition controls in the base view of a custom wrapper connector
answered 23-02-2021 07:09:19 -0500

I limited the allowed operators to “=”, “>=”, and “<=” by overriding the getConfiguration method with CustomWrapperConfiguration configuration = super.getConfiguration(); configuration.setAllowedOperators(new String[] { CustomWrapperCondition.OPE...

Answers: 1

Custom Connector custom wrapper

vql to get only the exact database URI for data source in Denodo
answered 23-02-2021 00:23:51 -0500

HI team, do we have some system table, or vql command, which get only the exact database URI for a Denodo data source, for example we only want to get below kind of information: jdbc:oracle:thin:@aassddcc.compant.com:6566/aassddcc I understand we have...

Answers: 3

vql database URI

Error while launching Denodo Monitor - Failed to invoke from(CompositeData)
answered 22-02-2021 09:54:57 -0500

Hi, I’m making tests using Denodo Express 8.0 for Windows 64 bits. I need to trace the queries done by each user and i want to check that Denodo Monitor can give me all the needed information. I followed this instructions : https://community.denodo.c...

Answers: 2

Denodo Monitor

Same Query Returns different number of records in Baseview and Derivedview
answered 19-02-2021 07:29:38 -0500

Hello Team, I have created 2 baseview(bv_studies, bv_results) of dfferent sources in Denodo. After that, I have created one derived view(dv_final) from these baseview with Inner Join. I am passing 2 parameters to bv_studies. Now the problem is, while ...

Answers: 4

Quary execution Baseview derived view