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
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
Is there any possible way to post the denodo data dynamically into an API?
Answers:
1
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
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
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
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
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
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
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