Q&A BY TAG 'Denodo and Hive'

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

FK/PK constraints in Hive3
answered 13-08-2021 08:00:01 -0400

Hi denodo team i have a question about denodo and hive3. I heard that hive3 will be add into official support source database in next denodo updates. And will denodo collect releationships(PK/FK) automatically when create several base view from hive l...

Answers: 1

Hive Denodo and Hive

to_date function from denodo cannot be delegated to HIVE
answered 09-10-2020 19:21:03 -0400

Hi, I am getting warning as to_date cannot be delegated while trying to find the difference between two dates in denodo with source as HIVE The logic I have used in denodo as: getdaysbetween(to_date('yyyy-MM-dd', table1.start_dt), to_date('yyyy-MM-dd...

Answers: 3

Denodo and Hive

fail to export data from jdbc source to hhive
answered 06-05-2020 00:48:44 -0400

I try to export data from mysql into hive using denodo scheduler and I create the 2 tables same structure but when I execute the job error appears "Group0#JDBCExporter0: Document 1: Method not supported" ..any help why this happen ? full error 1929530...

Answers: 4

Job scheduler Denodo and Hive

Hive connection issue with Denodo VDP
answered 25-09-2018 23:15:12 -0400

Hi Team, Product Name: Virtual DataPort 7.0 (Express) Hive Version: Hive v1.1.0 CDH (Cloudera Distribution Hadoop): v 5.13.0 Database Adapter : Hive 2.0.0 (HiveServer2) Driver Class path : 'hive-2.0.0' Driver Class : org.apache.hive.jdbc.HiveDriver D...

Answers: 1

Denodo and Hive

How to limit the records while creating the derived view in denodo with Hive as the source
answered 07-05-2018 08:17:13 -0400

Hi Team, I have a limitation from Hive source that more than 1 GB data cannot be fetched from Denodo. If the data is more than 1 GB will throw error in Denodo saying more than 1 GB data cannot be retrieved. Now I need to create a derived view on top ...

Answers: 1

Denodo and Hive