Q&A

Hi Team, Can Denodo 7 ODBC connect to Denodo 8 Server? Or it is a must to connect Denodo 8 with Denodo 8 ODBC? I mean both windows and linux. How about JDBC, for both windows and linux. Thanks.

SELECT DISTINCT pd.PROJECT_ID, vuc.ID, vuc.NAME, vuc.PARENT_ID, ( SELECT DISTINCT CASE WHEN vuc.NODE_LEVEL=2 THEN 'null' WHEN vuc.NODE_LEVEL=3 THEN vuc.NAME WHEN vuc.NODE_LEVEL=4 THEN (select mo.name from unit_code mo where mo.id= vuc.PARENT_ID) END FR...

I have created base view with the data type as 'ENDDATE' :'java.sql.Timestamp' (OPT) (sourcetyperadix='10', sourcetypename='TIMESTAMP(6)', sourcetypeid='93', sourcetypedecimals='6', sourcetypesize='11') SORTABLE. In my source date having milli seconds ...

Hi ALL, i am facing one issue , in one of the postgres table , i have data in datetime , when i am creating Base view and accesing data , the date is showing as '1970-01-01 12:11:11.000' but the date present in soure is '2020-01-01 10:11:00' Any help...

HI Denedo SME, I need help in installing Denedo platform on on premise / Local computer . (windows 64 bit ) machine. 1) I have laptop with windows64 bit , and 8 GB ram . 2) What are the Denedo tools / platform are required to installed on local com...

-- doubledecimalseparator should be '.' instead of '' DESC VQL MAP i18n us_pst Generated with Denodo Platform 8.0. DROP MAP i18n IF EXISTS us_pst CASCADE; CREATE MAP i18n us_pst ( 'country' = 'US' 'datepattern' = 'MMM d, yyyy h:mm:ss a' 'datesubtype...

Related to: Number of decimal places using i18n map

Hi, I want to write a VQL to get any field value from an array without flattening it. How i can do it? I know how to get a field value from register. example for register: SELECT (REGISTER_NAME).FIELD_NAME from VIEW_NAME If there is a way get field ...

Is there a way to get a result set that has the view, number of rows and the last cache refresh date? I want to make this a data set availbe easily to end-users to see when the cache was last updated. I have scoured the user documentation but do not ...

While calculating median. I am receiving the following error. [GROUPBY] [ERROR] java.lang.reflect.InvocationTargetException Received exception with message 'java.lang.reflect.InvocationTargetException' The logs are as follows: *ERROR 2021-05-31T09:38...

Good morning, Using Denodo express to test out several possibilities for generating base views for an IBM i we are looking at generating the VQL for parts of the base view and replacing those particular portions in the Denodo generating base view. Thi...