Q&A

Caching data sources with > 1024 columns
answered 09-02-2021 06:07:25 -0500

Hi, A lot of the data we work with has > 1k columns. When I try and set caching for such a data set (~2k columns), I get an error (Error modifying view: CREATE TABLE failed because column 'xxx' in table 'xxx' exceeds the maximum of 1024 columns.). ...

Answers: 1

cache 1024 columns

High Volume Data extraction from Denodo 8 - 50 plus million rows (approximately data size is 10 plus GB) per table. We have close to 200 such tables
answered 08-02-2021 06:05:00 -0500

Hi, We are currently using Denodo 8 in our env. We have tables with more 50 Million rows on an average that needs to be exposed via Denodo. What is the best approach to do this. 1) Create a webservice on top of the Denodo View and expose as an API wit...

Answers: 1

Data extraction from Denodo

Error executing on a Hive Table
answered 08-02-2021 04:18:28 -0500

I have configured Hive on Denodo 6.0 using following parameters: database adapter: Hive 0.12.0 (Hiveserver2) Driver classpath: 'hive-0.12.0' Driver class: org.apache.hive.jdbc.HiveDriver Database URI: jdbc:hive2://13.82.57.6:10000/default Transaction i...

Answers: 2

Hive Issue hive; hadoop

on demand course
answered 08-02-2021 03:39:56 -0500

hi, I have registered for on demand course. but not getting how to start the courses. the email says get the app. there are no other links which can be open in laptop and I can watch training videos. Please help! Thanks in advance.

Answers: 1

Authorization in Solution Manager 7.0
answered 05-02-2021 06:38:46 -0500

Hi Team, Lately we started using solution manager 7.0. We had a requirement as follows: As per the current security architecture in solution manager, it manages licenses for 2 applications say app1 and app2. Currently app1 manages adding vdp instances...

Answers: 1

#solutionmanager7.0 #authorization #solutionmanager

Sales Engineering Toolkit from partner portal has not all dependencies installed that are required for the developing modules
answered 05-02-2021 05:21:29 -0500

Hi, I have successfully installed the Toolkit from the partner portal. Now I want to get through the module 'Data Virtualization Developer'. I started with the first lesson, where I need access to the Virtual DataPort Admin Tool. But apparently thi...

Answers: 1

Sales Engineering Toolkit Partner Portal Virtual DataPort Admin Tool Data Virtualization Developer

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