How to push "left outer join" function in Amazon Redshift datasource TIBCO Data Virtualization?
Article ID: KB0075595
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 8.2.0 |
Description
When using the Amazon Redshift Data Source, users may see the following error in the execution plan while executing a query in TDV Studio:
No Push Reason: Cannot push outer join because the data source Amazon Redshift does not support either sql 92 outer join syntax or native outer join syntax.
No Push Reason: Cannot push outer join because the data source Amazon Redshift does not support either sql 92 outer join syntax or native outer join syntax.
Environment
All supported operating systems.
Resolution
Follow the steps below to resolve this error:
1. Open your Amazon Redshift data source in TDV Studio and navigate to the 'Overrides' tab which is on the bottom of the data source.
2. Navigate to "Simple Properties" tab in "Overrides" tab.
3. Search for below properties and add them as shown below :
- Supports SQL92 JOIN syntax.
- Supports native (nonstandard) OUTER JOIN syntax.
4. Save the changes in datasource.
1. Open your Amazon Redshift data source in TDV Studio and navigate to the 'Overrides' tab which is on the bottom of the data source.
2. Navigate to "Simple Properties" tab in "Overrides" tab.
3. Search for below properties and add them as shown below :
- Supports SQL92 JOIN syntax.
- Supports native (nonstandard) OUTER JOIN syntax.
4. Save the changes in datasource.
Issue/Introduction
This article contains the steps to be followed to push "left outer join" function in TDV Amazon Redshift datasource.
Additional Information
Note:
Analyze the Query Execution Plan to verify if the custom function is pushed successfully to the underlying Amazon Redshift data source.
Analyze the Query Execution Plan to verify if the custom function is pushed successfully to the underlying Amazon Redshift data source.
Feedback
Yes
No
Powered by
