Latest Activity
I want to create a VDP job in scheduler which must keep retrying unless the column returns a row which is equal to CURRENT_DATE() select count(*) from Table where Date_Column = CURRENT_DATE() This query must get completed in scheduler only if the cou...
I have a scheduled VDPCache job which starts every Saturday at 12:00. The actual databases from where the cache data gets loaded will undergo a weekend processing and gets new data. Sometimes this processing will takes long time than expected. If I kee...
I have a scheduled VDPCache job which starts every Saturday at 12:00. It invalidates the data for All Rows and load the cache every weekend . This makes the Cache Database keep a lot of invalidated data which is of no use and the disk space consumption...
Hello, I am trying to run VDPCache jobs in the Scheduler. For a particular table, I gave the parameters for year column 2001, 2002, 2003......2017 so it can cache one year after the other in a sequence. But, I am seeing an error while the scheduler is...
Hello, I am trying to cache the data using scheduler. There are around 30 views to be cached. 23 of them are having less data (around 10000 all together) and 7 of them are having heavy data (around 80000000 rows all together). So I created two VDPCach...
Community, I'm fairly new to the forumsd, so please be patient with me. I configured a SQL Server 2014 data source using the SQL Server 2014 JDBC driver and noticed poor performance characteristics when issuing a query using a varchar field as the se...
Slow Query Response SQL Server Table scans of Text fields Ignores Server Indexes
I'm currently able to connect to SQL server databases in my environement using the JDBC connector, when I want to create base views I expand the data source where it's only displaying SQL security roles and not any orther objects like tables and views ...
Hi, I am new with Denodo. I have two simple views. One coming from Sql Server and another Redshift. For exmaple: View 1: Name: v1 Source: SqlServer Column: col1 long View 2: Name: v2 Source: Redshift Column: col1 text In v2, col1 can be NULL. I am r...
Is it possible to use NOLOCK hint in select statement on SQL Source
I am running into an issue connecting to a SQL Server 2008 R2 named instance using JDBC with either the JTDS or the MS Driver. I've tried specifying just the instance (which would be ideal, as it is conceivable that with named instances they could be u...