Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in November 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Phrase "Maximum size in memory" is unclear in the following topic: configuring the memory usage and swapping policy
answered 19-06-2019 05:41:20 -0400

Review this topic: https://community.denodo.com/docs/html/browse/7.0/vdp/administration/server_administration_-_configuring_the_server/configuring_the_memory_usage_and_swapping_policy/configuring_the_memory_usage_and_swapping_policy#configuring-the-mem...

Answers: 1

#swapping #memoryusage

How to run statistics using Denodo Scheduler
answered 18-06-2019 20:37:32 -0400

I tried to use Denodo Scheduler to update the stats on a base view following the instructions here: https://community.denodo.com/kb/view/document/How%20to%20update%20the%20statistics%20of%20a%20view%20automatically?category=Scheduler However, I always...

Answers: 1

scheduler generate_stats run statistics connect database

Converting time zones in Denodo?
answered 18-06-2019 08:55:19 -0400

Hi, What is the equivalent for the "AT TIME ZONE" (https://docs.microsoft.com/en-us/sql/t-sql/queries/at-time-zone-transact-sql?view=sql-server-2017) function in SQL Server in Denodo? How can we convert the (default) displayed time zone of timestamps...

Answers: 1

Delimited File sources with DateRange
answered 18-06-2019 07:58:32 -0400

Could someone provide an example which works for using Delimited Files with a date range in the file name (or path)? I have given up our own design for now, and I am currently trying to recreate the example from "Virtual DataPort Administration Guide"...

Answers: 4

Interpolation Variables Delimited Files

Git commit failed with operation cannot include non-modified, non-marked-for-deletion out-of-sync elements
answered 18-06-2019 05:39:52 -0400

Hi, I have a setup like: database1 database2 database3 database1 is the source database where I create all my views and database2 and database3 use the views referenced at database1. Now, I have integretaed all these database with git and when I am ...

Answers: 3

How to connect to other database using Denodo
answered 17-06-2019 06:01:46 -0400

How to connect to other database using Denodo

Answers: 1

Unable to configure the Datasource for HiveLLAP(Hive 2.0.0 -Hiveserver2)
answered 17-06-2019 03:41:56 -0400

I am trying to create a Datasource to make test connection to HiveLLAP. Getting Unable to establish connection: Insufficient resources to execute operation error.

Answers: 1

LDAP Authentication through multiple domains
answered 14-06-2019 12:38:03 -0400

We have a requirement where multiple LDAP data source need to be accessed. currently it is based on one data source.

Answers: 1

#LDAP

Date Temporary Table
answered 14-06-2019 12:16:20 -0400

Hello All, I am trying to create a temporary table with two years worth of dates. Is this possible in VQL? I looked through the documentation and it doesn't look like we can call any looping functions. Similar procedure in MS SQL: https://stackoverf...

Answers: 1

Function Temp Tables

Start with denodo express
answered 14-06-2019 11:01:12 -0400

I can access to the administration tool i try to access with my email and password but i can't Please help me to strat working with this tool

Answers: 1

Denodo Express