Q&A

Parameterizing GET_STATS_FOR_FIELDS Scheduler job to automatically refresh the stats for all enabled views.
answered 03-06-2022 05:25:18 -0400

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

Answers: 2

Gather Statistics Denodo Scheduler 8.0

Base view gets created from query, however, cannot execute it.
answered 02-06-2022 19:59:32 -0400

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

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

Base view baseview created from query Create Base View

Posting the data to API
answered 31-05-2022 11:48:48 -0400

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

Answers: 1

Extended support for database
answered 31-05-2022 06:00:01 -0400

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

Answers: 1

Azure chache

Add Column Description doesn't work with UNION
answered 31-05-2022 05:03:40 -0400

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

Answers: 1

COLUMN_DESCRIPTION UNION

Add Column Description doesn't work with UNION when appending record
answered 31-05-2022 05:01:43 -0400

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

Answers: 1

COLUMN_DESCRIPTION UNION

Error connecting SQL Server to Denodo Testing Tool
answered 30-05-2022 07:58:00 -0400

Hello Support Team, I'm trying to connect Denodo testing tool to SQL Server Db and seeing below error: Error creating data source MSSQL. All the connection details are provided correctly in the configration file and yet I see the same issue. What c...

Answers: 1

Charset encoding error when creating base view over HTTP Client JSON connection on Denodo
answered 30-05-2022 04:05:16 -0400

Hi, I am trying to create a base view over HTTP GET connection on JSON Datasource, test connection is fine and it is coming from api of denodo scheduler. I tested it on local envinorment it works ok with no errors but on Client environment it is throw...

Answers: 4

#HTTP#GET#JSON#CHARSET

Has anyone had success integrated a VCS like GIT and Azure Devops and performning DevOps like deployment practices? Ideally, i would be able to initiation a build and release using git and deploy without any user interaction.
answered 27-05-2022 09:15:55 -0400

Hi Team, I would like load latest VQL file from git and want to automate the deployment with denodo is it possible?is any plugin identified for the same. or i want to create vql file and deploy same in to different env like dev,qa, prod how we can a...

Answers: 1

Devops

[JDBC ROUTE] [CONNECTION_ERROR] Unexpected error creating a connection
answered 27-05-2022 09:09:34 -0400

Finished with error: Error executing query. Total time 0.422 seconds.QUERY [PROJECTION] [ERROR] AR_10_ASSETCLASSDESCRIPTIONS [BASE] [ERROR] AR_10_ASSETCLASSDESCRIPTIONS [ODBC WRAPPER] [ERROR] AR_10_ASSETCLASSDESCRIPTIONS#0 [JDBC ROUTE] [CONNECTION_ERRO...

Answers: 1