Stack Overflow
Stack Overflow

Questions tagged [denodo]

The Denodo Platform is a middleware software platform for the (virtual) integration of data of diverse natures coming from several kinds of sources (databases, web, delimited files...). This software can be applied in scenarios like those involving SOA, Web automation or Web crawling.

The Denodo Data Services Platform is an enterprise Data Virtualization, Data Federation and Cloud Data Integration middleware that uses a declarative approach to abstract, unify, federate and understand disparate data sources and systems, supporting multiple acquisition and delivery modes and latency requirements, as well as a rich set of easy to use data transformation, data federation and data mashup capabilities.

100 questions
0
votes
1 answer

Is there anyway to connect to a denodo db using flask sqlalchemy?

I'm currently able to connect to the denodo db utilizing a denodo driver that I compiled and use with pyodbc and I can also connect and query the table if I directly use psycopg2. However, it would be ideal if I can utilize Sqlalchemy's ORM. The…
Jon
  • 25
  • 1
  • 5
0
votes
1 answer

Subquery as Join?

My query is shown below. SELECT *, SUM(A.money_step) over ( partition by A.id_key, A.P ORDER BY A.actual_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW )as accumulated FROM ( SELECT A.*, ( SELECT CASE WHEN…
G21
  • 37
  • 4
0
votes
1 answer

Fail to insert in hive using jdbc driver

I try to insert into hive using jdbc driver 'hive-jdbc-2.1.1-cdh6.3.0-standalone.jar' (through denodo tool) but it always fails to insert and error appears that method not supported .. I retrieve data successfully but fail to insert...any help…
Aser
  • 27
  • 4
0
votes
2 answers

Unable to connect to denodo via jdbc driver to mavenized mule application

I’m trying to establish a connection with denodo using JDBC driver to mulesoft which is a maven based application. Mule runtime: 3.8.6 Denodo version: Denodo 7.0 update-20181011 JDBC Jar used: denodo-vdp-jdbcdriver-7.0-update-20181011.jar Maven…
vennapu
  • 45
  • 7
0
votes
1 answer

Create View for Latest Value Each Day (No Skipped Days)

I have a table that records the firmware version for each device every day. If a device goes down, the script to populate the device's firmware won't be able to reach it for a value so there is no record for offline days. I need a view that will…
greenbellpepper
  • 412
  • 2
  • 7
  • 14
0
votes
2 answers

Select Value of Parameter in Array with Denodo (VQL)

I am trying to do something that seems simple but cannot find the right syntax for Denodo's VQL (Virtual Query Language). I have a string like this: XXXX-YYYY-ZZZZ-AAAA-BBBB in a column called "location" that varies in length, and I want to get the…
greenbellpepper
  • 412
  • 2
  • 7
  • 14
0
votes
2 answers

Randomly sampling data in Denodo

I wonder what is analog of SQL SERVER newid() command in Denodo (VQL)? My ultimate goal is to randomly sample data in Denodo.
user1700890
  • 7,144
  • 18
  • 87
  • 183
0
votes
1 answer

Denodo Custom Stored Procedure using Java

Just like other error, already tried all solving solution but still get an error like this. The project was not built since its build path is incomplete. Cannot find the class file for java.lang.Object. Fix the build path then try building this…
Shem Lim
  • 15
  • 5
0
votes
1 answer

Move file from one folder to another folder in Denodo

I am processing some source CSV files using Denodo VDP and finally creating output files using Denodo Scheduler. After processing the source files, i want to archive source files into different folders by moving to another file. I searched upon in…
Sundar
  • 1
0
votes
0 answers

Error while trying to execute the query in Denodo using Python SQLAlchemy

I'm trying to get a table from Denodo using Python and sqlalchemy library. That's my code from sqlalchemy import create_engine import os sql = """SELECT * FROM test_table LIMIT 10 """ engine = create_engine('mssql+pyodbc://DenodoODBC',…
Katarzyna Malina
  • 21
  • 1
0
votes
0 answers

Error querying timestamp data using Python and Jaydebeapi

I'm receiving an error when trying to query data fields in Denodo that have a timestamp type. I'm using python 3.7.3 and the jaydebeapi. Referencing the error I receive below, '%Y-%m-%d %H:%M:%S' is indeed how the field is formatted, and…
Millie Smith
  • 1
  • 1
0
votes
2 answers

Multiprocessing/multithreading for database query in Python

I have millions of records in database and I want to read it through Python and store it in pandas data frame . The problem is the select query processing time is very high. To reduce the query processing time I try to perform multi threading on…
rishi kumar agarwal
  • 1
  • 1
  • 2
0
votes
1 answer

How do you declare a variable in Denodo?

I'm having trouble declaring a variable in my query to use with Denodo. I've tried writing it using sql syntax, but I get an error with "declare". declare @var1 varchar(6) = 'table1' select column_name, column_description from view('pb',…
Henry
  • 28
  • 8
0
votes
0 answers

ErrorMessage while open connection to Denodo via npgsql in c#

sorry, if this is question is (to) easy for stackoverflow community. I am trying to connect to Denodo (Version 7), via c# code. I installed npqsql and created a connection string with: {host} {port} {username} {passwd} {database} and the SSL-Mode…
user9364465
0
votes
0 answers

Is there a way to deliver an array via a REST-Webservice in Denodo?

I´m importing a JSON-Datasource in Denodo which contains 2 arrays. In order to work with the data i flatten those arrays. However when delivering the data I want to get back to the initial array structure to get something like { "name":…
ThreexD
  • 1
  • 1
1 2 3 4
5
6 7