Q&A BY TAG 'CREATE BASE VIEW'

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

the views in the VDP folders are all disappear
answered 08-06-2022 21:22:32 -0400

I faced a problem, in Denodo 7, my folders are all empty. I cannot see the views inside, but I can save the views, just I cannot see them. And my colleagues can see them in their Denodo VDP, very strange. does anybody know why? Thanks and regards.

Answers: 2

b Create Base View Base View configuration

Base view gets created from query, however, cannot execute it.
answered 02-06-2022 19:59:32 -0400

I am able to create a base view from query, and do not get any error messages when creating it, given the instructions. However, when I attempt to execute it, I get following error message. Code is fine, and it runs with no issues and returns results, ...

Answers: 1
Related to: Invalid query error using Create base view from query

Base view baseview created from query Create Base View

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

How to Create Base View in Denodo to a NEO4J data-source?
answered 27-09-2021 01:16:38 -0400

Hi All, I know that a very similar question was asked before, but my problem is not connecting Denodo with Neo4j, I could connect the tools using the corresponding Driver, placing it in the folder "<DENODO_HOME> \ lib \ extensions \ jdbc-drivers...

Answers: 7

Neo4j Create Base View Connection JDBC

Error in Data source creation in ADLS 2 container
answered 15-07-2021 05:27:29 -0400

Hi, I am trying to establish a connection to read and write back a csv file ADLS 2.0 container. I am trying in custom wrapper so I configured my core-site.xml with my ADLS account with keys. When I try to test connection the connection is succes...

Answers: 2

CSV Create Base View Data sources Azure Data Lake Storage Gen2

creating a base view off of a working script in VQL Shell
answered 10-03-2021 10:04:35 -0500

I have the following code that is working to produce a result but I am not 100% sure how to turn it into a baseview that I can join against another existing view. select * from (select * from hcc_dv_dev.bv_ctigeneral_s3_ldap_matrix_regionsector)a RIGH...

Answers: 1

select query Vql shell Create Base View

Denodo unable to fetch all the records for an entity which contains different Schemas file extensions for the parquet files from S3
answered 24-02-2021 06:15:56 -0500

Hello, I tried to create a base with file pattern (.) for the parquet file entity/table in s3 region. Then, when i excute the count query to fetch all the recodrs in the entity.I could able to get the below mentioned error. Finished with error: Error ...

Answers: 3

custom S3 HDFSCustomWrapper; S3 DENODO AWS S3 Create Base View

Error Creating the Base View
answered 27-01-2021 05:51:43 -0500

I tried testing Json data source from SAP using HTTP method 'GET', but it responded below error message when creating base view Unable to obtain the data structure: com.denodo.util.exceptions.InternalErrorException: Error retrieving data from 'http://&...

Answers: 1

Create base view Vitural data port 8 denodo express 8

Dynamic Base View based on another Base view (not JOIN)
answered 04-01-2021 12:18:07 -0500

Hi, I need help with a very specific use case. I have 2 different data sources and I need to create a base view from source A filtered by some values from another base view coming from source B. This values in the second view would be a hole column, ...

Answers: 5

Dynamic Interpolation Variables Create Base View join

Need help creating a Base View from a SQL Server Stored Procedure
answered 18-08-2020 08:14:29 -0400

I have a SQL Stored Procedure which I will use to create a Base View in Denodo. The issue is that the Stored Procedure takes an User-Defined Table type as input parameter. If I select the SP and click Create from Selected I get an error that says the ...

Answers: 3

Base view Create Base View Stored Procedure SQL Server