Q&A

Query limited to 10000 rows
answered 04-02-2021 00:56:00 -0500

Hi, I’m making tests on data file load using Denodo Express 8.0 for Windows 64 bits. I have a csv file with 11870 lines (1 header and 11869 records). I made a data source on this file and a base view on the data source. When i make the query "SELECT...

Answers: 1

ROW_LIMIT_REACHED

RIGHTPAD(project_key, 3) function returning error Function 'rightpad' with arity 2 not found
answered 04-02-2021 00:25:39 -0500

Hi, I have strings like this bvq7527.i6v6f8.0ppnf4l967ussr48re21g in project_key field and I want to get the last 3 characters for example 21g, so when I tried to run select rightpad(project_key, 3) from iisdq.iv_sl_xmeta_project_dim in the VQL, I'm g...

Answers: 3

How to get dynamic query from UI to denodo API
answered 03-02-2021 07:01:48 -0500

Hi Team, I have a requirement from front end where they will build the select query dynamically in UI based on some parameters like studentID > 10 then that condition should convert into a select * from viewname where studentID > 10 and send tha...

Answers: 1

HTTP path types
answered 03-02-2021 06:25:44 -0500

Hi Team, I'm using Denodo 7.0 version and followed below link to find the edit http connection tab to configure my REST API as GET/POST/PUT and the required input parameters. can you help with this issue. https://community.denodo.com/docs/html/browse/...

Answers: 1

#Rest API #HTTP Paths

Why VCS operations not enabled after migrating denodo 7.0 to 8.0? Denodo 7.0 has this enabled.
answered 02-02-2021 16:18:19 -0500

Denodo 7 has VCS enabled for databases but after migrating 7 to 8 and using design studio for 8, vcs option is greyed out and says vcs is not enabled.

Answers: 1

Session Timeout Configuration
answered 02-02-2021 07:41:22 -0500

Hi everyone, is there a way to configure Session Timeout (E.g. Set Session Timeout to 30 mins) for Denodo?

Answers: 1

session

Denodo MS SQL Server datasource: parameterized URI
answered 02-02-2021 07:08:37 -0500

Hi ! I'd like to be able to use the same view for different databases on the instance. That means to have same generic datasource (?) connecting to the same instance but different databases. Is this possible ? Interpolation variable in the URI ? there ...

Answers: 1

How to move the Denodo code from dev to testing
answered 02-02-2021 05:41:22 -0500

Hi Team, can you please share what is the best practice and stepd to be followed to move the code written for dev to testing enviornment. If any specifc documents which explains with best practices. Thank you

Answers: 1

DATAMOVEMENT Plan Error "There are '1' data movements defined in view 'view-name' for subview 'view-name-1' but there should be 2 "
answered 02-02-2021 05:23:02 -0500

I have created a derived view (view-name), which uses a base view, a view from different source to which I have read access (view-name-1), and data manipulation in WITH clause. Inside with clause view-name-1 is being used 2 times in query joins. As so...

Answers: 1

MDX command with UNSUPPORTED
answered 02-02-2021 05:00:09 -0500

Hi We are having issue with more than 50 columns in multi dimesion data source , we are seeing following error if more than 50 columns is that excpeted Data source SAP HANA Error executing BAPI: Invalid MDX command with UNSUPPORTED: > 50 CHARACT

Answers: 1