I've installed Dendo 7 express but I now need to update to 201903122200.
Answers:
1
Hi Team, I have a field which have sample data like /abc/data/source/AYZ/SrcFile/XYZ_ABC_1023456789^900061767ABC00100002^ABC_2019-10-15_00.00.51.62 I want to extract two id's 1023456789 and 900061767ABC00100002 ( which is between two chars '^' ) fro...
Answers:
1
Hi, I have implemented a function in DB2 which would take Denodo User-ID as one of the parameter. I have created a base view using DB2 function as shown below. CREATE OR REPLACE WRAPPER JDBC bv_consumer FOLDER = '/01 - data sources' DATASOURCENAME=d...
Answers:
4
Hi support team, We have a VQL which execution time is more than 10 seconds in VQL shell, while it's generated native SQL can be run in Oracle client in only 3 to 4 seconds. In VQL shell, the "Execution Trace" shows "Virtual Plan" takes more than 1...
Answers:
1
When I try to configure the internal database for Denodo in the Data Catalog, every time I restart the Data Catalog there is a login error that comes up saying " unknown column 'search_description' in 'field_list' ". I am using mysql5, have put the jdb...
Answers:
1
Hi Team, I'm facing issue with Information self service tool. When i query a view in isst, it displays the fields in alphabetical order and not as order in view. for example, i have a derived view dvtest which has fields a, d, c, b in same order. when...
Answers:
3
Select * into #Temp from xyz Select * from #Temp When I run this Script using Create Base view from Query, I am getting the below error message. Error: Received exception with message 'Incorrect syntax near the keyword 'into' MS SQL Server 2014 JDBC...
Answers:
1
Related to:
Best Practices for Migrating SQL queries to Denodo VQL
we would like to ensure that only a specified time interval data ( say 10 days of data) can be retrieved from denodo views. assuming that table has time series data l. we would like to accept only those queries which are selecting data within specified...
Answers:
1
hi Team, I am getting below after installation Denodo.Updated only VDBconfiguration.properties . Please help me the data catalog is not getting up 22-Oct-2019 18:29:07.819 WARNING [main] org.apache.catalina.startup.SetAllPropertiesRule.begin [SetAllPr...
Answers:
1
I am trying to create a Denodo base view from an already developed Teradata view used in Tableau TDE. THe same query executed fine in Teradata, but give the below error while I try to create a base view from query n Denodo. com.denodo.util.exceptions....
Answers:
1