Q&A

Gettimeinmillis
asked 18-09-2021 21:13:01 -0400

Hi, I am trying to convert a timestamp field which is in the format (2021-08-25 12:53:29.13) to milli seconds by using the function gettimeinmillis(timestamp). Why is it not working? When I try it using dual for example : SELECT gettimeinmillis(now())...

Answers: 0

Gettimeinmillis

Issue while scaling with metadata in volume
answered 17-09-2021 15:24:03 -0400

Hi Team, As mentioned in the artical it is possible to mount volume in kubernetes for Denodo metadata and depending on the storage class we could persist across deployments. However there is a teething problem with volume mount. With the volume metada...

Answers: 1
Related to: https://community.denodo.com/kb/en/view/document/Data Persistence in Containers?category=Operation

kubernetes derby volumes Error Vertical scaling

Adding CONTEXT to JDBC Database URI
answered 17-09-2021 09:33:52 -0400

I am trying to add a timeout context to a JDBC connection. JDBC Parameters are referenced in the documentation (https://community.denodo.com/docs/html/browse/6.0/vdp/developer/access_through_jdbc/parameters_of_the_jdbc_connection_url/parameters_of_the_...

Answers: 4

context JDBC

Composite keys select query in denodo
answered 17-09-2021 09:10:59 -0400

How to write select query for composite keys in denodo like oracle Below is the example for oracle: SELECT * FROM table_name WHERE (key_part_1, key_part_2) IN ( ('B',1), ('C',2) ); Could you please let me know ASAP Thanks Satish K

Answers: 1

composite keys

Issue post installing Denodo Express
asked 17-09-2021 08:28:18 -0400

Hi Team, I am not able to create any folder/VDB after successfully installing Denodo Express in one of the WIndows Machine with the default login/password: admin/admin. I took help of the IT team while installing it in the machine as advised during i...

Answers: 0

#Metadata Loading Metadata

Changing JDBC Connection Password with VQL
answered 17-09-2021 01:49:43 -0400

Hi, I need help constructing the correct VQL to change the password for a JDBC connection within VDP? I believe it is something like: ALTER DATASOURCE JDBC connectionname ENCRYPT_PASSWORD 'thisisthenewpassword';

Answers: 1

vql JDBC Password

Duplicate server adresses and authentication data for same the Rest data sources
asked 16-09-2021 11:03:38 -0400

I have a server with a Rest API that has multiple endpoints that return JSON data (e.g. a jasperserver that has a rest call to get all report units and a rest call to get all report schedules). I now want to create one table for the report units and on...

Answers: 0

How to search for a range of dates based on a text value - Interpolation variable
answered 16-09-2021 09:18:36 -0400

I currently have a baseview that with an interpolation variable for a date value that can be used to dynamically target a specific CSV file on AWS S3 as the source. select * from hcc_dv.dv_ctigeneral_s3_gdw_backupdate where backupdate = '09-01-2021' ...

Answers: 2

Interpolation Variables AWS S3

Base10_to_base64 How to in denodo?
answered 16-09-2021 08:42:58 -0400

there is a function for base64_to_base10 but why not a base10_to_base64. because the only available function you provide to convert to hex is Base64_to_hex. is there a way to convert Base10 to hex? all this because denodo does not have a way to handle...

Answers: 2

Setting up a Gateway/ODBC Data Source on a virtual machine for Power BI
answered 16-09-2021 04:10:30 -0400

Hi, I recently created a Power BI report based on a Denodo datasource and published it to powerbi.com. I want to set up a scheduled refresh on powerbi.com. In order to do that, it looks like I need to use a gateway. To ensure that the refresh is cons...

Answers: 1