Latest Activity

code

VQL Shell count() discrepancy

Hi Team, We are getting less count from VDP VQL Shell than actual count. Example: VDP Admit tool: select count(*) from myview; count 300; if we execute the view retrieve all rows, count is 1000.

code

Denodo express- access from different machines

Hi, I have installed Denodo express 8.0 on Windows VM. Now I want to access it from a different machine, is it possible? If yes, how?

code

Order to start/stop denodo services

Hi, What is the best order to start/stop denodo services for Denodo 7.0?

code

How to enable JDBC logging?

According to Enabling JDBC Logging, logging can be enabled e. g. using loggerLevel=FINE&loggerFile=c:/vdpjdbc.log. However, this results in: java.sql.SQLException: Invalid parameter: loggerLevel at com.denodo.vdb.jdbcdriver.VDBJDBCDriver.conn...

code

How to write this If/Then function?

hello, I'm trying to write a field expression. here's are the assumptions. The data has an id, a date1, and a date2 I want the login to look like this: Max(if(id = NULL, NULL, date1),date2) So, what the max of two dates, but use the first date only ...

code

Unable to establish JDBC connection in Denodo with Snowflake

Hi . I am trying to establish JDBC connection with Snowflake. In the username and password field I am entering my Snowflake Username & password. When I enter the username and password I am getting a message which says: " Unable to connect to the da...

code

Gather Statistics for views built on top of external APIs

Hi team, Is there any recommendation on when to collect the statistics? I am building views on external APIs so is it recommended to collect stats on those views? Thanks!

code

denodo view name maximum length

I can not find the maximum limit for denodo view name anywhare. We want maximum charecters denodo supports for view naming for denodo 7.0 Appreciate your help.

code

Source Refresh not working on web Virtual DataPort

Hi, I have some columns that didn't change in my source, but they weren't in my base view because I didn't need them before. But now I need so I want to update my baseview and add that columns. A coleague of mine has the virtual dataport application an...

code

Bit datatype transforms to boolean in denodo base views

I have one scenario where one of the fields from the source(MSSQL) is a bit datatype while creating a base view in denodo it gets transformed into boolean datatype. Users want to see the results in 0/1 instead of true/false. Even end user application...