Q&A

Connection from Python to Denodo
answered 13-01-2020 03:33:12 -0500

Hello, I want to access data from denodo using python3. My code looks like the following: import jaydebeapi hostname = '####################' port = '####' driver = 'com.denodo.vdp.jdbc.Driver' user = '#####' password = '#####' path = '/home/I011404...

Answers: 9

Python

Incompatible subtype
answered 10-01-2020 20:49:26 -0500

Hi there, The data source data type has changed from int to text. I would like to change the my base you to reflect this new data type. The error im getting is "the field has a compatible subtype for type "text": INTEGER Please assist with me with c...

Answers: 1

string conversion

in selection view, is there any way that input parameter can accept values from subquery rather direct assignment
answered 10-01-2020 19:26:28 -0500

in selection view, is there any way that input view parameter can accept values from subquery rather direct assignment of values. if i assign values through sun query like below SELECT GETDAYSBETWEEN(in_from_effective_date, in_to_effective_date), p_p...

Answers: 1

Parameter View Parameter entry selection view

Issues with "Denodo Email Exported Files Custom Handler" on Denodo Scheduler.
answered 10-01-2020 06:07:17 -0500

Hi Team, I have configured "email export files" on Denodo Scheduler as given in the document link "https://community.denodo.com/docs/html/document/denodoconnects/7.0/Custom%20Handler%20Email%20Exported%20Files%20-%20User%20Manual". But I am facing is...

Answers: 1

querying very large data sets in denodo?
answered 09-01-2020 06:06:21 -0500

if I want to build a machine learning model using Apache Spark that accesses terabytes of data in denodo, is there a way to access the data using a more performant method than jdbc, such as hdfs?

Answers: 1

"Denodo Email Exported Files Custom Handler" Plugin For Scheduler
answered 08-01-2020 13:29:17 -0500

Hi Team, Can I get a link from where I can download "Denodo Email Exported Files Custom Handler" Plugin to run it on denodo scheduler.

Answers: 1

querying unstructured data with denodo
answered 08-01-2020 07:41:06 -0500

I have watched the webinar here, which shows how to use structued data for building ML/AI models - https://www.denodo.com/en/webinar/advanced-analytics-and-machine-learning-data-virtualization Some models such as neural nets require images (unstructur...

Answers: 1

SSL error in SQL server
answered 07-01-2020 13:42:13 -0500

Hi Team, Denodo 6.0 Database Adapter : MS SQL server 2012 (MS Driver) Driver Class Path : sqljdbc4.jar Driver Class : com.microsoft.sqlserver.jdbc.SQLServerDriver Error: Unable to establish connection: The driver could not establish a secure connecti...

Answers: 13

SSL

Cannot connect to VDP
answered 07-01-2020 12:09:24 -0500

Hi, I am getting timeout issue when connecting to VDP. Server is up and running. 106198 [AWT-EventQueue-0] ERROR 2020-01-07T14:43:03.379 com.denodo.vdb.admin.gui.components.connection.ConnectionPanel [] - Connection error:com.denodo.vdb.admin.model...

Answers: 1

Connection issue to VDP

how can we ensure in a join /subquery a query passed to underlying source first then another one in a same session
answered 06-01-2020 17:40:44 -0500

HI , usually when we perform a join in two base views or use a subquery in denodo. it creates two different parallel connection to get data from underlying source. can we ensure that both of queries on join run in same session and one after another. be...

Answers: 1

query execution VDP query optimisation