Q&A

odata filter on array type
answered 07-01-2021 11:42:08 -0500

Hi, I am trying to use filter for array type column like below http://localhost:9090/server/tutorial/denodo-odata4-service/denodo-odata.svc/?$filter=srvlcdin_list={ ROW('') } Its giving error message as { "error": { "code": null, "message": "A col...

Answers: 2

OData ODATA

unable to perform crud operations in denodo 7.0
answered 07-01-2021 10:33:26 -0500

Query1: i tried creating insert update statments using create from query tab but not able to can anyone help me how to create insert update delete statements in denodo Query 2: I have macros in teradata and trying to migrate them to denodo, can someo...

Answers: 2

Convert CSV into rows without the use of SPLIT function
answered 07-01-2021 02:08:55 -0500

Hi experts, Looking for alternative ways of converting comma separated values into rows without using the SPLIT/FLATTEN function as we want to delegate this completely to an oracle source. Please let me know if any ideas. Thanks.

Answers: 1

Delegate FLATTEN Split

Plans for "insert into select"?
answered 06-01-2021 15:06:08 -0500

Just curious if you have plans to evaluate and implement the "insert into select" syntax that is standard on all RDBMS platforms these days? Often the insert into values() syntax is not enough since you need to select from another table. The above sy...

Answers: 5

vdp select

Getting error while creating diagnostic report in Diagnostic & Monitoring Tool
answered 06-01-2021 04:40:52 -0500

Hi Team, When you create a diagnostic report in Diagnostic & Monitoring webtool, a Diagnostic Database is created in VDP admin tool by default. I have to delete this Diagnostic database due to some reason. Now again I want to create diagnostic repo...

Answers: 2

denodo monitoring and diagnostic tool Denodo Diagnostic & Monitoring Tool

An error was found: java.lang.OutOfMemoryError: Java heap space
answered 06-01-2021 02:00:18 -0500

I am getting An error was found: java.lang.OutOfMemoryError: Java heap space on using export with option Include Jar Error Screenshot

Answers: 2

Export

Rest Webservice Failling
answered 05-01-2021 21:52:07 -0500

Hi, I am using the sample stored procedureCalculateAvgRevenue .I created a rest webservice. Below GET works http://localhost:9090/server/tutorial/p_getrev/views/p_getrev?taxid_list={ ROW( '1') } But POST with X-HTTP-Method-Override is throwing error Th...

Answers: 2

REST REST Webservice

prise en main de zeppelin pour Denodo
answered 05-01-2021 09:12:12 -0500

Bonsoir je voudrais savoir comment accéder à une vue dérivé créer dans Denodo à parti de zeppelin dans l'optique de la gestion de la qualité des données? Et comment accédé, appliqué les outils de gestion de qualité des données donc disposent Denodo sur...

Answers: 1

5

Fetching Column issue in VQL
answered 05-01-2021 05:39:50 -0500

we have SAP Data Base, when we excute the base view in the denodo tool we could able get the 150 records. But, while excuting in the VQL shell for the specific Query like Select <Column_name> from <data_base>.<Base_view_name> throwin...

Answers: 1

VQL SAP DENODO SAP BW/4HANA

Dynamic Base View based on another Base view (not JOIN)
answered 04-01-2021 12:18:07 -0500

Hi, I need help with a very specific use case. I have 2 different data sources and I need to create a base view from source A filtered by some values from another base view coming from source B. This values in the second view would be a hole column, ...

Answers: 5

Dynamic Interpolation Variables Create Base View join