Latest Activity

code

Handling of Array by Spark Simba driver

Hi Team, I am using spark driver in denodo to query the data. While i directly query objects in S3, the column datatype is shown as an array, but when we onboard it to denodo it is onboarded as "text" and I don't see a dataype as an array in denodo. D...

code

non-JRMP server at remote endpoint - Can't connect jconsole

Hello, When I try to connect to localhost:9997 using the jconsole I get an error: Connection failed: non-JRMP server at remote endpoint. I have TLS enabled. What might be wrong? Thank you

code

GQL service

How did you configure denodo GQL service with apollo playground here?

Related to: GraphQL in Action - Execution and Navigation

code

How to add a trailing 0 to number

Hello, I have month and day in this format 1,2,3... how can I convert it to 01,02,03, ... Thank you

code

Convert text to Timestamp

Hello. I am trying to convert a text to timestamp: My text has this format dd-MMM-yyyy HH:mm:ss I am using this function to_timestamp('dd-MMM-yyyy HH:mm:ss', bv_ho_orders.date_placed) When I convert to timestamp some of the dates are null. ...

code

Configuring an environment with localhost

Hello, I am trying to follow the demo in DEN80EDU18S01, but when I use localhost as a host it does not let me. Is there any way of doing this demo in the same server? Thank you

code

How to assign specific admin role that prevent modification on databases created by others ?

Hello, I'm wondering how to assign a specif ADMIN role to users that : allow granted users to create/modify their own databases and related objects does not allow these users to modify existing databases created by others Currently, I'm only ...

code

Compare Objects From One Environment to Another

Hi, We have 3 environments -- Development, Stage and Production. Ideally, these environments should have the same objects/views to it but of course if there are development/testing chances are, there will be differences but is there a quick way to fin...

code

Date subtraction

I am trying to subtract 4 months from the current date (without time) and then convert it to numeric value in the YYYYMMDD format. Looking at the manual (https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/language_for_defining_and_processing_...

code

Retieve header from http client request

Hello, In order to connect a denodo to a rest API, I need to first execute the request to log in and retrieve a cookie that is return among the headers of the response. The body of that response is a json. So I created a JSON Data source connector. I...