Q&A BY TAG 'Create Base View'
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
Cannot Create BaseView Form SQL Server Partition Table
answered
08-03-2020 22:21:50 -0400
I will create 6 baseview from sql datasource, i'm not sure the table have partition table or not. But on denodo only 1 table created and another table error (conflict table name). Illustration, i will create base view - https://imgur.com/HdsObLD + ...
Answers:
2
on conflict partition Create Base View Baseview Denodo_SQL_Server SQL
Date Range error
answered
10-02-2020 05:55:55 -0500
Hi, I am doing the denodo on demand training. One chapter has this excersize 'DEN70EDUD1102LAB02 - Create a Delimited File data source using DateRange function" The file saved in my local directory as below 20160101 20160102 20160103 20160104 2016010...
Answers:
1
Date Range parameter doesn't accept date
answered
10-02-2020 05:50:58 -0500
Hi, I am doing the denodo on demand training. One chapter has this excersize 'DEN70EDUD1102LAB02 - Create a Delimited File data source using DateRange function" The file saved in my local directory as below 20160101 20160102 20160103 20160104 2016010...
Answers:
1
Delimited file data source Create Base View delimited file sources rows columns pattern tupple
GENERATE_VQL_TO_CREATE_<json>_BASE_VIEW()
answered
07-02-2020 20:22:19 -0500
Hey, There is a stored procedure to generate vql to create base view for jdbc sources - GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW() but is there a option i can generate vql for otehr datasource. I.e json, csv, custom, etc
Answers:
1
Unable to connect to the database when creating base view on DB2 datasource or reading data after upgarde to v7
answered
05-06-2018 19:36:05 -0400
Hi I have migated from Denodo Expressv6 to Denodo Express v7 and for one of the DB2 database, I get the error below when adding a base view: Unable to connect to the database: Internal error: sun.nio.cs.MS1252.getDecoderSingleByteMappings()Ljava/lang/...
Answers:
3
How to Create Base View and execute in Denodo to a NEO4J data-source?
answered
22-04-2018 03:01:44 -0400
Hello everyone ... again, I will be quick and objective in explaining my problem. I want to create a Base View from a Neo4j database. I was able to connect the tools with the corresponding driver, placing it in the folder "<INICIO_DENODO> \ lib ...
Answers:
2
How to Create Base View in Denodo to a NEO4J data-source?
answered
13-04-2018 18:36:11 -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:
5