Latest Activity

code

Base View from query

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.

Query Stored Procedure

code

Extracting query with the hardcoded values not parameterized.

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...

query plan Parameterize Query Execution plans Parameter

code

track failed query

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...

query

code

Denodo & SQL Question - Temporary Tables & Updates

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...

Query SQL Temp Tables

code

ERROR: operator does not exist: timestamp without time zone >= character varying'

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...

query Parameter Date timestamp

code

Catalog metadata file not found null

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] [...

VQL meta data view VDP query

code

Denodo query to search rows by column using wildcard character

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...

query