Q&A BY TAG 'base view'

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

How to avoid array data conversion into text format while creating base view?
answered 12-11-2021 07:47:31 -0500

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

Answers: 1

Base view ARRAY Create Base View

remove all _0 from field names on new base view
answered 17-10-2021 22:51:00 -0400

we have config turned on where if a field is renamed because of space or special characters it appends underscore 0 to the end of the field name, we want to keep that feature on but I have a view of like 100 fields and half of them have it. Is there a...

Answers: 1

Base view Vql shell Rename

How to create a base view from query in S3
answered 13-10-2021 08:53:32 -0400

How to create a base view from query in S3?

Answers: 2

Base view

Joining Census data with Azure dataverse data
answered 04-08-2021 13:11:12 -0400

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

Answers: 2

Base view Azure census geocode Derived views

The following fields are obligatory in the view 'view_name' : field_name
answered 07-06-2021 16:41:46 -0400

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

Answers: 1

Base view DENODO SQL

Can't create Remote table, Denodo says that the view was not found, but it exists
answered 19-04-2021 09:36:27 -0400

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

Answers: 2

Base view remote table

Aggregation of derived views delegating search methods to base view
answered 02-04-2021 07:46:17 -0400

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

Answers: 3

VQL Denodo 7.0 Base view REST ARRAY derived view data aggregation

denodo base view refresh
answered 15-03-2021 08:46:28 -0400

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?

Answers: 3

Denodo 7.0 Base view Source refresh

vql to invalidate cache (base views, derived views)
answered 26-11-2020 16:11:49 -0500

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

Answers: 1

base view vql invalidate cache

For base view vql, what does "ESCAPE" mean?
answered 05-11-2020 04:35:49 -0500

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

Answers: 4

vql base view ESCAPE