Hi. My view has a field with timestamp. Although, the field type is "text". I really only want to get a date from the field, but I don't know how. Here is an example of the text field: 2019-12-21T13:15:49.000-0600 2019-10-02T15:01:43.000-0500 I need ...
Answers:
2
Hi. I have two views in Denodo (in different datebases). I want to join the two on date (and another ID). However, the views do not have date, they only store timestamp. I want to get just the date from the timestamp in both views and join them. Here ...
Answers:
2
Hello, I have a Json Data source configured to get data from external application. I am seeing the data . But there are 2 cols, Updated At and Created At. values in those columns are coming in the format /Date(1589932800000)/ I tried creating a new f...
Answers:
3
How will be the metadata be brought in to the Denodo from source system? Esp the semantic information.
Answers:
1
Hello, Is it possible to allow a Denodo Scheduler job to start only when the value returned by a query indicates it is ok for the job to start? The scenario is as follows: We want to cache a Denodo view. However, before we can start the cache job, we...
Answers:
1
We have linux machine with denodo client installed, we use import.sh to run some vql file, I have a question, if my vql file wants to have a parameter such as where filters contain some parameter, can import.sh run that vql with parameter contained in ...
Answers:
3
I am trying to recover data from an excel file which is in a shairpoint. do i have to create an excel data source and use http client or do i go through xml data source?
Answers:
6
Hi, I completed on-demand Denodo DV Architect training today (03/04/2018). Under Achievement tab it is showing completed but I do not see any option of printing certificate or share on linkedIn. Please advise how can I get certificate of successful com...
Answers:
3
Hi! I am having an issue with this query: SELECT TOP 5 * FROM TABLE It shows the message: Error: Exception parsing query near 5 Thanks
Answers:
1
Hi, I need to create base view from query and my query it´s DESC DATASOURCE JDBC (all jdbc datasources). How do I do this? I create base view with this information in text mode: DESC DATASOURCE JDBC vdb1.ds_source1 DESC DATASOURCE JDBC vdb2.ds_sourc...
Answers:
1