How to pushdown TRUNC function from TIBCO Data Virtualization to Amazon redshift datasource?

How to pushdown TRUNC function from TIBCO Data Virtualization to Amazon redshift datasource?

book

Article ID: KB0073689

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization TIBCO Data Virtualization 8.2 and higher

Description

When using the Amazon Redshift datasource, a no push reason for the "TRUNC" function can be encountered as follows:

"No Push Reason: Cannot push selectable because the data source Amazon Redshift does not support the function --trunc."

Environment

All Operating Systems

Resolution

To resolve this issue, follow the steps below:
  1. Open the Amazon Redshift datasource.
  2. Go to the Overrides -> Functions tab.
  3.  Search for the "TRUNC" property and click on it.
  4. Change the values as follows:
  • Default Native Expression(what gets pushed): TRUNC($1)
  • Add TRUNC variation with no of arguments: 1 (Click on the plus icon)
  • arg1: cis.timestamp
        5. Save and query the View containing TRUNC again.

Issue/Introduction

This article explains the steps to perform if a no push reason is encountered while using the "TRUNC" function on Amazon Redshift datasource
Powered by Wolken Software