How to push Hive2 "UNION DISTINCT" function in TIBCO Data Virtualization?

How to push Hive2 "UNION DISTINCT" function in TIBCO Data Virtualization?

book

Article ID: KB0077001

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All Supported Versions

Description

When using the Hive2 Data Source, if the below error is received while executing a query in TDV Studio then follow the workaround mentioned in this article to resolve the issue.

No Push Reason: Cannot push union node because the data source Hive2 does not support UNION DISTINCT. 

Issue/Introduction

How to push Hive2 "UNION DISTINCT" function in TIBCO Data Virtualization?

Resolution

1. Navigate to the below path:
[TDV Server Installation Directory]\conf\adapters\system\apache_hive_2_x

2. Open the apache_hive_2_x_values.xml file using a text editor.
 
3. Append the below code to the file and save the file. 
<ns27:attribute xmlns:ns27="http://www.compositesw.com/services/system/util/common">
  <ns27:name>/runtime/query/union</ns27:name>
  <ns27:type>BOOLEAN</ns27:type>
  <ns27:value>true</ns27:value>
  <ns27:configID>jdbc.union</ns27:configID>
</ns27:attribute>
3. A TDV server restart is required for the above changes to take effect.
Powered by Wolken Software