Q&A BY TAG 'Create Base View'
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
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
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
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
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
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
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
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