Q&A BY TAG 'JDBC query'

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

Retrieving Lineage of views
answered 22-10-2020 02:11:03 -0400

Hi Denodo team, I want to retrieve lineage of a view and its columns through query. Like if give a view name to query it should fetch its relative views.In similar way for its columns.Please help me with this.

Answers: 1

JDBC query data lineage #Data Lineage Lineage

Getting Source Tables and Columns of a Datasource through Query
answered 14-10-2020 06:23:36 -0400

Hi Denodo team, Are there any queries to get all the tables in the datasource and also columns in a datasource for a specified table. I have seen that GET_SOURCE_TABLE() procedure is giving table but it takes view name as a parameter,but I don't want t...

Answers: 1

JDBC query Database JDBC DataSource

How can we display the data of multi queries/views in multiple table formats using REST in VDP?
answered 13-08-2019 02:04:00 -0400

I want to display data in multiple table formats from different quries. Below is the format i needed in browser using REST api. Customer Name Customer Number Gogly 1456 Product Name Product ID HR 10 Payroll 11 But when i use, joins it is giving like ...

Answers: 1

JDBC query VDP Joining of Two Rest API DataSources Data

How do I pull all records from the past two days?
answered 23-05-2017 06:39:57 -0400

What is the best way to pull all records from the past two days? Here is what I currently have and it does not work: select * from table_1 where creation_date between CURRENT_DATE and Subtract(CURRENT_DATE(), 2)

Answers: 1

JDBC query QueryOptimization

Issue with fields with the new Denodo 6 version through JDBC
answered 14-04-2017 16:46:45 -0400

We tackled a new error, after update to the last Denodo 6 version (from January 2017). we get an exception from : com.denodo.vdb.engine.wrapper.raw.jdbc.JDBCAccess [] - Error creating new metavalue the next line of the exception is : com.denodo.vdb.en...

Answers: 6

JDBC query