Hi i have installed Denodo software and can see Denodo shortcut icon on the desktop screen. However when i double click the icon nothing happens, also i tried clicking the icon in the actual location folder and nothing happens, i mean Denodo does not s...
Answers:
3
This error message is sent when executing queries against two joined sql tables: QUERY [JDBC ROUTE] [ERROR] Received exception with message 'Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in th...
Answers:
3
For an API, can I query by multiple values? Example, if I have multiple employees, how can I write a queryable API to handpick a few employee's ?employee_id in '02019590, 02019592, 02019593' does not seem to work.
Answers:
1
We have a customer who is trying to use our software to query via ODBC a Denodo virtual database. Apparently something about the way we format the SELECT statement is not liked by your query engine. Where can I find a reference on your SQL query lang...
Answers:
1
Hi Team, Is there a way to do vertical pivoting in denodo? I have one data element which is a combination of 3 fields basically seperated by ~. Example: abc~dfv~1234 cvfdv~as~23 So the first seperation till ~ belongs to field A, second part belongs to...
Answers:
1
We have a requirement to cache an Intermediate view and it should never expire. We don't want it to be done manually for every single run. We need to implement it permanently. How do we do it in VDP or VQL Shell? We tried doing it by ticking the check ...
Answers:
1
When creating the base view of a new JSON resource I get this error: ( ISO-8859-1) Unable to obtain the data structure: com.denodo.util.exceptions.InternalErrorException: Unexpected character ('' (code 173)): expected a valid value (number, String, ...
Answers:
3
I create a map manully and want to use this map to finish some augument convert, yes the augument can convert, but the query plan changed, the query take much more cost: select count() from AA where "WID" = 2020092 select count() from AA where "WID" = ...
Answers:
2
I am aware that ResultSet.TYPE_SCROLL_INSENSITIVE is not supported by denodo currently. Do you have a suggestion as to what I can use instead to retrieve the row count of the result set?
Answers:
3
We are utilizing 7.0, update 20181011. Power BI users that do not have access to all columns of a view are unable to utilize the Denodo connector. They see an error due to the fact that not all of the columns can be projected and they can not get to th...
Answers:
3