Q&A BY TAG 'Base view'
Base view deployed even though table not present in database
answered
27-03-2020 12:22:06 -0400
Hello team, We are deploying a view created from A database from A environment to B environment. When deployed a view from A to B we found that the table was not present in the database B yet the view was deployed. we got to know that table was not pr...
Answers:
1
SolutionManager Invalid query in create base view from query Base view Deployment using Solution Manager Best Practice
Querry execution return error
answered
26-03-2020 10:30:07 -0400
Hi I just strart testing denodo Sandbox free trial but when executing some querry its return error DataBriks.historical_store_sales Finished with error: Error executing query. Total time 92.279 seconds. HISTORICAL_STORE_SALES [BASE] [ERROR] HISTORICAL...
Answers:
1
Delimited File Error
answered
14-01-2020 07:10:08 -0500
Hi all, During the Denodo 7.0 lab DEN70EDUD1102LAB01 I have created the log data source successfully, however cannot perform the creation of a base view; every attempt results in the folloing error: “There was an error while creating this base vi...
Answers:
1
Timestamp Issue
answered
26-12-2019 17:40:21 -0500
Hi, During our PoC with Denodo, we faced some issues related with Timestamp-NTZ and Timestamp-LTZ column types. When we include these fields in Base View (or SQL based Base View) columns are mismatching. Basically, denodo cannot determine the column(s...
Answers:
1
Create BV with variable
answered
14-11-2019 06:04:52 -0500
Hello: I want to create a BV from a JDBC resource, and I have a csv, with some fields and I want to get the value of the variable from this CSV. the query is select name, address from people where country=@country and I have this CSV: L...
Answers:
1
Denodo Cached Base View Issue: returns 0 records in left join
answered
23-09-2019 08:11:59 -0400
Nevermind! Figure out the issue.
Answers:
1
My base views are not appearing when I am searching my data catalog
answered
19-08-2019 01:32:29 -0400
Once I have syncronized my data with the Data Catalog from the VDP server, how to I get it to appear in search results? I have synched my data from the VDP and it is appearing in the Element Management page. When I search for the views in the catalogue...
Answers:
1
error while creating base view
answered
18-07-2019 07:58:13 -0400
I have problem while creating a base view. I can open the same url in postman but here in denodo while creatingbase view I have this error Error mssg: Unable to obtain the data structure: com.denodo.util.exceptions.InternalErrorException: Unexpected v...
Answers:
1
How can we display multi queries/views data in multiple tables using REST in VDP?
answered
20-06-2019 01:27:07 -0400
7.0
Answers:
1
find base view from query
answered
11-06-2019 13:26:06 -0400
Hi Team, Denodo 7.0 Is there any scripted way (stored procedure), which can tell what base views are created from query and what otherwise. Please help. Thnaks.
Answers:
3