Latest Activity

code

Performance View

Hi, guys. I have been creating some views and execute in Denodo. I takes a long time to execute, so when I connect Tableau in Denodo, it dowsn´t work. Time off. Could help me give some suggestions. I can send my view. I don´t know how.

Base view

code

How to avoid array data conversion into text format while creating base view?

I have created a data source connection with another denodo data base. That data base has view in which data are present in array form. On creating a base view from that view, the array data get converted into text form automatically. Could you tell me...

Base view ARRAY Create Base View

code

How to create a base view from query in S3

How to create a base view from query in S3?

Base view

code

Joining Census data with Azure dataverse data

Hi All, This is probably mainly to get pointed in the right direction. Here's the problem. I would like to be able to geocode addresses as they appear in the Address table. My idea is 1) Create a base view for the REST API from the census. The censu...

Base view Azure census geocode Derived views

code

The following fields are obligatory in the view 'view_name' : field_name

Hi Denodo Team, When I am trying to run a select query from java (through jdbc connectivity) on one of my view in denodo, I am having an issue in getting result. It is throwing the error : SQL state [HY000]; error code [31002]; No search methods ready...

Base view DENODO SQL

code

Can't create Remote table, Denodo says that the view was not found, but it exists

Hello I am trying to create a remote table in DEN80EDU23DS06 as follows: SELECT * FROM CREATE_REMOTE_TABLE() WHERE remote_table_name = 'bv_cc_case_call_remote' and query = 'SELECT call_id, location_id, problem_code, status_code, date_ticket_issued, dat...

Base view remote table

code

Aggregation of derived views delegating search methods to base view

Hello, i have following problem. I want to expose a REST Web Service that shows aggregated data coming from one single Base View. The Base View can be seen as the following having some input parameters (BV has search methods): ID Desc...

VQL Denodo 7.0 Base view REST ARRAY derived view data aggregation

code

denodo base view refresh

We have scenario where we need to refresh base views using scripts/VQL. Is there a script to mass refresh base views and confirm with single script?

Denodo 7.0 Base view Source refresh

code

vql to invalidate cache (base views, derived views)

Hi team, I want to find out vql to invalidate cache, I run below for a base views, but it has error "selected view: 'base_view_name' is a base view": ALTER VIEW base_view_name CACHE INVALIDATE it cna only run for derived view: ALTER VIEW derived_view_...

base view vql invalidate cache

code

For base view vql, what does "ESCAPE" mean?

I just observer the vql of the base view (data source is Hadoop Dremio), for the columns whose sourcetypename='CHARACTER VARYING', some has the attribute "ESCAPE NOT SORTABLE" , some has the attribute "NOT SORTABLE", why for the same data type, they ha...

base view vql ESCAPE