Latest Activity

code

Can Denodo 7 ODBC connect to Denodo 8 Server

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.

code

Can someone help me how to implement the below logic that uses sub query?

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...

code

Base view Milli Seconds Issue

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 ...

code

Denodo time issue

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...

code

Installation of Denedo platform on Local laptop

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...

code

Incorrect script generated by DESC for i18

-- 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

code

How to read field value from an array using VQL without flattening it.

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 ...

code

VQL to show all cached sources and when it was last refreshed?

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 ...

code

MEDIAN gives an error

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...

code

Error calculating the capacity

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...