Q&A

Content Search + Live Data
answered 04-05-2020 09:22:32 -0400

I have configured Content search and works as expected except for when I click on LIve Data link, msg comes up with "Invalid value: <view name>" Not sure why or how to fix it. Cheers

Answers: 1

#index #livedata #contentsearch #datacatalog

Parse field with HTML to generate rows based on specific character string.
answered 04-05-2020 07:59:15 -0400

I have a view with a field called description. This has custom HTML and I am trying to create a Select statement that will parse a new row in the output everytime "/>" appears in the HTML.

Answers: 3

text to row html parse

Write the retrieved data into multiple files
answered 04-05-2020 05:23:54 -0400

Hello, Need to retrive the data from Oracle database, it may have millions for records, I need to write the data in to muliteple CSV files(split the data in to mulitple files). I was able to read the data and write it as single files using schedule adm...

Answers: 1

Denodo scheduler admin Delimited Files

Missing 3rd way
answered 01-05-2020 16:28:50 -0400

You mention there are 3 ways to add parameters to the body of the request however you demonstrate only 2. What is the 3rd way?

Answers: 1
Related to: Error creating JSON data source with "Post Body" parameters

parameters

Execute a DDL statement in a column in a table
answered 30-04-2020 15:00:35 -0400

Hello, We have a create table statement stored in a table. Do we have any option in denodo to Execute the query stored in a column one by one. Thanks & Regards, Gokul

Answers: 4

query execution column ddl table

Gaterhing stats.
answered 29-04-2020 16:58:38 -0400

So does denodo really make queries or views more efficient by gathering stats. is it sophisitcated with creating new plans and optimizations when stats are gathered.? is it a best practice to run stats on a regular basis? but if really , my mvp is ju...

Answers: 1

Gather Statistics

Cron expression with linked jobs
answered 29-04-2020 13:55:42 -0400

I have multiple linked jobs, and I would like to add a cron expression. If I start the jobs manually I launched executing "Start with dependecies" in the last job, but If I want to add a cron expresion, I need to add the cron expresion in all the jobs...

Answers: 1

cron triggers list dependencies

Data Catalog- Impossible to parse the statement "select * from dual() where User Name= 'test'"
answered 28-04-2020 22:18:51 -0400

Hi Team, We have a view on denodo and there is a column which has blank in its name, like "User Name". When we do search with denodo data catalog and add "User Name" to Filters. it reported error: Impossible to parse the statement "select * from dual...

Answers: 3

data catalog

How to schedulle a run in Scheduler every first Sunday of each month?
answered 28-04-2020 17:16:41 -0400

I would like to schedule a run of jobs every first Sunday at 3 pm of each month. Could you help? Thank you

Answers: 1

cron Automic scheduler Job scheduler triggers

how are queries selected for NUMTESTPEREVICTION?
answered 28-04-2020 17:07:55 -0400

We use an oracle server for our cache, but we are seeing the number of threads creep up. We have tweaked the settings as outlined below, but the idle threads still increase. I wanted to see how Denodo determines which threads to check for eviction as a...

Answers: 1