Q&A

Metadata proc - datasource for a base view
answered 14-06-2019 04:07:08 -0400

Is there a predefined stored proc where I can see the details of the datasource for a base view? I've been looking through https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_stored_proce...

Answers: 3

Metadata

Getting SSL I/O errors while loading data from Denodo views using Informatica sessions
answered 14-06-2019 02:16:17 -0400

I am getting few SSL I/O errors in the Informatica session when I try to load data from Denodo view. The issue seems to go away when I try restart the failed session, but seeing this issue quite often. Do I need to make any configuration changes on De...

Answers: 3

SSL I/O error PostgreSQL Informatica

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