Q&A

Handling of Array by Spark Simba driver
answered 14-05-2021 17:12:12 -0400

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...

Answers: 1

#array #customfunction

non-JRMP server at remote endpoint - Can't connect jconsole
answered 14-05-2021 16:58:03 -0400

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

Answers: 1

jconsole

GQL service
answered 13-05-2021 18:38:33 -0400

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

Answers: 1
Related to: GraphQL in Action - Execution and Navigation

How to add a trailing 0 to number
answered 13-05-2021 11:23:44 -0400

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

Answers: 2

concatenate

Convert text to Timestamp
answered 13-05-2021 11:23:10 -0400

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. ...

Answers: 2

Date Conversion timestamp

Configuring an environment with localhost
answered 13-05-2021 11:21:54 -0400

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

Answers: 2

Environments Solution Manager

How to assign specific admin role that prevent modification on databases created by others ?
answered 13-05-2021 06:24:11 -0400

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 ...

Answers: 3

Roles Users

Compare Objects From One Environment to Another
answered 12-05-2021 18:16:43 -0400

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...

Answers: 1

Date subtraction
answered 12-05-2021 17:10:35 -0400

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_...

Answers: 1

Date Conversion

Retieve header from http client request
answered 12-05-2021 09:27:51 -0400

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...

Answers: 1