Q&A

You must sign in to ask a question. If you do not have an account, you can register here

Access to data sources on S3
answered 21-04-2021 23:41:07 -0400

Hi. Several days ago I started to test Denodo Standard 8.0 (free trial) for learning yours platform on AWS. And now when I try to connect S3 file system for my test cluster I have such problems (https://community.denodo.com/kb/view/document/How%20to%20...

Answers: 1

AWS S3

Reply to my another question - How to use 3 parameters in 'instr' function?
answered 21-04-2021 21:01:42 -0400

Hi DENODO Team, I need to read the given string in reverse order ( from reverse position). STRING: ‘abcd-E3/FGHIJ:KL-MNOP-QRST’ As per your last reply answer, I will get the 1st position of symbol ‘-‘, which is 4 SELECT INSTR(SUBSTR(‘abcd-E3/FGHIJ:...

Answers: 1

INSTR

How to use 3 parameters in 'instr' function
answered 21-04-2021 20:59:08 -0400

SELECT * FROM <view_name> where instr(<column_name>,'|', 2); Like from which position we need to search the given character.

Answers: 3

instr function

Get all JSON results from restful webservice
answered 21-04-2021 07:22:54 -0400

I have the following URL that is return JSON format for one of my views: http://mycompany:9090/denodo-restfulws/hcc_dv/views/mytestview/?$format=JSON However, it only returns the first 25 rows. I have tried every conceivable varitation to get all 150 ...

Answers: 1

pagination json REST Webservice

Apache Zeppelin for Denodo - Shared Server - Not found
answered 20-04-2021 19:20:29 -0400

Hi, Need help to install Zeppelin. I followed the Denodo documentation. But the link to download Denodo Apache Zeppelin on this page is not working. Are we supposed to install only from Denodo site to get the interpretor ? https://community.denodo.com...

Answers: 3

Zeppelin

Can we use Denodo data set for full test search
answered 20-04-2021 08:15:51 -0400

Hi Team, We are doing some POC for Denodo to create DataSet from different API and databases. I am curious if Denodo provide some ways for enable Full Text Search on top of this dataset ? Is there a way we can use the data populated though Dataset to f...

Answers: 3

elasticsearch fulltextsearch

Rerun batch job in Denodo scheduler server
answered 20-04-2021 05:13:05 -0400

Hi Team, I reran one batch job in the server this morning, I found the parameter was input wrongly after job being triggered and it's not possible to stop it by 'stop' or 'disable', the job reran by itself again and again, and then I had to edit the j...

Answers: 2

Denodo scheduler server

JiSQL setup failing with Could not find or load main class
answered 19-04-2021 11:35:55 -0400

Hello, I have been try to setup jisal , i followed steps likes downloaded the .zip extracted and also copied the jdbc driver "denodo-vdp-jdbcdriver.jar" in jisql-2.0.11/lib/ . But when i try java -classpath lib/jisql-2.0.11.jar:lib/jopt-simple-3.2.j...

Answers: 3

JiSQL

Can't create Remote table, Denodo says that the view was not found, but it exists
answered 19-04-2021 09:36:27 -0400

Hello I am trying to create a remote table in DEN80EDU23DS06 as follows: SELECT * FROM CREATE_REMOTE_TABLE() WHERE remote_table_name = 'bv_cc_case_call_remote' and query = 'SELECT call_id, location_id, problem_code, status_code, date_ticket_issued, dat...

Answers: 2

Base view remote table

Issue when accessing the GraphQL service on denodo
answered 19-04-2021 09:21:50 -0400

Denodo version 8 followed doc at https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/restful_architecture/graphql_service/graphql_service Upon visiting the service http://denodo:9090/denodo-graphql-service/graphql/<our-database-...

Answers: 1

GraphQL