Q&A

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

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in April 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community

Numbering of array elements in flatten()
answered 16-07-2018 19:01:27 -0400

Hi, I have a Denodo view "personaldata" with a column "addresses" containing an array of addresses. I created a flatten view like this CREATE OR REPLACE VIEW personaldata_addresses AS SELECT user_id, last_udpated, _updated AS address_last_updated, ...

Answers: 1

Denodo Solution Manager
answered 16-07-2018 18:08:24 -0400

Hi Team While Installing Denodo 7.0 on Linux , I have not installed Denodo Solution Manager . Is it necessaary to install denodo Solution manager on Linux ? Why ? Same case if we isntalled Denodo 7.0 on Windows Machine then is it imporatnt to insta...

Answers: 1

Instllation

Denodo Performance Issues
asked 16-07-2018 15:18:09 -0400

HI Team, need your help here on performace. I have a view in DB, Viewname is "employee" when I write a query in DB for one specifi parameter like select from emp where empid=100; in DB its talking 1 sec to bring the 100 records. I imported same view i...

Answers: 0

Can I virtualize shape file (*.*shp) in Denodo?
asked 16-07-2018 12:56:52 -0400

Can I virtualize shape file (.shp) in Denodo? If yes, then how?

Answers: 0

shape

Error while copying response file into destination folder
answered 16-07-2018 06:50:39 -0400

Hi Team, While installing denodo client we are getting ErrorMessage=Error while copying response file into destination folder. we are trying to install in C:\DENODO. can any help on this issue.

Answers: 1

Query existing roles
asked 16-07-2018 06:45:16 -0400

We are on Denodo 6 and would like to query existing roles to dump into a spreadsheet. I have reviewed the existing functions such as 'CATALOGPERMISSIONS', but we are simply only looking for all roles setup in Denodo.

Answers: 0

query roles

Converting varchar to timestamp
asked 15-07-2018 09:55:12 -0400

Hello, I wanted to convert a datetime field I have to a unix timestamp. This thing is - that the datetime values are stored as varchar on the DB. Is there a way to convert a varchar to unix timestamp on Denodo? Thanks, Itay.

Answers: 0

Denodo Base view times out in 15 minutes
asked 13-07-2018 23:38:36 -0400

Denodo Server still times out when I try to access the base view that takes more than 15 minutes to execute. I have already changed Admin Tool Preference -> Connection -> Query timeout(milliseconds) to ZERO. Admin -> Server Configuration -&g...

Answers: 0

Connection Time out QUERY_TIMEOUT

Changes made at scheduler level
answered 13-07-2018 14:11:37 -0400

Hi Team, Schedule of one of our prod job got chagned and we are trying to find out who / what / when and how ? Can you guide us how to trace above information or which log to scan for ? Thanks

Answers: 1

DBeaver, SQLserver. java.sql.SQLException: Invalid mapping to BYTE
answered 13-07-2018 11:22:35 -0400

I'm trying to access data from SQLserver via Denodo (I think version 6), using latest Dbeaver (on Win7). I'm not an adminstrator so have no visibility of Denodo setup etc. nor the database itself. I'm getting warnings when viewing data from views of ...

Answers: 2

BYTE DBeaver SQLserver.