Latest Activity

code

Month integer to Month name

I have a column with values of month numbers called "month" 01 02 03 I want the results to be of months name Jan Feb Mar, How to achieve this

code

Access to Solution Manager and VDP for workling with Design Studio

Hi, i am using the denodo proffesional free trail on AWS during my registration ( helped by youtube-video and denodo page) i managed all and can now log in to the design studio can i also get free access to the solution manager and the data virtualisat...

code

How can I rename a REST web service?

How can I rename a REST Web Service I created in Denodo?

code

Services fail to start, referring to wrapper.startup.timeout

The Denodo 8 services failed to start on a Windows 2019 machine (startup type = Automatic). When looking at the logs, I found the following message: WARNING|7680/0|22-06-01 12:10:45|startup of java application timed out. if this is due to server over...

code

Parameterizing GET_STATS_FOR_FIELDS Scheduler job to automatically refresh the stats for all enabled views.

Hey, we are trying to use GETSTATSFORFIELDS in a Scheduler job to automatically refresh the stats for all views with statistics enabled. With LIST VIEWSTATSUMMARIES on myVdb I can get a list of all the views in the VDB, that have statistics enabled. N...

code

Base view gets created from query, however, cannot execute it.

I am able to create a base view from query, and do not get any error messages when creating it, given the instructions. However, when I attempt to execute it, I get following error message. Code is fine, and it runs with no issues and returns results, ...

Related to: Invalid query error using Create base view from query

code

Posting the data to API

Is there any possible way to post the denodo data dynamically into an API?

code

Extended support for database

Planning on the Denodo platform on the Azure platform. However, in the service provided by Azure, Database is not listed as official support. example ・Azure SQL Database ・Azure Database for PostgreSQL ・Azure Database for MySQL etc... Reference:List ...

code

Add Column Description doesn't work with UNION

I am trying to append a specific record to a derived view with UNION. The view can be created without DESCRIPTION. But when I do CREATE OR REPLACE VIEW xxx DESCRIPTION = 'xxx' (columnname (DESCRIPTION = 'xxx')), it will give me an error saying the firl...

code

Add Column Description doesn't work with UNION when appending record

I am trying to append a specific record to a derived view with UNION. The view can be created without DESCRIPTION. But when I do CREATE OR REPLACE VIEW xxx DESCRIPTION = ‘xxx’ (columnname (DESCRIPTION = ‘xxx’)), it will give me an error saying the firl...