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

SQL Query Reference
answered 27-09-2019 02:20:20 -0400

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

Vertical pivoting
answered 27-09-2019 02:05:46 -0400

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

#array #customfunction

Caching Intermediate views
answered 26-09-2019 08:30:43 -0400

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

JSON Resource cannot be created due to problem with charset?
answered 26-09-2019 05:19:10 -0400

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


When use map function, the query plan change, query take much more cost
answered 26-09-2019 01:26:13 -0400

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

map query plan

What to use instead of ResultSet.TYPE_SCROLL_INSENSITIVE
answered 25-09-2019 12:00:57 -0400

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

row number Resu type_scroll_insensitive

Unable to use Power BI Denodo connector for views with column restrictions
answered 25-09-2019 08:58:07 -0400

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

Power BI

Create variable or custom date in denodo
answered 25-09-2019 08:08:21 -0400

Hi, In scheduler output file name, i'm looking to get yesterday's date. Currently we can use only 4 variables which are jobid, jobstarttime, projectname, jobname. So how can i get previous date as output file name. Or how to create a custom exporter fo...

Answers: 1

How to create map with query a view? where is my map
answered 24-09-2019 08:27:55 -0400

Hi team, I create a map with below and it can be used. CREATE MAP SIMPLE dates_test ( 20190701 = 2020091 20190702 = 2020092 20190703 = 2020093 ) Question is: I looked for all my database, I cannot found this map? where is located in? Also, since I have...

Answers: 1


Top-down update
answered 24-09-2019 08:19:56 -0400

I have understood that the bottom-up update (narrow black arrows in the picture) takes place in real time, but it is not so clear if the top-down update (fat red arrows in the picture) is possible, and, if this is the case, how? i.e. if an external a...

Answers: 1

scai finance