Q&A

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

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

How does "Case sensitivity in comparison of literal strings" work in Denodo? I am getting the same results for Uppercase and lowercase strings.
answered 04-01-2021 08:59:13 -0500

I am implementing a search module on Denodo REST API. When the users perform a search, they are likely to use lower case for all their search terms. However, if it is case-sensitive, if the search information was spelled with an uppercase in our system...

Answers: 2

REST API REST search

Error while creating a project in Eclipse
answered 04-01-2021 06:29:09 -0500

Hi I'm trying to create a new project in eclipse after installing the denodo4e software successfully, but its giving me an error saying wizard cannot be started. Please help me on this as my teams development activities are getting delayed because of...

Answers: 1

Denodo stored procedure Custom stored procedure