Netezza does not natively support the Group_Concat function (See referenced links below) . Netezza Group concat is a User defined function (UDF) provided by IBM . It may require for the Netezzza SQL Extensions toolkit to be installed in the database that is queried from TIBCO Data Virtualization (TDV) . If the Netezza SQL Extensions Toolkit has been installed in the database, the query with group_concat function can be pushed down to Netezza by following the below steps :
1. Navigate to [TDV Installation Directory]/apps\dlm\cis_ds_netezza\conf\ and locate the netezza capabilities file named - netezza_7_0.netezza.capabilities and the below listed lines:
GROUP_CONCAT(~string): GROUP_CONCAT($1)
GROUP_CONCAT(~string,~string): GROUP_CONCAT($1, $2)
2. Restart the TDV Server Service. If using windows, you can launch Control Panel>>System and security>>Administrative Tools>>Services and find the service named "TDV Server [Version] and click on Restart. If using Linux, navigate to [TDV Install direcory]/bin and execute composite.sh Server stop followed by composite.sh Server Start
3. Reconnect the TDV Studio session and execute the query. The group_concat function is now pushed down to the Netezza database.
NOTE: If the query execution fails with the below error :
"Cause: ERROR: Function 'GROUP_CONCAT(VARCHAR, UNKNOWN)' does not exist
Unable to identify a function that satisfies the given argument types"
This is likely because the Netezza SQL Extensions Toolkit is not installed in the Netezza database.