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.

VQL equivalent for T-SQL "WITH (NOLOCK)"
answered 13-06-2019 21:26:31 -0400

Our DBA claims that the Denodo view is causing DEADLOCKs on the SQL Server. They recommended us to pass the query to SQL Server with the "WITH (NOLOCK)" option. Is this possible with Denodo views? If yes, please provide specific example. Btw, the SQL...

Answers: 1

sql server deadlock nolock deadlock read uncommitted sql server

My Vdp cache Job which runs for every one hour is entering in to long running state some time and stopping with error ,when i restart it is running fine ?
answered 13-06-2019 21:26:04 -0400

My Vdp cache Job which runs for every one hour is entering in to long running state some time and stopping with error ,when i restart the job it is running fine,i am getting the below error Error executing query. Total time 62058.195 seconds. Incompl...

Answers: 1

How to get list of views with statistics enabled
answered 13-06-2019 20:19:58 -0400

How can I get a list of views where statistics has been enabled for a given database?

Answers: 1

views with statistics view properties properties statistics

Denodo and Hadoop
answered 13-06-2019 15:55:20 -0400

Looking for a solution to orchestrate data movement from a variety of sources to a variety of targets with CDC support. Wondering if Denodo could work for us. For example Iot device stream -> denodo -> HDFS or Kafka stream -> denodo -> ...

Answers: 1

Denodo Sources and Targets
answered 13-06-2019 15:52:55 -0400

Looking for a solution to orchestrate data movement from a variety of sources to a variety of targets with a tool that supports CDC. Wondering if Denodo could work for us. For example Iot device stream -> denodo -> HDFS or Kafka stream -> ...

Answers: 1

Compare sql Vs vql using denodo testing tool
answered 13-06-2019 12:11:13 -0400

This is the errror I am receiving. Exception in thread "main" java.lang.IllegalArgumentException: Missing configuration parameter 'encoding' at com.denodo.connect.testing.Configuration.get(Configuration.java:106) at com.denodo.connect.testing.Configur...

Answers: 2

Denodo TEsting Tool SQL Server

cannot initiate machine "CentOS7 Denodo Training 7.0 Sources"
answered 12-06-2019 17:49:44 -0400

When trying to initiate machine "CentOS7 Denodo Training 7.0 Sources" with Oracle VM VirtualBox (6.0) this message appears: The following interfaces were not found: Intel(R) Ethernet Connection (5) I219-LM (adapter 1), VirtualBox Host-Only Ethernet Ad...

Answers: 1

Athena Data Souce connected through JDBC but no objects found to create base view
answered 12-06-2019 17:28:30 -0400

Hi Team, I have connected to Athena-AWS datasource thorugh JDBC using presto adapter. Connection is successful and I am able to see the datbase and schemas under it. But for my bad luck, I am not able to see any tables under the schema were I am suppo...

Answers: 1

#Athena #Baseview #Table_not_found #DataSource

Athena Data Souce connected through JDBC but no objects found to create base views!
answered 12-06-2019 17:23:16 -0400

Hi Team, I have connected to Athena-AWS datasource thorugh JDBC using presto adapter. Connection is successful and I am able to see the datbase and schemas under it. But for my bad luck, I am not able to see any tables under the schema were I am suppo...

Answers: 1

#Athena #Baseview #Table_not_found #DataSource

Connection difficulties to Denodo through load balancer from Tableau
answered 12-06-2019 17:22:36 -0400

Hello, we are having difficulties to keep the connection from Tableau to Denodo alive when we put a load balancer in place. When we directly connect to a Denodo server through the special Denodo connector included in Tableau we don't have difficulties...

Answers: 1