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

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


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


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


load comments from tables of a orig data source (Oracle) to existing data ource on Denodo
answered 19-04-2021 08:26:11 -0400

Denodod 8 original tabel is on Oracle DB I added some comments to a table which on a Oracle DB and I want ot load the comments to the table/base view on Denodo

Answers: 1

Is it possible to create an enterprise VDB that contains primary data sources to be shared with other VDBs?
answered 19-04-2021 08:20:40 -0400

If we create a view in one VDB, can it actually be based on a data source located in a separate VDB?

Answers: 1