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

create views over xml columns denodo
answered 06-04-2020 13:35:27 -0400

can I create views over xml columns , as I have view contain colum xml record and I have multiple rows .. so I need to create view to list xml records (as columns)

Answers: 1

Base view XML

create base view for xml record from json file
answered 06-04-2020 12:05:31 -0400

Please i want to ask how i can create base view for spcific key at JSON obect file , which means I import json object from json file and this file contain key which it's value xml .. i need to create base view for this xml key

Answers: 1

Base view XML JSON

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

Base view Create Base View

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

Base view Delimited Files

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

snowflake Base view DENODO timestamp

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

Base view Interpolation Variables variable

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

Base view Query Cache

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

Base view synchonization

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

Base view https