Q&A BY TAG 'SQL'

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

Unable to Query views with individual columns in select query
answered 03-12-2020 06:51:36 -0500

Hi Denodo team, I am trying to query a view with its individual columns in the select query but it is failing to fetch the result and throwing the below error. Finished with error: Error in select view conditions: Field not found 'view_name.column_name...

Answers: 1

JDBC query JDBC SQL

Connecting MS SQL Server through Denodo Testing tool throws error.
answered 15-10-2020 07:07:41 -0400

I'm trying to establish a connection to SQL Server using the below properties through config file. mssql.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver mssql.jdbcUrl=jdbc:sqlserver://sqlsrv- devtest.database.windows.net:1433;databaseName...

Answers: 1

SQL Server SQL

Mismatch in arithmetic operation result
answered 08-06-2020 07:41:29 -0400

Hi all, I am facing an issue for which i can't come up with an explanation. Hopefully I can find some help here in the community. I am pulling up data from SQL server, using multiple tables to create a new field in denodo. I am doing the same in SQL ...

Answers: 1

DENODO SQL

No suitable driver exception when trying to connect using Jmeter
answered 31-03-2020 07:47:41 -0400

Hi, When I try to establish a connection in Jmeter I am getting the error exception as "Cannot create JDBC driver of class 'com.denodo.vdp.jdbc.driver for connect URL' and "SQL Exception: No suitable driver found". I have followed this document to se...

Answers: 1

Jmeter JDBC AWS SQL

Cannot Create BaseView Form SQL Server Partition Table
answered 08-03-2020 22:21:50 -0400

I will create 6 baseview from sql datasource, i'm not sure the table have partition table or not. But on denodo only 1 table created and another table error (conflict table name). Illustration, i will create base view - https://imgur.com/HdsObLD + ...

Answers: 2

on conflict partition Create Base View Baseview Denodo_SQL_Server SQL

ON CONFLICT Clause
answered 18-09-2019 06:48:48 -0400

Does denodo support on conflict clause for updating ?

Answers: 1

on conflict SQL

Complex query that return a time out in VDP
answered 04-07-2019 07:43:26 -0400

Hello, I have a query like that: SELECT t1.* FROM elements t1 WHERE ( ( t1.name IS NULL OR t1.name = '' ) AND t1.id NOT IN ( SELECT t2.id FROM elements t2 WHERE ...

Answers: 1

SQL

Refresh the Data Source
answered 24-05-2019 22:14:18 -0400

How can we refresh the Base view source (SQL) after done any modification? Do we need to refresh manual or it's automate? How to do it?

Answers: 1

SQL DVP

How to access Denodo Base view in SQL server?
answered 21-05-2019 20:35:07 -0400

I created base view in Denodo from mutiple source like oracle and other sorces. How can i access the baseview from SQL?

Answers: 1

bas DENODO API SQL base

Write values to a data base
answered 20-02-2019 18:17:36 -0500

Hi, can we use Denodo to write (insert records, delete recors, modify) the results of a given query to a data base? (i.e i would like to store the results of a query into a SQL data base) Many thanks,

Answers: 1

Insert Operation SQL Server SQL