Q&A BY TAG 'Query'

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

Base View from query
answered 31-01-2019 05:42:13 -0500

Hi Team, Denodo 5.5 How to create a Base View from Query on stored procedure 'element_metadata()' Please tell. I also intend to use interpolation variables. Thanks.

Answers: 2

Query Stored Procedure

Extracting query with the hardcoded values not parameterized.
answered 29-08-2018 05:33:44 -0400

Hi, Currently we are running a query which has a lot of hard coded values. The query in its execution plan shows up like below Select as column1, as column2 from table; parameters = [<parameter1>, <parameter2>] How can I extract a que...

Answers: 1

query plan Parameterize Query Execution plans Parameter

track failed query
answered 25-06-2018 17:31:49 -0400

A user is hitting Denodo from tableau, He is facing issue with some tableau dashboards. While working with him we found that we can see 'active session with the query hitting from tableau to denodo', but we are unable to track failed query which was hi...

Answers: 3


Denodo & SQL Question - Temporary Tables & Updates
answered 25-06-2018 11:58:33 -0400

Hello, I am finding myself creating the majority of my base views by using the create from query function. I have a query I am looking to use to create a base view and in the query I have created temporary tables followed by update statements. The reas...

Answers: 1

Query Temp Tables SQL

ERROR: operator does not exist: timestamp without time zone >= character varying'
answered 19-06-2018 12:38:06 -0400

Hello, I am new to Denodo and because I have a strong background in SQL I have been using my SQL skills by creating base views off a query. When I get to the next step of creating my derived view witha a date parameter I continue to receive the followi...

Answers: 1

query Parameter Date timestamp

Catalog metadata file not found null
answered 02-03-2016 12:27:54 -0500

Hi, I have connected to a hive datasource and imported a table using "Create selected base views". I can see the table on the left hand side panel. But when I execute the view, the following error pops up : TABLE [BASE] [ERROR] TABLE [JDBC WRAPPER] [...

Answers: 4

VQL meta data view VDP query

Denodo query to search rows by column using wildcard character
answered 24-04-2015 08:28:05 -0400

I am a newbie to denodo, I am trying to figure out how to manage a view to return resultset based on the wildcard search. If it oracle, I will use `select * from employee_table where employee_name = '%Jac%'` This will return a resultset where the emplo...

Answers: 8