Stack Overflow
Stack Overflow

Questions tagged [denodo]

The Denodo Platform is a middleware software platform for the (virtual) integration of data of diverse natures coming from several kinds of sources (databases, web, delimited files...). This software can be applied in scenarios like those involving SOA, Web automation or Web crawling.

The Denodo Data Services Platform is an enterprise Data Virtualization, Data Federation and Cloud Data Integration middleware that uses a declarative approach to abstract, unify, federate and understand disparate data sources and systems, supporting multiple acquisition and delivery modes and latency requirements, as well as a rich set of easy to use data transformation, data federation and data mashup capabilities.

100 questions
1
vote
1 answer

CASE** returns the result of the **first**

I am trying to do some case statement in my SQL. Below example shows what I want to do. Example case WHEN p = 1 THEN 'SOMETHING' WHEN p = 1 AND q = 1 THEN 'SOMETHING ELSE' Here, CASE returns the result of the first WHEN clause that evaluates…
Nirav Patel
  • 1,297
  • 1
  • 12
  • 23
1
vote
0 answers

passing query param to REST service which is dynamic in nature in denodo

I need to call REST API from DENODO (I use denodo express 7) with dynamic query param. This query param value would come from another JDBC data source view so that I can straightaway limit the results. I have tried using interpolation variables, for…
Devendra S
  • 13
  • 3
1
vote
1 answer

Split function in Denodo does not work! (second way) Regex for complex string in Denodo

I am basically trying to split the following string in Denodo and trying to create new columns in the database for each value. my_string = ABLMNC_154342_O_UW_UA-UCOU_SMC The problem i am facing is when i split the string, Denodo creates an array.…
ashubhargave
  • 230
  • 2
  • 14
1
vote
1 answer

NULLS LAST flag in Denodo, MemSQL, Spark, VectorWise, and XtremeData

I am doing a pseudo-ORM for a personal project, and I'm compiling a list of compatibility checks for the 20+ different SQL dialects out there. Currently, I am doing research on whether a dialect supports the NULLS LAST flag, i.e. when sorting a…
theGreenCabbage
  • 5,197
  • 19
  • 79
  • 169
1
vote
1 answer

How do I install the Denodo OData service in the embedded tomcat container in Denodo 5.5?

I'd like to install the custom OData service into the embedded Tomcat web container in Denodo 5.5. I've found that the instructions Denodo provides are somewhat confusing, and thus I'm posting to stackoverflow and including the answer in hopes…
Colorado Techie
  • 1,302
  • 1
  • 13
  • 21
1
vote
1 answer

Will Denodo support jsonp or CORS

I have a denodo returning json data. My tomcat domain is different than that of the the denodo domain. I do not have much idea if denodo would support jsonp or CORS. If it doesn't support I need to go with more traditional approach of proxy servlet…
user525146
  • 3,918
  • 14
  • 60
  • 103
1
vote
1 answer

How do I enable HTTPS for the embedded tomcat in Denodo?

I'd like to enable https for all my incoming web requests to Denodo using a self-signed certificate. How do I do this? (Denodo comes installed with an embedded JRE and Tomcat) (I'm posting this question and including the answer in hopes that…
Colorado Techie
  • 1,302
  • 1
  • 13
  • 21
0
votes
0 answers

Denodo on RHEL 7 without gui

How to install Denodo on rhel7 CLI without GUI? i have installed it using denodo_installer_cli.sh on rhel7 and it was successful. it is throwing an error x11 variable not found. while i run the script denodo_platform.sh. all the requirments has…
Himanshu Tripathi
  • 1
0
votes
0 answers

Denodo throwing error "The field properties can only be specified for derived fields" on a job while altering column description of columns

I have created a job in denodo to update column descriptions of all the views. All the information related to views are stored in glossary only.We have created a view on top of this glossary datasource.We are then creating a view which contains a…
Catherine Babu
  • 1
0
votes
1 answer

Denodo column DISTINCT values concatenation

I'm looking for ways to concatenate two or more row values using the "|" separator. I found and used the GROUP_CONCAT() function, but it doesn't work for me using the "DISTINCT" clause. Here is an example of a working and non-working query: Working…
Rahul Hendawe
  • 902
  • 1
  • 14
  • 39
0
votes
0 answers

"Unable to detect database type" error while connecting to Denodo from Spring boot

I am trying to connect to Denodo 8 using spring boot. I have configured below properties in the test.yml file. During the application startup, I see the error - "java.lang.IllegalStateException: Unable to detect database type" and application fails…
Rohith
  • 1
0
votes
2 answers

`Function 'stdev' with arity 1 not found` in mysql (denodo)

I have a problem with calculating STDEV in mysql (denodo) Here's the code: select STDEV(amount) OVER (PARTITION BY customer_id ORDER BY datetime ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING) from my_table where And this is the error I…
aew aew
  • 1
0
votes
0 answers

Npgsql in C# can not execute large queries

I have a .NET 6 C# console app connected to Denodo using Npgsql. The main task is just to pull data with SELECT using different queries. Now I'm facing an error with one of the largest queries with 29K lines (it's big because it has some mapping to…
MarioG
  • 25
  • 1
  • 10
0
votes
1 answer

Temp Tables and Looping VQL/Denodo question

Suppose I had a query that would return something like this, except 1000 of records. lets call this EncounterTable EncId | StartDate | EndDate | Weight 1 1/1/2022 1/4/2022 .5 2 12/28/2021 …
DapperDanh
  • 555
  • 2
  • 5
  • 17
0
votes
1 answer

SQL - How to parse out data with multiply values in single column with separated pipe delimiter

I need a way to parse out data that contains multiply values in the same column. The values are separated by pipe delimiters. Any help on how to achieve this in SQL would be great. Current Table: ''' Expected outcome needed: '''
Alan Paul
  • 91
  • 6
1
2
3 4 5 6 7